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

Overview of views in the sys tenant

Dictionary views overview

AI models

View name	Description
oceanbase.CDB_OB_AI_MODELS	This view displays the AI model information of all tenants.
oceanbase.CDB_OB_AI_MODEL_ENDPOINTS	This view displays the AI model endpoint information of all tenants.
oceanbase.DBA_OB_AI_MODELS	This view displays the AI model information of the current tenant.
oceanbase.DBA_OB_AI_MODEL_ENDPOINTS	This view displays the AI model endpoint information of the current tenant.

Security privileges

View name	Description
oceanbase.CDB_OB_USERS	This view displays the user information of all tenants.
oceanbase.CDB_OB_DATABASE_PRIVILEGE	This view displays the database-level privileges of all tenants.
oceanbase.DBA_OB_AUTO_INCREMENT	This view displays the auto-increment column information of the current tenant.
oceanbase.DBA_OB_USERS	This view displays the user information of the current tenant.
oceanbase.DBA_OB_DATABASE_PRIVILEGE	This view displays the database-level privileges of the current tenant.
oceanbase.DBA_OB_USER_DEFINED_RULES	This view displays the user-defined rule information.

Security policies

View name	Description
oceanbase.DBA_POLICIES	This view displays the fine-grained access control (FAC) policy information.
oceanbase.DBA_POLICY_CONTEXTS	This view displays the policy context information.
oceanbase.DBA_POLICY_GROUPS	This view displays the policy group information.
oceanbase.DBA_SEC_RELEVANT_COLS	This view displays the column information related to security policies.
oceanbase.ALL_POLICIES	This view displays the FAC policy information accessible to the current user.
oceanbase.ALL_POLICY_CONTEXTS	This view displays the policy context information accessible to the current user.
oceanbase.ALL_POLICY_GROUPS	This view displays the policy group information accessible to the current user.
oceanbase.ALL_SEC_RELEVANT_COLS	This view displays the column information related to security policies and accessible to the current user.

Backup and restore

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

Views and columns

View	Description
oceanbase.CDB_IND_COLUMNS	This view displays the column information of the index tables of all tenants.
oceanbase.CDB_INDEXES	This view displays the INDEX information of all tenants.
oceanbase.CDB_TABLES	This view displays the TABLE information of all tenants.
oceanbase.CDB_OB_TABLEGROUP_TABLES	This view displays the association between the TABLEGROUP and TABLE of all tenants under the sys tenant. The tables not in the TABLEGROUP are not displayed.
oceanbase.CDB_TAB_COLS	This view displays the column information of the tables and views of all tenants.
oceanbase.CDB_TAB_COLS_V$	This view displays the column information of the tables and views of all tenants.
oceanbase.DBA_OB_TABLEGROUP_TABLES	This view displays the association between the TABLEGROUP and TABLE. The tables not in the TABLEGROUP are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	This view displays the columns of the partitioning keys in all partitioned objects.
oceanbase.DBA_SUBPART_KEY_COLUMNS	This view displays the columns of the subpartitioning keys in all partitioned objects.
oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO	This view displays the column checksum inconsistency information between the index tables (global and local indexes) and the primary tables.
oceanbase.CDB_OB_TABLE_LOCATIONS	This view displays the locations of tables and partitions, including system tables, user tables, and index tables.
oceanbase.DBA_OB_TABLE_LOCATIONS	This view displays the locations of tables and partitions, including system tables, user tables, and index tables.
information_schema.TABLESPACES	This view displays information about tablespaces. Note This view is provided for MySQL 5.7 compatibility. The related features are not supported. You can only query the table structure.
oceanbase.DBA_TABLES	This view displays the table information of the current tenant.
oceanbase.CDB_INDEX_USAGE	This view displays the index usage statistics of all tenants.
oceanbase.DBA_INDEX_USAGE	This view displays the index usage statistics of the current tenant.
oceanbase.DBA_TAB_COLS_V$	This view displays the column information of the tables and views of the current tenant.
oceanbase.DBA_OB_TABLE_SPACE_USAGE	This view displays the space usage of tables of the current tenant.

CCL

View	Description
oceanbase.CDB_OB_CCL_RULES	This view displays the concurrency control throttling rules of all tenants.
oceanbase.DBA_OB_CCL_RULES	This view displays the concurrency control throttling rules of the current tenant.

View	Purpose
oceanbase.CDB_OB_SPACE_USAGE	This view displays the space usage of all tenants.
oceanbase.CDB_OB_SERVER_SPACE_USAGE	This view displays the space usage of all OBServer nodes.
oceanbase.CDB_OB_TABLE_SPACE_USAGE	This view displays the space usage of all tables in all tenants.

View	Purpose
oceanbase.CDB_OB_ACCESS_POINT	This view displays the access endpoints of all tenants.
oceanbase.DBA_OB_ACCESS_POINT	This view displays the access endpoints of the current tenant.

View	Description
oceanbase.CDB_IND_PARTITIONS	This view displays the partition information of all index tables in all tenants.
oceanbase.CDB_IND_SUBPARTITIONS	This view displays the subpartition information of all indexes in all tenants.
oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information of all tenants.
oceanbase.CDB_PART_INDEXES	This view displays the partition information of all index tables in all tenants.
oceanbase.CDB_PART_TABLES	This view displays the partition information of all partitioned tables in all tenants.
oceanbase.CDB_SUBPARTITION_TEMPLATES	This view displays the secondary partition information of all partitioned tables in all tenants.
oceanbase.CDB_TAB_PARTITIONS	This view displays the partition information of all partitioned tables in all tenants.
oceanbase.CDB_TAB_SUBPARTITIONS	This view displays the secondary partition information of all partitioned tables in all tenants.
oceanbase.DBA_IND_PARTITIONS	This view displays the partition information of all indexes in all tenants.
oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information of the current tenant.
oceanbase.DBA_PART_INDEXES	This view displays the partition information of all partitioned indexes.
oceanbase.DBA_PART_TABLES	This view displays the partition information of all user tables.
oceanbase.DBA_TAB_PARTITIONS	This view displays the multi-level partition information, partition storage parameters, and partition statistics that the current user can access.
oceanbase.DBA_TAB_SUBPARTITIONS	This view displays the subpartition name, table name, partition name, storage attributes, and statistics generated by the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	This view displays the subpartition template description information.

Load balancing

View	Description
oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT	This view displays all partitions with special weights in all user tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS	This view displays the current partition transfer tasks of all tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the history of executed partition transfer tasks of all tenants.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	This view displays the current partition transfer tasks of the current tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the history of executed partition transfer tasks of the current tenant.
oceanbase.CDB_OB_BALANCE_JOBS	This view displays the load balancing jobs of all tenants.
oceanbase.CDB_OB_BALANCE_JOB_HISTORY	This view displays the history of executed load balancing jobs of all tenants.
oceanbase.CDB_OB_BALANCE_TASKS	This view displays the load balancing tasks of all tenants.
oceanbase.CDB_OB_BALANCE_TASK_HISTORY	This view displays the history of executed load balancing tasks of all tenants.
oceanbase.CDB_OB_TRANSFER_TASKS	This view displays the transfer tasks of all tenants.
oceanbase.CDB_OB_TRANSFER_TASK_HISTORY	This view displays the history of executed transfer tasks of all tenants.
oceanbase.DBA_OB_BALANCE_JOBS	This view displays the load balancing jobs of the current tenant.
oceanbase.DBA_OB_BALANCE_JOB_HISTORY	This view displays the history of executed load balancing jobs of the current tenant.
oceanbase.DBA_OB_BALANCE_TASKS	This view displays the load balancing tasks of the current tenant.
oceanbase.DBA_OB_BALANCE_TASK_HISTORY	This view displays the history of executed load balancing tasks of the current tenant.
oceanbase.DBA_OB_TRANSFER_TASKS	This view displays the transfer tasks of the current tenant.
oceanbase.DBA_OB_TRANSFER_TASK_HISTORY	This view displays the history of executed transfer tasks of the current tenant.

