System View Overview|V4.3.5| docs|Distributed Database

View name	Description
oceanbase.CDB_IND_COLUMNS	Displays the column information of all index tables.
oceanbase.CDB_INDEXES	Displays the INDEX information of all tenants.
oceanbase.CDB_TABLES	Displays the TABLE information of all tenants.
oceanbase.CDB_OB_TABLEGROUP_TABLES	Displays the association between TABLEGROUPs and TABLEs in all tenants. TABLEs not in any TABLEGROUP are not displayed.
oceanbase.CDB_TAB_COLS	Displays the column information of all table and view objects.
oceanbase.CDB_TAB_COLS_V$	Displays the column information of all table and view objects.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the association between TABLEGROUPs and TABLEs. TABLEs not in any TABLEGROUP are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays the columns in the partition keys of all partitioned objects.
oceanbase.DBA_SUBPART_KEY_COLUMNS	Displays the columns in the subpartition keys of all partitioned objects.
oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO	Displays the information about column checksum inconsistencies between the index table (including global and local index tables) and the primary table.
oceanbase.CDB_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.
information_schema.TABLESPACES	Displays information about tablespaces. Note This view is supported only for compatibility with MySQL 5.7. You can query only the table schemas from this view.

View name	Description
oceanbase.CDB_MVIEW_RUNNING_JOBS	Displays all materialized view-related tasks of all tenants, including refresh tasks and MLOG cleanup tasks.
oceanbase.DBA_MVIEW_DEPS	Displays the dependency relationships of materialized views of the current tenant.
oceanbase.DBA_MVIEW_LOGS	Displays the log information of materialized views.
oceanbase.DBA_MVIEW_RUNNING_JOBS	Displays all materialized view-related tasks of the current tenant, including refresh tasks and MLOG cleanup tasks.
oceanbase.DBA_MVIEWS	Displays the information of all materialized views.
oceanbase.DBA_MVREF_CHANGE_STATS	Displays the statistics of materialized view refreshes.
oceanbase.DBA_MVREF_RUN_STATS	Displays the information about each run of materialized view refreshes, where each run is identified by a refresh ID.
oceanbase.DBA_MVREF_STATS	Displays the basic timing statistics of materialized view refreshes.
oceanbase.DBA_MVREF_STATS_PARAMS	Displays the refresh statistics attribute associated with each materialized view.
oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS	Displays the system-level default values of statistics attributes for materialized view refresh history.
oceanbase.DBA_MVREF_STMT_STATS	Describes the information associated with refresh statements.

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

View name	Description
DBA_OB_ZONE_STORAGE	Displays information about the shared storage clusters configured on each zone.

View name	Description
oceanbase.DBA_OB_OUTLINES	Displays the outline information of the execution plans for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the outline information of the throttling rules for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the execution plan and throttling rule outline history information for the current tenant.

View name	Description
oceanbase.CDB_OB_DATABASES	Displays the database metadata of all tenants in the system tenant.
oceanbase.CDB_OB_MAJOR_COMPACTION	Displays the global major compaction information of all tenants in the system tenant.
oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of all zones of all tenants in the system tenant.
oceanbase.DBA_OB_DATABASES	Displays the database metadata of all tenants.
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the Root Service event history.
oceanbase.DBA_OB_SERVER_JOBS	Displays all tasks related to OBServer nodes.
oceanbase.DBA_OB_SERVERS	Displays the information about all OBServer nodes.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of all zones of the current tenant.
oceanbase.DBA_OB_ZONES	Displays the information about all zones.
oceanbase.CDB_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).
information_schema.events	Records all event information.

View name	Description
oceanbase.CDB_IND_PARTITIONS	Displays the primary partition information of indexed tables for all tenants.
oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES	Displays the information about dynamic partition tables for all tenants.
oceanbase.CDB_PART_INDEXES	Displays the partition information of indexed tables for all tenants.
oceanbase.CDB_PART_TABLES	Displays the partition information of partitioned tables for all tenants.
oceanbase.CDB_SUBPARTITION_TEMPLATES	Displays the secondary partition information of partitioned tables for all tenants.
oceanbase.CDB_TAB_PARTITIONS	Displays the primary partition information of partitioned tables for all tenants.
oceanbase.CDB_TAB_SUBPARTITIONS	Displays the secondary partition information of partitioned tables for all tenants.
oceanbase.DBA_IND_PARTITIONS	Displays the primary and secondary partition information of indexed tables.
oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES	Displays the information about dynamic partition tables of the current tenant.
oceanbase.DBA_PART_INDEXES	Displays the partition information of all partitioned indexes.
oceanbase.DBA_PART_TABLES	Displays the partition information of user tables.
oceanbase.DBA_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics that are accessible to the current user.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the name of a subpartition, the name of the table to which the subpartition belongs, the name of the partition to which the subpartition belongs, the storage attributes of the subpartition, and the statistics generated by the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays the description information of all subpartition templates.

View name	Description
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS	Displays all partition transfer tasks being processed by all tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the history of all partition transfer tasks executed by all tenants.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	Displays the partition transfer tasks being processed by the current tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the history of partition transfer tasks executed by the current tenant.

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

View name	Description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlock events. This view shows the history of all tenants in the root tenant.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlock events. This view shows the history of the current tenant in a non-root tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	Displays the history of OBServer node events.

View name	Description
oceanbase.CDB_OB_RESTORE_PROGRESS	Displays the 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 backup set pieces.
oceanbase.CDB_OB_BACKUP_SET_FILES	Displays the file status of backup sets.
oceanbase.CDB_OB_BACKUP_JOBS	Displays all backup jobs of all tenants in the cluster. Each initiated backup task records one job.
oceanbase.CDB_OB_BACKUP_JOB_HISTORY	Displays the history of all backup jobs of all tenants in the cluster.
oceanbase.CDB_OB_BACKUP_TASKS	Displays all task-level backup tasks of all tenants in the cluster. Each task record corresponds to one backup_set backup. The task records and job records are in a one-to-one correspondence.
oceanbase.CDB_OB_BACKUP_TASK_HISTORY	Displays the history of all task-level backup tasks of all tenants in the cluster.
oceanbase.DBA_OB_BACKUP_JOBS	Displays the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the history of the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the history of task-level backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the file status of backup sets.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays archive destination configurations.
oceanbase.CDB_OB_ARCHIVE_DEST	Displays archive destination configurations.
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	Displays the history of backup cleanup tasks executed in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS	Displays the information about backup_set/backup_piece cleanup tasks being executed in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of backup_set/backup_piece cleanup tasks completed in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_POLICY	Displays the cleanup policies for expired cleanup and automatic cleanup set in the tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO	Displays the backup destination information used for backup and restore in the tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of the backup destination information used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the backup destination information used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of the backup destination information used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup policies for expired cleanup and automatic cleanup set in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of backup cleanup tasks executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays the information about backup_set/backup_piece cleanup tasks being executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of backup_set/backup_piece cleanup tasks completed in the tenant.
oceanbase.DBA_OB_ARCHIVELOG	Displays the log backup status on each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all log backups, both historical and current.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of backup set pieces.
oceanbase.CDB_OB_ARCHIVELOG	Displays the log archiving status on each path.
oceanbase.CDB_OB_ARCHIVELOG_SUMMARY	Displays the status of all log archiving, both historical and current.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS	Displays information about table-level restore tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	Displays information about table-level restore tasks.
oceanbase.CDB_OB_IMPORT_TABLE_JOBS	Displays information about import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	Displays information about import tasks.
oceanbase.CDB_OB_IMPORT_TABLE_TASKS	Displays records of cross-tenant import tasks at the table level.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	Displays records of table-level import tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of table-level restore tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of table-level restore tasks.
oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY	Displays the results of import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	Displays the results of import tasks.
oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY	Displays the history of cross-tenant import tasks at the table level.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	Displays the history of cross-tenant import tasks at the table level.

View name	Description
oceanbase.DBA_TAB_STATISTICS	Displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays the column statistics and histogram information of all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays the column statistics and histogram information of all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information of all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays the histograms of all columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays the histogram endpoints of all partitions in all tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays the histogram endpoints of all subpartitions in all tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	Displays the table statistics history of all tables in the database.
oceanbase.DBA_IND_STATISTICS	Displays the optimizer statistics of all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the cumulative modification information of all tables in the database.
oceanbase.CDB_TAB_COL_STATISTICS	Displays the column-level statistics in the sys tenant.

View name	Description
oceanbase.DBA_OBJECTS	Displays all database objects. The view definition is the same as that of ALL_OBJECTS.
oceanbase.CDB_OBJECTS	Displays all objects of all tenants in the sys tenant.
oceanbase.DBA_OB_TENANTS	Displays the basic information of all tenants, including the sys tenant, user-created tenants (user tenants), and Meta tenants. You can distinguish the tenant types based on the `TENANT_TYPE` column.
oceanbase.DBA_OB_TENANT_JOBS	Displays the task information at the tenant level.
oceanbase.CDB_OB_SYS_VARIABLES	Displays the system variable information of all tenants in the sys tenant.

View name	Description
oceanbase.DBA_OB_RESOURCE_POOLS	Displays the resource pool information of all tenants.
oceanbase.DBA_OB_UNIT_JOBS	Displays all unit-related tasks.
oceanbase.DBA_OB_UNITS	Displays the unit information of all tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	Displays the unit specification information of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.

