System views overview|V4.2.5|OceanBase Database| docs|Distributed Database

View name	Description
oceanbase.CDB_IND_COLUMNS	This view displays the column information of the index tables of all tenants.
oceanbase.CDB_INDEXES	This view displays the INDEX information of all tenants.
oceanbase.CDB_TABLES	This view displays the TABLE information of all tenants.
oceanbase.CDB_OB_TABLEGROUP_TABLES	This view displays the association between the TABLEGROUP and TABLE of all tenants in the sys tenant. Tables not in a TABLEGROUP are not displayed.
oceanbase.CDB_TAB_COLS	This view displays the column information of the tables and views of all tenants.
oceanbase.CDB_TAB_COLS_V$	This view displays the column information of the tables and views of all tenants.
oceanbase.DBA_OB_TABLEGROUP_TABLES	This view displays the association between the TABLEGROUP and TABLE. Tables not in a TABLEGROUP are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	This view displays the columns of the partitioning key in all partitioning objects.
oceanbase.DBA_SUBPART_KEY_COLUMNS	This view displays the columns of the subpartitioning key in all subpartitioning objects.
oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO	This view displays the column checksum inconsistency information between the index tables (including global indexes and local indexes) and the primary tables.
oceanbase.CDB_OB_TABLE_LOCATIONS	This view displays the location of a table or partition, including system tables, user tables, and index tables.
oceanbase.DBA_OB_TABLE_LOCATIONS	This view displays the location of a table or partition, including system tables, user tables, and index tables.
information_schema.TABLESPACES	This view displays the information about tablespaces. Note This view is available starting with MySQL 5.7. The related features are not supported. You can only query the table structure.

View name	Description
oceanbase.CDB_OB_RESTORE_PROGRESS	Displays the current execution progress of physical restore tasks.
oceanbase.CDB_OB_RESTORE_HISTORY	Displays the status of physical restore tasks upon completion.
oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in a backup set.
oceanbase.CDB_OB_BACKUP_SET_FILES	Displays the file status of a backup set.
oceanbase.CDB_OB_BACKUP_JOBS	Displays backup jobs for all tenants in the cluster. One job record is created for each backup task initiated by a user.
oceanbase.CDB_OB_BACKUP_JOB_HISTORY	Displays the historical records of backup jobs for all tenants in the cluster.
oceanbase.CDB_OB_BACKUP_TASKS	Displays task-level backup tasks for all tenants in the cluster. One task record corresponds to one backup set. Task records and job records are in a one-to-one correspondence.
oceanbase.CDB_OB_BACKUP_TASK_HISTORY	Displays the historical records of task-level backup tasks for all tenants in the cluster.
oceanbase.DBA_OB_BACKUP_JOBS	Displays backup jobs for the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the historical records of backup jobs for the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the historical records of backup jobs for the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the historical records of task-level backup tasks for the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the file status of a backup set.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays the progress of ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays the status of completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the archive path configuration.
oceanbase.CDB_OB_ARCHIVE_DEST	Displays the archive path configuration.
oceanbase.CDB_OB_BACKUP_PARAMETER	Displays backup parameters.
oceanbase.CDB_OB_BACKUP_DELETE_JOBS	Displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY	This view displays the history of backup cleanup tasks that have been executed in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS	This view displays the information about backup_set/backup_piece cleanup tasks that are being executed in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY	This view displays the history of backup_set/backup_piece cleanup tasks that have been completed in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_POLICY	This view displays the cleanup policies set for expired or automatic cleanup in the tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO	This view displays the information about the backup destination used for backup and restore in the tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY	This view displays the history of the backup destination used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	This view displays the information about the backup destination used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	This view displays the history of the backup destination used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	This view displays the cleanup policies set for expired or automatic cleanup in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	This view displays the execution progress of backup cleanup jobs at the tenant level.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	This view displays the history of backup cleanup tasks that have been executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	This view displays the information about backup_set/backup_piece cleanup tasks that are being executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	This view displays the history of backup_set/backup_piece cleanup tasks that have been completed in the tenant.
oceanbase.DBA_OB_ARCHIVELOG	This view displays the status of log backups on each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	This view displays the status of all log backups, including historical and current ones.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	This view displays the status of pieces in a backup set.
oceanbase.CDB_OB_ARCHIVELOG	This view displays the status of log archiving on each path.
oceanbase.CDB_OB_ARCHIVELOG_SUMMARY	This view displays the status of all log archiving, including historical and current ones.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS	This view displays information about table-level restore tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	This view displays information about table-level restore tasks.
oceanbase.CDB_OB_IMPORT_TABLE_JOBS	This view displays information about import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	This view displays information about import tasks.
oceanbase.CDB_OB_IMPORT_TABLE_TASKS	This view displays records of table-level cross-tenant import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	This view displays records of table-level import tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY	This view displays the results of table-level restore tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	This view displays the results of table-level restore tasks.
oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY	This view displays the results of import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	This view displays the results of import tasks.
oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY	This view displays the history records of table-level cross-tenant import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	This view displays the history records of table-level cross-tenant import tasks.

View name	Description
oceanbase.CDB_IND_PARTITIONS	This view displays the definitions of index partitioning in all tenants.
oceanbase.CDB_PART_INDEXES	This view displays the partition information of the index tables of all tenants.
oceanbase.CDB_PART_TABLES	This view displays the partitioning information of all partitioned tables.
oceanbase.CDB_SUBPARTITION_TEMPLATES	This view displays the subpartition templates of partitioned tables in all tenants.
oceanbase.CDB_TAB_PARTITIONS	Displays primary partition information of all partitioned tables in all tenants.
oceanbase.CDB_TAB_SUBPARTITIONS	This view displays the subpartition information of partitioned tables for all tenants.
oceanbase.DBA_IND_PARTITIONS	This view displays the partitioning information about indexes.
oceanbase.DBA_PART_INDEXES	This view displays the partition information of all partitioned indexes.
oceanbase.DBA_PART_TABLES	This view displays user-defined table partitions.
oceanbase.DBA_TAB_PARTITIONS	Displays the partition information, storage parameters, and statistics of all partitions of all tables that the current user has access to.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the names of all subpartitions, tables, partitions, storage attributes, and statistics generated by the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Description

View name	Description
oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT	This view displays all partitions with special weights in all user tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS	Displays all partition transfer tasks being processed by all tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the Transfer Partition task history of all tenants.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	This view displays the status of transfer partition tasks being processed in the current tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the history of executed transfer partition tasks in this tenant.