View name	Description
oceanbase.CDB_OB_CS_REPLICA_STATS	This view displays the progress of converting tablets to columnar storage in the log streams of C replicas on all OBServer nodes of all tenants.
oceanbase.CDB_OB_LS_LOCATIONS	This view displays the distribution of log stream (LS) replicas for all tenants.
oceanbase.CDB_OB_TABLEGROUPS	This view displays the metadata of table groups for all tenants under the sys tenant, mainly focusing on the partition information of the table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of partitioned table groups for all tenants under the sys tenant.
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of partitioned table groups for all tenants under the sys tenant.
oceanbase.CDB_OB_TABLET_TO_LS	This view displays the list of tablets and the log stream information to which each tablet belongs for all tenants under the sys tenant.
oceanbase.CDB_OB_TABLET_REPLICAS	This view displays the information of all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: `<TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.CDB_PART_KEY_COLUMNS	This view displays the primary partition key information of partitioned objects (partitioned tables and partitioned indexes) for all tenants.
oceanbase.CDB_SUBPART_KEY_COLUMNS	This view displays the secondary partition key information of partitioned objects (partitioned tables and partitioned indexes) for all tenants.
oceanbase.DBA_IND_SUBPARTITIONS	This view displays the information of all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of table groups, mainly focusing on the partition information of the table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays the information of all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	This view displays the list of tablets and the log stream information to which each tablet belongs in the current tenant.
oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution of log stream (LS) replicas in the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO	This view displays the information about data inconsistencies between tablet replicas.
oceanbase.CDB_OB_LS	This view displays the status and recovery progress of log streams.
oceanbase.DBA_OB_LS	This view displays the status and restore progress of log streams.
oceanbase.CDB_OB_LS_HISTORY	This view displays the historical information of log streams for all tenants.
oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS	This view displays the log stream archiving progress for all tenants.
oceanbase.CDB_OB_LS_REPLICA_TASKS	This view displays the log stream replica tasks for all tenants.
oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY	This view displays the historical information of log stream replica tasks for all tenants.
oceanbase.CDB_OB_LOG_RESTORE_SOURCE	This view displays the log restore source information for all tenants.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS	This view displays the arbitration replica tasks for all tenants.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY	This view displays the historical information of arbitration replica tasks for all tenants.
oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN	This view displays the flashback log SCN information for all tenants.
oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG	This view displays the data dictionary information in the logs of all tenants.
oceanbase.DBA_OB_LS_HISTORY	This view displays the historical information of log streams for the current tenant.
oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS	This view displays the log stream archiving progress for the current tenant.
oceanbase.DBA_OB_LS_REPLICA_TASKS	This view displays the log stream replica tasks for the current tenant.
oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY	This view displays the historical information of log stream replica tasks for the current tenant.
oceanbase.DBA_OB_LOG_RESTORE_SOURCE	This view displays the log restore source information for the current tenant.
oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS	This view displays the arbitration replica tasks for the current tenant.
oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY	This view displays the historical information of arbitration replica tasks for the current tenant.
oceanbase.DBA_OB_ARBITRATION_SERVICE	This view displays the arbitration service information.
oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN	This view displays the flashback log SCN information for the current tenant.
oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG	This view displays the data dictionary information in the logs of the current tenant.
oceanbase.ALL_LOCATIONS	This view displays the locations of tables or partitions accessible to the current user.

Service management

View	Purpose
oceanbase.CDB_OB_SERVICES	This view displays the service information of all tenants.
oceanbase.DBA_OB_SERVICES	This view displays the service information of the current tenant.
oceanbase.DBA_OB_SERVER_JOBS	This view displays the tasks related to all OBServer nodes.
oceanbase.DBA_OB_SERVERS	This view displays the information about all OBServer nodes.

Shared storage

View	Purpose
CDB_OB_SS_SPACE_USAGE	This view records the storage space occupied by each tenant on the object storage.
DBA_OB_SS_SPACE_USAGE	This view records the storage space occupied by the current tenant on the object storage.
DBA_OB_ZONE_STORAGE	This view displays the information about the object storage of the shared storage cluster configured in each zone.

InnoDB storage engine

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

View	Description
oceanbase.CDB_OB_TEMP_FILES	This view displays the information about temporary files of all tenants.
oceanbase.DBA_OB_TEMP_FILES	This view displays the information about temporary files.

View	Description
CDB_OB_STORAGE_IO_USAGE	This view displays the I/O operations of object storage and cloud disks for all tenants.

View	Description
oceanbase.CDB_OB_KV_TTL_TASKS	This view displays the TTL tasks being executed by all tenants under the sys tenant.
oceanbase.CDB_OB_KV_TTL_TASK_HISTORY	This view displays the historical TTL tasks of all tenants under the sys tenant.
oceanbase.DBA_OB_KV_TTL_TASKS	This view displays the TTL tasks being executed by the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	This view displays the historical TTL tasks of the current tenant.
V$OB_KV_CLIENT_INFO	This view displays the configuration parameters of all OBKV tenant clients connected to the current node.
GV$OB_KV_CLIENT_INFO	This view displays the configuration parameters of all OBKV tenant clients.
oceanbase.CDB_OB_KV_REDIS_TABLE	This view displays the information about OBKV Redis tables of all tenants.
oceanbase.DBA_OB_KV_REDIS_TABLE	This view displays the information about OBKV Redis tables of the current tenant.

View	Description
oceanbase.DBA_OB_OUTLINES	This view displays the execution plan outline information of the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the outline-related information of the throttling rules of the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the execution plan and throttling rule outline history information of the current tenant.
DBA_OB_FORMAT_OUTLINES	This view records the details of the format outline of the current tenant.

PLSQL types

View name	Description
oceanbase.DBA_PLSQL_COLL_TYPES	This view displays information about PL/SQL collection types.
oceanbase.DBA_PLSQL_TYPES	This view displays information about PL/SQL types.
oceanbase.DBA_PLSQL_TYPE_ATTRS	This view displays information about PL/SQL type attributes.
oceanbase.ALL_PLSQL_COLL_TYPES	This view displays information about PL/SQL collection types accessible to the current user.
oceanbase.ALL_PLSQL_TYPES	This view displays information about PL/SQL types accessible to the current user.
oceanbase.ALL_PLSQL_TYPE_ATTRS	This view displays information about PL/SQL type attributes accessible to the current user.

Full-text indexes

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

Task scheduler

View name	Description
oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS	This view displays the details of job runs for all tenants.
oceanbase.DBA_SCHEDULER_WINDOWS	This view displays information about scheduling windows.
oceanbase.DBA_SCHEDULER_JOB_CLASSES	This view displays information about job classes.
oceanbase.ALL_SCHEDULER_WINDOWS	This view displays information about scheduling windows accessible to the current user.

Event history monitoring

View name	Description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlock events. The view displays the history of all tenants under the root tenant.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlock events. The view displays the history of the current tenant under a non-root tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	This view displays the event history of OBServer nodes.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	This view displays the event history of the Root Service.

SPM

View name	Description
oceanbase.CDB_OB_SPM_EVO_RESULT	This view displays the evolution results of SQL plan management for all tenants.
oceanbase.DBA_OB_SPM_EVO_RESULT	This view displays the evolution results of SQL plan management for the current tenant.

Upgrade

View name	Description
oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY	This view displays the event history of the cluster.

Basic database information

View name	Description
oceanbase.CDB_OB_DATABASES	This view displays the database metadata of all tenants under the sys tenant.
oceanbase.DBA_OB_DATABASES	This view displays the database metadata of the current tenant.

| information_schema.events | This view records all event information. | | oceanbase.CDB_OB_AUTO_INCREMENT | This view displays the information of auto-increment columns for all tenants. |

| oceanbase.DBA_OB_TENANT_EVENT_HISTORY | This view displays the event history of the tenant. | | oceanbase.DBA_OB_SYS_VARIABLES | This view displays the system variable information of the current tenant. |

View name	Description
oceanbase.DBA_TAB_STATISTICS	This view displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	This view displays the column statistics and histogram information of all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	This view displays the column statistics and histogram information of all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information of all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	This view displays the histograms of all columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	This view displays the histogram data (endpoints of each histogram) of all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	This view displays the histogram data (endpoints of each histogram) of all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	This view displays the table statistics history of all tables in the database.
oceanbase.DBA_IND_STATISTICS	This view displays the optimizer statistics of all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	This view displays the cumulative modification information of tables in the database.
oceanbase.CDB_TAB_COL_STATISTICS	This view displays the column-level statistics in the sys tenant.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	This view queries the historical execution of table statistics collection.
oceanbase.CDB_OB_AUX_STATISTICS	This view displays the auxiliary statistics of all tenants.
oceanbase.DBA_OB_AUX_STATISTICS	This view displays the auxiliary statistics of the current tenant.
oceanbase.DBA_OB_TABLE_STAT_STALE_INFO	This view displays the staleness of statistics.
oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY	This view displays the history of table statistics collection tasks.

External resources

View	Description
oceanbase.CDB_OB_EXTERNAL_RESOURCES	This view displays all uploaded resource files.
oceanbase.CDB_OB_EXTERNAL_TABLE_FILES	This view displays the file list of all external tables created by tenants.
oceanbase.DBA_OB_EXTERNAL_RESOURCES	This view displays the uploaded resource files.
oceanbase.DBA_OB_EXTERNAL_TABLE_FILES	This view displays the file list of all external tables created in the current tenant.
oceanbase.ALL_OB_EXTERNAL_TABLE_FILES	This view displays the file list of all external tables accessible to the current user.

Foreign keys

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

View name	Description
oceanbase.CDB_MVIEW_RUNNING_JOBS	This view displays the current materialized view-related tasks, including refresh tasks and MLOG cleanup tasks, for all tenants.
oceanbase.CDB_MVIEWS	This view displays the materialized view information for all tenants.
oceanbase.CDB_MVIEW_LOGS	This view displays the materialized view log information for all tenants.
oceanbase.CDB_MVREF_CHANGE_STATS	This view displays the statistics related to materialized view refreshes for all tenants.
oceanbase.CDB_MVREF_RUN_STATS	This view displays the information about each refresh operation for all tenants.
oceanbase.CDB_MVREF_STATS	This view displays the basic timing statistics of materialized view refreshes for all tenants.
oceanbase.CDB_MVREF_STATS_PARAMS	This view displays the refresh statistics attributes associated with each materialized view for all tenants.
oceanbase.CDB_MVREF_STATS_SYS_DEFAULTS	This view displays the system-wide default values of the statistics attributes of materialized view refreshes for all tenants.
oceanbase.CDB_MVREF_STMT_STATS	This view displays the information about the refresh statements associated with each materialized view for all tenants.
oceanbase.DBA_MVIEW_DEPS	This view displays the dependencies of materialized views for the current tenant.
oceanbase.DBA_MVIEW_LOGS	This view displays the materialized view log information.
oceanbase.DBA_MVIEW_RUNNING_JOBS	This view displays the current materialized view-related tasks, including refresh tasks and MLOG cleanup tasks, for the current tenant.
oceanbase.DBA_MVIEWS	This view displays the information about all materialized views.
oceanbase.DBA_MVREF_CHANGE_STATS	This view displays the statistics related to materialized view refreshes.
oceanbase.DBA_MVREF_RUN_STATS	This view displays the information about each refresh operation. Each refresh operation is identified by a REFRESH_ID.
oceanbase.DBA_MVREF_STATS	This view displays the basic timing statistics of materialized view refreshes.
oceanbase.DBA_MVREF_STATS_PARAMS	This view displays the refresh statistics attributes associated with each materialized view.
oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS	This view displays the system-wide default values of the statistics attributes of materialized view refreshes.
oceanbase.DBA_MVREF_STMT_STATS	This view displays the information about the refresh statements associated with each materialized view.
oceanbase.ALL_MVIEWS	This view displays the information about materialized views accessible to the current user.
oceanbase.ALL_MVIEW_LOGS	This view displays the information about materialized view logs accessible to the current user.

View name	Description
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data of all tenants.
oceanbase.CDB_WR_CONTROL	This view displays the WR configuration information.
oceanbase.CDB_WR_EVENT_NAME	This view displays the tenant-level wait event names of all tenants.
oceanbase.CDB_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of all tenants.
oceanbase.CDB_WR_SQLSTAT	This view displays the basic performance statistics of all SQL statements executed by all tenants. Each SQL statement is displayed as a row (each unique combination of `SQL_ID` and `Plan_Hash` is displayed as a row).
oceanbase.CDB_WR_SQLTEXT	This view displays the SQL text collected by WR for all tenants.
oceanbase.CDB_WR_STATNAME	This view displays the names of the system statistics of all tenants.
oceanbase.CDB_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of all tenants.
oceanbase.CDB_WR_SYSSTAT	This view displays the details of the system statistics of all tenants.
oceanbase.CDB_WR_SYSTEM_EVENT	This view displays the tenant-level wait event information of all tenants.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data of the current tenant.
oceanbase.DBA_WR_CONTROL	This view displays the WR configuration information.
oceanbase.DBA_WR_EVENT_NAME	This view displays the tenant-level wait event names of the current tenant.
oceanbase.DBA_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of the current tenant.
oceanbase.DBA_WR_SQLSTAT	This view displays the basic performance statistics of all SQL statements executed by the current tenant. Each SQL statement is displayed as a row (each unique combination of `SQL_ID` and `Plan_Hash` is displayed as a row).
oceanbase.DBA_WR_SQLTEXT	This view displays the SQL text collected by WR for the current tenant.
oceanbase.DBA_WR_STATNAME	This view displays the names of the system statistics of the current tenant.
oceanbase.DBA_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of the current tenant.
oceanbase.DBA_WR_SYSSTAT	This view displays the details of the system statistics of the current tenant.
oceanbase.DBA_WR_SYSTEM_EVENT	This view displays the tenant-level wait event information after persistence.
oceanbase.CDB_WR_SQL_PLAN	This view displays the SQL execution plans collected by WR for all tenants.
oceanbase.CDB_WR_RES_MGR_SYSSTAT	This view displays the resource manager statistics collected by WR for all tenants.
oceanbase.DBA_WR_SQL_PLAN	This view displays the SQL execution plans collected by WR for the current tenant.
oceanbase.DBA_WR_RES_MGR_SYSSTAT	This view displays the resource manager statistics collected by WR for the current tenant.

Vector index

View	Description
oceanbase.CDB_OB_VECTOR_INDEX_TASKS	This view displays the vector index tasks of all tenants.
oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY	This view displays the vector index task history of all tenants.
oceanbase.DBA_OB_VECTOR_INDEX_TASKS	This view displays the vector index tasks of the current tenant.
oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY	This view displays the vector index task history of the current tenant.

Major compaction

View	Description
oceanbase.CDB_OB_MAJOR_COMPACTION	This view displays the global major compaction information of all tenants under the sys tenant.
oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of each zone of all tenants under the sys tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	This view displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of each zone of the current tenant.
oceanbase.CDB_OB_FREEZE_INFO	This view displays the version information generated by major freeze.
oceanbase.DBA_OB_FREEZE_INFO	This view displays the version information generated by major freeze.

Certificate management

View	Description
oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE	This view displays the information of trusted root certificates.

Resource management

View	Description
oceanbase.DBA_OB_RESOURCE_POOLS	This view displays the resource pool information of all tenants.
oceanbase.DBA_OB_UNIT_JOBS	This view displays all unit-related tasks.
oceanbase.DBA_OB_UNITS	This view displays the unit information of all tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	This view displays the unit specifications of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	This view displays all SEQUENCE objects in the database.
CDB_OB_RSRC_DIRECTIVES	This view displays the resource configuration parameters of all tenants in the Resource Manager.

Tenant management

View name	Description
oceanbase.DBA_OBJECTS	This view displays all database objects. The view definition is consistent with that of ALL_OBJECTS.
oceanbase.CDB_OBJECTS	This view displays the object information of all tenants under the sys tenant.
oceanbase.DBA_OB_TENANTS	This view displays the basic information of all tenants, including the sys tenant, user-created tenants (user tenants), and the meta tenant. You can use the `TENANT_TYPE` column to distinguish the types of tenants.
oceanbase.DBA_OB_TENANT_JOBS	This view displays the task information at the tenant level.
oceanbase.CDB_OB_SYS_VARIABLES	This view displays the system variable information of all tenants under the sys tenant.
oceanbase.CDB_OB_TENANT_EVENT_HISTORY	This view displays the tenant event history of all tenants.
oceanbase.DBA_OB_ZONES	This view displays the information of all zones.

Tenant cloning

View name	Description
oceanbase.DBA_OB_CLONE_HISTORY	This view displays the tenant cloning history.
oceanbase.DBA_OB_CLONE_PROGRESS	This view displays the tenant cloning progress.

View name	Description
oceanbase.CDB_OB_TTL_TASKS	This view displays the execution status of all user tenants' TTL tasks in SQL mode.
oceanbase.CDB_OB_TTL_TASK_HISTORY	This view displays the execution history of all user tenants' TTL tasks in SQL mode.
oceanbase.DBA_OB_TTL_TASKS	This view displays the execution status of the TTL tasks in SQL mode of the current tenant.
oceanbase.DBA_OB_TTL_TASK_HISTORY	This view displays the execution history of the TTL tasks in SQL mode of the current tenant.

Overview of performance views

View	Description
GV$ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$ACTIVE_SESSION_HISTORY	This view displays the active session history.
GV$OB_ACTIVE_SESSION_HISTORY	This view displays the active session history of all OBServer nodes for all tenants.
V$OB_ACTIVE_SESSION_HISTORY	This view displays the active session history of the current OBServer node for all tenants.

View	Description
GV$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of HMS Catalog clients for all tenants.
V$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of HMS Catalog clients for all tenants.

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

View	Description
GV$OB_TABLET_REPLICA_INFO	This view displays the basic information of all tablet replicas on each node for all tenants, including the tenant, log stream, table, database, and disk usage.
V$OB_TABLET_REPLICA_INFO	This view displays the basic information of all tablet replicas on the current node for all tenants, including the tenant, log stream, table, database, and disk usage.
GV$OB_LOG_STAT	This view displays the status of Palf.
GV$OB_LS_SNAPSHOTS	This view displays the information of log stream snapshots persisted in all units.
V$OB_LOG_STAT	This view displays the status of Palf.

View	Description
V$OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information for all tenants.

Shared storage

View name	Description
V$OB_SS_SSTABLES	This view displays the SSTable information on the shared storage of all tenants.
GV$OB_SS_LOCAL_CACHE	This view displays the metrics of various cache data in the local cache of each OBServer node for all tenants in shared storage mode.
V$OB_SS_LOCAL_CACHE	This view displays the metrics of various cache data in the local cache of the current OBServer node for all tenants in shared storage mode.
GV$OB_STORAGE_CACHE_TASKS	This view displays the cache task information on all OBServer nodes for all tenants.
V$OB_STORAGE_CACHE_TASKS	This view displays the cache task information on the current OBServer node for all tenants.
GV$OB_TABLET_LOCAL_CACHE	This view displays the overall cache information on all OBServer nodes for all tenants.
V$OB_TABLET_LOCAL_CACHE	This view displays the overall cache information on the current OBServer node for all tenants.
GV$OB_SERVER_STORAGE	This view displays the information about the object storage configured for the shared storage cluster on all OBServer nodes.
V$OB_SERVER_STORAGE	This view displays the information about the object storage configured for the shared storage cluster on the current OBServer node.
GV$OB_SS_LOCAL_CACHE_DIAGNOSE	This view is used to diagnose the running status of the local cache submodules for all tenants on each OBServer node in shared storage mode.
V$OB_SS_LOCAL_CACHE_DIAGNOSE	This view is used to diagnose the running status of the local cache submodules for all tenants on the current OBServer node in shared storage mode.

I/O

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

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

View	Purpose
GV$OB_MEMORY	This view displays the memory statistics of the tenant.
V$OB_MEMORY	This view displays the memory statistics of the tenant.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
V$OB_MEMSTORE	This view displays the MemStore statistics of the tenant.
GV$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
GV$OB_SSTABLES	This view displays the SSTable information of the tenant.
V$OB_SSTABLES	This view displays the SSTable information of the tenant.
GV$OB_TENANT_MEMORY	This view displays the memory usage of each tenant on the cluster.
V$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the current observer process.

View	Description
GV$OB_PROCESSLIST	This view displays session information on all OBServer nodes of the tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	This view displays the diagnostic information of COMPACTION.
GV$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information of TABLET-level COMPACTION.
GV$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress information of TABLET-level COMPACTION.
GV$OB_TRANSACTION_PARTICIPANTS	This view displays the information of transaction participants on all OBServer nodes.
GV$SESSION_EVENT	This view displays the session-level waiting events on all OBServer nodes in the cluster.
GV$SESSION_WAIT	This view displays the information of the current or previous waiting events of all sessions on all servers, including the waiting event name and waiting time.
GV$SESSION_WAIT_HISTORY	This view displays the information of the last 10 waiting events of all sessions on all servers.
GV$SYSTEM_EVENT	This view displays the waiting events at the tenant level in the cluster.
GV$SESSTAT	This view displays the session-level statistical events on all OBServer nodes.
GV$SYSSTAT	This view displays the tenant-level statistical events on all servers.
V$OB_COMPACTION_PROGRESS	This view displays the server-level major compaction progress of the tenant.
V$OB_COMPACTION_SUGGESTIONS	This view displays the suggestions of COMPACTION.
V$OB_PROCESSLIST	This view displays the session information on the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	This view displays the diagnostic information of COMPACTION.
V$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information of TABLET-level COMPACTION.
V$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress information of TABLET-level COMPACTION.
V$OB_TRANSACTION_PARTICIPANTS	This view displays the information of transaction participants on all OBServer nodes.
V$STATNAME	This view displays the definitions of all statistical events.
V$EVENT_NAME	This view displays all statistics event definitions on the current OBServer node.
V$SESSION_WAIT	This view displays the current waiting event details for each session. Each waiting event has three parameters, which record the corresponding values.
V$SESSION_WAIT_HISTORY	This view displays the current waiting event details for each session, including the last 10 waiting events.
V$SESSTAT	This view displays the statistics event overview at the session level.
V$SYSSTAT	This view displays the statistics event information at the tenant level on the current server.
V$SYSTEM_EVENT	This view displays the waiting event statistics at the tenant level.
GV$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations on the current OBServer node.

View	Description
GV$OB_PLAN_CACHE_STAT	This view displays the overall status of each plan cache on all OBServer nodes for the current tenant.
V$OB_PLAN_CACHE_STAT	This view records the overall status of each plan cache on all servers for the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache on all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache on the current server for the current tenant.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan caches on all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	This view monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
V$OB_PS_STAT	This view monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
GV$OB_PS_ITEM_INFO	This view provides monitoring capabilities for prepared statements and contains basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	This view provides monitoring capabilities for prepared statements and contains basic information about all prepared statements in the PS cache.
GV$OB_PX_P2P_DATAHUB	This view displays information about data transmission operations in parallel execution.
GV$OB_PX_TARGET_MONITOR	This view displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	This view displays the usage of PX threads on the OBServer node.
GV$OB_SQL_AUDIT	This view displays statistics such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	This view displays statistics such as the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	This view displays statistics about slow queries on all OBServer nodes, with each slow query having a corresponding entry, and also records the trace information of the plan.
V$SQL_PLAN_MONITOR	This view displays statistics about slow queries at the operation level, with each operation having a corresponding entry.
V$SQL_MONITOR_STATNAME	This view displays the meaning of the numbers in the `OTHERSTAT_X_ID` column of `GV$SQL_PLAN_MONITOR`.
GV$OB_FLT_TRACE_CONFIG	This view displays diagnostic information about full-link tracing.

View name	Description
GV$OB_SESSION	This view records session information created in all servers.

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

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

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

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

View	Description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	This view displays histogram information about the execution time of queries on all nodes for all tenants.
GV$OB_RES_MGR_SYSSTAT	This view displays statistics about resource groups on all OBServer nodes for all tenants.
GV$OB_SESS_TIME_MODEL	This view displays session-level Time Model statistics in the cluster.
GV$OB_SQLSTAT	This view displays basic performance statistics for SQL statements in the cluster. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).
GV$OB_SYS_TIME_MODEL	This view displays tenant-level Time Model statistics in the cluster.
V$OB_QUERY_RESPONSE_TIME_HISTOGRAM	This view displays histogram information about the execution time of queries on the current node for all tenants.
V$OB_RES_MGR_SYSSTAT	This view displays statistics about resource groups on the current OBServer node for all tenants.
V$OB_SESS_TIME_MODEL	This view displays session-level Time Model statistics on the current node.
V$OB_SQLSTAT	This view displays basic performance statistics for SQL statements on the current node. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).
V$OB_SYS_TIME_MODEL	This view displays tenant-level Time Model statistics on the current node.

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

View	Description
GV$OB_MERGE_INFO	This view displays statistics about completed compactions in the OceanBase cluster.
V$OB_MERGE_INFO	This view displays statistics about completed compactions in the OceanBase cluster.
GV$OB_COMPACTION_PROGRESS	This view displays the major compaction progress at the OBServer level for a tenant.
GV$OB_COMPACTION_SUGGESTIONS	This view displays suggestions for major compactions.

Resource management

View	Purpose
GV$OB_GROUP_IO_STAT	This view displays the real-time status of each resource group on all OBServer nodes for all tenants.
GV$OB_FUNCTION_IO_STAT	This view displays the I/O statistics of Function level on all OBServer nodes for all tenants.
V$OB_GROUP_IO_STAT	This view displays the real-time status of each resource group on the current OBServer node for all tenants.
V$OB_FUNCTION_IO_STAT	This view displays the I/O statistics of Function level on the current OBServer node for all tenants.

Overview of views in a MySQL tenant

Dictionary views overview

Backup and restore

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

Views and columns

View	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 information about tables and views used in view definitions.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the association between TABLEGROUP and TABLE. Tables not in a TABLEGROUP are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays columns included in the partition keys of all partitioned objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	Displays columns included in the subpartition keys of all partitioned objects in the database.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the location of tables or partitions, including system tables, user tables, and index tables.
information_schema.TABLESPACES	Information about tablespaces. Note This view is available only for MySQL 5.7 compatibility. The related features are not supported, and only table structures can be queried.
oceanbase.DBA_TABLES	Displays information about all tables in the current tenant.

Storage

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

Access control

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

View name	Description
information_schema.PARTITIONS	Records partition information.
oceanbase.DBA_IND_PARTITIONS	Displays the primary partition information of an index.
oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partition table information of the current tenant.
oceanbase.DBA_PART_INDEXES	Displays the partition information of all partition 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 information accessible to the current user.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the subpartition name, table name, partition name, 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_OBJECT_BALANCE_WEIGHT	Displays all partitions with special weights in the current user tenant.
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
oceanbase.DBA_OB_CS_REPLICA_STATS	This view displays the progress of converting tablets in the C replica log stream on all OBServer nodes of the current tenant.
oceanbase.DBA_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partitions of a partitioned table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partitions of a partitioned table group.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of a table group, mainly the partition information of the table group.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays the information about all tablet replicas of the current tenant. Each tablet replica is uniquely determined by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	This view displays the list of all tablets of the current tenant and the log stream to which each tablet belongs.
oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution of log stream (LS) replicas of the current tenant.
oceanbase.DBA_OB_CS_REPLICA_STATS	This view displays the progress of converting tablets in the C replica log stream on all OBServer nodes of the current tenant.
oceanbase.DBA_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partitions of a partitioned table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partitions of a partitioned table group.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of a table group, mainly the partition information of the table group.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays the information about all tablet replicas of the current tenant. Each tablet replica is uniquely determined by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	This view displays the list of all tablets of the current tenant and the log stream to which each tablet belongs.
oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution of log stream (LS) replicas of the current tenant.

View name	Description
DBA_OB_SS_SPACE_USAGE	This view records the storage space usage on the object storage of the current tenant.

Help commands

View	Purpose
mysql.help_topic	This view, together with the `mysql.help_category`, `mysql.help_relation`, and `mysql.help_keyword` tables, generates Help commands.
mysql.help_category	This view, together with the `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_keyword` tables, generates Help commands.
mysql.help_keyword	This view, together with the `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_category` tables, generates Help commands.
mysql.help_relation	This view, together with the `mysql.help_category`, `mysql.help_topic`, and `mysql.help_keyword` tables, generates Help commands.

InnoDB storage engine

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

I/O performance

View	Purpose
DBA_OB_STORAGE_IO_USAGE	This view displays the I/O operations of the object storage and cloud disks on all nodes of the current tenant.

OBKV

View	Purpose
oceanbase.DBA_OB_KV_TTL_TASKS	This view displays the TTL tasks that are being executed by the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	This view displays the historical TTL tasks of the current tenant.
V$OB_KV_CLIENT_INFO	This view displays the configuration parameters of the client connections to the OBKV tenant on the current node.
GV$OB_KV_CLIENT_INFO	This view displays the configuration parameters of the client connections to the OBKV tenant.

Outline

View	Purpose
oceanbase.DBA_OB_OUTLINES	This view displays the Outline information of the execution plans of the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the Outline information of the throttling rules of the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the Outline information of the execution plans and throttling rules of the current tenant.
DBA_OB_FORMAT_OUTLINES	This view records the detailed information of the Format Outline of the current tenant.

Task scheduler manager

View	Purpose
oceanbase.DBA_SCHEDULER_JOBS	This view displays the information of all scheduler jobs in the database.

Privilege

View	Purpose
mysql.db	This view displays the database-level privileges (VIRTUAL_TABLE).
mysql.user	This view records the user-level privileges (VIRTUAL_TABLE).
information_schema.COLUMN_PRIVILEGES	This view displays the column privileges.
information_schema.SCHEMA_PRIVILEGES	This view describes the database privileges.
information_schema.TABLE_PRIVILEGES	This view records the table privileges.
information_schema.USER_PRIVILEGES	This view records the user privileges.

Full-text index

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

Session

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

Time zone

View	Description
mysql.time_zone	This view displays information about time zones (SYSTEM_VIEW).
mysql.time_zone_name	This view records the name information of the time zone (SYSTEM_VIEW).
mysql.time_zone_transition	`mysql.time_zone_transition` is a system view that records the information about time zone transitions.
mysql.time_zone_transition_type	This view records the type of the time zone transition (SYSTEM_VIEW).

SPM

View	Description
oceanbase.DBA_SQL_PLAN_BASELINES	This view displays the plan baselines of SQL in SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	This view displays the configuration parameters in SPM.

Database basic information

View	Description
information_schema.GLOBAL_STATUS	This view records the global status information of OceanBase Database.
information_schema.GLOBAL_VARIABLES	This view records the global variable information.
information_schema.SCHEMATA	This view records the database metadata.
oceanbase.DBA_OB_DATABASES	This view displays the database metadata of the current tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	This view displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of each zone in the current tenant.
oceanbase.DBA_OB_FREEZE_INFO	This view displays the version information generated by major freeze.
information_schema.events	This view records all event information.

Statistics and histograms

View	Description
oceanbase.DBA_TAB_STATISTICS	This view displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	This view displays the column statistics and histogram information of all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	This view displays the column statistics and histogram information of all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information of all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	This view displays the histograms of all columns in the database.
oceanbase.DBA_PART_HISTOGRAMS	This view displays the histogram data (endpoints) of all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	This view displays the histogram data (endpoints) of all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	This view displays the table statistics history of all tables in the database.
oceanbase.DBA_IND_STATISTICS	This view displays the optimizer statistics of all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	This view displays the cumulative modification information of tables in the database.
information_schema.QUERY_RESPONSE_TIME	This view displays the histogram data (such as the response time) for Prometheus monitoring.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	This view queries the historical collection execution of a table.

Foreign keys

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

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

Materialized views

View name	Description
oceanbase.DBA_MVIEW_DEPS	This view displays the dependencies of materialized views in the current tenant.
oceanbase.DBA_MVIEW_LOGS	This view displays the logs of materialized views.
oceanbase.DBA_MVIEW_RUNNING_JOBS	This view displays the running materialized view tasks in the current tenant, including refresh tasks and MLOG cleanup tasks.
oceanbase.DBA_MVIEWS	This view displays the information of all materialized views.
oceanbase.DBA_MVREF_CHANGE_STATS	This view displays the statistics of materialized view refreshes.
oceanbase.DBA_MVREF_RUN_STATS	This view displays the information of each materialized view refresh, which is identified by the REFRESH_ID.
oceanbase.DBA_MVREF_STATS	This view displays the basic timing statistics of materialized view refreshes.
oceanbase.DBA_MVREF_STATS_PARAMS	This view displays the refresh statistics attributes associated with each materialized view.
oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS	This view displays the system-level default values of the refresh statistics attributes for materialized views.
oceanbase.DBA_MVREF_STMT_STATS	This view displays the information of the refresh statements.

View name	Description
oceanbase.DBA_OB_TTL_TASKS	This view displays the execution status of TTL tasks in the current tenant in SQL mode.
oceanbase.DBA_OB_TTL_TASK_HISTORY	This view displays the execution history of TTL tasks in the current tenant in SQL mode.

Threads

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

Constraints

View name	Description
information_schema.CHECK_CONSTRAINTS	This view displays the constraint information of tables and columns during `CREATE TABLE` operations.
information_schema.KEY_COLUMN_USAGE	This view records the constraint information of keys in a column.
information_schema.REFERENTIAL_CONSTRAINTS	This view displays the metadata of foreign key constraints.
information_schema.TABLE_CONSTRAINTS	This view describes the table constraints.

Resources

View name	Description
oceanbase.DBA_OB_SEQUENCE_OBJECTS	This view displays all SEQUENCE objects in the database.

View	Purpose
DBA_OB_RSRC_DIRECTIVES	This view displays the resource configuration parameters for the current tenant in Resource Manager.
DBA_OB_RSRC_IO_DIRECTIVES	This view displays the I/O resource configuration for the current tenant in Resource Manager.
DBA_RSRC_GROUP_MAPPINGS	This view displays the binding relationships between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	This view displays information about all resource groups in the database.
DBA_RSRC_PLANS	This view displays all resource management plans defined by the system.
DBA_RSRC_PLAN_DIRECTIVES	This view displays detailed information about each set of resource plan directives in the database.

View	Purpose
oceanbase.DBA_OBJECTS	This view displays all database objects in the database. The view definition is consistent with ALL_OBJECTS.
oceanbase.DBA_OB_TENANTS	This view displays the basic information of all tenants, including the system tenant, user-created tenants (user tenants), and the Meta tenant. You can distinguish the tenant types based on the `TENANT_TYPE` column.

View	Purpose
information_schema.CHARACTER_SETS	This view records the character set information of OceanBase Database.
information_schema.COLLATIONS	This view records the collation method information for each character set.
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY	This view records the correspondence between Character and Collation.

Overview of performance views

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

View name	Description
GV$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of the HMS Catalog client in the current tenant.
V$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of the HMS Catalog client in the current tenant.

Wait events

View	Description
GV$OB_COMPACTION_PROGRESS	This view displays the OBServer-level major compaction progress of all tenants.
GV$OB_COMPACTION_SUGGESTIONS	This view displays the major compaction suggestions.
GV$OB_PROCESSLIST	This view displays the session information of all OBServer nodes where the tenant is located.
GV$OB_COMPACTION_DIAGNOSE_INFO	This view displays the major compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information about major compaction at the tablet level.
GV$OB_TABLET_COMPACTION_PROGRESS	This view displays the major compaction progress at the tablet level.
GV$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participant information on all OBServer nodes.
GV$SESSION_EVENT	This view displays the session-level wait events on all OBServer nodes in the cluster.
GV$SESSION_WAIT	This view displays the information about the current or last wait events of all sessions on all servers, including the wait event name and wait duration.
GV$SESSION_WAIT_HISTORY	This view displays the information about the last 10 wait events of all sessions on all servers.
GV$SYSTEM_EVENT	This view displays the wait events at the tenant level for all servers in the cluster.
GV$SESSTAT	This view displays the session-level statistical events on all OBServer nodes.
GV$SYSSTAT	This view displays the tenant-level statistical events on all servers.
V$OB_COMPACTION_PROGRESS	This view displays the server-level major compaction progress of the tenant.
V$OB_COMPACTION_SUGGESTIONS	This view displays the major compaction suggestions.
V$OB_PROCESSLIST	This view displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	This view displays the major compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information about major compaction at the tablet level.
V$OB_TABLET_COMPACTION_PROGRESS	This view displays the major compaction progress at the tablet level.
V$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participants on all OBServer nodes.
V$STATNAME	This view displays the definitions of all statistics events.
V$EVENT_NAME	This view displays the definitions of all statistics events on the current OBServer node.
V$SESSION_WAIT	This view displays the details of the current waiting events for each session. As per the convention, each waiting event has three parameters, which record the corresponding values.
V$SESSION_WAIT_HISTORY	This view displays the details of the current waiting events for each session, including the last 10 waiting events.
V$SESSTAT	This view displays the statistics events at the session level.
V$SYSSTAT	This view displays the statistics events at the tenant level on the current server.
V$SYSTEM_EVENT	This view displays the statistics of waiting events at the tenant level.

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

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

View	Description
V$OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information of the current tenant.

View	Description
V$OB_SS_SSTABLES	This view displays the SSTable information of the current tenant on the shared storage.
GV$OB_SS_LOCAL_CACHE	This view displays the relevant metrics of various cache data in the local cache of each OBServer node for all tenants in shared storage mode.
V$OB_SS_LOCAL_CACHE	This view displays the relevant metrics of various cache data in the local cache of the current OBServer node for all tenants in shared storage mode.
GV$OB_STORAGE_CACHE_TASKS	This view displays the cache task information of the current tenant on all OBServer nodes.
V$OB_STORAGE_CACHE_TASKS	This view displays the cache task information of the current tenant on the current OBServer node.
GV$OB_TABLET_LOCAL_CACHE	This view displays the overall cache information of the current tenant on all OBServer nodes.
V$OB_TABLET_LOCAL_CACHE	This view displays the overall cache information of the current tenant on the current OBServer node.
GV$OB_SS_LOCAL_CACHE_DIAGNOSE	This view is used to diagnose the running status of the local cache submodules of the current tenant on each OBServer node in shared storage mode.
V$OB_SS_LOCAL_CACHE_DIAGNOSE	This view is used to diagnose the running status of the local cache submodules of the current tenant on the current OBServer node in shared storage mode.

Cache

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

View	Description
GV$OB_SHARED_STORAGE_QUOTA	This view displays IO access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA	This view displays IO access resource information on the current OBServer node.

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

View	Description
GV$OB_MEMORY	This view displays memory statistics at the tenant level.
V$OB_MEMORY	This view displays memory statistics at the tenant level.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
V$OB_MEMSTORE	This view displays MemStore statistics at the tenant level.
GV$OB_MEMSTORE_INFO	This view displays detailed information about MemTables for all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays detailed information about MemTables for all partitions of all tenants on all servers.
GV$OB_SSTABLES	This view displays SSTable information for tenants.
V$OB_SSTABLES	This view displays SSTable information for tenants.
GV$OB_TENANT_MEMORY	This view displays memory usage for each tenant in the cluster.
V$OB_TENANT_MEMORY	This view displays memory usage for each tenant in the current observer process.

View	Description
GV$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations on the current OBServer node.

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

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

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

View name	Description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	This view displays the histogram information of the query execution time on all nodes of the current tenant.
GV$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups on all OBServer nodes of the current tenant.
GV$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row, where each unique combination of `SQL_ID` and `Plan_Hash` corresponds to a row.
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row, where each unique combination of `SQL_ID` and `Plan_Hash` corresponds to a row.
GV$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level in the cluster.
V$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level on the current node.
V$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups on the current OBServer node of the current tenant.

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

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

Resource management

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

Data dump and major compaction

View	Purpose
GV$OB_MERGE_INFO	This view displays the statistics of completed major compactions in the OceanBase cluster.
V$OB_MERGE_INFO	This view displays the statistics of completed major compactions in the OceanBase cluster.

Overview of views in an Oracle tenant

Dictionary views

Applicability

This topic applies only to OceanBase Database Enterprise Edition.

Security privileges

View	Description
ALL_USERS	This view displays all database users visible to the current user.
DBA_USERS	This view displays all database users.
USER_USERS	This view displays information about the current user.
ALL_COL_PRIVS	This view displays column object privileges granted to the current user, the owner of the object, or the grantor. Column object privileges granted to enabled roles or the PUBLIC role are also displayed.
ALL_TAB_PRIVS	*This view displays object privileges granted to the current user, the owner of the object, or the grantor. Object privileges granted to activated roles or the PUBLIC role are also displayed.
DBA_COL_PRIVS	This view displays all column object privileges granted in the database.
DBA_SYS_PRIVS	This view displays system privileges granted to users and roles.
DBA_TAB_PRIVS	This view displays all object privileges granted in the database.
USER_TAB_PRIVS	This view displays object privileges owned by the current user.
USER_COL_PRIVS	This view displays column object privileges granted to the current user, the owner of the object, or the grantor.
USER_ROLE_PRIVS	This view displays roles granted to the current user.
USER_SYS_PRIVS	This view displays system privileges granted to the current user.
ROLE_TAB_PRIVS	This view displays table privileges granted to roles. Only information about roles accessible to users is provided.
ROLE_SYS_PRIVS	This view displays system privileges granted to roles.
ROLE_ROLE_PRIVS	This view displays roles granted to other roles. Only information about roles accessible to users is provided.
DBA_ROLE_PRIVS	This view displays roles granted to all users and roles in the database.
DBA_ROLES	This view displays all roles existing in the database.
ALL_DIRECTORIES	This view displays all directories accessible to the current user.
DBA_DIRECTORIES	This view displays all directories accessible to the current user.
USER_PRIVILEGES	This view displays the privileges of the current user.

View	Purpose
USER_POLICIES	This view displays the fine-grained access control policy information of the current user.
USER_POLICY_CONTEXTS	This view displays the policy context information of the current user.
USER_POLICY_GROUPS	This view displays the policy group information of the current user.
USER_SEC_RELEVANT_COLS	This view displays the column information related to the security policy of the current user.

Backup and restore

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

Views and tables

View	Description
ALL_ALL_TABLES	This view displays the object tables and relational tables accessible to the current user.
ALL_COL_COMMENTS	This view displays the column comments of all views and tables accessible to the current user.
ALL_TABLES	This view displays all tables accessible to the current user.
ALL_TAB_COLS	This view displays all columns of the tables, views, and clusters accessible to the current user.
ALL_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters accessible to the current user.
ALL_TAB_COMMENTS	This view displays the comments of the tables and views accessible to the current user.
DBA_COL_COMMENTS	This view displays the column comments of all views and tables in the database.
DBA_TAB_COMMENTS	This view displays the comments of all tables and views in the database.
USER_COL_COMMENTS	This view displays the column comments of all views and tables owned by the current user.
USER_TAB_COMMENTS	This view displays the comments of the tables and views owned by the current user.
DBA_OB_TABLEGROUP_TABLES	This view displays the association between the TABLEGROUP and TABLE. The tables not in a TABLEGROUP are not displayed.
DBA_TABLES	This view displays all tables in the database.
DBA_ALL_TABLES	This view displays the object tables and relational tables in the database. The fields of this view are the same as those of the ALL_ALL_TABLES view.
DBA_TABLESPACES	This view displays all tablespaces in the database.
DBA_TAB_COLS	This view displays all columns of the tables, views, and clusters in the database.
DBA_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters in the database.
USER_ALL_TABLES	This view displays the object tables and relational tables accessible to the current user. Except for the OWNER column, the other columns are the same as those of the ALL_ALL_TABLES view.
USER_TABLES	This view displays all tables owned by the current user.
USER_TABLESPACES	This view displays the tablespaces accessible to the current user. The columns of this view are the same as those of the `DBA_TABLESPACES` view, except for the `PLUGGED_IN` column.
USER_TAB_COLS	This view displays all columns of the tables, views, and clusters owned by the current user.
oceanbase.USER_TAB_COLS_V$	This view displays the column information of the tables and views owned by the current user.
USER_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters owned by the current user.
ALL_VIEWS	This view displays the views accessible to the current user.
DBA_VIEWS	This view displays all views in the database. The columns are the same as those in `ALL_VIEWS`.
USER_VIEWS	This view displays the views that belong to the current user.
DICTIONARY	This view displays the descriptions of data dictionary tables and views.
DICT	This view displays the descriptions of data dictionary tables and views.
DBA_OB_TABLE_LOCATIONS	This view displays the locations of tables and partitions, including system tables, user tables, and index tables.
DBA_OB_SPATIAL_COLUMNS	This view displays the database name, table name, type, and SRS information of spatial index columns.

Storage objects

View name	Description
ALL_ERRORS	This view displays errors of the storage objects accessible to the current user.
DBA_ERRORS	This view displays errors of the storage objects in the database.
USER_ERRORS	This view displays errors of the storage objects accessible to the current user.
DBA_SEGMENTS	This view displays storage information of all segments in the database.
USER_SEGMENTS	This view displays storage information of the segments of the objects in the current user.

Triggers

View name	Description
ALL_TRIGGERS	This view displays the triggers and their descriptions on the tables owned by the current user. If the current user has the CREATE ANY TRIGGER privilege, this view displays all triggers in the database.
DBA_TRIGGERS	This view displays all triggers in the database.
USER_TRIGGERS	This view displays the triggers owned by the current user.
DBA_TRIGGER_ORDERING	This view displays the execution order of triggers.
ALL_TRIGGER_ORDERING	This view displays the execution order of triggers accessible to the current user.
USER_TRIGGER_ORDERING	This view displays the execution order of triggers in the current user.

Object types

View name	Description
ALL_METHOD_PARAMS	This view displays method parameters of object types accessible to the current user.
DBA_METHOD_PARAMS	This view displays method parameters of object types in the database.
ALL_TYPE_METHODS	This view displays methods of object types accessible to the current user.
DBA_TYPE_METHODS	This view displays methods of object types in the database.
USER_TYPE_METHODS	This view displays methods of object types accessible to the current user. The fields of this view are the same as those of the ALL_TYPE_METHODS view, except that this view does not contain the OWNER field.

DBLINK

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

View	Description
ALL_PART_KEY_COLUMNS	This view displays the columns included in the partition keys of all partitioned objects accessible to the current user.
ALL_PART_TABLES	This view displays the partition information of all partitioned tables accessible to the current user.
ALL_SUBPARTITION_TEMPLATES	This view displays the descriptions of all subpartition templates.
ALL_SUBPART_KEY_COLUMNS	This view displays the columns included in the subpartition keys of all partitioned objects accessible to the current user.
ALL_TAB_PARTITIONS	This view displays the multi-level partition information, partition storage parameters, and partition statistics of all partitioned tables.
ALL_TAB_SUBPARTITIONS	This view displays the partition-level information, partition storage parameters, and partition statistics generated by the `DBMS_STATS` package for the partitioned tables accessible to the current user.
DBA_OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information of the current tenant.
DBA_PART_INDEXES	This view displays the partition information of all partitioned indexes.
DBA_PART_KEY_COLUMNS	This view displays the columns included in the partition keys of all partitioned objects in the database.
DBA_PART_TABLES	This view displays the partition information of all partitioned tables accessible to the current user.
DBA_SUBPARTITION_TEMPLATES	This view displays the descriptions of all subpartition templates.
DBA_SUBPART_KEY_COLUMNS	This view displays the columns included in the subpartition keys of all partitioned objects in the database.
DBA_TAB_PARTITIONS	This view displays the multi-level partition information, partition storage parameters, and partition statistics of all partitioned tables accessible to the current user.
DBA_TAB_SUBPARTITIONS	This view displays the subpartition name, table name, name of the partition to which it belongs, storage attributes, and statistics generated by the `DBMS_STATS` package.
USER_PART_KEY_COLUMNS	This view displays the columns included in the partition keys of all partitioned objects owned by the current user.
USER_PART_TABLES	This view displays the partition information of all partitioned tables owned by the current user.
USER_SUBPARTITION_TEMPLATES	This view displays the descriptions of all subpartition templates.
USER_SUBPART_KEY_COLUMNS	This view displays the columns included in the subpartition keys of all partitioned objects owned by the current user.
USER_TAB_SUBPARTITIONS	This view displays the subpartition name, table name, name of the partition to which it belongs, and storage attributes of each subpartition of the current user.
USER_TAB_PARTITIONS	This view displays the multi-level partition information, partition storage parameters, and partition statistics of all partitioned tables owned by the current user.

Load balancing

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

Replica logs

View	Description
DBA_OB_CS_REPLICA_STATS	This view displays the progress of converting Tablets to columnar storage in the C replicas of the OBServer nodes in the current tenant.
DBA_OB_LS_LOCATIONS	This view displays the distribution of log streams (LS) replicas in the current tenant.
DBA_OB_TABLEGROUPS	This view displays the metadata of table groups, mainly focusing on the partition information of the table groups.
DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of the table group partitions.
DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of the table group partitions.
DBA_OB_TABLET_REPLICAS	This view displays all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
DBA_OB_TABLET_TO_LS	This view displays all tablets in the current tenant and the log stream information to which each tablet belongs.
DBA_OB_LS	This view displays the status and recovery progress of log streams.

Shared storage

View	Description
DBA_OB_SS_SPACE_USAGE	This view records the storage space usage on the object storage of the current tenant.

Recycle bin

View	Description
DBA_RECYCLEBIN	This view displays information about all recycle bins in the database.
USER_RECYCLEBIN	This view displays information about the recycle bins owned by the current user. The columns are the same as those in `DBA_RECYCLEBIN`, except that the `OWNER` column is omitted.

I/O performance

View	Description
DBA_OB_STORAGE_IO_USAGE	This view displays the various I/O operations on the object storage and cloud disks of the current tenant.

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

View name	Description
DBA_OB_OUTLINES	This view displays the execution plan outlines of the current tenant.
DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the outline-related information of the throttling rules of the current tenant.
DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the execution plan outlines and throttling rule outlines of the current tenant.
DBA_OB_FORMAT_OUTLINES	This view records the details of the current tenant's format outlines.

View name	Description
DBA_SCHEDULER_JOBS	This view displays the information of scheduler jobs accessible to the current user.
DBA_SCHEDULER_PROGRAM	This view displays all the scheduler information in the database.
DBA_SCHEDULER_JOB_RUN_DETAILS	This view displays the information of all scheduler jobs in the tenant.
DBA_JOBS	This view displays the overview of submitted tasks.
USER_JOBS	This view displays the overview of submitted tasks.
DBA_JOBS_RUNNING	This view displays the running tasks.

View name	Description
USER_PLSQL_COLL_TYPES	This view displays the PL/SQL collection type information of the current user.
USER_PLSQL_TYPES	This view displays the PL/SQL type information of the current user.
USER_PLSQL_TYPE_ATTRS	This view displays the PL/SQL type attribute information of the current user.
DBA_OB_PL_OBJ_CACHE_STATUS	This view displays the PL object cache status information.

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

View name	Description
ALL_PROFILES	This view displays all profiles and their restrictions.
DBA_PROFILES	This view displays all profiles and their restrictions.
USER_PROFILES	This view displays all profiles and their restrictions.

View name	Description
DBA_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlock events. In a non-root tenant, this view displays the history of events for the current tenant.

View name	Description
DBA_SQL_PLAN_BASELINES	This view displays the plan baselines of SQL statements in SPM.
DBA_SQL_MANAGEMENT_CONFIG	This view displays the configuration parameters in SPM.

Database basic information

View	Purpose
DBA_CONTEXT	This view displays all context namespaces in the database.
DBA_OB_DATABASES	This view displays the database metadata of the current tenant.
DBA_OB_MAJOR_COMPACTION	This view displays the global major compaction information of the current tenant.
DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of each zone in the current tenant.
ALL_OBJECTS	This view displays all database objects accessible to the current user.
DBA_OBJECTS	This view displays all database objects.
USER_OBJECTS	This view displays all database objects owned by the current user.
ALL_DEPENDENCIES	This view displays the dependencies between all database objects.
DBA_DEPENDENCIES	This view displays all dependencies between database objects.
USER_DEPENDENCIES	This view displays the dependencies between objects in the current user schema.
DBA_OB_FREEZE_INFO	This view displays the version information generated by major freeze.
TENANT_VIRTUAL_GLOBAL_VARIABLE	This view displays the global variable information.
TENANT_VIRTUAL_SESSION_VARIABLE	This view displays the session variable information.

Audit

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

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

Statistics and histograms

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

Synonyms

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

Job Scheduler

View Name	Description
USER_SCHEDULER_JOBS	This view displays the information about the current user's scheduled jobs.
ALL_SCHEDULER_JOB_ARGS	This view displays the job parameters accessible to the user.
ALL_SCHEDULER_PROGRAM_ARGS	This view displays the program parameters accessible to the user.
DBA_SCHEDULER_JOB_ARGS	This view displays the job parameters in the database.
USER_SCHEDULER_JOB_ARGS	This view displays the job parameters owned by the current user.
DBA_SCHEDULER_PROGRAM_ARGS	This view displays the program parameters in the database.
USER_SCHEDULER_PROGRAM_ARGS	This view displays the program parameters owned by the current user.

WR

View Name	Description
DBA_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of the current tenant.
DBA_WR_ACTIVE_SESSION_HISTORY	This view displays the persistent ASH data of the current tenant.
DBA_WR_STATNAME	This view displays the names of the system statistics of the current tenant.
DBA_WR_SYSSTAT	This view displays the details of the system statistics of the current tenant.
DBA_WR_CONTROL	This view displays the WR configuration information.
DBA_WR_SYSTEM_EVENT	This view displays the persistent tenant-level waiting event information of the current tenant.
DBA_WR_EVENT_NAME	This view displays the persistent tenant-level waiting event names of the current tenant.
DBA_WR_SQLTEXT	This view displays the SQL text collected by WR of the current tenant.
DBA_WR_SQLSTAT	This view displays the basic performance statistics of the SQL statements executed by the current tenant.
DBA_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of the current tenant.

Materialized views

View name	Description
DBA_MVIEW_DEPS	This view displays the dependencies of materialized views in the current tenant.
DBA_MVIEW_LOGS	This view displays the logs of materialized views.
DBA_MVIEW_RUNNING_JOBS	This view displays the materialized view-related tasks, including refresh tasks and MLOG cleanup tasks, in the current tenant.
USER_MVIEWS	This view displays the information about materialized views.
DBA_MVIEWS	This view displays the information about all materialized views.
DBA_MVREF_CHANGE_STATS	This view displays the statistics about materialized view refreshes.
DBA_MVREF_RUN_STATS	This view displays the information about each run of a materialized view, identified by a refresh ID.
DBA_MVREF_STATS	This view displays the basic timing statistics about materialized view refreshes.
DBA_MVREF_STATS_PARAMS	This view displays the refresh statistics attributes associated with each materialized view.
DBA_MVREF_STATS_SYS_DEFAULTS	This view displays the system-wide default values for the statistics attributes of materialized view refreshes.
DBA_MVREF_STMT_STATS	This view displays the information about the statements associated with materialized view refreshes.
USER_MVIEW_LOGS	This view displays the logs of materialized views for the current user.
USER_MVREF_CHANGE_STATS	This view displays the statistics about materialized view refreshes for the current user.
USER_MVREF_RUN_STATS	This view displays the information about each run of a materialized view for the current user.
USER_MVREF_STATS	This view displays the basic timing statistics about materialized view refreshes for the current user.
USER_MVREF_STATS_PARAMS	This view displays the refresh statistics attributes associated with each materialized view for the current user.
USER_MVREF_STATS_SYS_DEFAULTS	This view displays the system-wide default values for the statistics attributes of materialized view refreshes for the current user.
USER_MVREF_STMT_STATS	This view displays the information about the statements associated with materialized view refreshes for the current user.

Time-to-live (TTL) features

View name	Description
DBA_OB_TTL_TASKS	This view displays the execution status of TTL tasks in the current tenant in SQL mode.
DBA_OB_TTL_TASK_HISTORY	This view displays the execution history of TTL tasks in the current tenant in SQL mode.

Source code

View name	Description
DBA_OB_SOURCE	This view displays the source code of stored procedures, functions, and other objects.
ALL_OB_SOURCE	This view displays the source code of objects accessible to the current user.
USER_OB_SOURCE	This view displays the source code of objects for the current user.

User-defined types

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

Constraints

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

Sequences

View name	Description
ALL_SEQUENCES	This view displays all SEQUENCEs accessible to the user.
DBA_SEQUENCES	This view displays all SEQUENCEs in the database.
USER_SEQUENCES	This view displays all SEQUENCEs owned by the current user.

Resource management

View	Purpose
DBA_OB_RSRC_DIRECTIVES	This view displays the resource configuration parameters of the current tenant in Resource Manager.
DBA_OB_RSRC_IO_DIRECTIVES	This view displays the I/O resource configuration of the current tenant in Resource Manager.
DBA_RSRC_GROUP_MAPPINGS	This view displays the mapping between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	This view displays the information about all resource groups in the database.
DBA_RSRC_PLANS	This view displays all resource management plans defined by the system.
DBA_RSRC_PLAN_DIRECTIVES	This view displays the details of resource plan directives in the database.

Performance views overview

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

View	Description
GV$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of the HMS Catalog client in the current tenant.
V$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of the HMS Catalog client in the current tenant.

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

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

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

View	Description
V$OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information of the current tenant.

View	Description
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans in the plan cache of all servers.
GV$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache of all servers for the current tenant.
GV$OB_PLAN_CACHE_STAT	This view records the status of each plan cache in all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans in the plan cache of the current server.
V$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache of the current server for the current tenant.
V$OB_PLAN_CACHE_STAT	This view records the status of each plan cache in all servers for the current tenant.
V$RSRC_PLAN	This view displays the resource management plan of the current active tenant.

View	Description
V$OB_SS_SSTABLES	This view displays the SSTable information on the shared storage of the current tenant.
GV$OB_SS_LOCAL_CACHE	This view 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	This view 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.

View	Description
GV$OB_SHARED_STORAGE_QUOTA	This view displays the IO access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA	This view displays the IO access resource information on the current OBServer node.

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

View name	Description
GV$OB_MEMORY	This view displays the memory usage of each tenant on all servers.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
GV$OB_SQL_WORKAREA_MEMORY_INFO	This view displays some overall information about the SQL Workarea, including the maximum available memory, current used memory, and current hold memory.
GV$OB_SSTABLES	This view displays the SSTable information of a tenant.
GV$OB_MEMSTORE_INFO	This view displays the detailed information about the MemTables of all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays the detailed information about the MemTables of all partitions of all tenants on all servers.
V$OB_MEMORY	This view displays the memory statistics at the tenant level.
V$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on the current server.
V$OB_SSTABLES	This view displays the SSTable information of a tenant.
GV$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the current observer process.

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

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

View name	Description
GV$OB_PROCESSLIST	This view displays session information on all OBServer nodes where the tenant is located.
GV$SESSION_WAIT	This view 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	This view displays information about the 10 most recent wait events of all sessions on all servers.
GV$SESSTAT	This view displays some statistics at the session level on all servers.
V$NLS_PARAMETERS	This view displays NLS parameters at the session level.
V$OB_PROCESSLIST	This view displays session information on the current OBServer node.
V$SESSION_WAIT	This view displays information about the current or previous wait events of all sessions on the current server, including the wait event name and wait time.
V$SESSION_WAIT_HISTORY	This view displays information about the 10 most recent wait events of all sessions on the current server.
V$SESSTAT	This view displays some statistics at the session level.
V$EVENT_NAME	This view displays event definitions under the tenant.

View name	Description
GV$OB_SQL_AUDIT	This view displays statistics such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	This view displays statistics such as the source and execution status of each SQL request on the current server.

View name	Description
GV$OB_FLT_TRACE_CONFIG	This view displays diagnostic information about full-link tracing.

Statistics views

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

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

View	Description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	This view displays the histogram information of the query execution time of all nodes in the current tenant.
GV$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups in all OBServer nodes of the current tenant.
V$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups in the current OBServer node of the current tenant.
GV$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row (each unique combination of `SQL_ID` and `Plan_Hash` corresponds to a row).
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (each unique combination of `SQL_ID` and `Plan_Hash` corresponds to a row).
GV$OB_SESS_TIME_MODEL	This view displays the session-level time model statistics in the cluster.
V$OB_SESS_TIME_MODEL	This view displays the session-level time model statistics on the current node.
GV$OB_SYS_TIME_MODEL	This view displays the tenant-level time model statistics in the cluster.
V$OB_SYS_TIME_MODEL	This view displays the tenant-level time model statistics on the current node.
V$OB_QUERY_RESPONSE_TIME_HISTOGRAM	This view displays the histogram information of the query execution time of the current node in the current tenant.

View	Description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, this view displays the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, this view displays the execution information of each thread.
GV$OB_PX_TARGET_MONITOR	This view displays the PX thread usage on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	This view displays the PX thread usage on OBServer nodes.

View	Description
V$SQL_MONITOR_STATNAME	This view displays the meaning of the numeric values in the `OTHERSTAT_X_ID` column of `GV$SQL_PLAN_MONITOR`.
GV$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has one statistics record, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has one statistics record, and the trace information of the plan is recorded.

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

Resource management

View	Purpose
GV$OB_GROUP_IO_STAT	This view displays the real-time status of each resource group on all OBServer nodes of the current tenant.
GV$OB_FUNCTION_IO_STAT	This view displays the I/O statistics at the Function level on all OBServer nodes of the current tenant.
V$OB_GROUP_IO_STAT	This view displays the real-time status of each resource group on the current OBServer node of the current tenant.
V$OB_FUNCTION_IO_STAT	This view displays the I/O statistics at the Function level on the current OBServer node of the current tenant.

Overview of views in the sys tenant

Dictionary views overview

AI models

View name	Description
oceanbase.CDB_OB_AI_MODELS	This view displays the AI model information of all tenants.
oceanbase.CDB_OB_AI_MODEL_ENDPOINTS	This view displays the AI model endpoint information of all tenants.
oceanbase.DBA_OB_AI_MODELS	This view displays the AI model information of the current tenant.
oceanbase.DBA_OB_AI_MODEL_ENDPOINTS	This view displays the AI model endpoint information of the current tenant.

Security privileges

View name	Description
oceanbase.CDB_OB_USERS	This view displays the user information of all tenants.
oceanbase.CDB_OB_DATABASE_PRIVILEGE	This view displays the database-level privileges of all tenants.
oceanbase.DBA_OB_AUTO_INCREMENT	This view displays the auto-increment column information of the current tenant.
oceanbase.DBA_OB_USERS	This view displays the user information of the current tenant.
oceanbase.DBA_OB_DATABASE_PRIVILEGE	This view displays the database-level privileges of the current tenant.
oceanbase.DBA_OB_USER_DEFINED_RULES	This view displays the user-defined rule information.

Security policies

View name	Description
oceanbase.DBA_POLICIES	This view displays the fine-grained access control (FAC) policy information.
oceanbase.DBA_POLICY_CONTEXTS	This view displays the policy context information.
oceanbase.DBA_POLICY_GROUPS	This view displays the policy group information.
oceanbase.DBA_SEC_RELEVANT_COLS	This view displays the column information related to security policies.
oceanbase.ALL_POLICIES	This view displays the FAC policy information accessible to the current user.
oceanbase.ALL_POLICY_CONTEXTS	This view displays the policy context information accessible to the current user.
oceanbase.ALL_POLICY_GROUPS	This view displays the policy group information accessible to the current user.
oceanbase.ALL_SEC_RELEVANT_COLS	This view displays the column information related to security policies and accessible to the current user.

Backup and restore

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

Views and columns

View	Description
oceanbase.CDB_IND_COLUMNS	This view displays the column information of the index tables of all tenants.
oceanbase.CDB_INDEXES	This view displays the INDEX information of all tenants.
oceanbase.CDB_TABLES	This view displays the TABLE information of all tenants.
oceanbase.CDB_OB_TABLEGROUP_TABLES	This view displays the association between the TABLEGROUP and TABLE of all tenants under the sys tenant. The tables not in the TABLEGROUP are not displayed.
oceanbase.CDB_TAB_COLS	This view displays the column information of the tables and views of all tenants.
oceanbase.CDB_TAB_COLS_V$	This view displays the column information of the tables and views of all tenants.
oceanbase.DBA_OB_TABLEGROUP_TABLES	This view displays the association between the TABLEGROUP and TABLE. The tables not in the TABLEGROUP are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	This view displays the columns of the partitioning keys in all partitioned objects.
oceanbase.DBA_SUBPART_KEY_COLUMNS	This view displays the columns of the subpartitioning keys in all partitioned objects.
oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO	This view displays the column checksum inconsistency information between the index tables (global and local indexes) and the primary tables.
oceanbase.CDB_OB_TABLE_LOCATIONS	This view displays the locations of tables and partitions, including system tables, user tables, and index tables.
oceanbase.DBA_OB_TABLE_LOCATIONS	This view displays the locations of tables and partitions, including system tables, user tables, and index tables.
information_schema.TABLESPACES	This view displays information about tablespaces. Note This view is provided for MySQL 5.7 compatibility. The related features are not supported. You can only query the table structure.
oceanbase.DBA_TABLES	This view displays the table information of the current tenant.
oceanbase.CDB_INDEX_USAGE	This view displays the index usage statistics of all tenants.
oceanbase.DBA_INDEX_USAGE	This view displays the index usage statistics of the current tenant.
oceanbase.DBA_TAB_COLS_V$	This view displays the column information of the tables and views of the current tenant.
oceanbase.DBA_OB_TABLE_SPACE_USAGE	This view displays the space usage of tables of the current tenant.

CCL

View	Description
oceanbase.CDB_OB_CCL_RULES	This view displays the concurrency control throttling rules of all tenants.
oceanbase.DBA_OB_CCL_RULES	This view displays the concurrency control throttling rules of the current tenant.

View	Purpose
oceanbase.CDB_OB_SPACE_USAGE	This view displays the space usage of all tenants.
oceanbase.CDB_OB_SERVER_SPACE_USAGE	This view displays the space usage of all OBServer nodes.
oceanbase.CDB_OB_TABLE_SPACE_USAGE	This view displays the space usage of all tables in all tenants.

View	Purpose
oceanbase.CDB_OB_ACCESS_POINT	This view displays the access endpoints of all tenants.
oceanbase.DBA_OB_ACCESS_POINT	This view displays the access endpoints of the current tenant.

View	Description
oceanbase.CDB_IND_PARTITIONS	This view displays the partition information of all index tables in all tenants.
oceanbase.CDB_IND_SUBPARTITIONS	This view displays the subpartition information of all indexes in all tenants.
oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information of all tenants.
oceanbase.CDB_PART_INDEXES	This view displays the partition information of all index tables in all tenants.
oceanbase.CDB_PART_TABLES	This view displays the partition information of all partitioned tables in all tenants.
oceanbase.CDB_SUBPARTITION_TEMPLATES	This view displays the secondary partition information of all partitioned tables in all tenants.
oceanbase.CDB_TAB_PARTITIONS	This view displays the partition information of all partitioned tables in all tenants.
oceanbase.CDB_TAB_SUBPARTITIONS	This view displays the secondary partition information of all partitioned tables in all tenants.
oceanbase.DBA_IND_PARTITIONS	This view displays the partition information of all indexes in all tenants.
oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information of the current tenant.
oceanbase.DBA_PART_INDEXES	This view displays the partition information of all partitioned indexes.
oceanbase.DBA_PART_TABLES	This view displays the partition information of all user tables.
oceanbase.DBA_TAB_PARTITIONS	This view displays the multi-level partition information, partition storage parameters, and partition statistics that the current user can access.
oceanbase.DBA_TAB_SUBPARTITIONS	This view displays the subpartition name, table name, partition name, storage attributes, and statistics generated by the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	This view displays the subpartition template description information.

Load balancing

View	Description
oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT	This view displays all partitions with special weights in all user tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS	This view displays the current partition transfer tasks of all tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the history of executed partition transfer tasks of all tenants.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	This view displays the current partition transfer tasks of the current tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the history of executed partition transfer tasks of the current tenant.
oceanbase.CDB_OB_BALANCE_JOBS	This view displays the load balancing jobs of all tenants.
oceanbase.CDB_OB_BALANCE_JOB_HISTORY	This view displays the history of executed load balancing jobs of all tenants.
oceanbase.CDB_OB_BALANCE_TASKS	This view displays the load balancing tasks of all tenants.
oceanbase.CDB_OB_BALANCE_TASK_HISTORY	This view displays the history of executed load balancing tasks of all tenants.
oceanbase.CDB_OB_TRANSFER_TASKS	This view displays the transfer tasks of all tenants.
oceanbase.CDB_OB_TRANSFER_TASK_HISTORY	This view displays the history of executed transfer tasks of all tenants.
oceanbase.DBA_OB_BALANCE_JOBS	This view displays the load balancing jobs of the current tenant.
oceanbase.DBA_OB_BALANCE_JOB_HISTORY	This view displays the history of executed load balancing jobs of the current tenant.
oceanbase.DBA_OB_BALANCE_TASKS	This view displays the load balancing tasks of the current tenant.
oceanbase.DBA_OB_BALANCE_TASK_HISTORY	This view displays the history of executed load balancing tasks of the current tenant.
oceanbase.DBA_OB_TRANSFER_TASKS	This view displays the transfer tasks of the current tenant.
oceanbase.DBA_OB_TRANSFER_TASK_HISTORY	This view displays the history of executed transfer tasks of the current tenant.

View name	Description
oceanbase.CDB_OB_CS_REPLICA_STATS	This view displays the progress of converting tablets to columnar storage in the log streams of C replicas on all OBServer nodes of all tenants.
oceanbase.CDB_OB_LS_LOCATIONS	This view displays the distribution of log stream (LS) replicas for all tenants.
oceanbase.CDB_OB_TABLEGROUPS	This view displays the metadata of table groups for all tenants under the sys tenant, mainly focusing on the partition information of the table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of partitioned table groups for all tenants under the sys tenant.
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of partitioned table groups for all tenants under the sys tenant.
oceanbase.CDB_OB_TABLET_TO_LS	This view displays the list of tablets and the log stream information to which each tablet belongs for all tenants under the sys tenant.
oceanbase.CDB_OB_TABLET_REPLICAS	This view displays the information of all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: `<TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.CDB_PART_KEY_COLUMNS	This view displays the primary partition key information of partitioned objects (partitioned tables and partitioned indexes) for all tenants.
oceanbase.CDB_SUBPART_KEY_COLUMNS	This view displays the secondary partition key information of partitioned objects (partitioned tables and partitioned indexes) for all tenants.
oceanbase.DBA_IND_SUBPARTITIONS	This view displays the information of all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of table groups, mainly focusing on the partition information of the table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays the information of all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	This view displays the list of tablets and the log stream information to which each tablet belongs in the current tenant.
oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution of log stream (LS) replicas in the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO	This view displays the information about data inconsistencies between tablet replicas.
oceanbase.CDB_OB_LS	This view displays the status and recovery progress of log streams.
oceanbase.DBA_OB_LS	This view displays the status and restore progress of log streams.
oceanbase.CDB_OB_LS_HISTORY	This view displays the historical information of log streams for all tenants.
oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS	This view displays the log stream archiving progress for all tenants.
oceanbase.CDB_OB_LS_REPLICA_TASKS	This view displays the log stream replica tasks for all tenants.
oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY	This view displays the historical information of log stream replica tasks for all tenants.
oceanbase.CDB_OB_LOG_RESTORE_SOURCE	This view displays the log restore source information for all tenants.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS	This view displays the arbitration replica tasks for all tenants.
oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY	This view displays the historical information of arbitration replica tasks for all tenants.
oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN	This view displays the flashback log SCN information for all tenants.
oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG	This view displays the data dictionary information in the logs of all tenants.
oceanbase.DBA_OB_LS_HISTORY	This view displays the historical information of log streams for the current tenant.
oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS	This view displays the log stream archiving progress for the current tenant.
oceanbase.DBA_OB_LS_REPLICA_TASKS	This view displays the log stream replica tasks for the current tenant.
oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY	This view displays the historical information of log stream replica tasks for the current tenant.
oceanbase.DBA_OB_LOG_RESTORE_SOURCE	This view displays the log restore source information for the current tenant.
oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS	This view displays the arbitration replica tasks for the current tenant.
oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY	This view displays the historical information of arbitration replica tasks for the current tenant.
oceanbase.DBA_OB_ARBITRATION_SERVICE	This view displays the arbitration service information.
oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN	This view displays the flashback log SCN information for the current tenant.
oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG	This view displays the data dictionary information in the logs of the current tenant.
oceanbase.ALL_LOCATIONS	This view displays the locations of tables or partitions accessible to the current user.