View name	Description
CDB_OB_RSRC_DIRECTIVES	Displays various resource configuration parameters in all tenants in the Resource Manager.

View name	Description
CDB_OB_STORAGE_IO_USAGE	Displays various I/O operations for object storage and cloud disks of all tenants.

View name	Description
oceanbase.CDB_OB_CS_REPLICA_STATS	Displays the progress of converting tablets to columnar storage in C logs on all OBServer nodes of all tenants.
oceanbase.CDB_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.CDB_OB_LS_LOCATIONS	Displays the distribution of LS replicas of all tenants.
oceanbase.CDB_OB_TABLEGROUPS	Displays the metadata of table groups of all tenants under the sys tenant. The metadata mainly includes the partition information of the table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	Displays the primary partition information of partitioned table groups of all tenants under the sys tenant.
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	Displays the secondary partition information of partitioned table groups of all tenants under the sys tenant.
oceanbase.CDB_OB_TABLET_TO_LS	Displays the tablet list and log stream information of the tablets of all tenants under the sys tenant.
oceanbase.CDB_OB_TABLET_REPLICAS	Displays the information about all tablet replicas of 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	Displays the primary partitioning key information of partitioned objects (partitioned tables and partitioned indexes) of all tenants.
oceanbase.CDB_SUBPART_KEY_COLUMNS	Displays the secondary partitioning key information of partitioned objects (partitioned tables and partitioned indexes) of all tenants.
oceanbase.DBA_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the primary partition information of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the secondary partition information of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUPS	Displays the metadata of table groups, mainly the partition information of the table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	Displays the information about all tablet replicas of 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	Displays the tablet list and log stream information of the tablets of the current tenant.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the distribution of LS replicas of the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO	Displays the information about the data inconsistencies among tablet replicas.
oceanbase.CDB_OB_LS	Displays the status and recovery progress of log streams.
oceanbase.DBA_OB_LS	Displays the status and recovery progress of log streams.

View name	Description
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY	Displays the ASH data of all tenants after it is persisted.
oceanbase.CDB_WR_CONTROL	Displays the WR-related configuration information.
oceanbase.CDB_WR_EVENT_NAME	Displays the tenant-level wait event names of all tenants after they are persisted.
oceanbase.CDB_WR_SNAPSHOT	Displays the `SNAPSHOT` information of all tenants.
oceanbase.CDB_WR_SQLSTAT	Displays the basic performance statistics of all SQL statements executed by all tenants. Each SQL statement is displayed on a separate row (i.e., each unique value of `SQL_ID` and `Plan_Hash` is on a separate row).
oceanbase.CDB_WR_SQLTEXT	Displays the SQL texts collected by WR for all tenants.
oceanbase.CDB_WR_STATNAME	Displays the names of all system statistics of all tenants.
oceanbase.CDB_WR_SYS_TIME_MODEL	Displays the WR data of all Time Model statistics of all tenants.
oceanbase.CDB_WR_SYSSTAT	Displays the details of all system statistics of all tenants.
oceanbase.CDB_WR_SYSTEM_EVENT	Displays the tenant-level wait event information of all tenants after it is persisted.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	Displays the ASH data of the current tenant after it is persisted.
oceanbase.DBA_WR_CONTROL	Displays the WR-related configuration information.
oceanbase.DBA_WR_EVENT_NAME	Displays the tenant-level wait event names of the current tenant after they are persisted.
oceanbase.DBA_WR_SNAPSHOT	Displays the `SNAPSHOT` information of the current tenant.
oceanbase.DBA_WR_SQLSTAT	Displays the basic performance statistics of all SQL statements executed by the current tenant. Each SQL statement is displayed on a separate row (i.e., each unique value of `SQL_ID` and `Plan_Hash` is on a separate row).
oceanbase.DBA_WR_SQLTEXT	Displays the SQL texts collected by WR for the current tenant.
oceanbase.DBA_WR_STATNAME	Displays the names of all system statistics of the current tenant.
oceanbase.DBA_WR_SYS_TIME_MODEL	Displays the WR data of all Time Model statistics of the current tenant.
oceanbase.DBA_WR_SYSSTAT	Displays the details of all system statistics of the current tenant.
oceanbase.DBA_WR_SYSTEM_EVENT	Displays the tenant-level wait event information of the current tenant after it is persisted.

View name	Description
information_schema.INNODB_SYS_FOREIGN	Displays the metadata of InnoDB foreign keys, which is equivalent to the SYS_FOREIGN table in the InnoDB data dictionary. Note This view is only compatible with MySQL 5.7. The related features are not supported. You can query only the table structure.
information_schema.INNODB_SYS_FOREIGN_COLS	Displays the status of InnoDB foreign key columns, which is equivalent to the SYS_FOREIGN_COLS table in the InnoDB data dictionary. Note This view is only compatible with MySQL 5.7. The related features are not supported. You can query only the table structure.

View name	Description
oceanbase.CDB_OB_KV_TTL_TASKS	Displays all the TTL tasks being executed in all tenants under the current system tenant.
oceanbase.CDB_OB_KV_TTL_TASK_HISTORY	Displays all the historical TTL tasks in all tenants under the current system tenant.
oceanbase.DBA_OB_KV_TTL_TASKS	Displays all the TTL tasks being executed in the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	Displays all the historical TTL tasks in the current tenant.
V$OB_KV_CLIENT_INFO	Displays the configuration parameters of all OBKV tenant client connections on the current node.
GV$OB_KV_CLIENT_INFO	Displays the configuration parameters of all OBKV tenant client connections.

View name	Description
GV$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$ACTIVE_SESSION_HISTORY	Displays the active session history.
GV$OB_ACTIVE_SESSION_HISTORY	Displays the active session history of all OBServer nodes across all tenants.
V$OB_ACTIVE_SESSION_HISTORY	Displays the active session history of the current OBServer node across all tenants.

View name	Description
V$OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partition table information of all tenants.

View name	Description
GV$OB_STORAGE_CACHE_TASKS	Displays cache task information for all tenants across all OBServer nodes.
V$OB_STORAGE_CACHE_TASKS	Displays cache task information for all tenants on the current OBServer node.
GV$OB_TABLET_LOCAL_CACHE	Displays the overall cache status for all tenants across all OBServer nodes.
V$OB_TABLET_LOCAL_CACHE	Displays the overall cache status for all tenants on the current OBServer node.
GV$OB_SERVER_STORAGE	Displays information about the object storage configured for shared storage clusters on all OBServer nodes.
V$OB_SERVER_STORAGE	Displays information about the object storage configured for shared storage clusters on the current OBServer node.

View name	Description
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.

View name	Description
GV$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information on the current OBServer node.
GV$OB_IO_CALIBRATION_STATUS	Displays the execution status of the I/O calibration task.
V$OB_IO_CALIBRATION_STATUS	Displays the execution status of the I/O calibration task.
GV$OB_IO_BENCHMARK	Displays the disk calibration data used by the I/O module.
V$OB_IO_BENCHMARK	Displays the disk calibration data used by the I/O module.

View name	Description
GV$OB_SS_LOCAL_CACHE	Displays the metrics of various types of cached data in the local cache of each OBServer node for all tenants in shared storage mode.
V$OB_SS_LOCAL_CACHE	Displays the metrics of various types of cached data in the local cache of the current OBServer node for all tenants in shared storage mode.
GV$OB_MEMORY	Displays the memory statistics of tenants.
V$OB_MEMORY	Displays the memory statistics of tenants.
GV$OB_MEMSTORE	Displays the memory usage of MemTables for all tenants on all servers.
V$OB_MEMSTORE	Displays the MemStore statistics of tenants.
GV$OB_MEMSTORE_INFO	Displays the details of MemTables for all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays the details of MemTables for all partitions of all tenants on all servers.
GV$OB_SSTABLES	Displays the information about the SSTables of tenants.
V$OB_SSTABLES	Displays the information about the SSTables of tenants.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

View name	Description
GV$OB_GROUP_IO_STAT	Displays the real-time status of each resource group on all OBServer nodes of all tenants.
GV$OB_FUNCTION_IO_STAT	Displays the function-level I/O statistics on all OBServer nodes of all tenants.
V$OB_GROUP_IO_STAT	Displays the real-time status of each resource group on the current OBServer node.
V$OB_FUNCTION_IO_STAT	Displays the function-level I/O statistics on the current OBServer node.

View name	Description
GV$OB_COMPACTION_PROGRESS	Displays the OBServer-level major compaction progress of the tenant.
GV$OB_COMPACTION_SUGGESTIONS	Displays the major compaction suggestions.
GV$OB_PROCESSLIST	Displays the session information of all OBServer nodes in the tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the major compaction diagnostics.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the tablet-level major compaction history.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the tablet-level major compaction progress.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participant information on all OBServer nodes.
GV$SESSION_EVENT	Displays the session-level wait events on all OBServer nodes in the cluster.
GV$SESSION_WAIT	Displays some information about the current or last wait event of all sessions on all servers, such as the wait event name and wait time.
GV$SESSION_WAIT_HISTORY	Displays the information about the last 10 wait events of all sessions on all servers.
GV$SYSTEM_EVENT	Displays the wait events of all tenants in the cluster.
GV$SESSTAT	Displays the session-level statistics of all OBServer nodes.
GV$SYSSTAT	Displays the tenant-level statistics of all servers.
V$OB_COMPACTION_PROGRESS	Displays the server-level major compaction progress of the tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays the major compaction suggestions.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the major compaction diagnostics.
V$OB_TABLET_COMPACTION_HISTORY	Displays the tablet-level major compaction history.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the tablet-level major compaction progress.
V$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participant information on all OBServer nodes.
V$STATNAME	Displays the definitions of all statistics.
V$EVENT_NAME	Displays the definitions of all statistics on the current OBServer node.
V$SESSION_WAIT	Displays the wait events of each session. Each wait event has three parameters, which record the corresponding values.
V$SESSION_WAIT_HISTORY	Displays the wait events of each session for the last 10 times.
V$SESSTAT	Displays the statistics of each session.
V$SYSSTAT	Displays the tenant-level statistics of the current server.
V$SYSTEM_EVENT	Displays the statistics of the wait events at the tenant level.
GV$SESSION_LONGOPS	Displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	Displays the execution status and progress of DDL operations on the current OBServer node.