View name	Description
oceanbase.CDB_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.CDB_OB_LS_LOCATIONS	This view displays the distribution of log streams (LS) replicas for all tenants.
oceanbase.CDB_OB_TABLEGROUPS	This view displays the metadata of all table groups for all tenants under the sys tenant, mainly focusing on partition information.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of all partitioned table groups for all tenants under the sys tenant.
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of all partitioned table groups for all tenants under the sys tenant.
oceanbase.CDB_OB_TABLET_TO_LS	This view displays the list of all tablets and the log stream information to which each tablet belongs under the sys tenant.
oceanbase.CDB_OB_TABLET_REPLICAS	This view displays all tablet replicas for the current tenant. Each tablet replica is uniquely identified by the composite key: `<TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.CDB_PART_KEY_COLUMNS	This view displays the primary partition key information for all tenants' partitioned objects (partitioned tables and partitioned indexes).
oceanbase.CDB_SUBPART_KEY_COLUMNS	This view displays the secondary partition key information for all tenants' partitioned objects (partitioned tables and partitioned indexes).
oceanbase.DBA_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of all partitioned table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of all partitioned table groups.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of all table groups, mainly focusing on partition information.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays all tablet replicas for the current tenant. Each tablet replica is uniquely identified by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	This view displays the list of all tablets and the log stream information to which each tablet belongs for the current tenant.
oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution of log streams (LS) replicas for the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO	This view displays information about data inconsistencies between tablet replicas.
oceanbase.CDB_OB_LS	This view displays the status and recovery progress of log streams.
oceanbase.DBA_OB_LS	This view displays the status and recovery progress of log streams.
DBA_OB_LS_REPLICA_TASK_HISTORY	This view displays the execution history of disaster recovery tasks.
CDB_OB_LS_REPLICA_TASK_HISTORY	This view displays the execution history of disaster recovery tasks.

View name	Description
oceanbase.CDB_OB_DATABASES	This view displays the database metadata of all tenants under the sys tenant.
oceanbase.CDB_OB_MAJOR_COMPACTION	This view displays the global major compaction information of all tenants under the sys tenant.
oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of all zones of all tenants under the sys tenant.
oceanbase.DBA_OB_DATABASES	This view displays the database metadata of the current tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	This view displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	This view displays the event history of the Root Service.
oceanbase.DBA_OB_SERVER_JOBS	This view displays the tasks of all OBServer nodes.
oceanbase.DBA_OB_SERVERS	This view displays the information of all OBServer nodes.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of all zones of the current tenant.
oceanbase.DBA_OB_ZONES	This view displays the information of all zones.
oceanbase.CDB_OB_FREEZE_INFO	This view displays the version information generated by major compaction (major_freeze).
oceanbase.DBA_OB_FREEZE_INFO	This view displays the version information generated by major compaction (major_freeze).

View name	Description
information_schema.INNODB_LOCK_WAITS	This view displays information about lock transactions and lock objects that are waiting when lock conflicts occur. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_LOCKS	This view displays information about all locks (waiting and held). Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP	This view displays the mapping relationship between NDB transactions, NDB transaction coordinators, and MySQL servers that are attached as API nodes to an NDB cluster. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_TRX	This view displays information about active transactions. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_BUFFER_PAGE	This view displays information about all cached pages in the buffer pool. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_BUFFER_PAGE_LRU	This view displays the LRU-sorted page information in the InnoDB buffer pool. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_BUFFER_POOL_STATS	This view displays statistics about the InnoDB buffer pool. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_CMP	This view displays the operation status information about compressed InnoDB tables. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_CMP_PER_INDEX	This view displays the operation information about compressed InnoDB tables and indexes. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_CMP_PER_INDEX_RESET	This view displays the operation reset time information about compressed InnoDB tables and indexes. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_CMP_RESET	This view displays the operation status about compressed InnoDB tables. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_CMPMEM	This view displays the status of compressed pages in the InnoDB buffer pool. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_CMPMEM_RESET	This view displays the reset time of compressed pages in the InnoDB buffer pool. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_SYS_DATAFILES	This view displays the data file paths of InnoDB files for each table and general tablespace. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_SYS_INDEXES	This view displays the InnoDB index metadata. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_SYS_TABLES	This view displays the InnoDB table metadata. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_SYS_TABLESPACES	This view displays the metadata of InnoDB table files and general tablespaces. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_SYS_TABLESTATS	This view displays the low-level status information about InnoDB tables. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_SYS_VIRTUAL	This view displays the metadata of virtual generated columns in InnoDB. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_TEMP_TABLE_INFO	This view displays information about active InnoDB temporary tables created by users. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_METRICS	This view displays InnoDB performance information. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.PLUGINS	This view displays information about server plugins. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_SYS_COLUMNS	This view displays column information for each InnoDB table. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.

View name	Description
mysql.func	This view displays information about user-defined functions (UDFs) created by using the `CREATE FUNCTION UDF` statement. Note This view is available starting with MySQL 5.7. However, this view does not support the related features. You can only query the table structure.

View name	Description
oceanbase.DBA_OB_OUTLINES	This view displays the execution plan outlines of the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the outline information of the throttling rules of the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the execution plan outlines and throttling rule outlines of the current tenant.

View name	Description
oceanbase.CDB_OB_KV_TTL_TASKS	This view displays the TTL tasks being executed by all tenants under the sys tenant.
oceanbase.CDB_OB_KV_TTL_TASK_HISTORY	This view displays the historical TTL tasks of all tenants under the sys tenant.
oceanbase.DBA_OB_KV_TTL_TASKS	This view displays the TTL tasks being executed by the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	This view displays the historical TTL tasks of the current tenant.

View name	Description
mysql.procs_priv	This view stores the privilege information of stored procedures.
mysql.role_edges	This view displays the grant relationships between roles and users.
mysql.default_roles	This view displays the roles enabled by default for users.

View name	Description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	This view displays the historical records of deadlock events. This view displays the historical records of all tenants under the root tenant.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	This view displays the historical records of deadlock events. This view displays the historical records of the current tenant under a non-root tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	This view displays the historical events of an OBServer node.

View name	Description
information_schema.INNODB_SYS_FIELDS	This view displays metadata information about key columns (fields) of InnoDB indexes. This is equivalent to the information in the SYS_FIELDS table of the InnoDB data dictionary. Note This view is available starting with MySQL 5.7. You can query only the table structure.
information_schema.INNODB_FT_BEING_DELETED	This view displays information about full-text indexes that are being deleted. Note This view is available starting with MySQL 5.7. You can query only the table structure.
information_schema.INNODB_FT_CONFIG	This view displays configuration information about the InnoDB full-text search engine. Note This view is available starting with MySQL 5.7. You can query only the table structure.
information_schema.INNODB_FT_DELETED	This view displays information about full-text indexes that have been marked for deletion. Note This view is available starting with MySQL 5.7. You can query only the table structure.
information_schema.INNODB_FT_INDEX_CACHE	This view displays cache status information about InnoDB full-text indexes. Note This view is available starting with MySQL 5.7. You can query only the table structure.

View name	Description
mysql.audit_log_filter	This view displays the definitions of audit filters.
mysql.audit_log_user	This view displays the mapping between audit filters and users.

View name	Description
oceanbase.DBA_TAB_STATISTICS	This view displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	This view displays the column statistics and histogram information of all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	This view displays the column statistics and histogram information of all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information of all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	This view displays the histograms of all columns in the database.
oceanbase.DBA_PART_HISTOGRAMS	This view displays the histogram data (endpoints of each histogram) of all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	This view displays the histogram data (endpoints of each histogram) of all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	This view displays the table statistics history of all tables in the database.
oceanbase.DBA_IND_STATISTICS	This view displays the optimizer statistics of all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	This view displays the cumulative modification information of tables in the database.
oceanbase.CDB_TAB_COL_STATISTICS	This view displays the column-level statistics in the sys tenant.
information_schema.OPTIMIZER_TRACE	This view displays the information generated by the optimizer trace activity. Note This view is only for MySQL 5.7 compatibility. The related features are not supported, and only the table structure can be queried.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	This view displays the historical execution of statistics collection.

View name	Description
oceanbase.DBA_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of the current tenant.
oceanbase.CDB_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of all tenants.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data persisted for the current tenant.
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data persisted for all tenants.
oceanbase.DBA_WR_STATNAME	This view displays the names of the system statistics of the current tenant.
oceanbase.CDB_WR_STATNAME	This view displays the names of the system statistics of all tenants.
oceanbase.DBA_WR_SYSSTAT	This view displays the details of the system statistics of the current tenant.
oceanbase.CDB_WR_SYSSTAT	This view displays the details of the system statistics of all tenants.
oceanbase.DBA_WR_CONTROL	This view displays the WR-related configuration information.
oceanbase.CDB_WR_CONTROL	This view displays the WR-related configuration information.
oceanbase.CDB_WR_SYSTEM_EVENT	This view displays the tenant-level waiting event information persisted for all tenants.
oceanbase.DBA_WR_SYSTEM_EVENT	This view displays the tenant-level waiting event information persisted for the current tenant.
oceanbase.CDB_WR_EVENT_NAME	This view displays the tenant-level waiting event names persisted for all tenants.
oceanbase.DBA_WR_EVENT_NAME	This view displays the tenant-level waiting event names persisted for the current tenant.
oceanbase.CDB_WR_SQLSTAT	This view displays the basic performance statistics of the SQL statements executed for all tenants. Each SQL statement is a row (each unique value of `SQL_ID` + `Plan_Hash` is a row).
oceanbase.DBA_WR_SQLSTAT	This view displays the basic performance statistics of the SQL statements executed for the current tenant. Each SQL statement is a row (each unique value of `SQL_ID` + `Plan_Hash` is a row).
oceanbase.CDB_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics for all tenants.
oceanbase.DBA_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics for the current tenant.
oceanbase.CDB_WR_SQLTEXT	This view displays the SQL texts collected by WR for all tenants.
oceanbase.DBA_WR_SQLTEXT	This view displays the SQL text collected by WR for the current tenant.

View name	Description
information_schema.INNODB_SYS_FOREIGN	This view displays metadata information about InnoDB foreign keys, equivalent to the information in the SYS_FOREIGN table of the InnoDB data dictionary. Note This view is available starting with MySQL 5.7.
information_schema.INNODB_SYS_FOREIGN_COLS	This view displays status information about InnoDB foreign key columns, equivalent to the SYS_FOREIGN_COLS table in the InnoDB data dictionary. Note This view is only supported for compatibility with MySQL 5.7. It does not support any related functionality, and only allows querying the table structure.

View name	Description
oceanbase.DBA_OB_SYS_VARIABLES	This view displays the configuration of system variables for the current tenant.

View name	Description
oceanbase.DBA_OBJECTS	This view displays all database objects, consistent with the ALL_OBJECTS view.
oceanbase.CDB_OBJECTS	This view displays information about all user tenant objects under the system tenant.
oceanbase.DBA_OB_TENANTS	Type
oceanbase.DBA_OB_TENANT_JOBS	This view displays information about tenant-level tasks.
oceanbase.CDB_OB_SYS_VARIABLES	This view displays the system variable information of all tenants in the system tenant.

View	Description
oceanbase.DBA_OB_RESOURCE_POOLS	This view displays information about resource pools of all tenants.
oceanbase.DBA_OB_UNIT_JOBS	This view displays all task information related to units.
oceanbase.DBA_OB_UNITS	This view displays the information about all tenants' UNITs.
oceanbase.DBA_OB_UNIT_CONFIGS	This view displays the unit specifications of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	This view displays all SEQUENCE objects in the database.

View name	Description
oceanbase.DBA_OB_SPM_EVO_RESULT	This view displays the SPM plan evolution information for all tenants.

View name	Description
GV$OB_ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$OB_ACTIVE_SESSION_HISTORY	This view displays the current active session history.

View name	Description
GV$OB_CGROUP_CONFIG	This view queries the cgroup configuration of an OBServer node.
V$OB_CGROUP_CONFIG	This view queries the cgroup configuration of an OBServer node.

View name	Description
GV$OB_MEMORY	This view displays the memory statistics at the tenant level.
V$OB_MEMORY	This view displays the memory statistics at the tenant level.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
V$OB_MEMSTORE	This view displays the MemStore statistics at the tenant level.
GV$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
GV$OB_SSTABLES	This view displays the SSTable information of a tenant.
V$OB_SSTABLES	This view displays the SSTable information of a tenant.
GV$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the current observer process.
GV$OB_PL_CACHE_OBJECT	This view displays the basic information of PL-related cache objects for all tenants.
V$OB_PL_CACHE_OBJECT	This view displays the basic information of PL-related cache objects for the current tenant.

View name	Description
GV$OB_IO_CALIBRATION_STATUS	This view displays the execution status of an I/O calibration task.
V$OB_IO_CALIBRATION_STATUS	This view displays the execution status of an I/O calibration task.
GV$OB_IO_BENCHMARK	This view displays the disk calibration data used by the I/O module.
V$OB_IO_BENCHMARK	This view displays the disk calibration data used by the I/O module.

View	Description
GV$OB_DTL_INTERM_RESULT_MONITOR	This view displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	This view displays the monitoring information of the DTL intermediate result manager.

View	Description
V$OB_ENCRYPTED_TABLES	This view displays the encryption status of tables that enable the encryption feature.
V$ENCRYPTED_TABLESPACES	This view displays the encryption status of tablespaces that enable the encryption feature.

View name	Description
V$OB_ENCRYPTED_TABLES	This view displays the encryption status of tables with the encryption feature enabled.
V$ENCRYPTED_TABLESPACES	This view displays the encryption status of tablespaces with the encryption feature enabled.

View name	Description
GV$OB_KV_GROUP_COMMIT_STATUS	This view displays the group commit status.
V$OB_KV_GROUP_COMMIT_STATUS	This view displays the group commit status.

View name	Description
GV$OB_LOG_STAT	This view displays the Palf status.
V$OB_LOG_STAT	This view displays the Palf status.

View	Description
GV$OB_COMPACTION_PROGRESS	This view displays the major compaction progress at the OBServer level for the current tenant.
GV$OB_COMPACTION_SUGGESTIONS	This view displays the compaction suggestions.
GV$OB_PROCESSLIST	This view displays the session information of all OBServer nodes in the current tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	This view displays the compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	This view displays the history of tablet-level compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress of tablet-level compactions.
GV$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participant information on all OBServer nodes.
GV$SESSION_EVENT	This view displays the session-level waiting events on all OBServer nodes in the cluster.
GV$SESSION_WAIT	This view displays some information about the current or previous waiting events of all sessions on all servers, including the waiting event name and waiting time.
GV$SESSION_WAIT_HISTORY	This view displays the information about the last 10 waiting events of all sessions on all servers.
GV$SYSTEM_EVENT	This view displays the waiting events at the tenant level in the cluster.
GV$SESSTAT	This view displays the session-level statistics of all OBServer nodes.
GV$SYSSTAT	This view displays the tenant-level statistics of all servers.
GV$ACTIVE_SESSION_HISTORY	This view displays the history of active sessions.
V$ACTIVE_SESSION_HISTORY	This view displays the history of active sessions.
V$OB_COMPACTION_PROGRESS	This view displays the major compaction progress at the server level for the current tenant.
V$OB_COMPACTION_SUGGESTIONS	This view displays the compaction suggestions.
V$OB_PROCESSLIST	This view displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	This view displays the compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	This view displays the history of tablet-level compactions.
V$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress of tablet-level compactions.
V$OB_TRANSACTION_PARTICIPANTS	This view displays the information about transaction participants on all OBServer nodes.
V$STATNAME	This view displays the definitions of all statistics events.
V$EVENT_NAME	This view displays the definitions of all statistics events on the current OBServer node.
V$SESSION_WAIT	This view displays the details of the current wait events for each session. According to the convention, each wait event has three parameters, which record the corresponding values.
V$SESSION_WAIT_HISTORY	This view displays the details of the current wait events for each session, including the most recent 10 wait events.
V$SESSTAT	This view displays the statistics events at the session level.
V$SYSSTAT	This view displays the statistics events at the tenant level on the current server.
V$SYSTEM_EVENT	This view displays the statistics of wait events at the tenant level.
GV$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations on the current OBServer node.

View Name	Description
GV$LATCH	This view displays the latch information for all OBServer nodes in the cluster.
V$LATCH	This view displays the latch information for all OBServer nodes in the cluster.

View name	Description
GV$OB_PLAN_CACHE_STAT	This view displays the overall status of each plan cache on all OBServer nodes for the current tenant.
V$OB_PLAN_CACHE_STAT	This view records the overall status of each plan cache on all servers for the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache on all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache on the current server for the current tenant.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache on all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	This view monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
V$OB_PS_STAT	This view monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
GV$OB_PS_ITEM_INFO	This view provides monitoring functionality for prepared statements, including basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	This view provides monitoring functionality for prepared statements, including basic information about all prepared statements in the PS cache.
GV$OB_SESSION_PS_INFO	This view displays the PS information opened by all sessions for the current tenant.
V$OB_SESSION_PS_INFO	This view displays the PS information opened by all sessions for the current OBServer tenant.
GV$OB_PX_TARGET_MONITOR	This view displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	This view displays the usage of PX threads on the OBServer node.
GV$OB_SQL_AUDIT	This view displays the statistics of each SQL request on all servers, including the source and execution status.
V$OB_SQL_AUDIT	This view displays the statistics of each SQL request on the current server, including the source and execution status.
GV$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistical record, and the trace information of the plan is also recorded.
V$SQL_PLAN_MONITOR	This view displays the operation-level statistics of slow queries. Each operation has a corresponding statistical record.
V$SQL_MONITOR_STATNAME	This view displays the meaning of the numeric values in the `OTHERSTAT_X_ID` column of the `GV$SQL_PLAN_MONITOR` view.
GV$OB_FLT_TRACE_CONFIG	This view displays diagnostic information about full-link tracing.
GV$OB_SQLSTAT	This view displays basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` corresponds to a row).
V$OB_SQLSTAT	This view displays basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` corresponds to a row).

View name	Description
GV$OB_KVCACHE	This view displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	This view displays the configuration information on all OBServer nodes where the tenant is located.
GV$OB_SERVER_SCHEMA_INFO	This view displays the schema information on all servers.
GV$OB_SERVERS	This view displays the information of all OBServer nodes.
GV$OB_UNITS	This view displays the unit information on the OBServer node where the tenant is located. The system tenant can view the unit information on all OBServer nodes in the cluster.
V$OB_KVCACHE	This view displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	This view displays the configuration information on the OBServer node.
V$OB_SERVER_SCHEMA_INFO	This view displays the schema information on all servers.
V$OB_SERVERS	This view displays the information of the OBServer node.
V$OB_UNITS	This view displays the unit information on the OBServer node.
GV$DML_STATS	This view displays the DML information in the current user table.
V$DML_STATS	This view displays the DML information in the current user table.
GV$OB_KV_CONNECTIONS	This view displays the statistics of the OBKV connections held by all servers.
V$OB_KV_CONNECTIONS	This view displays the statistics of the OBKV connections held by the current server.
V$OB_COMPATIBILITY_CONTROL	This view displays the features that can be controlled for compatibility with the behavior of OceanBase Database releases.

View	Description
GV$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level in the cluster.
V$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level on the current node.

View name	Description
GV$OB_RPC_OUTGOING	This view displays the statistics of RPC packets sent from all OBServer nodes.
GV$OB_RPC_INCOMING	This view displays the statistics of RPC packets received by all OBServer nodes.
V$OB_RPC_OUTGOING	This view displays the statistics of RPC packets sent from different tenants on all OBServer nodes.
V$OB_RPC_INCOMING	This view displays the statistics of RPC packets received by different tenants on all OBServer nodes.

View name	Description
GV$SQL_WORKAREA	This view displays the statistics of workareas for all operators that were executed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	This view displays the statistics of workareas for active operators.
GV$SQL_WORKAREA_HISTOGRAM	This view displays the statistics of all workarea executions, such as the number of times full in-memory processing was performed between 1 MB and 2 MB and the number of one-pass operations.
GV$OB_SQL_WORKAREA_MEMORY_INFO	This view queries some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory.
V$SQL_WORKAREA	This view displays the statistics of workareas for all operators that were executed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	This view displays the statistics of workareas for active operators.
V$SQL_WORKAREA_HISTOGRAM	This view displays the statistics of all workarea executions, such as the number of times full in-memory processing was performed between 1 MB and 2 MB and the number of one-pass operations.
V$OB_SQL_WORKAREA_MEMORY_INFO	This view queries some overall information about the SQL workarea, including the maximum available memory, current used memory, and current held memory.

View name	Description
GV$OB_PX_WORKER_STAT	This view displays the execution information of each thread in parallel execution scenarios.
V$OB_PX_WORKER_STAT	This view displays the execution information of each thread in parallel execution scenarios.
GV$OB_TENANT_RUNTIME_INFO	This view displays the information about queues and thread limits in tenant threads.
V$OB_TENANT_RUNTIME_INFO	This view displays the information about queues and thread limits in tenant threads.

View name	Description
GV$OB_MERGE_INFO	This view displays statistics related to major compactions that are completed for the cluster.
V$OB_MERGE_INFO	This view displays statistics related to major compactions that are completed for the cluster.

View name	Description
GV$OB_RES_MGR_SYSSTAT	This view displays the statistics of the resource groups in all OBServer nodes of all tenants.
V$OB_RES_MGR_SYSSTAT	This view displays the statistics of the resource groups in all OBServer nodes of all tenants.

View name	Description
DBA_OB_TABLE_SPACE_USAGE	This view displays the size of all user tables (based on the leader replica in a multi-replica environment) under the current tenant.
information_schema.COLUMNS	This view records column information.
information_schema.STATISTICS	This view records table index information.
information_schema.TABLES	This view records table information.
information_schema.VIEWS	This view records view information.
information_schema.VIEW_TABLE_USAGE	This view displays the information of tables and views used in the view definition.
oceanbase.DBA_OB_TABLEGROUP_TABLES	This view displays the association between TABLEGROUP and TABLE. It does not display tables not in a TABLEGROUP.
oceanbase.DBA_PART_KEY_COLUMNS	This view displays the columns in the partitioning key of all partitioning objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	This view displays the columns in the subpartitioning key of all partitioning objects in the database.
oceanbase.DBA_OB_TABLE_LOCATIONS	This view displays the location of a table or partition, including system tables, user tables, and index tables.
information_schema.TABLESPACES	This view displays information about tablespaces. Note This view is available starting with MySQL 5.7. It only supports querying table structures.

View Name	Description
oceanbase.DBA_OB_BACKUP_JOBS	This view displays backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	This view displays the history of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	This view displays the history of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	This view displays the history of task-level backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	This view displays the status of files in a backup set.
oceanbase.DBA_OB_RESTORE_PROGRESS	This view displays the progress of ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	This view displays the history of completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	This view displays the archive path configuration.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	This view displays information about the backup destination used for backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	This view displays the history of information about the backup destination used for backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	This view displays the deletion policy set for expired or automatic deletion in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	This view displays the execution progress of tenant-level backup deletion jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	This view displays the history of backup deletion jobs executed in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	This view displays information about backup_set/backup_piece deletion tasks being executed in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	This view displays the history of backup_set/backup_piece deletion tasks completed in the current tenant.
oceanbase.DBA_OB_ARCHIVELOG	This view displays the status of log backups on each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	This view displays the status of all log backups, including historical and current ones.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	This view displays the status of pieces in a backup set.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	This view displays information about table-level restore tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	This view displays information about import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	This view displays records of table-level import tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	This view displays the results of table-level restore tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	This view displays the results of import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	This view displays the history of cross-tenant table-level import tasks.

View name	Description
mysql.proc	This view displays information about stored procedures.
information_schema.ENGINES	Displays information about storage engines.
information_schema.PARAMETERS	This view provides information about stored procedure parameters and return values.
information_schema.ROUTINES	This view provides information about stored procedures.

View name	Description
oceanbase.DBA_SCHEDULER_JOBS	This view displays information about all database scheduler jobs.

View name	Description
oceanbase.DBA_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partitions of the partitioned table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partitions of the partitioned table group.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of the table group, mainly the partition information of the table group.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays all tablet replicas of the current tenant. Each tablet replica is uniquely determined by the joint key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	This view displays the list of all tablets in the current tenant and the log stream information to which each tablet belongs.
oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT	This view displays the partitions that are set with a special weight.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	This view displays the running Transfer Partition tasks in the current tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the history of transfer partition tasks that have been executed for the current tenant.

View Name	Description
oceanbase.DBA_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of a table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of a table group.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of a table group, mainly the partition information.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays all tablet replicas in the current tenant. Each tablet replica is uniquely determined by the joint key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	This view displays all tablet lists in the current tenant and the log stream information of each tablet.
oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution information of log streams (LS) replicas in the current tenant.
DBA_OB_LS_REPLICA_TASK_HISTORY	This view displays the execution history of disaster recovery tasks.

View Name	Description
mysql.help_topic	This view, together with the `mysql.help_category`, `mysql.help_relation`, and `mysql.help_keyword` tables, generates the Help command.
mysql.help_category	This view, together with the `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_keyword` tables, generates the Help command.
mysql.help_keyword	This view, together with the `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_category` tables, generates the Help command.
mysql.help_relation	This view, together with the `mysql.help_category`, `mysql.help_topic`, and `mysql.help_keyword` tables, generates the Help command.

View name	Description
information_schema.INNODB_LOCK_WAITS	This view displays information about the locks that are waiting for conflicts. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_LOCKS	This view displays information about all current locks (waiting and held). Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP	This view displays the mapping between NDB transactions, NDB transaction coordinators, and MySQL servers attached as API nodes to the NDB cluster. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_TRX	This view displays information about the active transactions. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_BUFFER_PAGE	This view displays information about all cached pages in the buffer pool. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_BUFFER_PAGE_LRU	This view displays the LRU-ordered pages in the InnoDB buffer pool. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_BUFFER_POOL_STATS	This view displays the statistics of the InnoDB buffer pool. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_CMP	This view displays the operation status of the compressed InnoDB tables. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_CMP_PER_INDEX	This view displays the operation information of the compressed InnoDB tables and indexes. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_CMP_PER_INDEX_RESET	This view displays the operation reset time of the compressed InnoDB tables and indexes. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_CMP_RESET	This view displays the operation status of the compressed InnoDB tables. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_CMPMEM	This view displays the status of the compressed pages in the InnoDB buffer pool. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_CMPMEM_RESET	This view displays the status of the compressed pages in the InnoDB buffer pool after they are reset. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_SYS_DATAFILES	This view displays the data file paths of the InnoDB files for each table and general tablespace. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_SYS_INDEXES	This view displays the metadata of the InnoDB indexes. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_SYS_TABLES	This view displays the metadata of the InnoDB tables. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_SYS_TABLESPACES	This view displays the metadata of the InnoDB table files and general tablespaces. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_SYS_TABLESTATS	This view displays the low-level status information of the InnoDB tables. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_SYS_VIRTUAL	This view displays the metadata of the InnoDB virtual generated columns. Note This view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried.
information_schema.INNODB_TEMP_TABLE_INFO	This view displays information about InnoDB temporary tables created by users. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_METRICS	This view displays InnoDB performance information. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.PLUGINS	This view displays information about server plugins. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_SYS_COLUMNS	This view displays column information for each InnoDB table. Note This view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure.

View name	Description
mysql.func	This view shows information about user-defined functions (UDFs) created by using the `CREATE FUNCTION UDF` statement. Note This view is available only for MySQL 5.7 compatibility. Its underlying features are not supported, and the view can only be queried for schema information.

View	Description
oceanbase.DBA_OB_KV_TTL_TASKS	Displays the TTL tasks that are being executed in the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	This view displays the historical TTL tasks of the current tenant.

View	Description
oceanbase.DBA_OB_OUTLINES	This view displays the execution plan outline information of the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the Outline related information of the throttling rules of the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the outline history information about execution plans and throttling rules of the current tenant.

View name	Description
mysql.db	This view shows database-level permissions information (VIRTUAL_TABLE).
mysql.user	This view is available starting with 1.0.
information_schema.COLUMN_PRIVILEGES	This view displays column privileges.
information_schema.SCHEMA_PRIVILEGES	Description
information_schema.TABLE_PRIVILEGES	This view records table privileges.
information_schema.USER_PRIVILEGES	Displays user privileges.
mysql.procs_priv	This view stores the permission information of stored procedures.
mysql.role_edges	This view displays the grant relationships of roles and users.
mysql.default_roles	This view displays the default roles enabled for users.

View	Description
oceanbase.DBA_SQL_PLAN_BASELINES	This view displays SQL plans in the SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	This view displays the parameters in SPM.
oceanbase.DBA_OB_SPM_EVO_RESULT	This view displays the SPM evolution results of the current tenant.

View	Description
mysql.time_zone	This view displays time zone information (SYSTEM_VIEW).
mysql.time_zone_name	Records the timezone name (SYSTEM_VIEW).
mysql.time_zone_transition	`mysql.time_zone_transition` is a system view that records time zone transition information.
mysql.time_zone_transition_type	Type

View name	Description
information_schema.GLOBAL_STATUS	The information_schema.GLOBAL_STATUS view records the global status of OceanBase Database.
information_schema.GLOBAL_VARIABLES	This view records information about global variables.
information_schema.SCHEMATA	This view records the database meta information.
oceanbase.DBA_OB_DATABASES	This view displays the database information of a tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	This view displays the global compaction information of the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of each zone of the current tenant.
oceanbase.DBA_OB_FREEZE_INFO	This view displays the version information of the major_freeze process.

View name	Description
information_schema.SESSION_STATUS	This view records session status information, such as the number of active connections and the database uptime.
information_schema.SESSION_VARIABLES	Records session variables.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlock events. The view displays the history records of the current tenant in non-root tenants.

View name	Description
information_schema.INNODB_SYS_FIELDS	This view displays metadata about key columns (fields) of InnoDB indexes, which is equivalent to the information in the SYS_FIELDS table of the InnoDB data dictionary. Note This view is available starting with MySQL 5.7. You can query only the table structure.
information_schema.INNODB_FT_BEING_DELETED	This view displays information about full-text indexes being deleted. Note This view is available starting with MySQL 5.7. You can query only the table structure.
information_schema.INNODB_FT_CONFIG	This view displays configuration information about the InnoDB full-text search engine. Note This view is available starting with MySQL 5.7. You can query only the table structure.
information_schema.INNODB_FT_DELETED	This view displays information about full-text indexes marked for deletion. Note This view is available starting with MySQL 5.7. You can query only the table structure.
information_schema.INNODB_FT_INDEX_CACHE	This view displays cache status information about InnoDB full-text indexes. Note This view is available starting with MySQL 5.7. You can query only the table structure.

View name	Description
mysql.audit_log_filter	This view displays the definitions of audit filters.
mysql.audit_log_user	This view displays the mapping between audit filters and users.

View name	Description
oceanbase.DBA_WR_SQLSTAT	This view displays basic performance statistics of SQL statements executed in the current tenant. Each SQL statement is represented as a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).

View name	Description
oceanbase.DBA_WR_SYS_TIME_MODEL	This view displays WR data of Time Model statistics items in the current tenant.

View name	Description
oceanbase.DBA_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics for the current tenant.

View name	Description
oceanbase.DBA_WR_SYS_TIME_MODEL	Displays the WR data of the time model statistics in the current tenant.

View name	Description
oceanbase.DBA_TAB_STATISTICS	This view displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	This view displays column statistics and histogram information for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	This view displays the column statistics and histogram information of all partitioned tables in the current database.
oceanbase.DBA_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	This view displays histograms of all columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	This view displays histogram data on all partitioned tables in the database (the endpoints of each histogram).
oceanbase.DBA_SUBPART_HISTOGRAMS	This view displays histogram data (endpoints) for all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	This view displays the table statistics for all tables in the database.
oceanbase.DBA_IND_STATISTICS	This view displays the optimizer statistics of all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	This view displays the cumulative modification information about all tables in the database.
information_schema.QUERY_RESPONSE_TIME	Type
information_schema.OPTIMIZER_TRACE	This view displays information generated by the optimizer trace. Note This view is provided for MySQL 5.7 compatibility. The related features are not supported, and the view structure can be queried.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	This view queries the execution history of a statistics collection task.

View name	Description
oceanbase.DBA_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of the current tenant.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data of the current tenant.
oceanbase.DBA_WR_STATNAME	This view displays the names of the system statistics of the current tenant.
oceanbase.DBA_WR_SYSSTAT	This view displays the details of the system statistics of the current tenant.
oceanbase.DBA_WR_CONTROL	This view displays the WR-related configuration information.
oceanbase.DBA_WR_SYSTEM_EVENT	This view displays the tenant-level waiting event information of the current tenant.
oceanbase.DBA_WR_EVENT_NAME	This view displays the tenant-level waiting event names of the current tenant.
oceanbase.DBA_WR_SQLTEXT	This view displays the SQL texts collected by WR of the current tenant.

View name	Description
information_schema.INNODB_SYS_FOREIGN	This view displays the metadata information of InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table of the InnoDB data dictionary. Note This view is only for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried.
information_schema.INNODB_SYS_FOREIGN_COLS	This view displays the status information of InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table of the InnoDB data dictionary. Note This view is only for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried.

View name	Description
information_schema.PROCESSLIST	This view displays the information of running threads.

View name	Description
oceanbase.DBA_OB_SYS_VARIABLES	This view displays the configuration of system variables of the current tenant.

View name	Description
information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS	This view displays the number of failed login attempts for different users.

View	Description
oceanbase.DBA_OB_SEQUENCE_OBJECTS	This view displays all sequences in the database.

View name	Description
GV$OB_ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$OB_ACTIVE_SESSION_HISTORY	This view displays the active session history.

View name	Description
GV$OB_CGROUP_CONFIG	This view displays the cgroup configuration of an OBServer node.
V$OB_CGROUP_CONFIG	This view displays the cgroup configuration of an OBServer node.

View	Description
GV$OB_COMPACTION_PROGRESS	This view displays the major compaction progress of all OBServer nodes in the tenant.
GV$OB_COMPACTION_SUGGESTIONS	This view displays the compaction suggestions.
GV$OB_PROCESSLIST	This view displays the session information of all OBServer nodes in the tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	This view displays the compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information of tablet-level major compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress of tablet-level major compactions.
GV$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participant information of all OBServer nodes.
GV$SESSION_EVENT	This view displays the session-level waiting events of all OBServer nodes in the cluster.
GV$SESSION_WAIT	This view displays the information about the current or last waiting events of all sessions on all servers, including the waiting event name and waiting time.
GV$SESSION_WAIT_HISTORY	This view displays the information about the 10 most recent waiting events of all sessions on all servers.
GV$SYSTEM_EVENT	This view displays the waiting events at the tenant level in the cluster.
GV$SESSTAT	This view displays the session-level statistics of all OBServer nodes.
GV$SYSSTAT	This view displays the tenant-level statistics of all servers.
GV$ACTIVE_SESSION_HISTORY	This view displays the history of active sessions.
V$ACTIVE_SESSION_HISTORY	This view displays the history of active sessions.
V$OB_COMPACTION_PROGRESS	This view displays the major compaction progress of the server.
V$OB_COMPACTION_SUGGESTIONS	This view displays the compaction suggestions.
V$OB_PROCESSLIST	This view displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	This view displays the compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	This view displays the history of tablet-level major compactions.
V$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress of tablet-level major compactions.
V$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participants on all OBServer nodes.
V$STATNAME	This view displays the definitions of all statistics events.
V$EVENT_NAME	This view displays the definitions of all statistics events on the current OBServer node.
V$SESSION_WAIT	This view displays the details of the current wait events for each session. Each wait event has three parameters, which will be recorded with corresponding values.
V$SESSION_WAIT_HISTORY	This view displays the details of the current wait events for each session, including the last 10 wait events.
V$SESSTAT	This view displays the statistics events at the session level.
V$SYSSTAT	This view displays the statistics events at the tenant level on the current server.
V$SYSTEM_EVENT	This view displays the statistics events at the tenant level.
GV$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations on the current OBServer node.

View Name	Description
GV$OB_DTL_INTERM_RESULT_MONITOR	This view displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	This view displays the monitoring information of the DTL intermediate result manager.

View Name	Description
GV$OB_MEMORY	This view displays the memory statistics at the tenant level.
V$OB_MEMORY	This view displays the memory statistics at the tenant level.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
V$OB_MEMSTORE	This view displays the MemStore statistics at the tenant level.
GV$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
GV$OB_SSTABLES	This view displays the SSTable information for a tenant.
V$OB_SSTABLES	This view displays the SSTable information for a tenant.
GV$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the current observer process.
GV$OB_PL_CACHE_OBJECT	This view displays the basic information of PL-related cache objects for all tenants.
V$OB_PL_CACHE_OBJECT	This view displays the basic information of PL-related cache objects for the current tenant.

View Name	Description
GV$OB_KV_GROUP_COMMIT_STATUS	This view queries the status information of the current group commit.
V$OB_KV_GROUP_COMMIT_STATUS	This view queries the status information of the current group commit.

View Name	Description
GV$OB_PLAN_CACHE_STAT	This view displays the overall status of each plan cache for the current tenant on all OBServer nodes.
V$OB_PLAN_CACHE_STAT	This view records the overall status of each plan cache for the current tenant on all servers.
GV$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache for the current tenant on all servers.
V$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache for the current tenant on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache of all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache of the current server.
GV$OB_PS_STAT	This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
V$OB_PS_STAT	This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
GV$OB_PS_ITEM_INFO	This view provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	This view provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache.
GV$OB_SESSION_PS_INFO	This view displays the PS information opened by all sessions for the current tenant.
V$OB_SESSION_PS_INFO	This view displays the PS information opened by all sessions for the current OBServer tenant.
GV$OB_PX_TARGET_MONITOR	This view displays the PX thread usage on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	This view displays the PX thread usage on the OBServer node.
GV$OB_SQL_AUDIT	This view displays the statistics of each SQL request on all servers, including the source and execution status.
V$OB_SQL_AUDIT	This view displays the statistics of each SQL request on the current server, including the source and execution status.
GV$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistic, and the trace information of the plan is also recorded.
V$SQL_PLAN_MONITOR	This view displays the operation-level statistics of slow queries. Each operation has a corresponding statistic.
V$SQL_MONITOR_STATNAME	This view displays the meaning of the numeric values in the `OTHERSTAT_X_ID` column of the `GV$SQL_PLAN_MONITOR` view.
GV$OB_FLT_TRACE_CONFIG	This view displays the diagnostic information of full-link tracing.

View Name	Description
GV$OB_LOG_STAT	This view displays the status of Palf.
V$OB_LOG_STAT	This view displays the status of Palf.

View Name	Description
GV$OB_RPC_OUTGOING	This view displays the statistics of RPC packets sent by all OBServer nodes.
GV$OB_RPC_INCOMING	This view displays the statistics of RPC packets received by all OBServer nodes.
V$OB_RPC_OUTGOING	This view displays the statistics of RPC packets sent by different tenants on OBServer nodes.
V$OB_RPC_INCOMING	This view displays the statistics of RPC packets received by different tenants on OBServer nodes.

View name	Description
GV$OB_KVCACHE	This view displays KVCACHE information on all OBServer nodes.
GV$OB_PARAMETERS	This view displays the configuration information on all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO	This view displays the schema information on all servers.
GV$OB_UNITS	This view displays the unit information on the OBServer node where the tenant resides. The system tenant can view the unit information on all OBServer nodes in the cluster.
V$OB_KVCACHE	This view displays KVCACHE information on all OBServer nodes.
V$OB_PARAMETERS	This view displays the configuration information on the OBServer node where the tenant resides.
V$OB_SERVER_SCHEMA_INFO	This view displays the schema information on all servers.
V$OB_UNITS	This view displays the unit information on the OBServer node where the tenant resides.
GV$DML_STATS	This view displays the DML information in the current user table.
V$DML_STATS	This view displays the DML information in the current user table.
GV$OB_KV_CONNECTIONS	This view displays the statistics of the OBKV connections held by all servers.
V$OB_KV_CONNECTIONS	This view displays the statistics of the OBKV connections held by the current server.
V$OB_COMPATIBILITY_CONTROL	This view displays the features that can be controlled for compatibility with the OceanBase Database release version.

View name	Description
GV$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is displayed as a row (each unique value of `SQL_ID` + `Plan_Hash` is a row).
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is displayed as a row (each unique value of `SQL_ID` + `Plan_Hash` is a row).

View name	Description
GV$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level in the cluster.
V$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level on the current node.

View name	Description
GV$OB_MERGE_INFO	This view displays the statistics related to completed major compactions in the OceanBase cluster.
V$OB_MERGE_INFO	This view displays the statistics related to completed major compactions in the OceanBase cluster.

View name	Description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, this view displays the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, this view displays the execution information of each thread.

View name	Description
GV$SQL_WORKAREA	This view displays the workarea statistics of all operators executed under SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	This view displays the workarea information of the currently active operators.
GV$SQL_WORKAREA_HISTOGRAM	This view displays the statistics of all workarea executions, such as the number of times full in-memory processing occurred in the range of 1M to 2M and the number of one-pass operations.
GV$OB_SQL_WORKAREA_MEMORY_INFO	This view displays some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory.
V$SQL_WORKAREA	This view displays the workarea statistics of all operators executed under SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	This view displays the workarea information of the currently active operators.
V$SQL_WORKAREA_HISTOGRAM	This view displays the statistics of all workarea executions, such as the number of times full in-memory processing occurred in the range of 1M to 2M and the number of one-pass operations.
V$OB_SQL_WORKAREA_MEMORY_INFO	This view displays some overall information about the SQL workarea, including the maximum available memory, current used memory, and current held memory.

View name	Description
V$OB_ENCRYPTED_TABLES	This view displays the encryption status of tables with encryption enabled.
V$ENCRYPTED_TABLESPACES	This view displays the encryption status of tablespaces with encryption enabled.

View name	Description
GV$LATCH	This view displays the latch information of all OBServer nodes in the cluster.
V$LATCH	This view displays the latch information of all OBServer nodes in the cluster.

View name	Description
GV$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups in all OBServer nodes of the current tenant.
V$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups in all tenants on the current OBServer node.

View name	Description
DBA_OB_TABLE_SPACE_USAGE	This view displays the sizes of all user tables (based on the leader replica in a multi-replica environment) in the current tenant.
ALL_ALL_TABLES	This view displays the object tables and relational tables accessible to the user.
ALL_COL_COMMENTS	This view displays the column comments of all views and tables accessible to the user.
ALL_TABLES	This view displays all tables accessible to the user.
ALL_TAB_COLS	This view displays all columns of the tables, views, and clusters accessible to the current user.
ALL_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters accessible to the current user.
ALL_TAB_COMMENTS	This view displays the comments of the tables and views accessible to the current user.
DBA_COL_COMMENTS	This view displays the column comments of all views and tables in the database.
DBA_TAB_COMMENTS	This view displays the comments of all tables and views in the database.
USER_COL_COMMENTS	This view displays the column comments of all views and tables owned by the current user.
USER_TAB_COMMENTS	This view displays the comments of the tables and views owned by the current user.
DBA_OB_TABLEGROUP_TABLES	This view displays the association between TABLEGROUP and TABLE. It does not display tables not in a TABLEGROUP.
DBA_TABLES	This view displays all tables in the database.
DBA_ALL_TABLES	This view displays the object tables and relational tables in the database. Its fields are the same as those of ALL_ALL_TABLES.
DBA_TABLESPACES	This view displays all tablespaces in the database.
DBA_TAB_COLS	This view displays all columns of the tables, views, and clusters in the database.
DBA_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters in the database.
USER_ALL_TABLES	This view displays the object tables and relational tables accessible to the current user. Except for the OWNER field, its fields are the same as those of ALL_ALL_TABLES.
USER_TABLES	This view displays all tables owned by the current user.
USER_TABLESPACES	This view displays the tablespaces accessible to the current user. Its columns are the same as those of `DBA_TABLESPACES`, except for the `PLUGGED_IN` field.
USER_TAB_COLS	This view displays all columns of the tables, views, and clusters owned by the current user.
USER_TAB_COLUMNS	This view displays all columns of tables, views, and clusters owned by the current user.
ALL_VIEWS	This view displays all views accessible to the current user.
DBA_VIEWS	This view displays all views in the database. The columns are the same as those in the `ALL_VIEWS` view.
USER_VIEWS	This view displays views owned by the current user.
DICTIONARY	Description
DICT	Description
DBA_OB_TABLE_LOCATIONS	This view displays the locations of tables and partitions. Table and partition locations include system tables, user tables, and index tables, and so on.

View	Description
DBA_OB_OUTLINES	This view displays the outline information for all plans in the current tenant.
DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the outline information related to the throttling rules in the current tenant.
DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the history of execution plans and throttle rules of an outline for the current tenant.

View	Description
DBA_SQL_PLAN_BASELINES	This view displays the plan baselines for SQL in the SPM.
DBA_SQL_MANAGEMENT_CONFIG	This view displays the parameters for SQL Plan Management.
ALL_PLSQL_TYPE_ATTRS	Type

View name	Description
DBA_CONTEXT	This view displays information about all namespaces of the database.
DBA_OB_DATABASES	This view displays the database metadata of the tenant.
DBA_OB_MAJOR_COMPACTION	This view displays major compaction information of all major compaction tasks.
DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information for all zones of the current tenant.
ALL_OBJECTS	This view displays all database objects accessible to the current user.
DBA_OBJECTS	This view displays all database objects in the database.
USER_OBJECTS	This view displays all database objects of the current user.
ALL_DEPENDENCIES	This view displays the dependencies of objects in the database.
DBA_DEPENDENCIES	This view displays all the dependencies between objects in a database.
USER_DEPENDENCIES	This view displays dependency relationships between objects in the current user schema.
DBA_OB_FREEZE_INFO	This view displays the version information generated during a major freeze operation.
DBA_OB_SOURCE	This view displays the source code information of all storage objects in the current tenant.
USER_OB_SOURCE	This view displays source code information of storage objects owned by the current user.
ALL_OB_SOURCE	This view displays source code information of the storage objects accessible to the current user.

View name	Description
ALL_ARGUMENTS	This view displays the parameters of functions and procedures accessible to the current user.
ALL_PROCEDURES	This view displays all functions and procedures accessible to the current user and their related attributes.
ALL_SOURCE	This view displays the text source of stored objects accessible to the current user.
DBA_ARGUMENTS	This view displays the parameters of functions and procedures available in the database. The columns are the same as those in `ALL_ARGUMENTS`.
DBA_PROCEDURES	This view displays all functions and procedures available in the database and their related attributes. The columns are the same as those in `ALL_PROCEDURES`.
DBA_SOURCE	This view displays the text source of all stored objects in the database. The columns are the same as those in `ALL_SOURCE`.
USER_ARGUMENTS	This view displays the parameters of functions and procedures owned by the current user. The columns are the same as those in `ALL_ARGUMENTS`, but without the `OWNER` column.
USER_PROCEDURES	This view displays all functions and procedures owned by the current user and their related attributes. The columns are the same as those in `ALL_PROCEDURES`, but without the `OWNER` column.
USER_SOURCE	This view displays the text source of stored objects owned by the current user. The columns are the same as those in `ALL_SOURCE`, but without the `OWNER` column.
DBA_JOBS	This view displays an overview of submitted tasks.
USER_JOBS	This view displays an overview of submitted tasks.
DBA_JOBS_RUNNING	This view displays running tasks.

View name	Description
DBA_OB_BACKUP_JOBS	This view displays the backup jobs of the current tenant.
DBA_OB_BACKUP_JOB_HISTORY	This view displays the history of the backup jobs of the current tenant.
DBA_OB_BACKUP_TASKS	This view displays the task-level backup jobs of the current tenant.
DBA_OB_BACKUP_TASK_HISTORY	This view displays the history of the task-level backup jobs of the current tenant.
DBA_OB_BACKUP_SET_FILES	This view displays the status of the files in a backup set.
DBA_OB_RESTORE_PROGRESS	This view displays the progress of the ongoing restore tasks.
DBA_OB_RESTORE_HISTORY	This view displays the history of the completed restore tasks.
DBA_OB_ARCHIVE_DEST	This view displays the archive destination configuration.
DBA_OB_BACKUP_STORAGE_INFO	This view displays the information about the backup destination used for backup and restore in the current tenant.
DBA_OB_BACKUP_STORAGE_INFO_HISTORY	This view displays the history of the backup destination used for backup and restore in the current tenant.
DBA_OB_BACKUP_DELETE_POLICY	This view displays the deletion policy set for expired or automatic deletion in the current tenant.
DBA_OB_BACKUP_DELETE_JOBS	This view displays the execution progress of the tenant-level backup deletion jobs.
DBA_OB_BACKUP_DELETE_JOB_HISTORY	This view displays the history of the backup deletion jobs executed in the current tenant.
DBA_OB_BACKUP_DELETE_TASKS	This view displays the information about the backup_set/backup_piece deletion tasks being executed in the current tenant.
DBA_OB_BACKUP_DELETE_TASK_HISTORY	This view displays the history of the backup_set/backup_piece deletion tasks completed in the current tenant.
DBA_OB_ARCHIVELOG	This view displays the status of the log backups on each path.
DBA_OB_ARCHIVELOG_SUMMARY	This view displays the status of all log backups in the history and current time.
DBA_OB_ARCHIVELOG_PIECE_FILES	This view displays the status of the pieces in a backup set.
DBA_OB_BACKUP_PARAMETER	This view displays the backup parameters.
DBA_OB_RECOVER_TABLE_JOBS	This view displays information about table-level recovery tasks.
DBA_OB_IMPORT_TABLE_JOBS	This view displays information about import tasks.
DBA_OB_IMPORT_TABLE_TASKS	This view displays records of table-level import tasks.
DBA_OB_RECOVER_TABLE_JOB_HISTORY	This view displays the results of table-level recovery tasks.
DBA_OB_IMPORT_TABLE_JOB_HISTORY	This view displays the results of import tasks.
DBA_OB_IMPORT_TABLE_TASK_HISTORY	This view displays the history of cross-tenant table-level import tasks.

View name	Description
ALL_PART_COL_STATISTICS	This view displays the column statistics and histogram information of the partitions of the partitioned tables accessible to the current user.
ALL_PART_HISTOGRAMS	This view displays the histogram information of the partitions.
ALL_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information of the subpartitions of the partitioned tables accessible to the current user.
ALL_SUBPART_HISTOGRAMS	This view displays the histogram information of the subpartitions.
ALL_TAB_COL_STATISTICS	This view displays the column statistics and histogram information of the tables accessible to the current user.
ALL_TAB_HISTOGRAMS	This view displays the histogram information of the tables.
ALL_TAB_STATISTICS	This view displays the optimizer statistics of the tables accessible to the current user.
DBA_PART_COL_STATISTICS	This view displays the column statistics and histogram information of the partitions of the partitioned tables in the database.
DBA_PART_HISTOGRAMS	This view displays the histogram information of the partitions.
DBA_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information of the subpartitions of the partitioned tables in the database.
DBA_SUBPART_HISTOGRAMS	This view displays the histogram information of the subpartitions.
DBA_TAB_COL_STATISTICS	This view displays the column statistics and histogram information of all tables in the database.
DBA_TAB_HISTOGRAMS	This view displays the histogram information of the tables.
DBA_TAB_STATISTICS	This view displays the optimizer statistics of all tables in the database.
USER_PART_COL_STATISTICS	This view displays the column statistics and histogram information of the partitions of the partitioned tables of the current user.
USER_PART_HISTOGRAMS	This view displays the histogram information of the partitions.
USER_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information of the subpartitions of the partitioned tables of the current user.
USER_SUBPART_HISTOGRAMS	This view displays the histogram information of the subpartitions.
USER_TAB_COL_STATISTICS	This view displays the column statistics and histogram information of the tables of the current user.
USER_TAB_HISTOGRAMS	This view displays the histogram information of the tables.
USER_TAB_STATISTICS	This view displays the optimizer statistics of all tables of the current user.
ALL_TAB_STATS_HISTORY	This view displays the table statistics modification history of all tables accessible to the current user.
DBA_TAB_STATS_HISTORY	This view displays the table statistics modification history of all tables in the database.
USER_TAB_STATS_HISTORY	This view displays the table statistics modification history of all tables owned by the current user.
ALL_IND_STATISTICS	This view displays the optimizer statistics of indexes on all tables accessible to the current user.
DBA_IND_STATISTICS	This view displays the optimizer statistics of all indexes in the database.
USER_IND_STATISTICS	This view displays the optimizer statistics of indexes on all tables owned by the current user.
ALL_TAB_MODIFICATIONS	This view displays the cumulative modification information of all tables accessible to the current user.
DBA_TAB_MODIFICATIONS	This view displays the cumulative modification information of all tables in the database.
USER_TAB_MODIFICATIONS	This view displays the cumulative modification information of all tables owned by the current user.
DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	This view queries the historical execution of table statistics collection.

View	Description
ALL_USERS	This view displays all database users that are visible to the current user.
DBA_USERS	This view displays all users in the database.
USER_USERS	This view displays information about the current user.
ALL_COL_PRIVS	The current user is the owner of the object, the grantor, or the grantee. The grantor is an enabled role or PUBLIC. Column privileges granted to the current user.
ALL_TAB_PRIVS	The current user is the owner of the object, the grantor, or the grantee. The grantor is an enabled role or PUBLIC. Table privileges granted to the current user.
DBA_COL_PRIVS	This view displays all column privileges granted in the database.
DBA_SYS_PRIVS	This view displays system privileges granted to users and roles.
DBA_TAB_PRIVS	This view displays all object privileges granted in the database.
USER_TAB_PRIVS	This view displays object privileges owned by the current user.
USER_COL_PRIVS	This view displays column privileges granted to the current user as the owner, grantor, or grantee.
USER_ROLE_PRIVS	This view displays roles granted to the current user.
USER_SYS_PRIVS	This view displays system privileges granted to the current user.
ROLE_TAB_PRIVS	This view displays table privileges granted to roles. It provides information about roles that users can access.
ROLE_SYS_PRIVS	This view displays system privileges granted to roles.
ROLE_ROLE_PRIVS	This view displays roles granted to other roles. It provides information about roles that users can access.
DBA_ROLE_PRIVS	This view displays roles granted to all users and roles in the database.
DBA_ROLES	This view displays all roles in the database.
ALL_DIRECTORIES	This view displays all directories accessible to the current user.
DBA_DIRECTORIES	This view displays all directories accessible to the current user.

View Name	Description
ALL_CONSTRAINTS	This view displays constraint information for all tables accessible to the current user.
ALL_CONS_COLUMNS	This view displays column information for constraints in all tables accessible to the current user.
DBA_CONSTRAINTS	This view displays constraint information for all tables in the database.
DBA_CONS_COLUMNS	This view displays column information for constraints in all tables in the database.
USER_CONSTRAINTS	This view displays constraint information for all tables owned by the current user.
USER_CONS_COLUMNS	This view displays column information for constraints in all tables owned by the current user.

View Name	Description
ALL_DEF_AUDIT_OPTS	This view displays the audit conditions for which any object is audited by default.
AUDIT_ACTIONS	This view displays the Action ID and corresponding name in audit records.
DBA_AUDIT_EXISTS	This view displays audit trail entries generated by the `AUDIT EXISTS` and `AUDIT NOT EXISTS` statements.
DBA_AUDIT_OBJECT	This view displays audit trail records for all objects in the database.
DBA_AUDIT_SESSION	This view displays audit trail records for `CONNECT` and `DISCONNECT` operations.
DBA_AUDIT_STATEMENT	This view displays audit trail records for `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements in the database.
DBA_AUDIT_TRAIL	This view displays all audit trail entries.
DBA_OBJ_AUDIT_OPTS	This view displays detailed object-level audit configurations.
DBA_STMT_AUDIT_OPTS	This view displays detailed statement-level audit configurations.
STMT_AUDIT_OPTION_MAP	This view displays the type, name, and priority of statement-level audit options.
USER_AUDIT_OBJECT	This view displays audit trail records for objects accessible to the current user.
USER_AUDIT_SESSION	This view displays audit trail records for the connection and disconnection of the current user.
USER_AUDIT_STATEMENT	This view displays audit trail entries for `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements issued by the current user.
USER_AUDIT_TRAIL	This view displays standard audit trail entries related to the current user.

View Name	Description
ALL_INDEXES	This view displays the index column information of all tables accessible to the user.
ALL_IND_COLUMNS	This view displays the index column information of all tables accessible to the user.
ALL_IND_EXPRESSIONS	This view displays the information of function-based indexes accessible to the user in the database.
ALL_IND_PARTITIONS	This view displays the information of index partitions accessible to the user in the database.
ALL_IND_SUBPARTITIONS	This view displays the information of all index subpartitions accessible to the user in the database.
ALL_PART_INDEXES	This view displays the partition information of partition indexes accessible to the current user.
DBA_INDEXES	This view displays the index information of all tables in the database.
DBA_IND_COLUMNS	This view displays the index column information of all tables in the database.
DBA_IND_EXPRESSIONS	This view displays the information of all function-based indexes in the database.
DBA_IND_PARTITIONS	This view displays the information of all index partitions in the database.
DBA_IND_SUBPARTITIONS	This view displays the information of all index subpartitions in the database.
USER_INDEXES	This view displays the index information of all tables owned by the user.
USER_IND_COLUMNS	This view displays the index column information of all tables owned by the user.
USER_IND_EXPRESSIONS	This view displays the information of function-based indexes owned by the user in the database.
USER_IND_PARTITIONS	This view displays the information of index partitions owned by the current user in the database. This view does not contain the `INDEX_OWNER` column, unlike `ALL_IND_PARTITIONS` and `DBA_IND_PARTITIONS`.
USER_IND_SUBPARTITIONS	This view displays the information of all index subpartitions owned by the user in the database. This view does not contain the `INDEX_OWNER` column, unlike `DBA_IND_SUBPARTITIONS` and `ALL_IND_SUBPARTITIONS`.
USER_PART_INDEXES	This view displays the partition information of partition indexes owned by the current user.

View name	Description
ALL_PART_KEY_COLUMNS	This view displays the columns in the partitioning key for all partitioned objects available to the user.
ALL_PART_TABLES	This view displays the partitions of all partition tables that are accessible to the current user.
ALL_SUBPARTITION_TEMPLATES	Description
ALL_SUBPART_KEY_COLUMNS	This view displays all columns that are included in the subpartitioning key in the partitioned objects that the current user can access.
ALL_TAB_PARTITIONS	This view displays the subpartition information, storage parameters, and statistics of all partitioned tables.
ALL_TAB_SUBPARTITIONS	This view displays information, storage parameters, and statistics at the partition level for partitions generated by the `DBMS_STATS` package that are accessible to the current user.
DBA_PART_INDEXES	This view displays all partitioned index information.
DBA_PART_KEY_COLUMNS	This view displays the columns contained in the partitioning keys for all partitioning objects in the database.
DBA_PART_TABLES	This view displays partition information about partitioned tables that the current user can access.
DBA_SUBPARTITION_TEMPLATES	Description
DBA_SUBPART_KEY_COLUMNS	This view displays all columns of a subpartition key for all partitioned objects in the database.
DBA_TAB_PARTITIONS	This view displays all subpartitions, subpartition storage parameters, and partition statistics that are accessible to the current user.
DBA_TAB_SUBPARTITIONS	This view displays the names of subpartitions, the tables that they belong to, the names of the partitions they belong to, their storage attributes, and the statistics generated by the `DBMS_STATS` package.
USER_PART_KEY_COLUMNS	This view displays columns included in partition keys in all partitioned objects owned by the current user.
USER_PART_TABLES	This view displays the partition information of the current user's partitioned tables.
USER_SUBPARTITION_TEMPLATES	Description
USER_SUBPART_KEY_COLUMNS	This view displays all subpartition key columns of all partitioned objects owned by the current user.
USER_TAB_SUBPARTITIONS	This view displays the subpartition name, the table name, the partition that the subpartition belongs to, and the storage properties for each subpartition of tables that you own.
USER_TAB_PARTITIONS	This view displays information about, storage parameters, and statistics of the partitions for all tables and cluster tables of the current user.

View name	Description
DBA_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlocks for the current non-root tenant.

View	Description
ALL_SEQUENCES	This view displays all SEQUENCE objects accessible to the current user.
DBA_SEQUENCES	This view displays all SEQUENCE in the database.
USER_SEQUENCES	Displays all SEQUENCEs owned by the current user.
TENANT_VIRTUAL_GLOBAL_VARIABLE	This view displays the global variables of a tenant.
TENANT_VIRTUAL_SESSION_VARIABLE	This view displays the variables of a session.

View	Description
ALL_SYNONYMS	This view displays all synonyms accessible to the user.
DBA_SYNONYMS	This view displays all synonyms in the database.
USER_SYNONYMS	Displays synonyms owned by the current user.

View	Description
ALL_SYNONYMS	This view displays all synonyms accessible to the current user.
DBA_SYNONYMS	This view displays all synonyms in the database.
USER_SYNONYMS	This view displays synonyms owned by the current user.

View name	Description
ALL_SYNONYMS	Displays all synonyms that the user has access to.
DBA_SYNONYMS	Displays all synonyms in the database.
USER_SYNONYMS	Displays all synonyms owned by the current user.

View name	Description
ALL_TRIGGERS	Description
DBA_TRIGGERS	This view displays all triggers in the database.
USER_TRIGGERS	This view displays all triggers owned by the current user.

View	Description
DBA_RECYCLEBIN	This view displays information about all recycle bins.
USER_RECYCLEBIN	This view displays recycle bin information owned by the current user. The columns in this view are the same as those in `DBA_RECYCLEBIN` view, but the `OWNER` column is removed.

View name	Description
DBA_RSRC_GROUP_MAPPINGS	This view displays the mappings between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	This view displays the resource groups in the database.
DBA_RSRC_PLANS	This view displays all resource management plans that are defined in the database.
DBA_RSRC_PLAN_DIRECTIVES	This view displays details about every resource plan directive in the database.

View	Description
NLS_DATABASE_PARAMETERS	This view displays NLS parameters at the OceanBase Database tenant level.
NLS_INSTANCE_PARAMETERS	This view displays instance-level (tenant-level) NLS parameters.
NLS_SESSION_PARAMETERS	This view displays the NLS session parameters.

View name	Description
ALL_COLL_TYPES	Type
ALL_TYPES	Type
ALL_TYPE_ATTRS	Type
DBA_COLL_TYPES	Type
DBA_TYPES	Type
DBA_TYPE_ATTRS	Type
USER_COLL_TYPES	Type
USER_TYPES	Type
USER_TYPE_ATTRS	Type

View name	Description
ALL_ERRORS	This view displays errors of the storage objects that the user can access.
DBA_ERRORS	This view displays errors of the storage objects in the database.
USER_ERRORS	This view displays errors of the storage objects that the user can access.
DBA_SEGMENTS	This view displays storage information of all segments in the database.
USER_SEGMENTS	This view displays storage information of segments of the objects in the current user's schema.

View name	Description
ALL_PROFILES	This view displays all profiles and the limits of these profiles.
DBA_PROFILES	This view displays all profiles and the limits of these profiles.
USER_PROFILES	This view displays all profiles and the limits of these profiles.

View name	Description
DBA_OB_LS_LOCATIONS	This view displays the distribution of log stream (LS) replicas in the current tenant.
DBA_OB_TABLEGROUPS	This view displays the metadata of table groups, mainly the partition information of table groups.
DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partitions of the partitioned table groups.
DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partitions of the partitioned table groups.
DBA_OB_TABLET_REPLICAS	This view displays all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
DBA_OB_TABLET_TO_LS	This view displays all tablets in the current tenant and the log stream information to which each tablet belongs.
DBA_OB_LS	This view displays the status and recovery progress of log streams.
DBA_OB_LS_REPLICA_TASK_HISTORY	This view displays the history of disaster recovery tasks.

View name	Description
DBA_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of the current tenant.
DBA_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data of the current tenant.
DBA_WR_STATNAME	This view displays the names of the system statistics of the current tenant.
DBA_WR_SYSSTAT	This view displays the details of the system statistics of the current tenant.
DBA_WR_CONTROL	This view displays the WR-related configuration information.
DBA_WR_SYSTEM_EVENT	This view displays the tenant-level waiting event information of the current tenant.
DBA_WR_EVENT_NAME	This view displays the tenant-level waiting event names of the current tenant.
DBA_WR_SQLTEXT	This view displays the SQL texts collected by WR of the current tenant.

View name	Description
DBA_WR_SQLSTAT	This view displays the basic performance statistics of the SQL statements executed by the current tenant.

View name	Description
DBA_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of the current tenant.

View name	Description
DBA_OB_OBJECT_BALANCE_WEIGHT	This view displays all partitions with special weights set in the current user's tenant.
DBA_OB_TRANSFER_PARTITION_TASKS	This view displays the Transfer Partition tasks currently being processed in the current tenant.
DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the history of Transfer Partition tasks executed in the current tenant.

View name	Description
DBA_SCHEDULER_JOBS	This view displays the scheduler job information accessible to the current user.
DBA_SCHEDULER_PROGRAM	This view displays all scheduler information in the database.
DBA_SCHEDULER_JOB_RUN_DETAILS	This view displays all scheduler job information in the tenant.

View name	Description
ALL_DB_LINKS	This view displays all DBLINKs accessible to the current user.
DBA_DB_LINKS	This view displays all DBLINKs created in the current tenant.
USER_DB_LINKS	This view displays all DBLINKs created by the current user.

View	Purpose
ALL_METHOD_PARAMS	Type
ALL_SCHEDULER_JOB_ARGS	This view displays user-specified scheduler job arguments.
ALL_SCHEDULER_PROGRAM_ARGS	This view displays the user-accessible scheduler program arguments.
ALL_TYPE_METHODS	Type
DBA_METHOD_PARAMS	Type
DBA_SCHEDULER_JOB_ARGS	This view displays the parameter information of the scheduled jobs in the database.
USER_SCHEDULER_JOB_ARGS	This view displays the parameter information of scheduled jobs owned by the current user.
DBA_SCHEDULER_PROGRAM_ARGS	This view displays the Scheduler program arguments information.
USER_SCHEDULER_PROGRAM_ARGS	This view displays the parameters of programs for the current user.
DBA_TYPE_METHODS	Type
USER_TYPE_METHODS	Type

View	Purpose
ALL_PLSQL_TYPES	Type
ALL_PLSQL_COLL_TYPES	Type
ALL_PLSQL_TYPE_ATTRS	Type

View name	Description
GV$OB_ACTIVE_SESSION_HISTORY	This view displays the active session history.

View name	Description
GV$OB_KVCACHE	This view displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	This view displays the configuration information on all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO	This view displays the schema information on all servers.
V$OB_SERVER_SCHEMA_INFO	This view displays the schema information on all servers.
GV$OB_UNITS	This view displays the unit information on the OBServer node where the tenant resides. The system tenant can view the unit information on all OBServer nodes in the cluster.
GV$SYSSTAT	This view displays the system-level statistical events on all servers.
GV$DML_STATS	This view displays the DML information in the current user table.
V$DML_STATS	This view displays the DML information in the current user table.
V$GLOBALCONTEXT	This view displays the `CLIENT_IDENTIFIER` value of the global context attribute accessible by the current session.
V$OB_KVCACHE	This view displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	This view displays the configuration information on the current OBServer node.
V$SYSSTAT	This view displays the system-level statistical events on the current server.
V$OB_UNITS	This view displays the unit information on the current OBServer node.
V$VERSION	This view displays the names and versions of all components of the database product.
V$STATNAME	This view displays the names of statistical items.

View	Description
GV$INSTANCE	This view displays the status of the current database instance.
V$INSTANCE	This view displays the status of the current database instance.

GV$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache of all servers.
GV$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache of all servers for the current tenant.
GV$OB_PLAN_CACHE_STAT	This view records the overall status of the plan cache on all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache of the current server.
V$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache of the current server for the current tenant.
V$OB_PLAN_CACHE_STAT	This view records the overall status of the plan cache on all servers for the current tenant.
V$RSRC_PLAN	This view displays the resource management plan of the current active tenant.
GV$OB_PL_CACHE_OBJECT	This view displays the basic information of PL/SQL cache objects for all tenants.
V$OB_PL_CACHE_OBJECT	This view displays the basic information of PL/SQL cache objects for all tenants.

View name	Description
GV$OB_LOG_STAT	This view displays the status of the Palf.
V$OB_LOG_STAT	This view displays the status of the Palf.

View name	Description
GV$OB_PX_TARGET_MONITOR	This view displays the PX thread usage on all OBServer nodes.
GV$OB_PS_ITEM_INFO	This view provides monitoring information for prepared statements. It contains the basic information of all prepared statements in the PS cache.
GV$OB_PS_STAT	This view monitors the overall status of the PS cache, including the hit rate, memory usage, and the number of cached items.
GV$OB_DTL_INTERM_RESULT_MONITOR	This view displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	This view displays the monitoring information of the DTL intermediate result manager.
V$OB_PX_TARGET_MONITOR	This view displays the PX thread usage on the OBServer node.
V$OB_PS_ITEM_INFO	This view provides monitoring information for prepared statements. It contains the basic information of all prepared statements in the PS cache.
V$OB_PS_STAT	This view monitors the overall status of the PS cache, including the hit rate, memory usage, and the number of cached items.
V$SQL_MONITOR_STATNAME	This view displays the meaning of the numbers in the `OTHERSTAT_X_ID` field of `GV$SQL_PLAN_MONITOR`.

View name	Description
GV$OB_PROCESSLIST	This view displays session information on all OBServer nodes of the current tenant.
GV$SESSION_WAIT	This view displays information about the current or last wait event of all sessions on all servers, including the wait event name and wait time.
GV$SESSION_WAIT_HISTORY	This view displays information about the last 10 wait events of all sessions on all servers.
GV$SESSTAT	This view displays session-level statistics on all servers.
GV$ACTIVE_SESSION_HISTORY	This view displays the history of active sessions.
V$ACTIVE_SESSION_HISTORY	This view displays the history of active sessions.
V$NLS_PARAMETERS	This view displays NLS parameters at the session level.
V$OB_PROCESSLIST	This view displays session information on the current OBServer node.
V$SESSION_WAIT	This view displays information about the current or last wait event of all sessions on the current server, including the wait event name and wait time.
V$SESSION_WAIT_HISTORY	This view displays information about the last 10 wait events of all sessions on the current server.
V$SESSTAT	This view displays session-level statistics.
V$EVENT_NAME	This view displays event definitions under the current tenant.

View name	Description
GV$OB_CGROUP_CONFIG	This view is used to query the cgroup configuration of the OBServer.
V$OB_CGROUP_CONFIG	This view is used to query the cgroup configuration of the OBServer.

View name	Description
GV$OB_SQL_AUDIT	This view displays the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	This view displays the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistical record, and the trace information of the plan is also recorded.
V$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistical record, and the trace information of the plan is also recorded.
GV$OB_FLT_TRACE_CONFIG	This view displays the diagnostic information of end-to-end tracing.
GV$OB_SESSION_PS_INFO	This view displays the PS information opened by all sessions in the current tenant.
V$OB_SESSION_PS_INFO	This view displays the PS information opened by all sessions in the current OBServer tenant.

View name	Description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.

View name	Description
GV$SQL_WORKAREA	This view displays the workarea statistics of all operators executed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	This view displays the workarea information of the current active operators.
GV$SQL_WORKAREA_HISTOGRAM	This view displays the workarea statistics of all previous executions.
V$OB_SQL_WORKAREA_MEMORY_INFO	This view queries some overall information about the SQL workarea, including the maximum available memory, current used memory, and current held memory.
V$SQL_WORKAREA	This view displays the workarea statistics of all operators executed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	This view displays the workarea information of the current active operators.
V$SQL_WORKAREA_HISTOGRAM	This view displays the workarea statistics of all previous executions.

View	Description
GV$OB_COMPACTION_PROGRESS	This view displays the OBServer-level major compaction progress of the tenant.
GV$OB_COMPACTION_SUGGESTIONS	This view displays the major compaction suggestions.
GV$OB_COMPACTION_DIAGNOSE_INFO	This view displays the major compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	This view displays the history of major compactions at the tablet level.
GV$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress of major compactions at the tablet level.
GV$OB_TRANSACTION_PARTICIPANTS	This view displays the information about transaction participants on all OBServer nodes.
GV$SYSTEM_EVENT	This view displays the system-level wait events of the tenant on all servers, including the number of occurrences, wait time, and number of timeouts for each type of wait event.
GV$GLOBAL_TRANSACTION	This view displays the information about active global transactions.
V$OB_COMPACTION_PROGRESS	This view displays the server-level major compaction progress of the tenant.
V$OB_COMPACTION_SUGGESTIONS	This view displays the major compaction suggestions.
V$OB_COMPACTION_DIAGNOSE_INFO	This view displays the major compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	This view displays the history of major compactions at the tablet level.
V$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress of major compactions at the tablet level.
V$OB_TRANSACTION_PARTICIPANTS	This view displays the information about transaction participants on all OBServer nodes.
V$SYSTEM_EVENT	This view displays the system-level wait events of the tenant on the current server, including the number of occurrences, wait time, and number of timeouts for each type of wait event.
V$GLOBAL_TRANSACTION	This view displays the information about active global transactions.
GV$OB_GLOBAL_TRANSACTION	This view displays the information about all XA transactions in the cluster.
V$OB_GLOBAL_TRANSACTION	This view displays the information about all XA transactions whose original scheduler is the current node.

View name	Description
V$TIMEZONE_NAMES	This view displays the valid time zone names.

View name	Description
V$OB_ENCRYPTED_TABLES	This view displays the encryption status of tables with encryption enabled.
V$ENCRYPTED_TABLESPACES	This view displays the encryption status of tablespaces with encryption enabled.

View name	Description
GV$DBLINK	This view displays all database links ( `IN_TRANSACTION=YES` ) opened after the query session issuing this view. These database links must be committed or rolled back before they are closed.
V$DBLINK	This view displays all database links ( `IN_TRANSACTION=YES` ) opened after the query session issuing this view. These database links must be committed or rolled back before they are closed.

View name	Description
GV$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).

View name	Description
GV$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level in the cluster.
V$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level on the current node.

View name	Description
GV$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups in all OBServer nodes of the current tenant.
V$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups in all OBServer nodes of all tenants.

View name	Description
GV$DBLINK	This view displays all database links ( `IN_TRANSACTION=YES` ) opened after the query session issuing this view. These database links must be committed or rolled back before they are closed.
V$DBLINK	This view displays all database links ( `IN_TRANSACTION=YES` ) opened after the query session issuing this view. These database links must be committed or rolled back before they are closed.

View name	Description
GV$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).

View name	Description
GV$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level in the cluster.
V$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level on the current node.

View name	Description
GV$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups in all OBServer nodes of the current tenant.
V$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups in all OBServer nodes of all tenants.

Customer Stories

Documentation

System views overview

Overview of views in the sys tenant

Dictionary views overview

Views and columns

Note

Backup and restore

Partition related

Load balancing

Replica and log-related

Major compaction related

InnoDB

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

MyISAM storage engine

Note

Outline

OBKV

Privilege

Session

Index-related

Note

Note

Note

Note

Note

Audit-related

Statistics and histograms

Note

WR-related views

FOREIGN KEY

Note

Note

System variables

Tenant-related

Resource related

SPM Related

SPM-related

SPM-related

Overview of performance views

ASH-related statistics

Cgroup-related

Cache-related statistics

I/O-related statistics

Statistics of monitoring information

Statistics of encrypted tables

OBKV

Statistics related to encrypted tables

OBKV related

Statistics of log-related information

Event-related statistics

Statistics related to transactions

SQL-related statistics

Statistics related to databases

Statistics related to the Time Model

Network-related statistics

Workarea-related statistics

Thread-related statistics