Service management

View	Purpose
oceanbase.CDB_OB_SERVICES	This view displays the service information of all tenants.
oceanbase.DBA_OB_SERVICES	This view displays the service information of the current tenant.
oceanbase.DBA_OB_SERVER_JOBS	This view displays the tasks related to all OBServer nodes.
oceanbase.DBA_OB_SERVERS	This view displays the information about all OBServer nodes.

Shared storage

View	Purpose
CDB_OB_SS_SPACE_USAGE	This view records the storage space occupied by each tenant on the object storage.
DBA_OB_SS_SPACE_USAGE	This view records the storage space occupied by the current tenant on the object storage.
DBA_OB_ZONE_STORAGE	This view displays the information about the object storage of the shared storage cluster configured in each zone.

InnoDB storage engine

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

View	Description
oceanbase.CDB_OB_TEMP_FILES	This view displays the information about temporary files of all tenants.
oceanbase.DBA_OB_TEMP_FILES	This view displays the information about temporary files.

View	Description
CDB_OB_STORAGE_IO_USAGE	This view displays the I/O operations of object storage and cloud disks for all tenants.

View	Description
oceanbase.CDB_OB_KV_TTL_TASKS	This view displays the TTL tasks being executed by all tenants under the sys tenant.
oceanbase.CDB_OB_KV_TTL_TASK_HISTORY	This view displays the historical TTL tasks of all tenants under the sys tenant.
oceanbase.DBA_OB_KV_TTL_TASKS	This view displays the TTL tasks being executed by the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	This view displays the historical TTL tasks of the current tenant.
V$OB_KV_CLIENT_INFO	This view displays the configuration parameters of all OBKV tenant clients connected to the current node.
GV$OB_KV_CLIENT_INFO	This view displays the configuration parameters of all OBKV tenant clients.
oceanbase.CDB_OB_KV_REDIS_TABLE	This view displays the information about OBKV Redis tables of all tenants.
oceanbase.DBA_OB_KV_REDIS_TABLE	This view displays the information about OBKV Redis tables of the current tenant.