View name	Description
GV$OB_PLAN_CACHE_STAT	Displays the overall status of each plan cache across all OBServer nodes in the current tenant.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache across all servers in the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache across all servers in the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache across all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	Monitors the overall status of the prepared statement (PS) cache, including hit rate, memory usage, and the number of cached items.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
GV$OB_PS_ITEM_INFO	Provides monitoring for prepared statements, including basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Provides monitoring for prepared statements, including basic information about all prepared statements in the PS cache.
GV$OB_PX_P2P_DATAHUB	Displays information about parallel execution data transfer operations.
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on OBServer nodes.
GV$OB_SQL_AUDIT	Displays statistics such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays statistics such as the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	Displays statistics about slow queries on all OBServer nodes at the plan level, including trace information for each slow query.
V$SQL_PLAN_MONITOR	Displays statistics about slow queries at the operation level, with each operation having its own statistics.
V$SQL_MONITOR_STATNAME	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	Displays diagnostic information about end-to-end tracing.

View name	Description
GV$OB_LOG_STAT	Displays the status of Palf.
GV$OB_LS_SNAPSHOTS	Displays the information about persistent log streams of all units.
V$OB_LOG_STAT	Displays the status of Palf.

View name	Description
GV$OB_RPC_OUTGOING	Displays the statistics about RPCs sent to all OBServer nodes.
GV$OB_RPC_INCOMING	Displays the statistics about RPC requests received from all OBServer nodes.
V$OB_RPC_OUTGOING	Displays the statistics about RPC data sent to different RPC packet codes for different tenants on OBServer nodes.
V$OB_RPC_INCOMING	Displays the statistics about RPC data received from different RPC packet codes for different tenants on OBServer nodes.

View name	Description
GV$OB_SESSION	Records the information about all sessions created in the server.

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes where the tenant is located.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_SERVERS	Displays the information on all OBServer nodes.
GV$OB_UNITS	Displays the unit information on the OBServer nodes where the tenant is located. The system tenant can view the unit information on all OBServer nodes in the cluster.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the parameter information on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_SERVERS	Displays the information on the current OBServer node.
V$OB_UNITS	Displays the unit information on the current OBServer node.
GV$DML_STATS	Displays the DML information in the current user table.
V$DML_STATS	Displays the DML information in the current user table.
V$OB_COMPATIBILITY_CONTROL	Displays the information about all the features that can be controlled for product behavior compatibility with the release version of OceanBase Database.

View name	Description
GV$OB_MERGE_INFO	Displays statistics about completed major compactions in the OceanBase cluster.
V$OB_MERGE_INFO	Displays statistics about completed major compactions in the OceanBase cluster.

View name	Description
GV$OB_PX_WORKER_STAT	Displays information about each thread in parallel execution scenarios.
V$OB_PX_WORKER_STAT	Displays information about each thread in parallel execution scenarios.
GV$OB_TENANT_RUNTIME_INFO	Displays information about queue and thread limits in tenant threads.
V$OB_TENANT_RUNTIME_INFO	Displays information about queue and thread limits in tenant threads.

View name	Description
GV$SQL_WORKAREA	Statistics of workareas for all operators executed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	Information about workareas for the currently active operator.
GV$SQL_WORKAREA_HISTOGRAM	Statistics about the execution of all workareas, such as the number of times full in-memory processing and one-pass processing occurred in the range of 1 M to 2 M.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Information about the overall SQL workarea, such as the maximum available memory, current used memory, and current held memory.
V$SQL_WORKAREA	Statistics of workareas for all operators executed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	Information about workareas for the currently active operator.
V$SQL_WORKAREA_HISTOGRAM	Statistics about the execution of all workareas, such as the number of times full in-memory processing and one-pass processing occurred in the range of 1 M to 2 M.
V$OB_SQL_WORKAREA_MEMORY_INFO	Information about the overall SQL workarea, such as the maximum available memory, current used memory, and current held memory.

View name	Description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	Displays the histogram of query execution times for all nodes and all tenants.
GV$OB_RES_MGR_SYSSTAT	Displays the statistics of resource groups on all OBServer nodes for all tenants.
GV$OB_SESS_TIME_MODEL	Displays the time model statistics at the session level in the cluster.
GV$OB_SQLSTAT	Displays the basic performance statistics of SQL in the cluster. Each SQL statement is displayed as a row (each unique value of `SQL_ID` + `Plan_Hash`).
GV$OB_SYS_TIME_MODEL	Displays the time model statistics at the tenant level in the cluster.
V$OB_QUERY_RESPONSE_TIME_HISTOGRAM	Displays the histogram of query execution times for the current node and all tenants.
V$OB_RES_MGR_SYSSTAT	Displays the statistics of resource groups on the current OBServer node for all tenants.
V$OB_SESS_TIME_MODEL	Displays the time model statistics at the session level on the current node.
V$OB_SQLSTAT	Displays the basic performance statistics of SQL on the current node. Each SQL statement is displayed as a row (each unique value of `SQL_ID` + `Plan_Hash`).
V$OB_SYS_TIME_MODEL	Displays the time model statistics at the tenant level on the current node.

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

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

View name	Description
mysql.help_topic	Collaborates with the other three tables `mysql.help_category`, `mysql.help_relation`, and `mysql.help_keyword` to generate help commands.
mysql.help_category	Collaborates with the other three tables `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_keyword` to generate help commands.
mysql.help_keyword	Collaborates with the other three tables `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_category` to generate help commands.
mysql.help_relation	Collaborates with the other three tables `mysql.help_category`, `mysql.help_topic`, and `mysql.help_keyword` to generate help commands.

View name	Description
oceanbase.DBA_SQL_PLAN_BASELINES	Displays the SQL plan baselines in SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

View name	Description
mysql.db	Displays database-level privileges (VIRTUAL_TABLE).
mysql.user	Records user-level privileges (VIRTUAL_TABLE).
information_schema.COLUMN_PRIVILEGES	Displays column privileges.
information_schema.SCHEMA_PRIVILEGES	Describes database privileges.
information_schema.TABLE_PRIVILEGES	Records table privileges.
information_schema.USER_PRIVILEGES	Records user privileges.

View name	Description
oceanbase.DBA_OB_KV_TTL_TASKS	Displays the current tenant's running TTL tasks.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	Displays the current tenant's historical TTL tasks.
V$OB_KV_CLIENT_INFO	Displays the configuration parameters of the current OBKV tenant's client connections on the current node.
GV$OB_KV_CLIENT_INFO	Displays the configuration parameters of the current OBKV tenant's client connections.

View name	Description
oceanbase.DBA_SCHEDULER_JOBS	Displays information about all scheduler jobs in the database.

View name	Description
mysql.proc	Displays information about stored procedures.
information_schema.ENGINES	Records information about storage engines.
information_schema.PARAMETERS	Provides information about the parameters and return values of stored procedures.
information_schema.ROUTINES	Provides information about stored procedures.

View name	Description
mysql.time_zone	Displays information about time zones (SYSTEM_VIEW).
mysql.time_zone_name	Records the names of time zones (SYSTEM_VIEW).
mysql.time_zone_transition	Records information about time zone transitions.
mysql.time_zone_transition_type	Records information about time zone transition types (SYSTEM_VIEW).

View name	Description
information_schema.CHARACTER_SETS	Records the character set information of OceanBase Database.
information_schema.COLLATIONS	Records the collation method information of each character set.
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY	Records the correspondence between character and collation.

View name	Description
information_schema.COLUMNS	Records column information.
information_schema.STATISTICS	Records table index information.
information_schema.TABLES	Records table information.
information_schema.VIEWS	Records view information.
information_schema.VIEW_TABLE_USAGE	Displays the tables and views used in the view definition.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the association between TABLEGROUPs and TABLEs. It does not display TABLEs that are not in any TABLEGROUP.
oceanbase.DBA_PART_KEY_COLUMNS	Displays the columns that contain the partitioning key in all partitioned objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	Displays the columns that contain the subpartitioning key in all partitioned objects in the database.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the location of a table or partition, including system tables, user tables, and index tables.
information_schema.TABLESPACES	Displays information about tablespaces. Note This view is only for compatibility with MySQL 5.7. The related features are not supported. You can query only the table structure.

View name	Description
oceanbase.DBA_MVIEW_DEPS	Displays the dependencies of materialized views in the current tenant.
oceanbase.DBA_MVIEW_LOGS	Displays the information about materialized view logs.
oceanbase.DBA_MVIEW_RUNNING_JOBS	Displays the materialized view-related tasks that are being performed in the current tenant, such as refresh tasks and MLOG cleanup tasks.
oceanbase.DBA_MVIEWS	Displays the information about all materialized views.
oceanbase.DBA_MVREF_CHANGE_STATS	Displays the statistics about materialized view refreshes.
oceanbase.DBA_MVREF_RUN_STATS	Displays the information about each run of a materialized view refresh. Each run is identified by a REFRESH_ID.
oceanbase.DBA_MVREF_STATS	Displays the basic timing statistics about materialized view refreshes.
oceanbase.DBA_MVREF_STATS_PARAMS	Displays the refresh statistics attributes associated with each materialized view.
oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS	Displays the system-level default values of the statistics attributes of the materialized view refresh history.
oceanbase.DBA_MVREF_STMT_STATS	Displays the information about the statements that are used for materialized view refreshes.

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

View name	Description
oceanbase.DBA_OB_OUTLINES	Displays the execution plan outline information of the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the throttling rule outline information of the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the execution plan and throttling rule outline history information of the current tenant.

View name	Description
information_schema.GLOBAL_STATUS	Records the global status information of OceanBase Database.
information_schema.GLOBAL_VARIABLES	Records the global variable information.
information_schema.SCHEMATA	Records the database metadata.
oceanbase.DBA_OB_DATABASES	Displays the metadata of the tenant's databases.
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the global information of the current tenant's major compactions.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of each zone in the current tenant.
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).
information_schema.events	Records all event information.

View name	Description
information_schema.PARTITIONS	Records partition information.
oceanbase.DBA_IND_PARTITIONS	Displays the primary and subpartition information of indexes.
oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES	Displays the information about dynamic partition tables in the current tenant.
oceanbase.DBA_PART_INDEXES	Displays the partition information of all partitioned indexes.
oceanbase.DBA_PART_TABLES	Displays the partition information of user tables.
oceanbase.DBA_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics of the current user.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the name of subpartitions, tables, and their parent partitions, their storage attributes, and statistics generated by the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays the description information of all subpartition templates.

View name	Description
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	Displays the transfer partition tasks being processed in the current tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the history of transfer partition tasks executed in the current tenant.

View name	Description
information_schema.PROCESSLIST	Displays information about running threads.

View name	Description
information_schema.CHECK_CONSTRAINTS	Displays constraint information related to tables and columns during `CREATE TABLE` operations.
information_schema.KEY_COLUMN_USAGE	Records constraint information about keys in columns.
information_schema.REFERENTIAL_CONSTRAINTS	Displays metadata about foreign key constraints.
information_schema.TABLE_CONSTRAINTS	Describes table constraints.

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

View name	Description
information_schema.SESSION_STATUS	Records the status of the session, such as the number of active connections and the database uptime.
information_schema.SESSION_VARIABLES	Records the variables of the session.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlock events. In a non-root tenant, this view displays the history of the current tenant.

View name	Description
information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS	Displays the number of failed login attempts for different users.

View name	Description
oceanbase.DBA_OB_BACKUP_JOBS	Displays backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the history of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the history of task-level backup tasks.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the file status of a backup set.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the configuration of archive paths.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays information about backup destinations used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup policies configured for expired data cleanup or automatic cleanup in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of backup cleanup jobs in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of backup cleanup tasks in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays the information about backup_set/backup_piece cleanup tasks being executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of backup_set/backup_piece cleanup tasks completed in the tenant.
oceanbase.DBA_OB_ARCHIVELOG	Displays the log backup status on each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all log backups, both historical and current.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in a backup set.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	Displays information about table-level restore tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	Displays information about import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	Displays records of table-level import tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of table-level restore tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	Displays the results of import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	Displays the history of cross-tenant table-level import tasks.

View name	Description
oceanbase.DBA_TAB_STATISTICS	Displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays the column statistics and histogram information of all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays the column statistics and histogram information of all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information of all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays the histograms of all columns in all tables.
oceanbase.DBA_PART_HISTOGRAMS	Displays the histogram data (endpoints) of all histograms on all partitioned tables.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays the histogram data (endpoints) of all histograms on all subpartitioned tables.
oceanbase.DBA_TAB_STATS_HISTORY	Displays the table statistics history of all tables in the database.
oceanbase.DBA_IND_STATISTICS	Displays the optimizer statistics of all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the cumulative modification information of all tables in the database.
information_schema.QUERY_RESPONSE_TIME	Displays the data types (histograms) such as the response time histogram for monitoring by Prometheus.

View name	Description
oceanbase.DBA_OBJECTS	Displays all database objects. The view definition is the same as that of ALL_OBJECTS.
oceanbase.DBA_OB_TENANTS	Displays the basic information of all tenants, including the sys tenant, user-created tenants (user tenants), and Meta tenants. You can use the `TENANT_TYPE` column to identify the tenant type.

View name	Description
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.

View name	Description
DBA_OB_RSRC_DIRECTIVES	Displays the various resource configuration parameters in the Resource Manager for the current tenant.
DBA_OB_RSRC_IO_DIRECTIVES	Displays the I/O resource configuration in the Resource Manager for the current tenant.
DBA_RSRC_GROUP_MAPPINGS	Displays the binding relationships between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	Displays the information about all resource groups in the database.
DBA_RSRC_PLANS	Displays all resource management plans defined in the system.
DBA_RSRC_PLAN_DIRECTIVES	Displays the detailed information about each resource plan directive in the database.

View name	Description
DBA_OB_STORAGE_IO_USAGE	Displays the various I/O operations of object storage and cloud disks of the current tenant.

View name	Description
oceanbase.DBA_OB_CS_REPLICA_STATS	Displays the progress of converting tablets into columnar storage in C logs of all OBServer nodes of the current tenant.
oceanbase.DBA_IND_SUBPARTITIONS	Displays the information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the primary partition information of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the secondary partition information of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUPS	Displays the metadata of table groups, mainly the partition information of table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	Displays all tablet replicas of the current tenant. Each tablet replica is uniquely identified by the joint key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	Displays all tablet lists and log stream information of the current tenant.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the replica distribution information of log streams (LS) of the current tenant.

View name	Description
oceanbase.DBA_WR_SNAPSHOT	Displays the `SNAPSHOT` information of the current tenant.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	Displays the persistent ASH data of the current tenant.
oceanbase.DBA_WR_STATNAME	Displays the names of system statistics of the current tenant.
oceanbase.DBA_WR_SYSSTAT	Displays the details of system statistics of the current tenant.
oceanbase.DBA_WR_CONTROL	Displays the WR-related configuration information.
oceanbase.DBA_WR_SYSTEM_EVENT	Displays the persistent tenant-level wait event information of the current tenant.
oceanbase.DBA_WR_EVENT_NAME	Displays the persistent tenant-level wait event names of the current tenant.
oceanbase.DBA_WR_SQLTEXT	Displays the SQL texts collected by WR in the current tenant.
oceanbase.DBA_WR_SQLSTAT	Displays the basic performance statistics of the SQL statements executed in the current tenant. Each SQL statement is displayed in a row (i.e., each unique value of `SQL_ID` + `Plan_Hash` is displayed in a row).
oceanbase.DBA_WR_SYS_TIME_MODEL	Displays the Time Model statistics of the current tenant.

View name	Description
information_schema.INNODB_SYS_FOREIGN	Displays the metadata about InnoDB foreign keys, which is equivalent to the SYS_FOREIGN table in the InnoDB data dictionary. Note This view is only compatible with MySQL 5.7. The related features are not supported, and you can only query the table structure.
information_schema.INNODB_SYS_FOREIGN_COLS	Displays the status of InnoDB foreign key columns, which is equivalent to the SYS_FOREIGN_COLS table in the InnoDB data dictionary. Note This view is only compatible with MySQL 5.7. The related features are not supported, and you can only query the table structure.

View name	Description
GV$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$OB_ACTIVE_SESSION_HISTORY	Displays the active session history of the current OBServer node in the tenant.
GV$OB_ACTIVE_SESSION_HISTORY	Displays the active session history of all OBServer nodes in the tenant.

View name	Description
V$OB_DYNAMIC_PARTITION_TABLES	Displays the information about dynamic partition tables in the current tenant.

View name	Description
GV$OB_STORAGE_CACHE_TASKS	Displays the cache task information in all OBServer nodes of the current tenant.
V$OB_STORAGE_CACHE_TASKS	Displays the cache task information in the current OBServer node of the current tenant.
GV$OB_TABLET_LOCAL_CACHE	Displays the overall cache information in all OBServer nodes of the current tenant.
V$OB_TABLET_LOCAL_CACHE	Displays the overall cache information in the current OBServer node of the current tenant.