View	Description
oceanbase.DBA_OB_OUTLINES	This view displays the execution plan outline information of the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the outline-related information of the throttling rules of the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the execution plan and throttling rule outline history information of the current tenant.
DBA_OB_FORMAT_OUTLINES	This view records the details of the format outline of the current tenant.

PLSQL types

View name	Description
oceanbase.DBA_PLSQL_COLL_TYPES	This view displays information about PL/SQL collection types.
oceanbase.DBA_PLSQL_TYPES	This view displays information about PL/SQL types.
oceanbase.DBA_PLSQL_TYPE_ATTRS	This view displays information about PL/SQL type attributes.
oceanbase.ALL_PLSQL_COLL_TYPES	This view displays information about PL/SQL collection types accessible to the current user.
oceanbase.ALL_PLSQL_TYPES	This view displays information about PL/SQL types accessible to the current user.
oceanbase.ALL_PLSQL_TYPE_ATTRS	This view displays information about PL/SQL type attributes accessible to the current user.

Full-text indexes

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

Task scheduler

View name	Description
oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS	This view displays the details of job runs for all tenants.
oceanbase.DBA_SCHEDULER_WINDOWS	This view displays information about scheduling windows.
oceanbase.DBA_SCHEDULER_JOB_CLASSES	This view displays information about job classes.
oceanbase.ALL_SCHEDULER_WINDOWS	This view displays information about scheduling windows accessible to the current user.