View name	Description
GV$OB_COMPACTION_PROGRESS	Displays the OBServer-level major compaction progress of the tenant.
GV$OB_COMPACTION_SUGGESTIONS	Displays the major compaction suggestions.
GV$OB_PROCESSLIST	Displays the session information of all OBServer nodes where the tenant is located.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the major compaction diagnostics.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the major compaction history at the tablet level.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the major compaction progress at the tablet level.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participant information on all OBServer nodes.
GV$SESSION_EVENT	Displays the session-level wait events on all OBServer nodes in the cluster.
GV$SESSION_WAIT	Displays some 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	Displays the information about the last 10 wait events on all sessions on all servers.
GV$SYSTEM_EVENT	Displays the wait events at the tenant level of all tenants in the cluster.
GV$SESSTAT	Displays the session-level statistics on all OBServer nodes.
GV$SYSSTAT	Displays the tenant-level statistics on all servers.
V$OB_COMPACTION_PROGRESS	Displays the server-level major compaction progress of the tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays the major compaction suggestions.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the major compaction diagnostics.
V$OB_TABLET_COMPACTION_HISTORY	Displays the major compaction history at the tablet level.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the major compaction progress at the tablet level.
V$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participant information on all OBServer nodes.
V$STATNAME	Displays the definitions of all statistics.
V$EVENT_NAME	Displays the definitions of all statistics on the current OBServer node.
V$SESSION_WAIT	Displays the current wait events of each session. Each wait event has three parameters, and each parameter records the corresponding value.
V$SESSION_WAIT_HISTORY	Displays the current wait events of each session and the last 10 wait events.
V$SESSTAT	Displays the statistics of each session.
V$SYSSTAT	Displays the tenant-level statistics on the current server.
V$SYSTEM_EVENT	Displays the wait events at the tenant level.
GV$SESSION_LONGOPS	Displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	Displays the execution status and progress of DDL operations on the current OBServer node.

View name	Description
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.

View name	Description
GV$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information of all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information of the current OBServer node.

View name	Description
GV$OB_SS_LOCAL_CACHE	Displays the metrics of various cache data in the local cache of all tenants on each OBServer node in shared storage mode.
V$OB_SS_LOCAL_CACHE	Displays the metrics of various cache data in the local cache of all tenants on the current OBServer node in shared storage mode.
GV$OB_MEMORY	Displays the memory statistics of tenants.
V$OB_MEMORY	Displays the memory statistics of tenants.
GV$OB_MEMSTORE	Displays the memory usage of MemTables for all tenants on all servers.
V$OB_MEMSTORE	Displays the MemStore statistics of tenants.
GV$OB_MEMSTORE_INFO	Displays the details of all MemTables of all partitions for all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays the details of all MemTables of all partitions for all tenants on all servers.
GV$OB_SSTABLES	Displays the SSTable information of tenants.
V$OB_SSTABLES	Displays the SSTable information of tenants.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

View name	Description
GV$OB_GROUP_IO_STAT	Displays the real-time status of each resource group on all OBServer nodes of the current tenant.
GV$OB_FUNCTION_IO_STAT	Displays the I/O statistics at the function level on all OBServer nodes of the current tenant.
V$OB_GROUP_IO_STAT	Displays the real-time status of each resource group on the current OBServer node.
V$OB_FUNCTION_IO_STAT	Displays the I/O statistics at the function level on the current OBServer node.

View name	Description
GV$OB_PLAN_CACHE_STAT	Displays the outline information of the current tenant, which is mainly used for outline migration.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers of the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache of all servers of the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache of the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache on all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	Monitors the overall status of the prepared statement (PS) cache, including hit rate, memory usage, and the number of cached items.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
GV$OB_PS_ITEM_INFO	Provides monitoring for prepared statements, including basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Provides monitoring for prepared statements, including basic information about all prepared statements in the PS cache.
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on OBServer nodes.
GV$OB_SQL_AUDIT	Displays statistics such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays statistics such as the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	Displays statistics about slow queries on all OBServer nodes at the plan level, including trace information for each plan.
V$SQL_PLAN_MONITOR	Displays statistics about slow queries at the operation level.
V$SQL_MONITOR_STATNAME	Displays the meaning of the numbers in the `OTHERSTAT_X_ID` field of the `GV$SQL_PLAN_MONITOR` view.
GV$OB_FLT_TRACE_CONFIG	Displays diagnostic information about end-to-end tracing.

View name	Description
GV$OB_LOG_STAT	Displays the status of Palf.
V$OB_LOG_STAT	Displays the status of Palf.

View name	Description
GV$OB_RPC_OUTGOING	Displays the statistics of RPCs sent to all OBServer nodes.
GV$OB_RPC_INCOMING	Displays the statistics of RPC requests received by all OBServer nodes.
V$OB_RPC_OUTGOING	Displays the statistics of RPC data sent to all tenants on OBServer nodes, based on different RPC packet codes.
V$OB_RPC_INCOMING	Displays the statistics of RPC data received by all tenants on OBServer nodes, based on different RPC packet codes.

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes where the tenant is located.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_UNITS	Displays the unit information on the OBServer nodes where the tenant is located. The sys tenant can view the unit information on all OBServer nodes in the cluster.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the parameter information on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_UNITS	Displays the unit information on the current OBServer node.
GV$DML_STATS	Displays the DML information in the current user table.
V$DML_STATS	Displays the DML information in the current user table.
V$OB_COMPATIBILITY_CONTROL	Displays the features that can be controlled for product behavior compatibility with the OceanBase Database release version.

View name	Description
GV$OB_MERGE_INFO	Displays statistics about completed compactions in the OceanBase cluster.
V$OB_MERGE_INFO	Displays statistics about completed compactions in the OceanBase cluster.

View name	Description
GV$OB_PX_WORKER_STAT	Displays the execution information of each thread in parallel execution scenarios.
V$OB_PX_WORKER_STAT	Displays the execution information of each thread in parallel execution scenarios.

View name	Description
GV$SQL_WORKAREA	Statistics about the workarea of all operators whose execution was managed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	Statistics about the workarea of the currently active operator.
GV$SQL_WORKAREA_HISTOGRAM	Statistics about the execution of all workareas, such as the number of times full in-memory processing and one-pass processing occurred in the range of 1 M to 2 M.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Information about the overall SQL workarea, such as the maximum available memory, current used memory, and current held memory.
V$SQL_WORKAREA	Statistics about the workarea of all operators whose execution was managed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	Statistics about the workarea of the currently active operator.
V$SQL_WORKAREA_HISTOGRAM	Statistics about the execution of all workareas, such as the number of times full in-memory processing and one-pass processing occurred in the range of 1 M to 2 M.
V$OB_SQL_WORKAREA_MEMORY_INFO	Information about the overall SQL workarea, such as the maximum available memory, current used memory, and current held memory.

View name	Description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	Displays the histogram information of query execution times for all nodes in the current tenant.
GV$OB_RES_MGR_SYSSTAT	Displays the statistics of resource groups in all OBServer nodes in the current tenant.
GV$OB_SQLSTAT	Displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is displayed as a row (i.e., each unique value of `SQL_ID` + `Plan_Hash` is a row).
V$OB_SQLSTAT	Displays the basic performance statistics of SQL statements on the current node. Each SQL statement is displayed as a row (i.e., each unique value of `SQL_ID` + `Plan_Hash` is a row).
GV$OB_SESS_TIME_MODEL	Displays the time model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	Displays the time model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	Displays the time model statistics at the tenant level in the cluster.
V$OB_SYS_TIME_MODEL	Displays the time model statistics at the tenant level on the current node.
V$OB_RES_MGR_SYSSTAT	Displays the statistics of resource groups in the current OBServer node in the current tenant.

View name	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables that have the encryption feature enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces that have the encryption feature enabled.

View name	Description
GV$LATCH	Displays the Latch information of all OBServer nodes in the cluster.
V$LATCH	Displays the Latch information of all OBServer nodes in the cluster.

View name	Description
ALL_ALL_TABLES	Displays the tables and views that the user can access.
ALL_COL_COMMENTS	Displays all column comments of the views and tables that the user can access.
ALL_TABLES	Displays all tables that the user can access.
ALL_TAB_COLS	Displays all columns of the tables, views, and clusters that the current user can access.
ALL_TAB_COLUMNS	Displays all columns of the tables, views, and clusters that the current user can access.
ALL_TAB_COMMENTS	Displays comments of the tables and views that the current user can access.
DBA_COL_COMMENTS	Displays all column comments of the views and tables in the database.
DBA_TAB_COMMENTS	Displays comments of the tables and views in the database.
USER_COL_COMMENTS	Displays all column comments of the views and tables owned by the current user.
USER_TAB_COMMENTS	Displays comments of the tables and views owned by the current user.
DBA_OB_TABLEGROUP_TABLES	Displays the association between TABLEGROUPs and TABLEs. TABLEs not in any TABLEGROUP are not displayed.
DBA_TABLES	Displays all tables in the database.
DBA_ALL_TABLES	Displays object tables and relational tables in the database. The fields are the same as those in ALL_ALL_TABLES.
DBA_TABLESPACES	Displays all tablespaces in the database.
DBA_TAB_COLS	Displays all columns of the tables, views, and clusters in the database.
DBA_TAB_COLUMNS	Displays all columns of the tables, views, and clusters in the database.
USER_ALL_TABLES	Displays object tables and relational tables that the current user can access. The fields are the same as those in ALL_ALL_TABLES, except for the OWNER field.
USER_TABLES	Displays all tables owned by the current user.
USER_TABLESPACES	Displays tablespaces that the current user can access. The columns are the same as those in `DBA_TABLESPACES`, except that the `PLUGGED_IN` field is removed.
USER_TAB_COLS	Displays all columns of the tables, views, and clusters owned by the current user.
USER_TAB_COLUMNS	Displays all columns of the tables, views, and clusters owned by the current user.
ALL_VIEWS	Displays views that the current user can access.
DBA_VIEWS	Displays all views in the database. The columns are the same as those in `ALL_VIEWS`.
USER_VIEWS	Displays views owned by the current user.
DICTIONARY	Displays descriptions of data dictionary tables and views.
DICT	Displays descriptions of data dictionary tables and views.
DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.
DBA_OB_SPATIAL_COLUMNS	Displays the database name, table name, type, and SRS information of spatial index columns.

View name	Description
DBA_MVIEW_DEPS	Displays the dependency relationships of materialized views.
DBA_MVIEW_LOGS	Displays the information about materialized view logs.
DBA_MVIEW_RUNNING_JOBS	Displays the materialized view-related tasks that are being performed in the current tenant, including refresh tasks and MLOG cleanup tasks.
USER_MVIEWS	Displays the information about materialized views.
DBA_MVIEWS	Displays the information about all materialized views.
DBA_MVREF_CHANGE_STATS	Displays the statistics about materialized view refreshes.
DBA_MVREF_RUN_STATS	Displays the information about each run of a materialized view refresh, which is identified by the REFRESH_ID.
DBA_MVREF_STATS	Displays the basic timing statistics about materialized view refreshes.
DBA_MVREF_STATS_PARAMS	Displays the refresh statistics attributes associated with each materialized view.
DBA_MVREF_STATS_SYS_DEFAULTS	Displays the system-level default values of the statistics attributes of the materialized view refresh history.
DBA_MVREF_STMT_STATS	Displays the information about the refresh statements.

View name	Description
DBA_OB_OUTLINES	Displays the execution plan outline information of the current tenant.
DBA_OB_CONCURRENT_LIMIT_SQL	Displays the concurrent limit rule outline information of the current tenant.
DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the execution plan outline and concurrent limit rule outline history information of the current tenant.

View name	Description
DBA_SQL_PLAN_BASELINES	Displays the SQL plan baselines in SPM.
DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

View name	Description
DBA_CONTEXT	Displays all context namespaces in the database.
DBA_OB_DATABASES	Displays the metadata of databases in a tenant.
DBA_OB_MAJOR_COMPACTION	Displays the major compaction information of the current tenant.
DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of each zone in the current tenant.
ALL_OBJECTS	Displays all database objects that the user can access.
DBA_OBJECTS	Displays all database objects in the database.
USER_OBJECTS	Displays all database objects owned by the current user.
ALL_DEPENDENCIES	Displays all dependencies between objects in the database.
DBA_DEPENDENCIES	Displays all dependencies between objects in the database.
USER_DEPENDENCIES	Displays the dependencies between objects in the current user's schema.
DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).
DBA_OB_SOURCE	Displays the source code of all stored objects in the current tenant.
USER_OB_SOURCE	Displays the source code of the stored objects owned by the current user.
ALL_OB_SOURCE	Displays the source code of the stored objects that the current user can access.

View name	Description
ALL_ARGUMENTS	Displays the parameters of functions and procedures that the current user can access.
ALL_PROCEDURES	Displays all functions and procedures that the current user can access, as well as their related attributes.
ALL_SOURCE	Displays the text sources of the stored objects that the current user can access.
DBA_ARGUMENTS	Displays the parameters of functions and procedures available in the database. The columns are the same as those in the `ALL_ARGUMENTS` view.
DBA_PROCEDURES	Displays all functions and procedures available in the database, as well as their related attributes. The columns are the same as those in the `ALL_PROCEDURES` view.
DBA_SOURCE	Displays the text sources of all stored objects in the database. The columns are the same as those in the `ALL_SOURCE` view.
USER_ARGUMENTS	Displays the parameters of functions and procedures owned by the current user. The columns are the same as those in the `ALL_ARGUMENTS` view, except that the `OWNER` column is removed.
USER_PROCEDURES	Displays all functions and procedures owned by the current user, as well as their related attributes. The columns are the same as those in the `ALL_PROCEDURES` view, except that the `OWNER` column is removed.
USER_SOURCE	Displays the text sources of the stored objects owned by the current user. The columns are the same as those in the `ALL_SOURCE` view, except that the `OWNER` column is removed.
DBA_JOBS	Displays the overview of the tasks submitted by the current user.
USER_JOBS	Displays the overview of the tasks submitted by the current user.
DBA_JOBS_RUNNING	Displays the running tasks.

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

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

View name	Description
DBA_OB_RSRC_DIRECTIVES	Displays the resource configuration parameters of the current tenant in the Resource Manager.
DBA_OB_RSRC_IO_DIRECTIVES	Displays the I/O resource configuration of the current tenant in the Resource Manager.
DBA_RSRC_GROUP_MAPPINGS	Displays the binding relationships between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	Displays the information about all resource groups in the database.
DBA_RSRC_PLANS	Displays all resource management plans defined in the system.
DBA_RSRC_PLAN_DIRECTIVES	Displays detailed information about each resource plan directive in the database.

View name	Description
DBA_OB_STORAGE_IO_USAGE	Displays the various I/O operations for object storage and cloud disks in the current tenant.

View name	Description
ALL_USERS	Displays all database users that are accessible to the current user.
DBA_USERS	Displays all users in the database.
USER_USERS	Displays information about the current user.
ALL_COL_PRIVS	Displays column object privileges granted to the current user, the owner of the object, or the grantor of the object.
ALL_TAB_PRIVS	Displays object privileges granted to the current user, the owner of the object, or the grantor of the object.
DBA_COL_PRIVS	Displays all column object privileges granted to the database.
DBA_SYS_PRIVS	Displays system privileges granted to users and roles.
DBA_TAB_PRIVS	Displays all object privileges granted to the database.
USER_TAB_PRIVS	Displays object privileges owned by the current user.
USER_COL_PRIVS	Displays column object privileges granted to the current user, the owner of the object, or the grantor of the object.
USER_ROLE_PRIVS	Displays roles granted to the current user.
USER_SYS_PRIVS	Displays system privileges granted to the current user.
ROLE_TAB_PRIVS	Displays table privileges granted to roles.
ROLE_SYS_PRIVS	Displays system privileges granted to roles.
ROLE_ROLE_PRIVS	Displays roles granted to other roles.
DBA_ROLE_PRIVS	Displays roles granted to all users and roles in the database.
DBA_ROLES	Displays all roles in the database.
ALL_DIRECTORIES	Displays all directories accessible to the current user.
DBA_DIRECTORIES	Displays all directories accessible to the current user.

View name	Description
ALL_CONSTRAINTS	Displays the constraint information of all tables that the user can access.
ALL_CONS_COLUMNS	Displays the column information of all constraints in all tables that the user can access.
DBA_CONSTRAINTS	Displays the constraint information of all tables in the database.
DBA_CONS_COLUMNS	Displays the column information of all constraints in all tables in the database.
USER_CONSTRAINTS	Displays the constraint information of all tables owned by the user.
USER_CONS_COLUMNS	Displays the column information of all constraints in all tables owned by the user.

View Name	Description
ALL_DEF_AUDIT_OPTS	Displays the audit conditions for auditing any object by default.
AUDIT_ACTIONS	Displays the Action ID and corresponding name in the audit records.
DBA_AUDIT_EXISTS	Displays the audit trail entries generated by `AUDIT EXISTS` and `AUDIT NOT EXISTS`.
DBA_AUDIT_OBJECT	Displays the audit trail records of all objects in the database.
DBA_AUDIT_SESSION	Displays the audit trail records of all `CONNECT` and `DISCONNECT` actions.
DBA_AUDIT_STATEMENT	Displays the audit trail records of `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements in the database.
DBA_AUDIT_TRAIL	Displays all audit trail entries.
DBA_OBJ_AUDIT_OPTS	Displays the detailed configuration of object-level auditing.
DBA_STMT_AUDIT_OPTS	Displays the detailed configuration of statement-level auditing.
STMT_AUDIT_OPTION_MAP	Displays the Type, name, and priority of each statement-level audit option.
USER_AUDIT_OBJECT	Displays the audit trail records of the objects that the current user can access.
USER_AUDIT_SESSION	Displays the audit trail records of the current user's connections and disconnections.
USER_AUDIT_STATEMENT	Displays the audit trail entries of the `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements issued by the current user.
USER_AUDIT_TRAIL	Displays the standard audit trail entries related to the current user.

View	Description
ALL_INDEXES	Displays the index column information of all indexes on tables that the user can access.
ALL_IND_COLUMNS	Displays the index column information of all indexes on tables that the user can access.
ALL_IND_EXPRESSIONS	Displays the information of all function-based indexes that the user can access in the database.
ALL_IND_PARTITIONS	Displays the information of all index partitions that the user can access in the database.
ALL_IND_SUBPARTITIONS	Displays the information of all index subpartitions that the user can access in the database.
ALL_PART_INDEXES	Displays the partition information of all partitioned indexes that the user can access.
DBA_INDEXES	Displays the information of all indexes on tables in the database.
DBA_IND_COLUMNS	Displays the index column information of all indexes on tables in the database.
DBA_IND_EXPRESSIONS	Displays the information of all function-based indexes in the database.
DBA_IND_PARTITIONS	Displays the information of all index partitions in the database.
DBA_IND_SUBPARTITIONS	Displays the information of all index subpartitions in the database.
USER_INDEXES	Displays the information of all indexes on tables owned by the user.
USER_IND_COLUMNS	Displays the index column information of all indexes on tables owned by the user.
USER_IND_EXPRESSIONS	Displays the information of all function-based indexes owned by the user in the database.
USER_IND_PARTITIONS	Displays the information of all index partitions in the database owned by the user. This view does not contain the `INDEX_OWNER` field, which is present in the `ALL_IND_PARTITIONS` and `DBA_IND_PARTITIONS` views.
USER_IND_SUBPARTITIONS	Displays the information of all index subpartitions in the database owned by the user. This view does not contain the `INDEX_OWNER` field, which is present in the `DBA_IND_SUBPARTITIONS` and `ALL_IND_SUBPARTITIONS` views.
USER_PART_INDEXES	Displays the partition information of all partitioned indexes owned by the user.