Event history monitoring

View name	Description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlock events. The view displays the history of all tenants under the root tenant.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlock events. The view displays the history of the current tenant under a non-root tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	This view displays the event history of OBServer nodes.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	This view displays the event history of the Root Service.

SPM

View name	Description
oceanbase.CDB_OB_SPM_EVO_RESULT	This view displays the evolution results of SQL plan management for all tenants.
oceanbase.DBA_OB_SPM_EVO_RESULT	This view displays the evolution results of SQL plan management for the current tenant.

Upgrade

View name	Description
oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY	This view displays the event history of the cluster.

Basic database information

View name	Description
oceanbase.CDB_OB_DATABASES	This view displays the database metadata of all tenants under the sys tenant.
oceanbase.DBA_OB_DATABASES	This view displays the database metadata of the current tenant.

| information_schema.events | This view records all event information. | | oceanbase.CDB_OB_AUTO_INCREMENT | This view displays the information of auto-increment columns for all tenants. |

View name	Description
oceanbase.DBA_TAB_STATISTICS	This view displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	This view displays the column statistics and histogram information of all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	This view displays the column statistics and histogram information of all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information of all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	This view displays the histograms of all columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	This view displays the histogram data (endpoints of each histogram) of all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	This view displays the histogram data (endpoints of each histogram) of all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	This view displays the table statistics history of all tables in the database.
oceanbase.DBA_IND_STATISTICS	This view displays the optimizer statistics of all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	This view displays the cumulative modification information of tables in the database.
oceanbase.CDB_TAB_COL_STATISTICS	This view displays the column-level statistics in the sys tenant.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	This view queries the historical execution of table statistics collection.
oceanbase.CDB_OB_AUX_STATISTICS	This view displays the auxiliary statistics of all tenants.
oceanbase.DBA_OB_AUX_STATISTICS	This view displays the auxiliary statistics of the current tenant.
oceanbase.DBA_OB_TABLE_STAT_STALE_INFO	This view displays the staleness of statistics.
oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY	This view displays the history of table statistics collection tasks.

External resources

View	Description
oceanbase.CDB_OB_EXTERNAL_RESOURCES	This view displays all uploaded resource files.
oceanbase.CDB_OB_EXTERNAL_TABLE_FILES	This view displays the file list of all external tables created by tenants.
oceanbase.DBA_OB_EXTERNAL_RESOURCES	This view displays the uploaded resource files.
oceanbase.DBA_OB_EXTERNAL_TABLE_FILES	This view displays the file list of all external tables created in the current tenant.
oceanbase.ALL_OB_EXTERNAL_TABLE_FILES	This view displays the file list of all external tables accessible to the current user.

Foreign keys

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

View name	Description
oceanbase.CDB_MVIEW_RUNNING_JOBS	This view displays the current materialized view-related tasks, including refresh tasks and MLOG cleanup tasks, for all tenants.
oceanbase.CDB_MVIEWS	This view displays the materialized view information for all tenants.
oceanbase.CDB_MVIEW_LOGS	This view displays the materialized view log information for all tenants.
oceanbase.CDB_MVREF_CHANGE_STATS	This view displays the statistics related to materialized view refreshes for all tenants.
oceanbase.CDB_MVREF_RUN_STATS	This view displays the information about each refresh operation for all tenants.
oceanbase.CDB_MVREF_STATS	This view displays the basic timing statistics of materialized view refreshes for all tenants.
oceanbase.CDB_MVREF_STATS_PARAMS	This view displays the refresh statistics attributes associated with each materialized view for all tenants.
oceanbase.CDB_MVREF_STATS_SYS_DEFAULTS	This view displays the system-wide default values of the statistics attributes of materialized view refreshes for all tenants.
oceanbase.CDB_MVREF_STMT_STATS	This view displays the information about the refresh statements associated with each materialized view for all tenants.
oceanbase.DBA_MVIEW_DEPS	This view displays the dependencies of materialized views for the current tenant.
oceanbase.DBA_MVIEW_LOGS	This view displays the materialized view log information.
oceanbase.DBA_MVIEW_RUNNING_JOBS	This view displays the current materialized view-related tasks, including refresh tasks and MLOG cleanup tasks, for the current tenant.
oceanbase.DBA_MVIEWS	This view displays the information about all materialized views.
oceanbase.DBA_MVREF_CHANGE_STATS	This view displays the statistics related to materialized view refreshes.
oceanbase.DBA_MVREF_RUN_STATS	This view displays the information about each refresh operation. Each refresh operation is identified by a REFRESH_ID.
oceanbase.DBA_MVREF_STATS	This view displays the basic timing statistics of materialized view refreshes.
oceanbase.DBA_MVREF_STATS_PARAMS	This view displays the refresh statistics attributes associated with each materialized view.
oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS	This view displays the system-wide default values of the statistics attributes of materialized view refreshes.
oceanbase.DBA_MVREF_STMT_STATS	This view displays the information about the refresh statements associated with each materialized view.
oceanbase.ALL_MVIEWS	This view displays the information about materialized views accessible to the current user.
oceanbase.ALL_MVIEW_LOGS	This view displays the information about materialized view logs accessible to the current user.

View name	Description
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data of all tenants.
oceanbase.CDB_WR_CONTROL	This view displays the WR configuration information.
oceanbase.CDB_WR_EVENT_NAME	This view displays the tenant-level wait event names of all tenants.
oceanbase.CDB_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of all tenants.
oceanbase.CDB_WR_SQLSTAT	This view displays the basic performance statistics of all SQL statements executed by all tenants. Each SQL statement is displayed as a row (each unique combination of `SQL_ID` and `Plan_Hash` is displayed as a row).
oceanbase.CDB_WR_SQLTEXT	This view displays the SQL text collected by WR for all tenants.
oceanbase.CDB_WR_STATNAME	This view displays the names of the system statistics of all tenants.
oceanbase.CDB_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of all tenants.
oceanbase.CDB_WR_SYSSTAT	This view displays the details of the system statistics of all tenants.
oceanbase.CDB_WR_SYSTEM_EVENT	This view displays the tenant-level wait event information of all tenants.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data of the current tenant.
oceanbase.DBA_WR_CONTROL	This view displays the WR configuration information.
oceanbase.DBA_WR_EVENT_NAME	This view displays the tenant-level wait event names of the current tenant.
oceanbase.DBA_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of the current tenant.
oceanbase.DBA_WR_SQLSTAT	This view displays the basic performance statistics of all SQL statements executed by the current tenant. Each SQL statement is displayed as a row (each unique combination of `SQL_ID` and `Plan_Hash` is displayed as a row).
oceanbase.DBA_WR_SQLTEXT	This view displays the SQL text collected by WR for the current tenant.
oceanbase.DBA_WR_STATNAME	This view displays the names of the system statistics of the current tenant.
oceanbase.DBA_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of the current tenant.
oceanbase.DBA_WR_SYSSTAT	This view displays the details of the system statistics of the current tenant.
oceanbase.DBA_WR_SYSTEM_EVENT	This view displays the tenant-level wait event information after persistence.
oceanbase.CDB_WR_SQL_PLAN	This view displays the SQL execution plans collected by WR for all tenants.
oceanbase.CDB_WR_RES_MGR_SYSSTAT	This view displays the resource manager statistics collected by WR for all tenants.
oceanbase.DBA_WR_SQL_PLAN	This view displays the SQL execution plans collected by WR for the current tenant.
oceanbase.DBA_WR_RES_MGR_SYSSTAT	This view displays the resource manager statistics collected by WR for the current tenant.

Vector index

View	Description
oceanbase.CDB_OB_VECTOR_INDEX_TASKS	This view displays the vector index tasks of all tenants.
oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY	This view displays the vector index task history of all tenants.
oceanbase.DBA_OB_VECTOR_INDEX_TASKS	This view displays the vector index tasks of the current tenant.
oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY	This view displays the vector index task history of the current tenant.

Major compaction

View	Description
oceanbase.CDB_OB_MAJOR_COMPACTION	This view displays the global major compaction information of all tenants under the sys tenant.
oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of each zone of all tenants under the sys tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	This view displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of each zone of the current tenant.
oceanbase.CDB_OB_FREEZE_INFO	This view displays the version information generated by major freeze.
oceanbase.DBA_OB_FREEZE_INFO	This view displays the version information generated by major freeze.

Certificate management

View	Description
oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE	This view displays the information of trusted root certificates.

Resource management

View	Description
oceanbase.DBA_OB_RESOURCE_POOLS	This view displays the resource pool information of all tenants.
oceanbase.DBA_OB_UNIT_JOBS	This view displays all unit-related tasks.
oceanbase.DBA_OB_UNITS	This view displays the unit information of all tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	This view displays the unit specifications of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	This view displays all SEQUENCE objects in the database.
CDB_OB_RSRC_DIRECTIVES	This view displays the resource configuration parameters of all tenants in the Resource Manager.

Tenant management

View name	Description
oceanbase.DBA_OBJECTS	This view displays all database objects. The view definition is consistent with that of ALL_OBJECTS.
oceanbase.CDB_OBJECTS	This view displays the object information of all tenants under the sys tenant.
oceanbase.DBA_OB_TENANTS	This view displays the basic information of all tenants, including the sys tenant, user-created tenants (user tenants), and the meta tenant. You can use the `TENANT_TYPE` column to distinguish the types of tenants.
oceanbase.DBA_OB_TENANT_JOBS	This view displays the task information at the tenant level.
oceanbase.CDB_OB_SYS_VARIABLES	This view displays the system variable information of all tenants under the sys tenant.
oceanbase.CDB_OB_TENANT_EVENT_HISTORY	This view displays the tenant event history of all tenants.
oceanbase.DBA_OB_ZONES	This view displays the information of all zones.

Tenant cloning

View name	Description
oceanbase.DBA_OB_CLONE_HISTORY	This view displays the tenant cloning history.
oceanbase.DBA_OB_CLONE_PROGRESS	This view displays the tenant cloning progress.

View name	Description
oceanbase.CDB_OB_TTL_TASKS	This view displays the execution status of all user tenants' TTL tasks in SQL mode.
oceanbase.CDB_OB_TTL_TASK_HISTORY	This view displays the execution history of all user tenants' TTL tasks in SQL mode.
oceanbase.DBA_OB_TTL_TASKS	This view displays the execution status of the TTL tasks in SQL mode of the current tenant.
oceanbase.DBA_OB_TTL_TASK_HISTORY	This view displays the execution history of the TTL tasks in SQL mode of the current tenant.

Overview of performance views

View	Description
GV$ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$ACTIVE_SESSION_HISTORY	This view displays the active session history.
GV$OB_ACTIVE_SESSION_HISTORY	This view displays the active session history of all OBServer nodes for all tenants.
V$OB_ACTIVE_SESSION_HISTORY	This view displays the active session history of the current OBServer node for all tenants.

View	Description
GV$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of HMS Catalog clients for all tenants.
V$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of HMS Catalog clients for all tenants.

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

View	Description
GV$OB_TABLET_REPLICA_INFO	This view displays the basic information of all tablet replicas on each node for all tenants, including the tenant, log stream, table, database, and disk usage.
V$OB_TABLET_REPLICA_INFO	This view displays the basic information of all tablet replicas on the current node for all tenants, including the tenant, log stream, table, database, and disk usage.
GV$OB_LOG_STAT	This view displays the status of Palf.
GV$OB_LS_SNAPSHOTS	This view displays the information of log stream snapshots persisted in all units.
V$OB_LOG_STAT	This view displays the status of Palf.

View	Description
V$OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information for all tenants.

Shared storage

View name	Description
V$OB_SS_SSTABLES	This view displays the SSTable information on the shared storage of all tenants.
GV$OB_SS_LOCAL_CACHE	This view displays the metrics of various cache data in the local cache of each OBServer node for all tenants in shared storage mode.
V$OB_SS_LOCAL_CACHE	This view displays the metrics of various cache data in the local cache of the current OBServer node for all tenants in shared storage mode.
GV$OB_STORAGE_CACHE_TASKS	This view displays the cache task information on all OBServer nodes for all tenants.
V$OB_STORAGE_CACHE_TASKS	This view displays the cache task information on the current OBServer node for all tenants.
GV$OB_TABLET_LOCAL_CACHE	This view displays the overall cache information on all OBServer nodes for all tenants.
V$OB_TABLET_LOCAL_CACHE	This view displays the overall cache information on the current OBServer node for all tenants.
GV$OB_SERVER_STORAGE	This view displays the information about the object storage configured for the shared storage cluster on all OBServer nodes.
V$OB_SERVER_STORAGE	This view displays the information about the object storage configured for the shared storage cluster on the current OBServer node.
GV$OB_SS_LOCAL_CACHE_DIAGNOSE	This view is used to diagnose the running status of the local cache submodules for all tenants on each OBServer node in shared storage mode.
V$OB_SS_LOCAL_CACHE_DIAGNOSE	This view is used to diagnose the running status of the local cache submodules for all tenants on the current OBServer node in shared storage mode.

I/O

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

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

View	Purpose
GV$OB_MEMORY	This view displays the memory statistics of the tenant.
V$OB_MEMORY	This view displays the memory statistics of the tenant.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
V$OB_MEMSTORE	This view displays the MemStore statistics of the tenant.
GV$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
GV$OB_SSTABLES	This view displays the SSTable information of the tenant.
V$OB_SSTABLES	This view displays the SSTable information of the tenant.
GV$OB_TENANT_MEMORY	This view displays the memory usage of each tenant on the cluster.
V$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the current observer process.

View	Description
GV$OB_PROCESSLIST	This view displays session information on all OBServer nodes of the tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	This view displays the diagnostic information of COMPACTION.
GV$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information of TABLET-level COMPACTION.
GV$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress information of TABLET-level COMPACTION.
GV$OB_TRANSACTION_PARTICIPANTS	This view displays the information of transaction participants on all OBServer nodes.
GV$SESSION_EVENT	This view displays the session-level waiting events on all OBServer nodes in the cluster.
GV$SESSION_WAIT	This view displays the information of the current or previous waiting events of all sessions on all servers, including the waiting event name and waiting time.
GV$SESSION_WAIT_HISTORY	This view displays the information of the last 10 waiting events of all sessions on all servers.
GV$SYSTEM_EVENT	This view displays the waiting events at the tenant level in the cluster.
GV$SESSTAT	This view displays the session-level statistical events on all OBServer nodes.
GV$SYSSTAT	This view displays the tenant-level statistical events on all servers.
V$OB_COMPACTION_PROGRESS	This view displays the server-level major compaction progress of the tenant.
V$OB_COMPACTION_SUGGESTIONS	This view displays the suggestions of COMPACTION.
V$OB_PROCESSLIST	This view displays the session information on the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	This view displays the diagnostic information of COMPACTION.
V$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information of TABLET-level COMPACTION.
V$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress information of TABLET-level COMPACTION.
V$OB_TRANSACTION_PARTICIPANTS	This view displays the information of transaction participants on all OBServer nodes.
V$STATNAME	This view displays the definitions of all statistical events.
V$EVENT_NAME	This view displays all statistics event definitions on the current OBServer node.
V$SESSION_WAIT	This view displays the current waiting event details for each session. Each waiting event has three parameters, which record the corresponding values.
V$SESSION_WAIT_HISTORY	This view displays the current waiting event details for each session, including the last 10 waiting events.
V$SESSTAT	This view displays the statistics event overview at the session level.
V$SYSSTAT	This view displays the statistics event information at the tenant level on the current server.
V$SYSTEM_EVENT	This view displays the waiting event statistics at the tenant level.
GV$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations on the current OBServer node.

View	Description
GV$OB_PLAN_CACHE_STAT	This view displays the overall status of each plan cache on all OBServer nodes for the current tenant.
V$OB_PLAN_CACHE_STAT	This view records the overall status of each plan cache on all servers for the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache on all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache on the current server for the current tenant.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan caches on all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	This view monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
V$OB_PS_STAT	This view monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
GV$OB_PS_ITEM_INFO	This view provides monitoring capabilities for prepared statements and contains basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	This view provides monitoring capabilities for prepared statements and contains basic information about all prepared statements in the PS cache.
GV$OB_PX_P2P_DATAHUB	This view displays information about data transmission operations in parallel execution.
GV$OB_PX_TARGET_MONITOR	This view displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	This view displays the usage of PX threads on the OBServer node.
GV$OB_SQL_AUDIT	This view displays statistics such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	This view displays statistics such as the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	This view displays statistics about slow queries on all OBServer nodes, with each slow query having a corresponding entry, and also records the trace information of the plan.
V$SQL_PLAN_MONITOR	This view displays statistics about slow queries at the operation level, with each operation having a corresponding entry.
V$SQL_MONITOR_STATNAME	This view displays the meaning of the numbers in the `OTHERSTAT_X_ID` column of `GV$SQL_PLAN_MONITOR`.
GV$OB_FLT_TRACE_CONFIG	This view displays diagnostic information about full-link tracing.

View name	Description
GV$OB_SESSION	This view records session information created in all servers.

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

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

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

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

View	Description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	This view displays histogram information about the execution time of queries on all nodes for all tenants.
GV$OB_RES_MGR_SYSSTAT	This view displays statistics about resource groups on all OBServer nodes for all tenants.
GV$OB_SESS_TIME_MODEL	This view displays session-level Time Model statistics in the cluster.
GV$OB_SQLSTAT	This view displays basic performance statistics for SQL statements in the cluster. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).
GV$OB_SYS_TIME_MODEL	This view displays tenant-level Time Model statistics in the cluster.
V$OB_QUERY_RESPONSE_TIME_HISTOGRAM	This view displays histogram information about the execution time of queries on the current node for all tenants.
V$OB_RES_MGR_SYSSTAT	This view displays statistics about resource groups on the current OBServer node for all tenants.
V$OB_SESS_TIME_MODEL	This view displays session-level Time Model statistics on the current node.
V$OB_SQLSTAT	This view displays basic performance statistics for SQL statements on the current node. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).
V$OB_SYS_TIME_MODEL	This view displays tenant-level Time Model statistics on the current node.

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

View	Description
GV$OB_MERGE_INFO	This view displays statistics about completed compactions in the OceanBase cluster.
V$OB_MERGE_INFO	This view displays statistics about completed compactions in the OceanBase cluster.
GV$OB_COMPACTION_PROGRESS	This view displays the major compaction progress at the OBServer level for a tenant.
GV$OB_COMPACTION_SUGGESTIONS	This view displays suggestions for major compactions.

Resource management

View	Purpose
GV$OB_GROUP_IO_STAT	This view displays the real-time status of each resource group on all OBServer nodes for all tenants.
GV$OB_FUNCTION_IO_STAT	This view displays the I/O statistics of Function level on all OBServer nodes for all tenants.
V$OB_GROUP_IO_STAT	This view displays the real-time status of each resource group on the current OBServer node for all tenants.
V$OB_FUNCTION_IO_STAT	This view displays the I/O statistics of Function level on the current OBServer node for all tenants.

Overview of views in a MySQL tenant

Dictionary views overview

Backup and restore

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

Views and columns

View	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 information about tables and views used in view definitions.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the association between TABLEGROUP and TABLE. Tables not in a TABLEGROUP are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays columns included in the partition keys of all partitioned objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	Displays columns included in the subpartition keys of all partitioned objects in the database.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the location of tables or partitions, including system tables, user tables, and index tables.
information_schema.TABLESPACES	Information about tablespaces. Note This view is available only for MySQL 5.7 compatibility. The related features are not supported, and only table structures can be queried.
oceanbase.DBA_TABLES	Displays information about all tables in the current tenant.

Storage

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

Access control

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

View name	Description
information_schema.PARTITIONS	Records partition information.
oceanbase.DBA_IND_PARTITIONS	Displays the primary partition information of an index.
oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES	Displays the dynamic partition table information of the current tenant.
oceanbase.DBA_PART_INDEXES	Displays the partition information of all partition 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 information accessible to the current user.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the subpartition name, table name, partition name, 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_OBJECT_BALANCE_WEIGHT	Displays all partitions with special weights in the current user tenant.
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
oceanbase.DBA_OB_CS_REPLICA_STATS	This view displays the progress of converting tablets in the C replica log stream on all OBServer nodes of the current tenant.
oceanbase.DBA_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partitions of a partitioned table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partitions of a partitioned table group.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of a table group, mainly the partition information of the table group.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays the information about all tablet replicas of the current tenant. Each tablet replica is uniquely determined by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	This view displays the list of all tablets of the current tenant and the log stream to which each tablet belongs.
oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution of log stream (LS) replicas of the current tenant.
oceanbase.DBA_OB_CS_REPLICA_STATS	This view displays the progress of converting tablets in the C replica log stream on all OBServer nodes of the current tenant.
oceanbase.DBA_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partitions of a partitioned table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partitions of a partitioned table group.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of a table group, mainly the partition information of the table group.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays the information about all tablet replicas of the current tenant. Each tablet replica is uniquely determined by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	This view displays the list of all tablets of the current tenant and the log stream to which each tablet belongs.
oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution of log stream (LS) replicas of the current tenant.

View name	Description
DBA_OB_SS_SPACE_USAGE	This view records the storage space usage on the object storage of the current tenant.

Help commands