View name	Description
ALL_PART_KEY_COLUMNS	Displays the columns that are included in the partitioning key of all partitioned objects that the user can access.
ALL_PART_TABLES	Displays the partition information of partitioned tables that the current user can access.
ALL_SUBPARTITION_TEMPLATES	Displays the description information of all subpartition templates.
ALL_SUBPART_KEY_COLUMNS	Displays the columns that are included in the subpartitioning key of all partitioned objects that the user can access.
ALL_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics of all partitioned tables.
ALL_TAB_SUBPARTITIONS	Displays the partition-level partition information, partition storage parameters, and partition statistics generated by the `DBMS_STATS` package for the partitions that the current user can access.
DBA_OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partition table information of the current tenant.
DBA_PART_INDEXES	Displays the partition information of all partitioned indexes.
DBA_PART_KEY_COLUMNS	Displays the columns that are included in the partitioning key of all partitioned objects in the database.
DBA_PART_TABLES	Displays the partition information of partitioned tables that the current user can access.
DBA_SUBPARTITION_TEMPLATES	Displays the description information of all subpartition templates.
DBA_SUBPART_KEY_COLUMNS	Displays the columns that are included in the subpartitioning key of all partitioned objects in the database.
DBA_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics of the partitions that the current user can access.
DBA_TAB_SUBPARTITIONS	Displays the subpartition name, table name, name of the partition to which the subpartition belongs, its storage attributes, and the statistics generated by the `DBMS_STATS` package.
USER_PART_KEY_COLUMNS	Displays the columns that are included in the partitioning key of all partitioned objects owned by the current user.
USER_PART_TABLES	Displays the partition information of the partitioned tables owned by the current user.
USER_SUBPARTITION_TEMPLATES	Displays the description information of all subpartition templates.
USER_SUBPART_KEY_COLUMNS	Displays the columns that are included in the subpartitioning key of all partitioned objects owned by the current user.
USER_TAB_SUBPARTITIONS	Displays the subpartition name, table name, name of the partition to which the subpartition belongs, and its storage attributes for each subpartition of the tables owned by the current user.
USER_TAB_PARTITIONS	Displays the multi-level partition information, partition storage parameters, and partition statistics of the partitions owned by the current user.

View name	Description
DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlock events. In a non-root tenant, it displays the history of the current tenant.

View name	Description
ALL_SEQUENCES	Displays all sequences that the user can access.
DBA_SEQUENCES	Displays all sequences in the database.
USER_SEQUENCES	Displays all sequences owned by the current user.
TENANT_VIRTUAL_GLOBAL_VARIABLE	Displays global variable information.
TENANT_VIRTUAL_SESSION_VARIABLE	Displays session variable information.

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

View name	Description
ALL_TRIGGERS	Displays the triggers on tables owned by the current user and their descriptions. If you have the CREATE ANY TRIGGER privilege, this view shows all triggers in the database.
DBA_TRIGGERS	Displays all triggers in the database.
USER_TRIGGERS	Displays the triggers owned by the current user.

View name	Description
DBA_RECYCLEBIN	Displays information about all recycle bins in the database.
USER_RECYCLEBIN	Displays information about the recycle bin of the current user. The columns are the same as those in the `DBA_RECYCLEBIN` view, except that the `OWNER` column is removed.

View name	Description
NLS_DATABASE_PARAMETERS	Displays the NLS parameters at the database level (tenant level in OceanBase Database).
NLS_INSTANCE_PARAMETERS	Displays the NLS parameters at the instance level (tenant level).
NLS_SESSION_PARAMETERS	Displays the NLS parameters at the session level.

View name	Description
ALL_COLL_TYPES	Displays the user-defined collection types available in the database. The columns are the same as those in `DBA_COLL_TYPES`.
ALL_TYPES	Displays the user-defined types available in the database.
ALL_TYPE_ATTRS	Displays the attribute information of the user-defined types available in the database.
DBA_COLL_TYPES	Displays the user-defined collection types available in the database. The columns are the same as those in `ALL_COLL_TYPES`.
DBA_TYPES	Displays the user-defined types available in the database.
DBA_TYPE_ATTRS	Displays the attribute information of the user-defined types available in the database.
USER_COLL_TYPES	Displays the user-defined collection types available to the current user.
USER_TYPES	Displays the user-defined types available to the current user.
USER_TYPE_ATTRS	Displays the attribute information of the user-defined types available to the current user.

View name	Description
ALL_ERRORS	Displays the errors of the current stored objects that the user can access.
DBA_ERRORS	Displays the errors of the current stored objects in the database.
USER_ERRORS	Displays the errors of the current stored objects that the user can access.
DBA_SEGMENTS	Displays the storage information of all segments in the database.
USER_SEGMENTS	Displays the storage information of the segments allocated to the objects under the current user.

View name	Description
ALL_PROFILES	Displays all profiles and their limits.
DBA_PROFILES	Displays all profiles and their limits.
USER_PROFILES	Displays all profiles and their limits.

View Name	Description
DBA_OB_CS_REPLICA_STATS	Displays the progress of converting tablets to columnar storage in the C logs of each OBServer in the current tenant.
DBA_OB_LS_LOCATIONS	Displays the distribution of log stream (LS) replicas in the current tenant.
DBA_OB_TABLEGROUPS	Displays the metadata of table groups, mainly the partition information of table groups.
DBA_OB_TABLEGROUP_PARTITIONS	Displays the primary partition information of table groups.
DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the secondary partition information of table groups.
DBA_OB_TABLET_REPLICAS	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	Displays all tablet lists in the current tenant and the log stream information to which each tablet belongs.
DBA_OB_LS	Displays the status and recovery progress of log streams.

View name	Description
DBA_WR_SNAPSHOT	Displays the `SNAPSHOT` information of the current tenant.
DBA_WR_ACTIVE_SESSION_HISTORY	Displays the ASH data of the current tenant after it is persisted.
DBA_WR_STATNAME	Displays the names of system statistics of the current tenant.
DBA_WR_SYSSTAT	Displays the details of system statistics of the current tenant.
DBA_WR_CONTROL	Displays the WR-related configuration information.
DBA_WR_SYSTEM_EVENT	Displays the persistent tenant-level wait event information of the current tenant.
DBA_WR_EVENT_NAME	Displays the persistent tenant-level wait event names of the current tenant.
DBA_WR_SQLTEXT	Displays the SQL text collected by WR for the current tenant.
DBA_WR_SQLSTAT	Displays the basic performance statistics of SQL statements executed in the current tenant.
DBA_WR_SYS_TIME_MODEL	Displays the WR data of the Time Model statistics of the current tenant.

View name	Description
DBA_OB_TRANSFER_PARTITION_TASKS	Displays the transfer partition tasks that are being processed in the current tenant.
DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the history of transfer partition tasks executed in the current tenant.

View name	Description
DBA_SCHEDULER_JOBS	Displays the information about the scheduler jobs that the current user can access.
DBA_SCHEDULER_PROGRAM	Displays all the scheduler information in the database.
DBA_SCHEDULER_JOB_RUN_DETAILS	Displays the information about all the scheduler jobs in the tenant.

View name	Description
ALL_DB_LINKS	Displays all the DBLINKs that the current user can access.
DBA_DB_LINKS	Displays all the DBLINKs created in the current tenant.
USER_DB_LINKS	Displays the DBLINKs created by the current user.

View	Description
ALL_METHOD_PARAMS	Displays the method parameters of the object types that the user can access.
ALL_SCHEDULER_JOB_ARGS	Displays the parameters of the user-scheduled jobs that the user can query.
ALL_SCHEDULER_PROGRAM_ARGS	Displays the parameters of the user-scheduled programs that the user can query.
ALL_TYPE_METHODS	Displays the methods of the object types that the user can access.
DBA_METHOD_PARAMS	Displays the method parameters of the object types in the database.
DBA_SCHEDULER_JOB_ARGS	Displays the parameters of the user-scheduled jobs in the database.
USER_SCHEDULER_JOB_ARGS	Displays the parameters of the user-scheduled jobs owned by the current user.
DBA_SCHEDULER_PROGRAM_ARGS	Displays the parameters of the user-scheduled programs in the database.
USER_SCHEDULER_PROGRAM_ARGS	Displays the parameters of the user-scheduled programs owned by the current user.
DBA_TYPE_METHODS	Displays the methods of the object types in the database.
USER_TYPE_METHODS	Displays the methods of the object types that the user can access. The view does not contain the OWNER field. The information of other fields is the same as that in the ALL_TYPE_METHODS view.

View name	Description
GV$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$ACTIVE_SESSION_HISTORY	Displays the active session history.
GV$OB_ACTIVE_SESSION_HISTORY	Displays the active session history of all OBServer nodes in the tenant.
V$OB_ACTIVE_SESSION_HISTORY	Displays the active session history of the current OBServer node in the tenant.