View	Purpose
mysql.help_topic	This view, together with the `mysql.help_category`, `mysql.help_relation`, and `mysql.help_keyword` tables, generates Help commands.
mysql.help_category	This view, together with the `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_keyword` tables, generates Help commands.
mysql.help_keyword	This view, together with the `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_category` tables, generates Help commands.
mysql.help_relation	This view, together with the `mysql.help_category`, `mysql.help_topic`, and `mysql.help_keyword` tables, generates Help commands.

InnoDB storage engine

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

I/O performance

View	Purpose
DBA_OB_STORAGE_IO_USAGE	This view displays the I/O operations of the object storage and cloud disks on all nodes of the current tenant.

OBKV

View	Purpose
oceanbase.DBA_OB_KV_TTL_TASKS	This view displays the TTL tasks that are being executed by the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	This view displays the historical TTL tasks of the current tenant.
V$OB_KV_CLIENT_INFO	This view displays the configuration parameters of the client connections to the OBKV tenant on the current node.
GV$OB_KV_CLIENT_INFO	This view displays the configuration parameters of the client connections to the OBKV tenant.

Outline

View	Purpose
oceanbase.DBA_OB_OUTLINES	This view displays the Outline information of the execution plans of the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the Outline information of the throttling rules of the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the Outline information of the execution plans and throttling rules of the current tenant.
DBA_OB_FORMAT_OUTLINES	This view records the detailed information of the Format Outline of the current tenant.

Task scheduler manager

View	Purpose
oceanbase.DBA_SCHEDULER_JOBS	This view displays the information of all scheduler jobs in the database.

Privilege

View	Purpose
mysql.db	This view displays the database-level privileges (VIRTUAL_TABLE).
mysql.user	This view records the user-level privileges (VIRTUAL_TABLE).
information_schema.COLUMN_PRIVILEGES	This view displays the column privileges.
information_schema.SCHEMA_PRIVILEGES	This view describes the database privileges.
information_schema.TABLE_PRIVILEGES	This view records the table privileges.
information_schema.USER_PRIVILEGES	This view records the user privileges.

Full-text index

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

Session

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

Time zone

View	Description
mysql.time_zone	This view displays information about time zones (SYSTEM_VIEW).
mysql.time_zone_name	This view records the name information of the time zone (SYSTEM_VIEW).
mysql.time_zone_transition	`mysql.time_zone_transition` is a system view that records the information about time zone transitions.
mysql.time_zone_transition_type	This view records the type of the time zone transition (SYSTEM_VIEW).

SPM

View	Description
oceanbase.DBA_SQL_PLAN_BASELINES	This view displays the plan baselines of SQL in SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	This view displays the configuration parameters in SPM.

Database basic information

View	Description
information_schema.GLOBAL_STATUS	This view records the global status information of OceanBase Database.
information_schema.GLOBAL_VARIABLES	This view records the global variable information.
information_schema.SCHEMATA	This view records the database metadata.
oceanbase.DBA_OB_DATABASES	This view displays the database metadata of the current tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	This view displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of each zone in the current tenant.
oceanbase.DBA_OB_FREEZE_INFO	This view displays the version information generated by major freeze.
information_schema.events	This view records all event information.

Statistics and histograms

View	Description
oceanbase.DBA_TAB_STATISTICS	This view displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	This view displays the column statistics and histogram information of all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	This view displays the column statistics and histogram information of all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information of all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	This view displays the histograms of all columns in the database.
oceanbase.DBA_PART_HISTOGRAMS	This view displays the histogram data (endpoints) of all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	This view displays the histogram data (endpoints) of all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	This view displays the table statistics history of all tables in the database.
oceanbase.DBA_IND_STATISTICS	This view displays the optimizer statistics of all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	This view displays the cumulative modification information of tables in the database.
information_schema.QUERY_RESPONSE_TIME	This view displays the histogram data (such as the response time) for Prometheus monitoring.
oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY	This view queries the historical collection execution of a table.

Foreign keys

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

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

Materialized views

View name	Description
oceanbase.DBA_MVIEW_DEPS	This view displays the dependencies of materialized views in the current tenant.
oceanbase.DBA_MVIEW_LOGS	This view displays the logs of materialized views.
oceanbase.DBA_MVIEW_RUNNING_JOBS	This view displays the running materialized view tasks in the current tenant, including refresh tasks and MLOG cleanup tasks.
oceanbase.DBA_MVIEWS	This view displays the information of all materialized views.
oceanbase.DBA_MVREF_CHANGE_STATS	This view displays the statistics of materialized view refreshes.
oceanbase.DBA_MVREF_RUN_STATS	This view displays the information of each materialized view refresh, which is identified by the REFRESH_ID.
oceanbase.DBA_MVREF_STATS	This view displays the basic timing statistics of materialized view refreshes.
oceanbase.DBA_MVREF_STATS_PARAMS	This view displays the refresh statistics attributes associated with each materialized view.
oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS	This view displays the system-level default values of the refresh statistics attributes for materialized views.
oceanbase.DBA_MVREF_STMT_STATS	This view displays the information of the refresh statements.

View name	Description
oceanbase.DBA_OB_TTL_TASKS	This view displays the execution status of TTL tasks in the current tenant in SQL mode.
oceanbase.DBA_OB_TTL_TASK_HISTORY	This view displays the execution history of TTL tasks in the current tenant in SQL mode.

Threads

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

Constraints

View name	Description
information_schema.CHECK_CONSTRAINTS	This view displays the constraint information of tables and columns during `CREATE TABLE` operations.
information_schema.KEY_COLUMN_USAGE	This view records the constraint information of keys in a column.
information_schema.REFERENTIAL_CONSTRAINTS	This view displays the metadata of foreign key constraints.
information_schema.TABLE_CONSTRAINTS	This view describes the table constraints.

Resources

View name	Description
oceanbase.DBA_OB_SEQUENCE_OBJECTS	This view displays all SEQUENCE objects in the database.

View	Purpose
DBA_OB_RSRC_DIRECTIVES	This view displays the resource configuration parameters for the current tenant in Resource Manager.
DBA_OB_RSRC_IO_DIRECTIVES	This view displays the I/O resource configuration for the current tenant in Resource Manager.
DBA_RSRC_GROUP_MAPPINGS	This view displays the binding relationships between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	This view displays information about all resource groups in the database.
DBA_RSRC_PLANS	This view displays all resource management plans defined by the system.
DBA_RSRC_PLAN_DIRECTIVES	This view displays detailed information about each set of resource plan directives in the database.

View	Purpose
oceanbase.DBA_OBJECTS	This view displays all database objects in the database. The view definition is consistent with ALL_OBJECTS.
oceanbase.DBA_OB_TENANTS	This view displays the basic information of all tenants, including the system tenant, user-created tenants (user tenants), and the Meta tenant. You can distinguish the tenant types based on the `TENANT_TYPE` column.

View	Purpose
information_schema.CHARACTER_SETS	This view records the character set information of OceanBase Database.
information_schema.COLLATIONS	This view records the collation method information for each character set.
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY	This view records the correspondence between Character and Collation.

Overview of performance views

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

View name	Description
GV$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of the HMS Catalog client in the current tenant.
V$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of the HMS Catalog client in the current tenant.

Wait events

View	Description
GV$OB_COMPACTION_PROGRESS	This view displays the OBServer-level major compaction progress of all tenants.
GV$OB_COMPACTION_SUGGESTIONS	This view displays the major compaction suggestions.
GV$OB_PROCESSLIST	This view displays the session information of all OBServer nodes where the tenant is located.
GV$OB_COMPACTION_DIAGNOSE_INFO	This view displays the major compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information about major compaction at the tablet level.
GV$OB_TABLET_COMPACTION_PROGRESS	This view displays the major compaction progress at the tablet level.
GV$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participant information on all OBServer nodes.
GV$SESSION_EVENT	This view displays the session-level wait events on all OBServer nodes in the cluster.
GV$SESSION_WAIT	This view displays the information about the current or last wait events of all sessions on all servers, including the wait event name and wait duration.
GV$SESSION_WAIT_HISTORY	This view displays the information about the last 10 wait events of all sessions on all servers.
GV$SYSTEM_EVENT	This view displays the wait events at the tenant level for all servers in the cluster.
GV$SESSTAT	This view displays the session-level statistical events on all OBServer nodes.
GV$SYSSTAT	This view displays the tenant-level statistical events on all servers.
V$OB_COMPACTION_PROGRESS	This view displays the server-level major compaction progress of the tenant.
V$OB_COMPACTION_SUGGESTIONS	This view displays the major compaction suggestions.
V$OB_PROCESSLIST	This view displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	This view displays the major compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information about major compaction at the tablet level.
V$OB_TABLET_COMPACTION_PROGRESS	This view displays the major compaction progress at the tablet level.
V$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participants on all OBServer nodes.
V$STATNAME	This view displays the definitions of all statistics events.
V$EVENT_NAME	This view displays the definitions of all statistics events on the current OBServer node.
V$SESSION_WAIT	This view displays the details of the current waiting events for each session. As per the convention, each waiting event has three parameters, which record the corresponding values.
V$SESSION_WAIT_HISTORY	This view displays the details of the current waiting events for each session, including the last 10 waiting events.
V$SESSTAT	This view displays the statistics events at the session level.
V$SYSSTAT	This view displays the statistics events at the tenant level on the current server.
V$SYSTEM_EVENT	This view displays the statistics of waiting events at the tenant level.

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

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

View	Description
V$OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information of the current tenant.

View	Description
V$OB_SS_SSTABLES	This view displays the SSTable information of the current tenant on the shared storage.
GV$OB_SS_LOCAL_CACHE	This view displays the relevant metrics of various cache data in the local cache of each OBServer node for all tenants in shared storage mode.
V$OB_SS_LOCAL_CACHE	This view displays the relevant metrics of various cache data in the local cache of the current OBServer node for all tenants in shared storage mode.
GV$OB_STORAGE_CACHE_TASKS	This view displays the cache task information of the current tenant on all OBServer nodes.
V$OB_STORAGE_CACHE_TASKS	This view displays the cache task information of the current tenant on the current OBServer node.
GV$OB_TABLET_LOCAL_CACHE	This view displays the overall cache information of the current tenant on all OBServer nodes.
V$OB_TABLET_LOCAL_CACHE	This view displays the overall cache information of the current tenant on the current OBServer node.
GV$OB_SS_LOCAL_CACHE_DIAGNOSE	This view is used to diagnose the running status of the local cache submodules of the current tenant on each OBServer node in shared storage mode.
V$OB_SS_LOCAL_CACHE_DIAGNOSE	This view is used to diagnose the running status of the local cache submodules of the current tenant on the current OBServer node in shared storage mode.

Cache

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

View	Description
GV$OB_SHARED_STORAGE_QUOTA	This view displays IO access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA	This view displays IO access resource information on the current OBServer node.

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

View	Description
GV$OB_MEMORY	This view displays memory statistics at the tenant level.
V$OB_MEMORY	This view displays memory statistics at the tenant level.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
V$OB_MEMSTORE	This view displays MemStore statistics at the tenant level.
GV$OB_MEMSTORE_INFO	This view displays detailed information about MemTables for all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays detailed information about MemTables for all partitions of all tenants on all servers.
GV$OB_SSTABLES	This view displays SSTable information for tenants.
V$OB_SSTABLES	This view displays SSTable information for tenants.
GV$OB_TENANT_MEMORY	This view displays memory usage for each tenant in the cluster.
V$OB_TENANT_MEMORY	This view displays memory usage for each tenant in the current observer process.

View	Description
GV$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations on the current OBServer node.

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

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

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

View name	Description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	This view displays the histogram information of the query execution time on all nodes of the current tenant.
GV$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups on all OBServer nodes of the current tenant.
GV$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row, where each unique combination of `SQL_ID` and `Plan_Hash` corresponds to a row.
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row, where each unique combination of `SQL_ID` and `Plan_Hash` corresponds to a row.
GV$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level in the cluster.
V$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level on the current node.
V$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups on the current OBServer node of the current tenant.

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

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

Resource management

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

Data dump and major compaction

View	Purpose
GV$OB_MERGE_INFO	This view displays the statistics of completed major compactions in the OceanBase cluster.
V$OB_MERGE_INFO	This view displays the statistics of completed major compactions in the OceanBase cluster.

Overview of views in an Oracle tenant

Dictionary views

Applicability

This topic applies only to OceanBase Database Enterprise Edition.

Security privileges

View	Description
ALL_USERS	This view displays all database users visible to the current user.
DBA_USERS	This view displays all database users.
USER_USERS	This view displays information about the current user.
ALL_COL_PRIVS	This view displays column object privileges granted to the current user, the owner of the object, or the grantor. Column object privileges granted to enabled roles or the PUBLIC role are also displayed.
ALL_TAB_PRIVS	*This view displays object privileges granted to the current user, the owner of the object, or the grantor. Object privileges granted to activated roles or the PUBLIC role are also displayed.
DBA_COL_PRIVS	This view displays all column object privileges granted in the database.
DBA_SYS_PRIVS	This view displays system privileges granted to users and roles.
DBA_TAB_PRIVS	This view displays all object privileges granted in the database.
USER_TAB_PRIVS	This view displays object privileges owned by the current user.
USER_COL_PRIVS	This view displays column object privileges granted to the current user, the owner of the object, or the grantor.
USER_ROLE_PRIVS	This view displays roles granted to the current user.
USER_SYS_PRIVS	This view displays system privileges granted to the current user.
ROLE_TAB_PRIVS	This view displays table privileges granted to roles. Only information about roles accessible to users is provided.
ROLE_SYS_PRIVS	This view displays system privileges granted to roles.
ROLE_ROLE_PRIVS	This view displays roles granted to other roles. Only information about roles accessible to users is provided.
DBA_ROLE_PRIVS	This view displays roles granted to all users and roles in the database.
DBA_ROLES	This view displays all roles existing in the database.
ALL_DIRECTORIES	This view displays all directories accessible to the current user.
DBA_DIRECTORIES	This view displays all directories accessible to the current user.
USER_PRIVILEGES	This view displays the privileges of the current user.

View	Purpose
USER_POLICIES	This view displays the fine-grained access control policy information of the current user.
USER_POLICY_CONTEXTS	This view displays the policy context information of the current user.
USER_POLICY_GROUPS	This view displays the policy group information of the current user.
USER_SEC_RELEVANT_COLS	This view displays the column information related to the security policy of the current user.

Backup and restore

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

Views and tables

View	Description
ALL_ALL_TABLES	This view displays the object tables and relational tables accessible to the current user.
ALL_COL_COMMENTS	This view displays the column comments of all views and tables accessible to the current user.
ALL_TABLES	This view displays all tables accessible to the current user.
ALL_TAB_COLS	This view displays all columns of the tables, views, and clusters accessible to the current user.
ALL_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters accessible to the current user.
ALL_TAB_COMMENTS	This view displays the comments of the tables and views accessible to the current user.
DBA_COL_COMMENTS	This view displays the column comments of all views and tables in the database.
DBA_TAB_COMMENTS	This view displays the comments of all tables and views in the database.
USER_COL_COMMENTS	This view displays the column comments of all views and tables owned by the current user.
USER_TAB_COMMENTS	This view displays the comments of the tables and views owned by the current user.
DBA_OB_TABLEGROUP_TABLES	This view displays the association between the TABLEGROUP and TABLE. The tables not in a TABLEGROUP are not displayed.
DBA_TABLES	This view displays all tables in the database.
DBA_ALL_TABLES	This view displays the object tables and relational tables in the database. The fields of this view are the same as those of the ALL_ALL_TABLES view.
DBA_TABLESPACES	This view displays all tablespaces in the database.
DBA_TAB_COLS	This view displays all columns of the tables, views, and clusters in the database.
DBA_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters in the database.
USER_ALL_TABLES	This view displays the object tables and relational tables accessible to the current user. Except for the OWNER column, the other columns are the same as those of the ALL_ALL_TABLES view.
USER_TABLES	This view displays all tables owned by the current user.
USER_TABLESPACES	This view displays the tablespaces accessible to the current user. The columns of this view are the same as those of the `DBA_TABLESPACES` view, except for the `PLUGGED_IN` column.
USER_TAB_COLS	This view displays all columns of the tables, views, and clusters owned by the current user.
oceanbase.USER_TAB_COLS_V$	This view displays the column information of the tables and views owned by the current user.
USER_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters owned by the current user.
ALL_VIEWS	This view displays the views accessible to the current user.
DBA_VIEWS	This view displays all views in the database. The columns are the same as those in `ALL_VIEWS`.
USER_VIEWS	This view displays the views that belong to the current user.
DICTIONARY	This view displays the descriptions of data dictionary tables and views.
DICT	This view displays the descriptions of data dictionary tables and views.
DBA_OB_TABLE_LOCATIONS	This view displays the locations of tables and partitions, including system tables, user tables, and index tables.
DBA_OB_SPATIAL_COLUMNS	This view displays the database name, table name, type, and SRS information of spatial index columns.

Storage objects

View name	Description
ALL_ERRORS	This view displays errors of the storage objects accessible to the current user.
DBA_ERRORS	This view displays errors of the storage objects in the database.
USER_ERRORS	This view displays errors of the storage objects accessible to the current user.
DBA_SEGMENTS	This view displays storage information of all segments in the database.
USER_SEGMENTS	This view displays storage information of the segments of the objects in the current user.

Triggers

View name	Description
ALL_TRIGGERS	This view displays the triggers and their descriptions on the tables owned by the current user. If the current user has the CREATE ANY TRIGGER privilege, this view displays all triggers in the database.
DBA_TRIGGERS	This view displays all triggers in the database.
USER_TRIGGERS	This view displays the triggers owned by the current user.
DBA_TRIGGER_ORDERING	This view displays the execution order of triggers.
ALL_TRIGGER_ORDERING	This view displays the execution order of triggers accessible to the current user.
USER_TRIGGER_ORDERING	This view displays the execution order of triggers in the current user.

Object types

View name	Description
ALL_METHOD_PARAMS	This view displays method parameters of object types accessible to the current user.
DBA_METHOD_PARAMS	This view displays method parameters of object types in the database.
ALL_TYPE_METHODS	This view displays methods of object types accessible to the current user.
DBA_TYPE_METHODS	This view displays methods of object types in the database.
USER_TYPE_METHODS	This view displays methods of object types accessible to the current user. The fields of this view are the same as those of the ALL_TYPE_METHODS view, except that this view does not contain the OWNER field.

DBLINK

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

View	Description
ALL_PART_KEY_COLUMNS	This view displays the columns included in the partition keys of all partitioned objects accessible to the current user.
ALL_PART_TABLES	This view displays the partition information of all partitioned tables accessible to the current user.
ALL_SUBPARTITION_TEMPLATES	This view displays the descriptions of all subpartition templates.
ALL_SUBPART_KEY_COLUMNS	This view displays the columns included in the subpartition keys of all partitioned objects accessible to the current user.
ALL_TAB_PARTITIONS	This view displays the multi-level partition information, partition storage parameters, and partition statistics of all partitioned tables.
ALL_TAB_SUBPARTITIONS	This view displays the partition-level information, partition storage parameters, and partition statistics generated by the `DBMS_STATS` package for the partitioned tables accessible to the current user.
DBA_OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information of the current tenant.
DBA_PART_INDEXES	This view displays the partition information of all partitioned indexes.
DBA_PART_KEY_COLUMNS	This view displays the columns included in the partition keys of all partitioned objects in the database.
DBA_PART_TABLES	This view displays the partition information of all partitioned tables accessible to the current user.
DBA_SUBPARTITION_TEMPLATES	This view displays the descriptions of all subpartition templates.
DBA_SUBPART_KEY_COLUMNS	This view displays the columns included in the subpartition keys of all partitioned objects in the database.
DBA_TAB_PARTITIONS	This view displays the multi-level partition information, partition storage parameters, and partition statistics of all partitioned tables accessible to the current user.
DBA_TAB_SUBPARTITIONS	This view displays the subpartition name, table name, name of the partition to which it belongs, storage attributes, and statistics generated by the `DBMS_STATS` package.
USER_PART_KEY_COLUMNS	This view displays the columns included in the partition keys of all partitioned objects owned by the current user.
USER_PART_TABLES	This view displays the partition information of all partitioned tables owned by the current user.
USER_SUBPARTITION_TEMPLATES	This view displays the descriptions of all subpartition templates.
USER_SUBPART_KEY_COLUMNS	This view displays the columns included in the subpartition keys of all partitioned objects owned by the current user.
USER_TAB_SUBPARTITIONS	This view displays the subpartition name, table name, name of the partition to which it belongs, and storage attributes of each subpartition of the current user.
USER_TAB_PARTITIONS	This view displays the multi-level partition information, partition storage parameters, and partition statistics of all partitioned tables owned by the current user.

Load balancing

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

Replica logs

View	Description
DBA_OB_CS_REPLICA_STATS	This view displays the progress of converting Tablets to columnar storage in the C replicas of the OBServer nodes in the current tenant.
DBA_OB_LS_LOCATIONS	This view displays the distribution of log streams (LS) replicas in the current tenant.
DBA_OB_TABLEGROUPS	This view displays the metadata of table groups, mainly focusing on the partition information of the table groups.
DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of the table group partitions.
DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of the table group partitions.
DBA_OB_TABLET_REPLICAS	This view displays all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
DBA_OB_TABLET_TO_LS	This view displays all tablets in the current tenant and the log stream information to which each tablet belongs.
DBA_OB_LS	This view displays the status and recovery progress of log streams.

Shared storage

View	Description
DBA_OB_SS_SPACE_USAGE	This view records the storage space usage on the object storage of the current tenant.

Recycle bin

View	Description
DBA_RECYCLEBIN	This view displays information about all recycle bins in the database.
USER_RECYCLEBIN	This view displays information about the recycle bins owned by the current user. The columns are the same as those in `DBA_RECYCLEBIN`, except that the `OWNER` column is omitted.

I/O performance

View	Description
DBA_OB_STORAGE_IO_USAGE	This view displays the various I/O operations on the object storage and cloud disks of the current tenant.

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

View name	Description
DBA_OB_OUTLINES	This view displays the execution plan outlines of the current tenant.
DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the outline-related information of the throttling rules of the current tenant.
DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the execution plan outlines and throttling rule outlines of the current tenant.
DBA_OB_FORMAT_OUTLINES	This view records the details of the current tenant's format outlines.

View name	Description
DBA_SCHEDULER_JOBS	This view displays the information of scheduler jobs accessible to the current user.
DBA_SCHEDULER_PROGRAM	This view displays all the scheduler information in the database.
DBA_SCHEDULER_JOB_RUN_DETAILS	This view displays the information of all scheduler jobs in the tenant.
DBA_JOBS	This view displays the overview of submitted tasks.
USER_JOBS	This view displays the overview of submitted tasks.
DBA_JOBS_RUNNING	This view displays the running tasks.

View name	Description
USER_PLSQL_COLL_TYPES	This view displays the PL/SQL collection type information of the current user.
USER_PLSQL_TYPES	This view displays the PL/SQL type information of the current user.
USER_PLSQL_TYPE_ATTRS	This view displays the PL/SQL type attribute information of the current user.
DBA_OB_PL_OBJ_CACHE_STATUS	This view displays the PL object cache status information.

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

View name	Description
ALL_PROFILES	This view displays all profiles and their restrictions.
DBA_PROFILES	This view displays all profiles and their restrictions.
USER_PROFILES	This view displays all profiles and their restrictions.

View name	Description
DBA_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlock events. In a non-root tenant, this view displays the history of events for the current tenant.

View name	Description
DBA_SQL_PLAN_BASELINES	This view displays the plan baselines of SQL statements in SPM.
DBA_SQL_MANAGEMENT_CONFIG	This view displays the configuration parameters in SPM.

Database basic information

View	Purpose
DBA_CONTEXT	This view displays all context namespaces in the database.
DBA_OB_DATABASES	This view displays the database metadata of the current tenant.
DBA_OB_MAJOR_COMPACTION	This view displays the global major compaction information of the current tenant.
DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of each zone in the current tenant.
ALL_OBJECTS	This view displays all database objects accessible to the current user.
DBA_OBJECTS	This view displays all database objects.
USER_OBJECTS	This view displays all database objects owned by the current user.
ALL_DEPENDENCIES	This view displays the dependencies between all database objects.
DBA_DEPENDENCIES	This view displays all dependencies between database objects.
USER_DEPENDENCIES	This view displays the dependencies between objects in the current user schema.
DBA_OB_FREEZE_INFO	This view displays the version information generated by major freeze.
TENANT_VIRTUAL_GLOBAL_VARIABLE	This view displays the global variable information.
TENANT_VIRTUAL_SESSION_VARIABLE	This view displays the session variable information.

Audit

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

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

Statistics and histograms

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

Synonyms

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

Job Scheduler

View Name	Description
USER_SCHEDULER_JOBS	This view displays the information about the current user's scheduled jobs.
ALL_SCHEDULER_JOB_ARGS	This view displays the job parameters accessible to the user.
ALL_SCHEDULER_PROGRAM_ARGS	This view displays the program parameters accessible to the user.
DBA_SCHEDULER_JOB_ARGS	This view displays the job parameters in the database.
USER_SCHEDULER_JOB_ARGS	This view displays the job parameters owned by the current user.
DBA_SCHEDULER_PROGRAM_ARGS	This view displays the program parameters in the database.
USER_SCHEDULER_PROGRAM_ARGS	This view displays the program parameters owned by the current user.

WR

View Name	Description
DBA_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of the current tenant.
DBA_WR_ACTIVE_SESSION_HISTORY	This view displays the persistent ASH data of the current tenant.
DBA_WR_STATNAME	This view displays the names of the system statistics of the current tenant.
DBA_WR_SYSSTAT	This view displays the details of the system statistics of the current tenant.
DBA_WR_CONTROL	This view displays the WR configuration information.
DBA_WR_SYSTEM_EVENT	This view displays the persistent tenant-level waiting event information of the current tenant.
DBA_WR_EVENT_NAME	This view displays the persistent tenant-level waiting event names of the current tenant.
DBA_WR_SQLTEXT	This view displays the SQL text collected by WR of the current tenant.
DBA_WR_SQLSTAT	This view displays the basic performance statistics of the SQL statements executed by the current tenant.
DBA_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of the current tenant.

Materialized views

View name	Description
DBA_MVIEW_DEPS	This view displays the dependencies of materialized views in the current tenant.
DBA_MVIEW_LOGS	This view displays the logs of materialized views.
DBA_MVIEW_RUNNING_JOBS	This view displays the materialized view-related tasks, including refresh tasks and MLOG cleanup tasks, in the current tenant.
USER_MVIEWS	This view displays the information about materialized views.
DBA_MVIEWS	This view displays the information about all materialized views.
DBA_MVREF_CHANGE_STATS	This view displays the statistics about materialized view refreshes.
DBA_MVREF_RUN_STATS	This view displays the information about each run of a materialized view, identified by a refresh ID.
DBA_MVREF_STATS	This view displays the basic timing statistics about materialized view refreshes.
DBA_MVREF_STATS_PARAMS	This view displays the refresh statistics attributes associated with each materialized view.
DBA_MVREF_STATS_SYS_DEFAULTS	This view displays the system-wide default values for the statistics attributes of materialized view refreshes.
DBA_MVREF_STMT_STATS	This view displays the information about the statements associated with materialized view refreshes.
USER_MVIEW_LOGS	This view displays the logs of materialized views for the current user.
USER_MVREF_CHANGE_STATS	This view displays the statistics about materialized view refreshes for the current user.
USER_MVREF_RUN_STATS	This view displays the information about each run of a materialized view for the current user.
USER_MVREF_STATS	This view displays the basic timing statistics about materialized view refreshes for the current user.
USER_MVREF_STATS_PARAMS	This view displays the refresh statistics attributes associated with each materialized view for the current user.
USER_MVREF_STATS_SYS_DEFAULTS	This view displays the system-wide default values for the statistics attributes of materialized view refreshes for the current user.
USER_MVREF_STMT_STATS	This view displays the information about the statements associated with materialized view refreshes for the current user.

Time-to-live (TTL) features

View name	Description
DBA_OB_TTL_TASKS	This view displays the execution status of TTL tasks in the current tenant in SQL mode.
DBA_OB_TTL_TASK_HISTORY	This view displays the execution history of TTL tasks in the current tenant in SQL mode.

Source code

View name	Description
DBA_OB_SOURCE	This view displays the source code of stored procedures, functions, and other objects.
ALL_OB_SOURCE	This view displays the source code of objects accessible to the current user.
USER_OB_SOURCE	This view displays the source code of objects for the current user.

User-defined types

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

Constraints

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

Sequences

View name	Description
ALL_SEQUENCES	This view displays all SEQUENCEs accessible to the user.
DBA_SEQUENCES	This view displays all SEQUENCEs in the database.
USER_SEQUENCES	This view displays all SEQUENCEs owned by the current user.

Resource management

View	Purpose
DBA_OB_RSRC_DIRECTIVES	This view displays the resource configuration parameters of the current tenant in Resource Manager.
DBA_OB_RSRC_IO_DIRECTIVES	This view displays the I/O resource configuration of the current tenant in Resource Manager.
DBA_RSRC_GROUP_MAPPINGS	This view displays the mapping between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	This view displays the information about all resource groups in the database.
DBA_RSRC_PLANS	This view displays all resource management plans defined by the system.
DBA_RSRC_PLAN_DIRECTIVES	This view displays the details of resource plan directives in the database.

Performance views overview

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

View	Description
GV$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of the HMS Catalog client in the current tenant.
V$OB_HMS_CLIENT_POOL_STAT	This view displays the usage of the HMS Catalog client in the current tenant.

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

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

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

View	Description
V$OB_DYNAMIC_PARTITION_TABLES	This view displays the dynamic partition table information of the current tenant.

View	Description
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans in the plan cache of all servers.
GV$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache of all servers for the current tenant.
GV$OB_PLAN_CACHE_STAT	This view records the status of each plan cache in all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans in the plan cache of the current server.
V$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache of the current server for the current tenant.
V$OB_PLAN_CACHE_STAT	This view records the status of each plan cache in all servers for the current tenant.
V$RSRC_PLAN	This view displays the resource management plan of the current active tenant.

View	Description
V$OB_SS_SSTABLES	This view displays the SSTable information on the shared storage of the current tenant.
GV$OB_SS_LOCAL_CACHE	This view 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	This view 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.

View	Description
GV$OB_SHARED_STORAGE_QUOTA	This view displays the IO access resource information on all OBServer nodes.
V$OB_SHARED_STORAGE_QUOTA	This view displays the IO access resource information on the current OBServer node.

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

View name	Description
GV$OB_MEMORY	This view displays the memory usage of each tenant on all servers.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
GV$OB_SQL_WORKAREA_MEMORY_INFO	This view displays some overall information about the SQL Workarea, including the maximum available memory, current used memory, and current hold memory.
GV$OB_SSTABLES	This view displays the SSTable information of a tenant.
GV$OB_MEMSTORE_INFO	This view displays the detailed information about the MemTables of all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays the detailed information about the MemTables of all partitions of all tenants on all servers.
V$OB_MEMORY	This view displays the memory statistics at the tenant level.
V$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on the current server.
V$OB_SSTABLES	This view displays the SSTable information of a tenant.
GV$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the current observer process.

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

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

View name	Description
GV$OB_PROCESSLIST	This view displays session information on all OBServer nodes where the tenant is located.
GV$SESSION_WAIT	This view 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	This view displays information about the 10 most recent wait events of all sessions on all servers.
GV$SESSTAT	This view displays some statistics at the session level on all servers.
V$NLS_PARAMETERS	This view displays NLS parameters at the session level.
V$OB_PROCESSLIST	This view displays session information on the current OBServer node.
V$SESSION_WAIT	This view displays information about the current or previous wait events of all sessions on the current server, including the wait event name and wait time.
V$SESSION_WAIT_HISTORY	This view displays information about the 10 most recent wait events of all sessions on the current server.
V$SESSTAT	This view displays some statistics at the session level.
V$EVENT_NAME	This view displays event definitions under the tenant.

View name	Description
GV$OB_SQL_AUDIT	This view displays statistics such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	This view displays statistics such as the source and execution status of each SQL request on the current server.

View name	Description
GV$OB_FLT_TRACE_CONFIG	This view displays diagnostic information about full-link tracing.

Statistics views

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

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

View	Description
GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM	This view displays the histogram information of the query execution time of all nodes in the current tenant.
GV$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups in all OBServer nodes of the current tenant.
V$OB_RES_MGR_SYSSTAT	This view displays the statistics of resource groups in the current OBServer node of the current tenant.
GV$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row (each unique combination of `SQL_ID` and `Plan_Hash` corresponds to a row).
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (each unique combination of `SQL_ID` and `Plan_Hash` corresponds to a row).
GV$OB_SESS_TIME_MODEL	This view displays the session-level time model statistics in the cluster.
V$OB_SESS_TIME_MODEL	This view displays the session-level time model statistics on the current node.
GV$OB_SYS_TIME_MODEL	This view displays the tenant-level time model statistics in the cluster.
V$OB_SYS_TIME_MODEL	This view displays the tenant-level time model statistics on the current node.
V$OB_QUERY_RESPONSE_TIME_HISTOGRAM	This view displays the histogram information of the query execution time of the current node in the current tenant.

View	Description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, this view displays the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, this view displays the execution information of each thread.
GV$OB_PX_TARGET_MONITOR	This view displays the PX thread usage on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	This view displays the PX thread usage on OBServer nodes.

View	Description
V$SQL_MONITOR_STATNAME	This view displays the meaning of the numeric values in the `OTHERSTAT_X_ID` column of `GV$SQL_PLAN_MONITOR`.
GV$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has one statistics record, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has one statistics record, and the trace information of the plan is recorded.

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

Resource management

View	Purpose
GV$OB_GROUP_IO_STAT	This view displays the real-time status of each resource group on all OBServer nodes of the current tenant.
GV$OB_FUNCTION_IO_STAT	This view displays the I/O statistics at the Function level on all OBServer nodes of the current tenant.
V$OB_GROUP_IO_STAT	This view displays the real-time status of each resource group on the current OBServer node of the current tenant.
V$OB_FUNCTION_IO_STAT	This view displays the I/O statistics at the Function level on the current OBServer node of the current tenant.

OceanBase

Customer Stories

Documentation

System views overview

Overview of views in the sys tenant

Dictionary views overview

AI models

Security privileges

Security policies

Backup and restore

Views and columns

Note

CCL

Storage-related

Access control-related

Partition-related views

Load balancing

Replica log-related

Service management

Shared storage

InnoDB storage engine

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Note

Views related to temporary file management

Views related to I/O performance

Views related to OBKV

Views related to outlines

PLSQL types

Full-text indexes

Note

Note

Note

Note

Note

Task scheduler

Event history monitoring

SPM

Upgrade

Basic database information

Views related to statistics and histograms

External resources

Foreign keys

Note

Note

Materialized view-related views

WR related

Vector index

Major compaction

Certificate management

Resource management

Tenant management

Tenant cloning

Time-to-live (TTL) related

Overview of performance views

ASH related

Catalog related

DTL related

Replica log related

Partition related

Shared storage

I/O