View name	Description
V$OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partition tables of the current tenant.

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes where the tenant is located.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_UNITS	Displays the unit information on the OBServer node where the tenant is located. The sys tenant can view the unit information on all OBServer nodes in the cluster.
GV$SYSSTAT	Displays the system-level statistics on all servers.
GV$DML_STATS	Displays the DML information in the current user table.
V$DML_STATS	Displays the DML information in the current user table.
V$GLOBALCONTEXT	Displays the `CLIENT_IDENTIFIER` value of the global context attributes accessible in the current session.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the parameter information on the current OBServer node.
V$SYSSTAT	Displays the system-level statistics on the current server.
V$OB_UNITS	Displays the unit information on the current OBServer node.
V$VERSION	Displays the names and versions of all components of the database.
V$STATNAME	Displays the names of statistics.

View name	Description
GV$INSTANCE	Displays the status of the current database instance.
V$INSTANCE	Displays the status of the current database instance.

View name	Description
GV$OB_MEMORY	Displays the memory usage of each tenant on all servers.
GV$OB_MEMSTORE	Displays the memory usage of all MemTables on all tenants on all servers.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Displays some information about the overall SQL workarea, including the maximum available memory, current used memory, and current held memory.
GV$OB_SSTABLES	Displays the SSTable information of the tenant.
GV$OB_MEMSTORE_INFO	Displays the detailed information about all MemTables of all partitions on all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays the detailed information about all MemTables of all partitions on all tenants on all servers.
V$OB_MEMORY	Displays the memory statistics of each tenant.
V$OB_MEMSTORE	Displays the memory usage of all MemTables on all tenants on the current server.
V$OB_SSTABLES	Displays the SSTable information of the tenant.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant on the cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

View name	Description
GV$OB_SS_LOCAL_CACHE	Displays the metrics of various types of cached data in the local cache of each OBServer node for all tenants in shared storage mode.
V$OB_SS_LOCAL_CACHE	Displays the metrics of various types of cached data in the local cache of the current OBServer node for all tenants in shared storage mode.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache of all OBServer nodes.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache of all OBServer nodes for the current tenant.
GV$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache for the current tenant on all OBServer nodes.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache of the current OBServer node.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache of the current OBServer node for the current tenant.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache for the current tenant on all OBServer nodes.
V$RSRC_PLAN	Displays the resource management plan of the current active tenant.

View name	Description
GV$OB_GROUP_IO_STAT	Displays the real-time status of each resource group on all OBServer nodes of the current tenant.
GV$OB_FUNCTION_IO_STAT	Displays the IO statistics at the function level on all OBServer nodes of the current tenant.
V$OB_GROUP_IO_STAT	Displays the real-time status of each resource group on the current OBServer node.
V$OB_FUNCTION_IO_STAT	Displays the IO statistics at the function level on the current OBServer node.

View name	Description
GV$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA	Displays the I/O access resource information on the current OBServer node.

View name	Description
GV$OB_LOG_STAT	Displays the status of Palf.
V$OB_LOG_STAT	Displays the status of Palf.

View name	Description
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on all OBServer nodes.
GV$OB_PS_ITEM_INFO	Provides monitoring for prepared statements, including basic information about all prepared statements in the PS cache.
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on OBServer nodes.
V$OB_PS_ITEM_INFO	Provides monitoring for prepared statements, including basic information about all prepared statements in the PS cache.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
V$SQL_MONITOR_STATNAME	Displays the meaning of the numeric values in the `OTHERSTAT_X_ID` field of `GV$SQL_PLAN_MONITOR`.

View name	Description
GV$OB_PROCESSLIST	Displays the session information of all OBServer nodes where the tenant is located.
GV$SESSION_WAIT	Displays some information about the current or previous wait events of all sessions on all servers, including the wait event name and wait time.
GV$SESSION_WAIT_HISTORY	Displays the information about the last 10 wait events of all sessions on all servers.
GV$SESSTAT	Displays some session-level statistics on all servers.
V$NLS_PARAMETERS	Displays the NLS parameters at the session level.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$SESSION_WAIT	Displays some information about the current or previous wait events of all sessions on the current server, including the wait event name and wait time.
V$SESSION_WAIT_HISTORY	Displays the information about the last 10 wait events of all sessions on the current server.
V$SESSTAT	Displays some session-level statistics.
V$EVENT_NAME	Displays the event definitions in the tenant.

View name	Description
GV$OB_SQL_AUDIT	Displays the statistics about the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays the statistics about the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	Displays the plan-level statistics about slow queries on all OBServer nodes. Each slow query has one set of statistics, and the trace information of the plan is also recorded.
V$SQL_PLAN_MONITOR	Displays the plan-level statistics about slow queries on all OBServer nodes. Each slow query has one set of statistics, and the trace information of the plan is also recorded.
GV$OB_FLT_TRACE_CONFIG	Displays the diagnostics information about end-to-end tracing.

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	Statistics about workareas of all operators executed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	Information about workareas of the currently active operator.
GV$SQL_WORKAREA_HISTOGRAM	Statistics about all workareas executed by all operators.
V$OB_SQL_WORKAREA_MEMORY_INFO	Information about the overall memory usage of SQL workareas, including the maximum available memory, current memory usage, and current held memory.
V$SQL_WORKAREA	Statistics about workareas of all operators executed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	Information about workareas of the currently active operator.
V$SQL_WORKAREA_HISTOGRAM	Statistics about all workareas executed by all operators.

View name	Description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	Displays the histogram information of query execution time for all nodes in the current tenant.
GV$OB_RES_MGR_SYSSTAT	Displays the statistics of resource groups on all OBServer nodes in the current tenant.
V$OB_RES_MGR_SYSSTAT	Displays the statistics of resource groups on the current OBServer node.
GV$OB_SQLSTAT	Displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is displayed on a separate line (each unique value of `SQL_ID` + `Plan_Hash`).
V$OB_SQLSTAT	Displays the basic performance statistics of SQL statements on the current node. Each SQL statement is displayed on a separate line (each unique value of `SQL_ID` + `Plan_Hash`).
GV$OB_SESS_TIME_MODEL	Displays the time model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	Displays the time model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	Displays the time model statistics at the tenant level in the cluster.
V$OB_SYS_TIME_MODEL	Displays the time model statistics at the tenant level on the current node.
V$OB_QUERY_RESPONSE_TIME_HISTOGRAM	Displays the histogram information of query execution time for the current node in the current tenant.

View name	Description
GV$OB_COMPACTION_PROGRESS	Displays the OBServer-level major compaction progress of the tenant.
GV$OB_COMPACTION_SUGGESTIONS	Displays the major compaction suggestions.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the major compaction diagnostics.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the major compaction history at the tablet level.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the major compaction progress at the tablet level.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
GV$SYSTEM_EVENT	Displays some wait events at the tenant system level on all servers, and statistics such as the number of occurrences, wait time, and timeout count of each wait event.
GV$GLOBAL_TRANSACTION	Displays the information about the current active global transactions.
V$OB_COMPACTION_PROGRESS	Displays the server-level major compaction progress of the tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays the major compaction suggestions.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the major compaction diagnostics.
V$OB_TABLET_COMPACTION_HISTORY	Displays the major compaction history at the tablet level.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the major compaction progress at the tablet level.
V$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
V$SYSTEM_EVENT	Displays some wait events at the tenant system level on the current server, and statistics such as the number of occurrences, wait time, and timeout count of each wait event.
V$GLOBAL_TRANSACTION	Displays the information about the current active global transactions.
GV$OB_GLOBAL_TRANSACTION	Displays the information about all XA transactions in the cluster.
V$OB_GLOBAL_TRANSACTION	Displays the information about all XA transactions whose original scheduler is the current node.

View name	Description
V$TIMEZONE_NAMES	Displays the valid time zone names.

View name	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables that have the encryption feature enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces that have the encryption feature enabled.

View name	Description
GV$DBLINK	Displays all database links ( `IN_TRANSACTION=YES` ) that were opened after the query session that issued the query to this view was opened. These database links must be committed or rolled back before they are closed.
V$DBLINK	Displays all database links ( `IN_TRANSACTION=YES` ) that were opened after the query session that issued the query to this view was opened. These database links must be committed or rolled back before they are closed.

System View Overview

View overview under the sys tenant

Dictionary View Overview

Views and columns

Note

Materialized views

InnoDB storage engine

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Shared storage

Outline

Database basic information

Partition-related views

Load balancing

Full-text indexing

Note

Note

Note

Note

Note

Session related

Backup and restore

Statistics and histograms

Tenant-related views

Resource-related views

Resource Manager related

I/O related statistics

Replicas and logs

Views related to WR

Foreign key-related views

Note

Note

OBKV-related views

Performance View Overview

Views related to ASH

Views related to partitions

Views related to shared storage

Views related to monitoring

I/O statistics

Statistics related to cache

Resource Manager related views

Event-related statistics

Statistics related to SQL

Statistics related to logs

Statistics related to networks

Sessions

Database-related statistics

Statistics related to minor compactions

Statistics related to threads

Statistics related to workarea

Views related to WR

Statistics related to encryption

Statistics related to transactions

Overview of views in a MySQL tenant

Dictionary View Overview

Help commands

SPM-related views

Views related to privileges

Views related to OBKV

Scheduler views

Views related to storage