Overview of views in the sys tenant
Overview of dictionary views
AI models
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_AI_MODELS | Displays the AI model information for all tenants. |
| oceanbase.CDB_OB_AI_MODEL_ENDPOINTS | Displays the AI model endpoint information for all tenants. |
| oceanbase.DBA_OB_AI_MODELS | Displays the AI model information of the current tenant. |
| oceanbase.DBA_OB_AI_MODEL_ENDPOINTS | Displays the AI model endpoint information of the current tenant. |
Security permissions
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_USERS | Display user information for all tenants. |
| oceanbase.CDB_OB_DATABASE_PRIVILEGE | Displays the database-level privileges of all tenants. |
| oceanbase.DBA_OB_AUTO_INCREMENT | Displays the auto-increment column information for the current tenant. |
| oceanbase.DBA_OB_USERS | Displays the user information of the current tenant. |
| oceanbase.DBA_OB_DATABASE_PRIVILEGE | Displays the database-level permission information of the current tenant. |
| oceanbase.DBA_OB_USER_DEFINED_RULES | Displays user-defined rule information. |
Security policies
View Name |
Feature description |
|---|---|
| oceanbase.DBA_POLICIES | Displays fine-grained access control policy information. |
| oceanbase.DBA_POLICY_CONTEXTS | Displays the policy context information. |
| oceanbase.DBA_POLICY_GROUPS | Displays policy group information. |
| oceanbase.DBA_SEC_RELEVANT_COLS | Displays column information related to security policies. |
| oceanbase.ALL_POLICIES | Displays the fine-grained access control policy information accessible to the current user. |
| oceanbase.ALL_POLICY_CONTEXTS | Displays the policy context information accessible to the current user. |
| oceanbase.ALL_POLICY_GROUPS | Displays the information about the policy groups that the current user can access. |
| oceanbase.ALL_SEC_RELEVANT_COLS | Displays the column information related to security policies that the current user has access to. |
Backup and recovery
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_BACKUP_VALIDATE_JOBS | Displays information about all job-level backup verification tasks initiated by tenants. |
| oceanbase.CDB_OB_BACKUP_VALIDATE_JOB_HISTORY | Displays the execution history of job-level backup verification tasks initiated by all tenants. |
| oceanbase.CDB_OB_BACKUP_VALIDATE_TASKS | Displays information about all backup verification task-level tasks initiated by tenants. |
| oceanbase.CDB_OB_BACKUP_VALIDATE_TASK_HISTORY | Displays the execution history of backup verification task-level tasks initiated by all tenants. |
| oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS | Displays information about the job-level backup verification tasks initiated by the current tenant. |
| oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY | Displays the execution history of job-level backup verification tasks initiated by this tenant. |
| oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS | Displays information about the backup verification task initiated by the current tenant. |
| oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY | Displays the execution history of backup verification tasks initiated by the current tenant. |
| oceanbase.CDB_OB_RESTORE_PROGRESS | Displays the current execution progress of a physical restore task. |
| oceanbase.CDB_OB_RESTORE_HISTORY | Displays the status when a physical restore task is completed. |
| oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES | Displays the status of pieces in a backup set. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | Displays the file status of the backup set. |
| oceanbase.CDB_OB_BACKUP_JOBS | Displays the backup job tasks for all tenants in the cluster. Each time a user initiates a backup task, a corresponding job record is created. |
| oceanbase.CDB_OB_BACKUP_JOB_HISTORY | Displays the historical records of backup job tasks for all tenants in the cluster. |
| oceanbase.CDB_OB_BACKUP_TASKS | Displays the task-level backup tasks for all tenants in the cluster. Each task record corresponds to one backup set. There is a one-to-one correspondence between task records and job records. |
| oceanbase.CDB_OB_BACKUP_TASK_HISTORY | Displays the historical records of task-level backup tasks for all tenants in the cluster. |
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup job tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the historical records of backup job tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the historical records of backup job tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | Displays the historical records of the tenant's own task-level backup tasks. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | Displays the file status of the backup set. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | Displays the ongoing restore tasks. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays completed restore tasks. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the archive path configuration. |
| oceanbase.CDB_OB_ARCHIVE_DEST | Displays the archive path configuration. |
| oceanbase.CDB_OB_BACKUP_PARAMETER | Displays backup parameters. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOBS | Displays the execution progress of tenant-level backup cleanup jobs. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY | Displays the historical information of backup cleanup tasks executed under a tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | Displays information about the backup_set and backup_piece cleanup tasks being executed under a tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY | Displays the historical information of completed backup_set and backup_piece cleanup tasks for a tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies set for expiration cleanup and automatic cleanup under the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | Displays information about the backup destinations used for backup and restore operations in a tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information of backup destinations used for backup and restore operations under a tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays information about the backup destinations used for backup and restore operations in a tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information of backup destinations used for backup and restore operations under a tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies set for expiration cleanup and automatic cleanup under the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of tenant-level backup cleanup jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the historical information of backup cleanup tasks executed under a tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays information about the backup_set and backup_piece cleanup tasks being executed under a tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the historical information of completed backup_set and backup_piece cleanup tasks for a tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | Displays the log backup status for each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log backups. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of pieces in a backup set. |
| oceanbase.CDB_OB_ARCHIVELOG | Displays the log archiving status for each path. |
| oceanbase.CDB_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log archivals. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOBS | Displays information about table-level restore tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOBS | Displays information about table-level restore tasks. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOBS | Displays information related to the import task. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | Displays information related to the import task. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASKS | Displays records for table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | Displays records for table-level import tasks. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of a table-level restore task. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of a table-level restore task. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY | Displays the result of the import task. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the result of the import task. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY | Displays the historical records of table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the historical records of table-level cross-tenant import tasks. |
Tables and columns
View Name |
Feature description |
|---|---|
| oceanbase.CDB_IND_COLUMNS | Displays the column information of index tables for all tenants. |
| oceanbase.CDB_INDEXES | Displays the index information for all tenants. |
| oceanbase.CDB_TABLES | Displays the TABLE information for all tenants. |
| oceanbase.CDB_OB_TABLEGROUP_TABLES | The system tenant displays the TABLEGROUP and TABLE relationships for all tenants. TABLES that are not part of a TABLEGROUP are not displayed. |
| oceanbase.CDB_TAB_COLS | Displays the column information for tables and views of all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | Displays the column information for tables and views of all tenants. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the association between TABLEGROUPs and TABLEs. TABLEs that are not part of a TABLEGROUP are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the columns contained in the partitioning key for all partition objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | View the columns contained in the subpartitioning key for all partition objects in the database. |
| oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO | Displays column validation and inconsistency information between index tables (including global indexes and local indexes) and the primary table. |
| oceanbase.CDB_OB_TABLE_LOCATIONS | Displays the location of tables or partitions, including system tables, user tables, index tables, etc. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the location of tables or partitions, including system tables, user tables, index tables, etc. |
| information_schema.TABLESPACES | Information related to tablespaces.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| oceanbase.DBA_TABLES | Displays information about all tables in the current tenant. |
| oceanbase.CDB_INDEX_USAGE | Displays the index usage statistics for all tenants. |
| oceanbase.DBA_INDEX_USAGE | Displays the index usage statistics for the current tenant. |
| oceanbase.DBA_TAB_COLS_V$ | Displays the column information of table and view objects for the current tenant. |
| oceanbase.DBA_OB_TABLE_SPACE_USAGE | Displays the space usage of each table for the current tenant. |
Catalog
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS | This API is used to query partition-level statistics of external table columns in an external catalog. |
| oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS | This API is used to query column-level statistics of external tables in a catalog. |
| oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS | This API is used to query table-level statistics of external tables in a catalog. |
CCL
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_CCL_RULES | Displays the concurrency control and throttling rules for all tenants. |
| oceanbase.DBA_OB_CCL_RULES | Displays the concurrency control and throttling rules for the current tenant. |
Storage space
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_SPACE_USAGE | Displays the space usage of all tenants. |
| oceanbase.CDB_OB_SERVER_SPACE_USAGE | Displays the space usage of all OBServer nodes. |
| oceanbase.CDB_OB_TABLE_SPACE_USAGE | Displays the space usage of each table for all tenants. |
Access control
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_ACCESS_POINT | Displays the access endpoint information for all tenants. |
| oceanbase.DBA_OB_ACCESS_POINT | Displays the access endpoint information of the current tenant. |
Partitions
View Name |
Feature description |
|---|---|
| oceanbase.CDB_IND_PARTITIONS | Displays the partition information of all tenant index tables. |
| oceanbase.CDB_IND_SUBPARTITIONS | Query all index subpartitions in a database. |
| oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partitioned table information for all tenants. |
| oceanbase.CDB_PART_INDEXES | Displays the partition information of index tables for all tenants. |
| oceanbase.CDB_PART_TABLES | Displays the partition information for partitioned tables of all tenants. |
| oceanbase.CDB_SUBPARTITION_TEMPLATES | Displays the subpartition information of partitioned tables for all tenants. |
| oceanbase.CDB_TAB_PARTITIONS | Displays the partition information of partitioned tables for all tenants. |
| oceanbase.CDB_TAB_SUBPARTITIONS | Displays the subpartition information of partitioned tables for all tenants. |
| oceanbase.DBA_IND_PARTITIONS | Displays the partition information of an index. |
| oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partitioned table information of the current tenant. |
| oceanbase.DBA_PART_INDEXES | Displays the partition information for all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | Displays information about user table partitions. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the multi-level partition information, partition storage parameters, and partition statistics that the current user has access to. |
| oceanbase.DBA_TAB_SUBPARTITIONS | It displays the subpartition name, the table and partition names to which it belongs, its storage attributes, andDBMS_STATSThe package generates statistics. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays the descriptions of all subpartition templates. |
Load balancing
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT | Displays all partitions with special weights under all user tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS | Displays the partition transfer tasks currently in progress for all tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of all partition transfer tasks executed by tenants. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the current partition transfer tasks being processed for the tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of transfer partition tasks executed for this tenant. |
| oceanbase.CDB_OB_BALANCE_JOBS | Displays the load balancing job tasks for all tenants. |
| oceanbase.CDB_OB_BALANCE_JOB_HISTORY | Displays the historical records of load balancing job tasks for all tenants. |
| oceanbase.CDB_OB_BALANCE_TASKS | Displays the load balancing tasks for all tenants. |
| oceanbase.CDB_OB_BALANCE_TASK_HISTORY | Displays the CLB task history for all tenants. |
| oceanbase.CDB_OB_TRANSFER_TASKS | Displays the transfer task information for all tenants. |
| oceanbase.CDB_OB_TRANSFER_TASK_HISTORY | Displays the transfer task history for all tenants. |
| oceanbase.DBA_OB_BALANCE_JOBS | Displays the load balancing job tasks of the current tenant. |
| oceanbase.DBA_OB_BALANCE_JOB_HISTORY | Displays the historical records of the load balancing job tasks for the current tenant. |
| oceanbase.DBA_OB_BALANCE_TASKS | Displays the load balancing tasks of the current tenant. |
| oceanbase.DBA_OB_BALANCE_TASK_HISTORY | Displays the CLB task history of the current tenant. |
| oceanbase.DBA_OB_TRANSFER_TASKS | Displays the transfer task information of the current tenant. |
| oceanbase.DBA_OB_TRANSFER_TASK_HISTORY | Displays the transfer task history of the current tenant. |
Replica logs
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_CS_REPLICA_STATS | Displays the progress of converting tablets to columnar storage in the log streams of C replicas on each OBServer node for all tenants. |
| oceanbase.CDB_OB_LS_LOCATIONS | Displays the replica distribution information of log stream (LS) for all tenants. |
| oceanbase.CDB_OB_TABLEGROUPS | The system tenant displays the meta information of table groups for all tenants, primarily showing the partition information of the table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | The system tenant displays the partition information of all tenant's partitioned table groups. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | The system tenant displays the subpartition information for all tenant's partitioned table groups. |
| oceanbase.CDB_OB_TABLET_TO_LS | The system tenant displays the tablet list for all tenants and the log stream information to which each tablet belongs. |
| oceanbase.CDB_OB_TABLET_REPLICAS | This view displays information about all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key:<TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.CDB_PART_KEY_COLUMNS | Displays the partitioning key information of all tenant's partition objects (partitioned tables and partitioned indexes). |
| oceanbase.CDB_SUBPART_KEY_COLUMNS | Displays the subpartitioning key information for all tenant partition objects (partitioned tables and partitioned indexes). |
| oceanbase.DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the partition information of a table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information for a table group that is partitioned. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the meta information of a table group, mainly its partition information. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays information about all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key:<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays a list of all tablets for the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution information of log stream (LS) replicas for the current tenant. |
| oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO | Displays information about data inconsistencies between tablet replicas. |
| oceanbase.CDB_OB_LS | Displays the status and recovery progress of the log stream. |
| oceanbase.DBA_OB_LS | Displays the status and recovery progress of the log stream. |
| oceanbase.CDB_OB_LS_HISTORY | Displays the log stream history information for all tenants. |
| oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS | Displays the log stream archiving progress for all tenants. |
| oceanbase.CDB_OB_LS_REPLICA_TASKS | Displays the log stream replication tasks for all tenants. |
| oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY | Displays the task history of log stream replication for all tenants. |
| oceanbase.CDB_OB_LOG_RESTORE_SOURCE | Displays the log restore source information for all tenants. |
| oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS | Displays the arbitration replica tasks for all tenants. |
| oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY | Displays the arbitration replica task history for all tenants. |
| oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN | Displays the flashback log SCN information for all tenants. |
| oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG | Displays data dictionary information from all tenant logs. |
| oceanbase.DBA_OB_LS_HISTORY | Displays the historical information of the current tenant's log streams. |
| oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS | Displays the log stream archiving progress of the current tenant. |
| oceanbase.DBA_OB_LS_REPLICA_TASKS | Displays the log stream replication tasks for the current tenant. |
| oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY | Displays the historical task records of log stream replication for the current tenant. |
| oceanbase.DBA_OB_LOG_RESTORE_SOURCE | Displays the log restore source information for the current tenant. |
| oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS | Displays the arbitration replica tasks for the current tenant. |
| oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY | Displays the arbitration replica task history for the current tenant. |
| oceanbase.DBA_OB_ARBITRATION_SERVICE | Displays information about the arbitration service. |
| oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN | Displays the flashback log SCN information for the current tenant. |
| oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG | Displays the data dictionary information in the current tenant's logs. |
| oceanbase.ALL_LOCATIONS | Displays the location information of tables or partitions accessible to the current user. |
Service management
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_SERVICES | Displays the service information of all tenants. |
| oceanbase.DBA_OB_SERVICES | Displays the service information of the current tenant. |
| oceanbase.DBA_OB_SERVER_JOBS | Displays all tasks related to OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | Displays information about all OBServer nodes. |
Keywords
View name |
Feature description |
|---|---|
| oceanbase.V$OB_KEYWORDS | Displays keyword information. |
Keywords
View name |
Feature description |
|---|---|
| information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP | This view displays the mapping information between NDB transactions, the NDB transaction coordinator, and MySQL servers attached to the NDB cluster as API nodes.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_TRX | This view displays information about current active transactions.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_LOCK_WAITS | This view displays information about the lock transactions and lock objects that are waiting when a lock conflict occurs.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_LOCKS | This view displays information about all locks currently held or waiting to be acquired.
NoteThis view is provided only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE | This view displays information about all cached pages in the buffer pool.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE_LRU | This view displays the LRU sorted information of pages in the InnoDB buffer pool.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_POOL_STATS | This view displays statistics of the InnoDB buffer pool.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP | Displays and compresses the status information related to InnoDB tables.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX | Displays information related to operations on InnoDB tables and indexes.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | This view displays the reset time information for InnoDB table and index-related operations, including display and compression.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure. |
| information_schema.INNODB_CMP_RESET | Displays the operation status related to compressing an InnoDB table.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMPMEM | This view displays the status of compressed pages in the InnoDB buffer pool.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMPMEM_RESET | Displays the reset time of compressed pages in the InnoDB buffer pool.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_DATAFILES | Displays the data file path information for the InnoDB files of each table and general tablespace.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_INDEXES | Displays InnoDB index metadata information.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_TABLES | Displays the metadata of an InnoDB table.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_TABLESPACES | Displays the metadata of InnoDB table files and general tablespaces.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_TABLESTATS | Displays low-level status information of an InnoDB table.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_VIRTUAL | Displays the metadata of columns virtually generated by InnoDB.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_TEMP_TABLE_INFO | Displays information about InnoDB temporary tables created by active users.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_METRICS | This view displays InnoDB performance information.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
Temporary file management
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_TEMP_FILES | Displays the temporary file information for all tenants. |
| oceanbase.DBA_OB_TEMP_FILES | Displays temporary file information. |
I/O Performance
View Name |
Feature description |
|---|---|
| CDB_OB_STORAGE_IO_USAGE | Displays the I/O operation statistics of all tenant object storage and cloud disks. |
OBKV related
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_KV_TTL_TASKS | This API is used to query all tenants for the number of TTL tasks in progress. |
| oceanbase.CDB_OB_KV_TTL_TASK_HISTORY | This API is used to query the historical TTL tasks of all tenants under the system tenant. |
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the TTL tasks currently being executed by the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks of the current tenant. |
| V$OB_KV_CLIENT_INFO | Displays the configuration parameter information of all OBKV tenant client connections on the current node. |
| GV$OB_KV_CLIENT_INFO | Displays the configuration parameters of all client connections to the OBKV tenant. |
| oceanbase.CDB_OB_KV_REDIS_TABLE | Displays the OBKV Redis table information for all tenants. |
| oceanbase.DBA_OB_KV_REDIS_TABLE | Displays the OBKV Redis table information for the current tenant. |
Outline related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | Displays the execution plan outline information for the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | Displays the throttling rule outline information for the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the execution plan and throttling rule outline historical information for this tenant. |
| DBA_OB_FORMAT_OUTLINES | Records the details of the current tenant's format outline. |
PLSQL types
View Name |
Feature description |
|---|---|
| oceanbase.DBA_PLSQL_COLL_TYPES | Displays PL/SQL collection type information. |
| oceanbase.DBA_PLSQL_TYPES | Displays PL/SQL type information. |
| oceanbase.DBA_PLSQL_TYPE_ATTRS | Displays PL/SQL type attribute information. |
| oceanbase.ALL_PLSQL_COLL_TYPES | Displays the PL/SQL collection types accessible to the current user. |
| oceanbase.ALL_PLSQL_TYPES | Displays information about the PL/SQL types accessible to the current user. |
| oceanbase.ALL_PLSQL_TYPE_ATTRS | Displays the PL/SQL type attribute information accessible to the current user. |
Full-text indexes
View Name |
Feature description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | Displays information about the full-text indexes being dropped.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_CONFIG | Displays the configuration information of the InnoDB full-text search engine.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_DELETED | Displays information about full-text indexes that have been marked for deletion.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_INDEX_CACHE | This view displays the cache status information of InnoDB full-text indexes.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_FIELDS | This view displays the metadata of key columns (fields) for InnoDB indexes, which is equivalent to the information in the SYS_FIELDS table of the InnoDB data dictionary.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure. |
Task Scheduling Manager Related
View Name |
Feature description |
|---|---|
| oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS | Displays the runtime details of scheduled jobs for all tenants. |
| oceanbase.DBA_SCHEDULER_WINDOWS | Displays the scheduling window information. |
| oceanbase.DBA_SCHEDULER_JOB_CLASSES | Displays information about scheduled jobs. |
| oceanbase.ALL_SCHEDULER_WINDOWS | Displays the scheduling window information accessible to the current user. |
| oceanbase.CBA_SCHEDULER_RUNNING_JOBS | Displays all jobs running under the tenant. |
| oceanbase.DBA_SCHEDULER_RUNNING_JOBS | Displays all jobs running under the tenant. |
Event history monitoring related
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | Displays the historical records of deadlock events. This view shows the historical records of all tenants under the root tenant. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the historical records of deadlock events. This view shows the historical records of the current tenant in non-root tenants. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | Displays the event history information of an OBServer node. |
| oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY | Displays the event history of the root service. |
SPM-related
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_SPM_EVO_RESULT | Displays the evolution results of SQL plan management for all tenants. |
| oceanbase.DBA_OB_SPM_EVO_RESULT | Displays the evolution results of SQL plan management for the current tenant. |
Upgrade related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY | Displays the historical information of cluster events. |
Basic database information
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_SYS_VARIABLE_HISTORY | The system tenant displays the modification history of system variables for all tenants. |
| oceanbase.DBA_OB_SYS_VARIABLE_HISTORY | Displays the modification history of system variables for the current tenant. |
| oceanbase.CDB_OB_DATABASES | The system tenant displays the database metadata of all tenants. |
| oceanbase.DBA_OB_DATABASES | Displays the database metadata of a tenant. |
| information_schema.events | Records all event information. |
| oceanbase.CDB_OB_AUTO_INCREMENT | Displays the auto-increment column information for all tenants. |
| oceanbase.DBA_OB_TENANT_EVENT_HISTORY | Displays the event history of a tenant. | | oceanbase.CDB_OB_SYS_VARIABLES | Display the system variable information of all tenants under the sys tenant. | | oceanbase.DBA_OB_SYS_VARIABLES | Displays the system variable information of the current tenant. |
Statistics and histograms
View Name |
Feature description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays optimizer statistics for all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms for all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays the column statistics and histogram information for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays histograms for all columns in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays the histogram data (the endpoints of each histogram) for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays the histogram data (the endpoints of each histogram) on all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the historical table statistics for all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays the optimizer statistics for all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the cumulative modification information of tables in the database. |
| oceanbase.CDB_TAB_COL_STATISTICS | Column-level statistics are displayed under the sys tenant. |
| oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | Query the historical collection and execution status of a table. |
| oceanbase.CDB_OB_AUX_STATISTICS | Displays auxiliary statistics for all tenants. |
| oceanbase.DBA_OB_AUX_STATISTICS | Displays the auxiliary statistics of the current tenant. |
| oceanbase.DBA_OB_TABLE_STAT_STALE_INFO | Displays the expiration status of statistics. |
| oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY | Displays the history of table statistics collection tasks. |
External resources
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_EXTERNAL_RESOURCES | Displays all uploaded resource files. |
| oceanbase.CDB_OB_EXTERNAL_TABLE_FILES | Displays the file list of external tables created by all tenants. |
| oceanbase.DBA_OB_EXTERNAL_RESOURCES | Displays the uploaded resource files. |
| oceanbase.DBA_OB_EXTERNAL_TABLE_FILES | Displays the file list corresponding to all external tables created under the current tenant. |
| oceanbase.ALL_OB_EXTERNAL_TABLE_FILES | Displays a list of files for external tables to which the current user has access. |
Foreign key related
View Name |
Feature description |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | Displays metadata information about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table in the InnoDB data dictionary.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_FOREIGN_COLS | This view displays status information about InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table in the InnoDB data dictionary.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure. |
Materialized view related
View Name |
Feature description |
|---|---|
| oceanbase.CDB_MVIEW_RUNNING_JOBS | It displays all current materialized view-related tasks for all tenants, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.CDB_MVIEWS | This API is used to query the materialized view information of all tenants. |
| oceanbase.CDB_MVIEW_LOGS | This API is used to display the materialized view log information of all tenants. |
| oceanbase.CDB_MVREF_CHANGE_STATS | This view displays statistics related to materialized view refreshes for all tenants. |
| oceanbase.CDB_MVREF_RUN_STATS | This view displays information about each refresh operation of materialized views for all tenants. |
| oceanbase.CDB_MVREF_STATS | This view displays basic timing statistics for materialized view refreshes of all tenants. |
| oceanbase.CDB_MVREF_STATS_PARAMS | Displays the refresh statistics attributes associated with each materialized view for all tenants. |
| oceanbase.CDB_MVREF_STATS_SYS_DEFAULTS | Displays the system-wide default values for the statistical attributes of all tenant materialized view refresh history. |
| oceanbase.CDB_MVREF_STMT_STATS | This view displays information related to all tenant materialized view refresh statements. |
| oceanbase.DBA_MVIEW_DEPS | Displays the dependencies of materialized views for the current tenant. |
| oceanbase.DBA_MVIEW_LOGS | This topic describes how to display materialized view log information. |
| oceanbase.DBA_MVIEW_RUNNING_JOBS | Displays the materialized view-related tasks currently in progress for the current tenant, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.DBA_MVIEWS | This view displays information about all materialized views. |
| oceanbase.DBA_MVREF_CHANGE_STATS | This view displays statistics related to materialized view refreshes. |
| oceanbase.DBA_MVREF_RUN_STATS | It displays information about each refresh operation of the materialized view, with each operation identified by a REFRESH_ID. |
| oceanbase.DBA_MVREF_STATS | This view displays basic timing statistics for materialized view refreshes. |
| oceanbase.DBA_MVREF_STATS_PARAMS | Displays the refresh statistics attributes associated with each materialized view. |
| oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS | The system-wide default value for the historical statistics refresh attribute of materialized views. |
| oceanbase.DBA_MVREF_STMT_STATS | Describes the information associated with the refresh statement. |
| oceanbase.ALL_MVIEWS | Displays the information about materialized views that the current user can access. |
| oceanbase.ALL_MVIEW_LOGS | Displays the materialized view log information accessible to the current user. |
WR-related
View Name |
Feature description |
|---|---|
| oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY | Displays the persistent ASH data for all tenants. |
| oceanbase.CDB_WR_CONTROL | Displays the configuration information related to write requests. |
| oceanbase.CDB_WR_EVENT_NAME | Displays the names of persistent tenant-level wait events for all tenants. |
| oceanbase.CDB_WR_SNAPSHOT | Display all tenants'SNAPSHOTInformation. |
| oceanbase.CDB_WR_SQLSTAT | This view displays the basic performance statistics of all SQL statements executed by tenants. Each SQL statement is represented as a row in the view.SQL_ID + Plan_HashThe unique value of the primary key is one row). |
| oceanbase.CDB_WR_SQLTEXT | Displays the SQL text collected for write operations of all tenants. |
| oceanbase.CDB_WR_STATNAME | Displays the names of system statistics for all tenants. |
| oceanbase.CDB_WR_SYS_TIME_MODEL | This API is used to query the write-through data of all tenants. |
| oceanbase.CDB_WR_SYSSTAT | Displays detailed system statistics for all tenants. |
| oceanbase.CDB_WR_SYSTEM_EVENT | This API is used to display the persistent tenant-level wait event information for all tenants. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | Displays the persisted ASH data for this tenant. |
| oceanbase.DBA_WR_CONTROL | Displays the configuration information related to write requests. |
| oceanbase.DBA_WR_EVENT_NAME | Displays the names of persistent tenant-level wait events for the current tenant. |
| oceanbase.DBA_WR_SNAPSHOT | Display the of this tenant.SNAPSHOTInformation. |
| oceanbase.DBA_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed by the current tenant. Each SQL statement is represented as a row in the table.SQL_ID + Plan_HashThe unique value of the column is one row). |
| oceanbase.DBA_WR_SQLTEXT | Displays the SQL text collected for write requests of the current tenant. |
| oceanbase.DBA_WR_STATNAME | Displays the name of the system statistic item for this tenant. |
| oceanbase.DBA_WR_SYS_TIME_MODEL | Displays the write-through data of time model statistics for the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | Displays detailed information about the system statistics of the current tenant. |
| oceanbase.DBA_WR_SYSTEM_EVENT | This API is used to display the persistent tenant-level wait event information of the current tenant. |
| oceanbase.CDB_WR_SQL_PLAN | Displays the SQL execution plan information collected for write operations of all tenants. |
| oceanbase.CDB_WR_RES_MGR_SYSSTAT | Displays the resource manager statistics collected for write operations of all tenants. |
| oceanbase.DBA_WR_SQL_PLAN | Displays the SQL execution plan information collected for write operations of the current tenant. |
| oceanbase.DBA_WR_RES_MGR_SYSSTAT | Displays the resource manager statistics collected for write requests of the current tenant. |
Vector index related
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_VECTOR_INDEX_TASKS | Displays the vector index task information for all tenants. |
| oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY | Displays the vector index task history for all tenants. |
| oceanbase.DBA_OB_VECTOR_INDEX_TASKS | Displays the vector index task information for the current tenant. |
| oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY | Displays the history of vector index tasks for the current tenant. |
Minor compaction and major compaction related
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_MAJOR_COMPACTION | The system tenant displays the global major compaction information for all tenants. |
| oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION | The system tenant displays the major compaction information for each zone of all tenants. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the global major compaction information for the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays the major compaction information for each zone in the tenant. |
| oceanbase.CDB_OB_FREEZE_INFO | Displays the version information generated during a major freeze. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated during a major freeze. |
Certificate Management
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE | Displays the information about trusted root certificates. |
Resource management
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | Displays the resource pool information for all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | Displays all UNIT-related tasks. |
| oceanbase.DBA_OB_UNITS | Displays the unit information for all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | Displays the unit specifications of all tenants. |
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | Displays all sequences in the database. |
| CDB_OB_RSRC_DIRECTIVES | Displays the resource configuration parameters of all tenants in the Resource Manager. |
Tenant management
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OBJECTS | Displays all database objects. The view definition is the same as that of ALL_OBJECTS. |
| oceanbase.CDB_OBJECTS | The system tenant displays the object information for all tenants. |
| oceanbase.DBA_OB_TENANTS | This API is used to display the basic information of all tenants, including the system tenant, user-created tenants (user tenants), and the Meta tenant. You can query byTENANT_TYPEColumns are used to distinguish tenant types. |
| oceanbase.DBA_OB_TENANT_JOBS | Displays task information at the tenant level. |
| oceanbase.CDB_OB_TENANT_EVENT_HISTORY | Displays the event history of all tenants. |
| oceanbase.DBA_OB_ZONES | Displays information for all zones. |
TTL related
View Name |
Feature description |
|---|---|
| oceanbase.CDB_OB_TTL_TASKS | Displays the execution status of all user tenant TTL tasks in SQL mode. |
| oceanbase.CDB_OB_TTL_TASK_HISTORY | Displays the execution history of all user tenant TTL tasks in SQL mode. |
| oceanbase.DBA_OB_TTL_TASKS | Displays the execution status of the TTL tasks for the current tenant in SQL mode. |
| oceanbase.DBA_OB_TTL_TASK_HISTORY | Displays the execution history of the TTL tasks for the current tenant in SQL mode. |
Performance view overview
ASH-related
View Name |
Feature description |
|---|---|
| GV$ACTIVE_SESSION_HISTORY | Displays the history of active sessions. |
| V$ACTIVE_SESSION_HISTORY | Displays the history of active sessions. |
| GV$OB_ACTIVE_SESSION_HISTORY | This API is used to display the active session history of all OBServer nodes under all tenants. |
| V$OB_ACTIVE_SESSION_HISTORY | This API is used to display the active session history on the current OBServer node for all tenants. |
Catalog-related
View Name |
Feature description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This API is used to query the usage of HMS Catalog clients for all tenants. |
| V$OB_HMS_CLIENT_POOL_STAT | This API is used to query the usage of HMS Catalog clients for all tenants. |
| GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT | Retrieves the catalog pooling information of all OBServer nodes. |
| V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT | Retrieves the catalog pooling information of the OBServer node that executed the SQL statement. |
DTL-related
View Name |
Feature description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
Replica logs
View Name |
Feature description |
|---|---|
| GV$OB_TABLET_REPLICA_INFO | Displays the basic information of all tablet replicas on each node of all tenants, including the tenant to which they belong, log stream, table, database, and disk usage. |
| V$OB_TABLET_REPLICA_INFO | Displays the basic information of all tablet replicas for all tenants on the current node, including the tenant, log stream, table, database, and disk usage. |
| GV$OB_LOG_STAT | Displays the status of Palf. |
| GV$OB_LS_SNAPSHOTS | Displays information about the log stream snapshots persisted in all units. |
| V$OB_LOG_STAT | Displays the status of Palf. |
Partitioning
View Name |
Feature description |
|---|---|
| V$OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partitioned table information for all tenants. |
I/O-related
View Name |
Feature description |
|---|---|
| GV$OB_SHARED_STORAGE_QUOTA | Displays the I/O access resource information on all OBServer nodes. |
| V$OB_SHARED_STORAGE_QUOTA | Displays the I/O access resource information on the current OBServer node. |
| GV$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| V$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| GV$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
| V$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
Encryption tables
View Name |
Feature description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with encryption enabled. |
Memory-related
View Name |
Feature description |
|---|---|
| GV$OB_MEMORY | Displays memory statistics at the tenant level. |
| V$OB_MEMORY | Displays memory statistics at the tenant level. |
| GV$OB_MEMSTORE | This API is used to display the memory usage of the MemTable for all tenants on all servers. |
| V$OB_MEMSTORE | Displays the statistics of the tenant-level MemStore. |
| GV$OB_MEMSTORE_INFO | Displays detailed information about the MemTables of all partitions for all tenants on all servers. |
| V$OB_MEMSTORE_INFO | Displays detailed information about the MemTables of all partitions for all tenants on all servers. |
| GV$OB_SSTABLES | Displays the SSTable information of a tenant. |
| V$OB_SSTABLES | Displays the SSTable information of a tenant. |
| GV$OB_TENANT_MEMORY | This API is used to display the memory usage of each tenant in a cluster. |
| V$OB_TENANT_MEMORY | This API is used to display the memory usage of each tenant in the current observer process. |
Event-related
View Name |
Feature description |
|---|---|
| GV$OB_PROCESSLIST | Displays the session information on all OBServer nodes of a tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of COMPACT. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level compaction. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level compaction. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays information about transaction participants on all OBServer nodes. |
| GV$SESSION_EVENT | This metric displays the session-level wait events for all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | This view displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait time. |
| GV$SESSION_WAIT_HISTORY | This view displays information about the last 10 wait events for all sessions on all servers. |
| GV$SYSTEM_EVENT | Displays wait events at the tenant level for all tenants in the cluster. |
| GV$SESSTAT | Statistics events at the session level for all OBServer nodes. |
| GV$SYSSTAT | Displays tenant-level statistical event information on all servers. |
| V$OB_COMPACTION_PROGRESS | Displays the server-level major compaction progress information of a tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the recommended information for COMPACT. |
| V$OB_PROCESSLIST | Displays the session information of the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of COMPACT. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level compaction. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level compaction. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays information about transaction participants on all OBServer nodes. |
| V$STATNAME | This topic describes all statistical events. |
| V$EVENT_NAME | The following table describes the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | Details of each event currently being waited for by the session. By convention, each event has three parameters, each recording a corresponding value. |
| V$SESSION_WAIT_HISTORY | Details of the events currently being waited on by each session, including the last 10 such events. |
| V$SESSTAT | Displays the statistical event overview at the session level. |
| V$SYSSTAT | Displays tenant-level statistical event information on the current server. |
| V$SYSTEM_EVENT | Statistics on tenant-level wait events. |
| GV$SESSION_LONGOPS | Displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | Displays the execution status and progress of DDL operations on the current OBServer node. |
Cache related
View Name |
Feature description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache on all OBServer nodes for the current tenant. |
| V$OB_PLAN_CACHE_STAT | Records the overall status of each plan cache on all servers for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Records the status of each cached object in the plan cache on all servers for the current tenant. |
| V$OB_PLAN_CACHE_PLAN_STAT | 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 | Displays the physical execution plans cached on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache of the current server. |
| GV$OB_PS_STAT | Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache. |
| GV$OB_PX_P2P_DATAHUB | Displays information related to data transfer operations during parallel execution. |
| GV$OB_PX_TARGET_MONITOR | Displays the PX thread usage on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | Displays the PX thread usage on the OBServer node. |
| GV$OB_SQL_AUDIT | It displays statistics such as the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | It displays statistical information such as the source and execution status of each SQL request on the current server. |
| GV$SQL_PLAN_MONITOR | This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry that also records the trace information for that plan. |
| V$SQL_PLAN_MONITOR | Statistics at the operation level for slow queries, with one statistic record per operation. |
| V$SQL_MONITOR_STATNAME | DisplayGV$SQL_PLAN_MONITORof theOTHERSTAT_X_IDThe meaning of the numbers in the fields. |
| GV$OB_FLT_TRACE_CONFIG | Displays diagnostic information for end-to-end tracing. |
Session-related
View Name |
Feature description |
|---|---|
| GV$OB_SESSION | Records the session information created on all servers. |
Database-related
View Name |
Feature description |
|---|---|
| GV$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameter information on all OBServer nodes where the tenant resides. |
| GV$OB_SERVER_SCHEMA_INFO | Displays schema information on all servers. |
| GV$OB_SERVERS | Displays information about all OBServer nodes. |
| GV$OB_UNITS | Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster. |
| V$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameter information on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays schema information on all servers. |
| V$OB_SERVERS | Displays information about the current OBServer node. |
| V$OB_UNITS | Displays the unit information of the current OBServer node. |
| GV$DML_STATS | Displays DML information in the current user's tables. |
| V$DML_STATS | Displays DML information in the current user's tables. |
| V$OB_COMPATIBILITY_CONTROL | This topic describes the features that can be controlled for compatibility with product behaviors based on the OceanBase Database release version. |
Lock-related
Network
View Name |
Feature description |
|---|---|
| GV$OB_RPC_OUTGOING | The RPC sending statistics of all OBServer nodes. |
| GV$OB_RPC_INCOMING | This view displays statistics on RPC requests received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | This topic describes how to collect statistics on the number of RPC packets sent by different tenant RPC packet codes on an OBServer node. |
| V$OB_RPC_INCOMING | This metric is used to count the number of RPC packets received by different tenant RPC packet codes on an OBServer node. |
Workarea-related
View Name |
Feature description |
|---|---|
| GV$SQL_WORKAREA | Workarea statistics for all operators previously executed by the SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays statistics from all workareas executed previously, such as the number of times processing was done entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This API is used to query general information about SQL Workarea, such as the maximum available memory, current memory usage, and current held memory. |
| V$SQL_WORKAREA | Workarea statistics for all operators previously executed by the SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| V$SQL_WORKAREA_HISTOGRAM | Displays statistics from all previous workareas, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This API is used to query general information about the SQL workarea, including the maximum available memory, current memory usage, and current held memory. |
WR-related
View Name |
Feature description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | A histogram that shows the query execution time of all nodes in all tenants. |
| GV$OB_RES_MGR_SYSSTAT | This API is used to display the statistical information of resource groups in all OBServer nodes under all tenants. |
| GV$OB_SESS_TIME_MODEL | Displays time model statistics at the session level for the cluster. |
| GV$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements in a cluster. Each SQL statement is represented by a row (that is, eachSQL_ID + Plan_HashEach unique value corresponds to one row). |
| GV$OB_SYS_TIME_MODEL | This API is used to display time series metrics at the tenant level in a cluster. |
| V$OB_QUERY_RESPONSE_TIME_HISTOGRAM | A histogram that shows the query execution time of all tenants on the current node. |
| V$OB_RES_MGR_SYSSTAT | This API is used to display the statistical information of resource groups in the current OBServer for all tenants. |
| V$OB_SESS_TIME_MODEL | Displays the time model statistics at the session level on the current node. |
| 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 (that is, eachSQL_ID + Plan_Hash(The unique value of is one row.) |
| V$OB_SYS_TIME_MODEL | Displays time model statistics at the tenant level on the current node. |
Thread-related
View Name |
Feature description |
|---|---|
| GV$OB_TENANT_WORKER_GROUPS | Displays the status of worker thread groups on all nodes of a tenant. |
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, view the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, view the execution information of each thread. |
| GV$OB_TENANT_RUNTIME_INFO | Displays information related to thread queues and thread quotas in a tenant. |
| V$OB_TENANT_RUNTIME_INFO | Displays information related to thread queues and thread quotas in a tenant. |
Minor compaction and major compaction related
View Name |
Feature description |
|---|---|
| GV$OB_MERGE_INFO | Displays statistics related to completed compactions in the OceanBase cluster. |
| V$OB_MERGE_INFO | Displays statistics related to completed compactions in the OceanBase cluster. |
| GV$OB_COMPACTION_PROGRESS | Displays the OBServer-level major compaction progress information of a tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the recommended information for COMPACT. |
Resource management
View Name |
Feature description |
|---|---|
| GV$OB_GROUP_IO_STAT | Displays the real-time status of each resource group on all OBServer nodes of all tenants. |
| GV$OB_FUNCTION_IO_STAT | Displays the I/O statistics at the function level for all tenants across all OBServer nodes. |
| V$OB_GROUP_IO_STAT | Displays the real-time status of each resource group for all tenants on the current OBServer node. |
| V$OB_FUNCTION_IO_STAT | Displays the I/O statistics at the function level for all tenants on the current OBServer node. |
Overview of views in a MySQL-compatible tenant
Overview of dictionary views
Backup and restore related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS | Displays information about the job-level backup verification tasks initiated by the current tenant. |
| oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY | Displays the execution history of job-level backup verification tasks initiated by this tenant. |
| oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS | Displays information about the backup verification task initiated by the current tenant. |
| oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY | Displays the execution history of backup verification tasks initiated by the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup job tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the historical records of backup job tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the historical records of backup job tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup job tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the historical records of backup job tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the historical records of backup job tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | Displays the historical records of the tenant's own task-level backup tasks. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | Displays the file status of the backup set. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | Displays the ongoing restore tasks. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays completed restore tasks. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the archive path configuration. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays information about the backup destinations used for backup and restore operations in a tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information of backup destinations used for backup and restore operations under a tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies set for expiration cleanup and automatic cleanup under the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of tenant-level backup cleanup jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the historical information of backup cleanup tasks executed under a tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays information about the backup_set and backup_piece cleanup tasks being executed under a tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the historical information of completed backup_set and backup_piece cleanup tasks for a tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | Displays the log backup status for each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log backups. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of pieces in a backup set. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOBS | Displays information related to table-level restore tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | Displays information related to the import task. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | Displays records for table-level import tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of a table-level restore task. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the result of the import task. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the historical records of table-level cross-tenant import tasks. |
Tables and columns related
View Name |
Feature description |
|---|---|
| information_schema.COLUMNS | Record column information. |
| information_schema.STATISTICS | Records index information for tables. |
| information_schema.TABLES | Records table information. |
| information_schema.VIEWS | Records view information. |
| information_schema.VIEW_TABLE_USAGE | Displays information about the tables and views used in the view definition. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the association between TABLEGROUPs and TABLEs. TABLEs that are not part of a TABLEGROUP are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the columns contained in the partitioning key for all partition objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | View the columns contained in the subpartitioning key for all partition objects in the database. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the location of tables or partitions, including system tables, user tables, index tables, etc. |
| information_schema.TABLESPACES | Information related to tablespaces.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| oceanbase.DBA_TABLES | Displays information about all tables in the current tenant. |
Catalog related
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS | This API is used to query partition-level statistics of external table columns in an external catalog. |
| oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS | This API is used to query column-level statistics of external tables in a catalog. |
| oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS | This API is used to query table-level statistics of external tables in a catalog. |
Storage related
View Name |
Feature description |
|---|---|
| mysql.proc | Displays information about the stored procedure. |
| information_schema.ENGINES | Records information related to the storage engine. |
| information_schema.PARAMETERS | Provides information about stored procedure parameters and return values. |
| information_schema.ROUTINES | Provides information related to stored procedures. |
Access control related
View Name |
Feature description |
|---|---|
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | Displays the number of failed login attempts by different users. |
Partitioning related
View Name |
Feature description |
|---|---|
| information_schema.PARTITIONS | Records partition information. |
| oceanbase.DBA_IND_PARTITIONS | Displays the partition information of an index. |
| oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partitioned table information of the current tenant. |
| oceanbase.DBA_PART_INDEXES | Displays the partition information for all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | Displays information about user table partitions. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the multi-level partition information, partition storage parameters, and partition statistics that the current user has access to. |
| oceanbase.DBA_TAB_SUBPARTITIONS | It displays the subpartition name, the table and partition names to which it belongs, its storage attributes, andDBMS_STATSThe statistics generated by the package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays the descriptions of all subpartition templates. |
Load balancing related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT | Displays all partitions with special weights set under the current user tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the current partition transfer tasks being processed for the tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of transfer partition tasks executed for this tenant. |
Replica logs related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_CS_REPLICA_STATS | Displays the progress of converting tablets to columnar storage in the log streams of the C replicas on each OBServer node of the tenant. |
| oceanbase.DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the partition information of a table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information for a table group that is partitioned. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the meta information of a table group, mainly its partition information. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays information for all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key:<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays a list of all tablets for the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution information of log stream (LS) replicas for the current tenant. |
| oceanbase.DBA_OB_CS_REPLICA_STATS | Displays the progress of converting tablets to columnar storage in the log streams of C replicas on each OBServer node of the tenant. |
| oceanbase.DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the partition information of a table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information for a table group that is partitioned. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the meta information of a table group, mainly its partition information. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays information about all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key:<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays a list of all tablets for the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution information of log stream (LS) replicas for the current tenant. |
Keywords related
View name |
Feature description |
|---|---|
| oceanbase.V$OB_KEYWORDS | Displays keyword information. |
Help commands related
View name |
Feature description |
|---|---|
| oceanbase.V$OB_KEYWORDS | Displays keyword information. |
Help commands related
View Name |
Feature description |
|---|---|
| mysql.help_topic | With the other three tablesmysql.help_category、mysql.help_relation、mysql.help_keywordCollaborate to generate Help commands. |
| mysql.help_category | With the other three tablesmysql.help_relation、mysql.help_topic、mysql.help_keywordGenerate the help command together. |
| mysql.help_keyword | With the other three tablesmysql.help_relation、mysql.help_topic、mysql.help_categoryGenerate the help command together. |
| mysql.help_relation | With the other three tablesmysql.help_category、mysql.help_topic、mysql.help_keywordGenerate Help commands in cooperation. |
InnoDB storage engine related
View Name |
Feature description |
|---|---|
| information_schema.INNODB_LOCK_WAITS | This view displays information about the lock transactions and lock objects that are waiting when a lock conflict occurs.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_LOCKS | This view displays information about all locks currently held or waiting to be acquired.
NoteThis view is provided only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP | This view displays the mapping information between NDB transactions, the NDB transaction coordinator, and MySQL servers attached to the NDB cluster as API nodes.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_TRX | This view displays information about current active transactions.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE | This view displays information about all cached pages in the buffer pool.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE_LRU | This view displays the LRU sorted information of pages in the InnoDB buffer pool.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_POOL_STATS | This view displays statistics of the InnoDB buffer pool.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP | Displays and compresses the status information related to InnoDB tables.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX | Displays information related to operations on InnoDB tables and indexes.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | This view displays the reset time information for InnoDB table and index-related operations, including display and compression.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure. |
| information_schema.INNODB_CMP_RESET | Displays the operation status related to compressing an InnoDB table.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMPMEM | This view displays the status of compressed pages in the InnoDB buffer pool.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMPMEM_RESET | Displays the reset time of compressed pages in the InnoDB buffer pool.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_DATAFILES | Displays the data file path information for the InnoDB files of each table and general tablespace.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_INDEXES | Displays InnoDB index metadata information.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_TABLES | Displays the metadata of an InnoDB table.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_TABLESPACES | Displays the metadata of InnoDB table files and general tablespaces.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_TABLESTATS | Displays low-level status information of an InnoDB table.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_VIRTUAL | Displays the metadata of columns virtually generated by InnoDB.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_TEMP_TABLE_INFO | Displays information about InnoDB temporary tables created by active users.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_METRICS | This view displays InnoDB performance information.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
I/O performance related
View Name |
Feature description |
|---|---|
| DBA_OB_STORAGE_IO_USAGE | Displays the I/O operation statistics of the current tenant's object storage and cloud disks. |
OBKV-related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the TTL tasks currently being executed by the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks of the current tenant. |
| V$OB_KV_CLIENT_INFO | Displays the configuration parameter information of the current node's OBKV tenant client connection. |
| GV$OB_KV_CLIENT_INFO | Displays the configuration parameters of the client connection for this OBKV tenant. |
Outline related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | Displays the execution plan outline information for the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | Displays the throttling rule outline information for the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the execution plan and throttling rule outline historical information for this tenant. |
| DBA_OB_FORMAT_OUTLINES | Records the details of the current tenant's format outline. |
Task Scheduling Manager Related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_SCHEDULER_JOBS | Displays information about all scheduler jobs in the database. |
Permissions
View Name |
Feature description |
|---|---|
| mysql.db | Displays database-level privilege information (VIRTUAL_TABLE). |
| mysql.user | Used to record user-level privilege information (VIRTUAL_TABLE). |
| information_schema.COLUMN_PRIVILEGES | Displays column permission information. |
| information_schema.SCHEMA_PRIVILEGES | Describes database permission information. |
| information_schema.TABLE_PRIVILEGES | Records table privilege information. |
| information_schema.USER_PRIVILEGES | Records user permission information. |
Full-text indexes
View Name |
Feature description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | Displays information about the full-text indexes being dropped.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_CONFIG | Displays the configuration information of the InnoDB full-text search engine.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_DELETED | Displays information about full-text indexes that have been marked for deletion.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_INDEX_CACHE | This view displays the cache status information of InnoDB full-text indexes.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_FIELDS | This view displays the metadata of key columns (fields) for InnoDB indexes, which is equivalent to the information in the SYS_FIELDS table of the InnoDB data dictionary.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure. |
Session-related
View Name |
Feature description |
|---|---|
| information_schema.SESSION_STATUS | Records the status information of a session, such as the current number of active connections and the database uptime. |
| information_schema.SESSION_VARIABLES | Variable information of the session. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the historical records of deadlock events. This view shows the historical records of the current tenant in non-root tenants. |
Time zone
View Name |
Feature description |
|---|---|
| mysql.time_zone | Displays time zone-related information (SYSTEM_VIEW). |
| mysql.time_zone_name | Used to record the name of the time zone (SYSTEM_VIEW). |
| mysql.time_zone_transition | mysql.time_zone_transitionis a system view used to record time zone conversion information. |
| mysql.time_zone_transition_type | Used to record the time zone conversion type (SYSTEM_VIEW). |
SPM-related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | Displays the plan baseline for the SQL statement in SPM. |
| oceanbase.DBA_SQL_MANAGEMENT_CONFIG | Displays the configuration parameters in SPM. |
Basic database information
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_SYS_VARIABLE_HISTORY | Displays the modification history of system variables for the current tenant. |
| information_schema.GLOBAL_STATUS | Records the global state information of OceanBase Database. |
| information_schema.GLOBAL_VARIABLES | Records global variable information. |
| oceanbase.DBA_OB_SYS_VARIABLES | Displays the system variable information of the current tenant. |
| information_schema.SCHEMATA | Records database metadata. |
| oceanbase.DBA_OB_DATABASES | Displays the database metadata of a tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the global major compaction information for the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays the major compaction information for each zone in the tenant. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated during a major freeze. |
| information_schema.events | Records all event information. |
Statistics and histograms
View Name |
Feature description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays optimizer statistics for all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms for all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays the column statistics and histogram information for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays histograms for all columns in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays the histogram data (the endpoints of each histogram) for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays the histogram data (the endpoints of each histogram) on all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the historical table statistics for all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays the optimizer statistics for all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the cumulative modification information of tables in the database. |
| information_schema.QUERY_RESPONSE_TIME | It displays data types such as RESPONSE TIME histograms for monitoring by Prometheus. |
| oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | Query the historical collection execution of a table. |
Foreign key related
View Name |
Feature description |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | Displays metadata information about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table in the InnoDB data dictionary.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_FOREIGN_COLS | This view displays status information about InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table in the InnoDB data dictionary.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure. |
WR-related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | Display the of this tenant.SNAPSHOTInformation. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | Displays the persisted ASH data for this tenant. |
| oceanbase.DBA_WR_STATNAME | Displays the name of the system statistic item for this tenant. |
| oceanbase.DBA_WR_SYSSTAT | Displays detailed information about the system statistics of the current tenant. |
| oceanbase.DBA_WR_CONTROL | Displays the configuration information related to write requests. |
| oceanbase.DBA_WR_SYSTEM_EVENT | This API is used to display the persistent tenant-level wait event information of the current tenant. |
| oceanbase.DBA_WR_EVENT_NAME | Displays the names of persistent tenant-level wait events for the current tenant. |
| oceanbase.DBA_WR_SQLTEXT | Displays the SQL text collected for write requests of the current tenant. |
| oceanbase.DBA_WR_SQLSTAT | This view displays basic performance statistics for SQL statements executed by the current tenant. Each SQL statement is represented as a row in the table.SQL_ID + Plan_HashThe unique value of is one row). |
| oceanbase.DBA_WR_SYS_TIME_MODEL | This table displays the write data of time model statistics for the current tenant. |
Materialized views
View Name |
Feature description |
|---|---|
| oceanbase.DBA_MVIEW_DEPS | Displays the dependencies of materialized views for the current tenant. |
| oceanbase.DBA_MVIEW_LOGS | This topic describes how to display materialized view log information. |
| oceanbase.DBA_MVIEW_RUNNING_JOBS | Displays the materialized view-related tasks currently in progress for the current tenant, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.DBA_MVIEWS | This view displays information about all materialized views. |
| oceanbase.DBA_MVREF_CHANGE_STATS | This view displays statistics related to materialized view refreshes. |
| oceanbase.DBA_MVREF_RUN_STATS | It displays information about each refresh operation of the materialized view, with each operation identified by a REFRESH_ID. |
| oceanbase.DBA_MVREF_STATS | This view displays basic timing statistics for materialized view refreshes. |
| oceanbase.DBA_MVREF_STATS_PARAMS | Displays the refresh statistics attributes associated with each materialized view. |
| oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS | The system-wide default value for the historical statistics refresh attribute of materialized views. |
| oceanbase.DBA_MVREF_STMT_STATS | Describes the information associated with the refresh statement. |
TTL related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_TTL_TASKS | Displays the execution status of the TTL tasks for the current tenant in SQL mode. |
| oceanbase.DBA_OB_TTL_TASK_HISTORY | Displays the execution history of the TTL tasks for the current tenant in SQL mode. |
Thread-related
View Name |
Feature description |
|---|---|
| information_schema.PROCESSLIST | Provides information about running threads. |
Constraints
View Name |
Feature description |
|---|---|
| information_schema.CHECK_CONSTRAINTS | DisplayCREATE TABLEConstraints on tables and columns during operations. |
| information_schema.KEY_COLUMN_USAGE | Records the constraint information of the key in the column. |
| information_schema.REFERENTIAL_CONSTRAINTS | Displays the metadata of foreign key constraints. |
| information_schema.TABLE_CONSTRAINTS | Describes the table constraints. |
Resource-related
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | Displays all sequences in the database. |
Resource Manager-related
View Name |
Feature description |
|---|---|
| DBA_OB_RSRC_DIRECTIVES | Displays the resource configuration parameters of the current tenant in the Resource Manager. |
| DBA_OB_RSRC_IO_DIRECTIVES | Displays the I/O resource configuration of the current tenant in the resource manager. |
| DBA_RSRC_GROUP_MAPPINGS | Displays the binding relationship between users and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | Display information about all resource groups in the database. |
| DBA_RSRC_PLANS | Displays all system-defined resource management plans. |
| DBA_RSRC_PLAN_DIRECTIVES | Displays the details of each set of resource plan directives in the database. |
Tenant management
View Name |
Feature description |
|---|---|
| oceanbase.DBA_OBJECTS | Displays all database objects. The view definition is the same as that of ALL_OBJECTS. |
| oceanbase.DBA_OB_TENANTS | This API is used to display the basic information of all tenants, including the system tenant, user-created tenants (user tenants), and the Meta tenant. You can query byTENANT_TYPEColumns are used to distinguish tenant types. |
Character sets
View Name |
Feature description |
|---|---|
| information_schema.CHARACTER_SETS | Records the character set information of OceanBase Database. |
| information_schema.COLLATIONS | Records the comparison method information for each character set. |
| information_schema.COLLATION_CHARACTER_SET_APPLICABILITY | Records the correspondence between characters and collations. |
Performance view overview
ASH-related
View Name |
Feature description |
|---|---|
| GV$ACTIVE_SESSION_HISTORY | Displays the history of active sessions. |
| V$ACTIVE_SESSION_HISTORY | Displays the history of active sessions. |
| V$OB_ACTIVE_SESSION_HISTORY | This API is used to display the active session history of the current OBServer node in the current tenant. |
| GV$OB_ACTIVE_SESSION_HISTORY | This API is used to display the active session history of all OBServer nodes in the current tenant. |
Catalog-related
View Name |
Feature description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This API is used to query the HMS catalog usage of the current tenant. |
| V$OB_HMS_CLIENT_POOL_STAT | This API is used to query the HMS catalog usage of the current tenant. |
| GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT | Retrieves the catalog pooling information of all OBServer nodes. |
| V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT | Retrieves the catalog pooling information of the OBServer node that executed the SQL statement. |
Wait for Events
View Name |
Feature description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the OBServer-level major compaction progress information of a tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the recommended information for COMPACT. |
| GV$OB_PROCESSLIST | Displays the session information on all OBServer nodes of a tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of COMPACT. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level compaction. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level compaction. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays information about transaction participants on all OBServer nodes. |
| GV$SESSION_EVENT | This metric displays the session-level wait events for all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | This view displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait time. |
| GV$SESSION_WAIT_HISTORY | This view displays information about the last 10 wait events for all sessions on all servers. |
| GV$SYSTEM_EVENT | Displays wait events at the tenant level for all tenants in the cluster. |
| GV$SESSTAT | Statistics events at the session level for all OBServer nodes. |
| GV$SYSSTAT | Displays tenant-level statistical event information on all servers. |
| V$OB_COMPACTION_PROGRESS | Displays the server-level major compaction progress information of a tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the recommended information for COMPACT. |
| V$OB_PROCESSLIST | Displays the session information of the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of COMPACT. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level compaction. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level compaction. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays information about transaction participants on all OBServer nodes. |
| V$STATNAME | This topic describes all statistical events. |
| V$EVENT_NAME | The following table describes the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | Details of each event currently being waited for by the session. By convention, each event has three parameters, each recording a corresponding value. |
| V$SESSION_WAIT_HISTORY | Details of the events currently being waited on by each session, including the last 10 such events. |
| V$SESSTAT | Displays the statistical event overview at the session level. |
| V$SYSSTAT | Displays tenant-level statistical event information on the current server. |
| V$SYSTEM_EVENT | Tenant-level wait event statistics. |
DTL Tasks
View Name |
Feature description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
Replica logs
View Name |
Feature description |
|---|---|
| GV$OB_LOG_STAT | Displays the status of Palf. |
| V$OB_LOG_STAT | Displays the status of Palf. |
Partitioning
View Name |
Feature description |
|---|---|
| V$OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partitioned table information of the current tenant. |
Cache-related
View Name |
Feature description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache on all OBServer nodes for the current tenant. |
| V$OB_PLAN_CACHE_STAT | Records the overall status of each plan cache on all servers for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Records the status of each cached object in the plan cache on all servers for the current tenant. |
| V$OB_PLAN_CACHE_PLAN_STAT | 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 | Displays the physical execution plans cached on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache of the current server. |
| GV$OB_PS_STAT | Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache. |
| GV$OB_PX_TARGET_MONITOR | Displays the PX thread usage on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | Displays the PX thread usage on the OBServer node. |
| GV$OB_SQL_AUDIT | It displays statistics such as the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | It displays statistical information such as the source and execution status of each SQL request on the current server. |
| GV$SQL_PLAN_MONITOR | This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry that also records the trace information for that plan. |
| V$SQL_PLAN_MONITOR | Statistics at the operation level for slow queries, with one statistic record per operation. |
| V$SQL_MONITOR_STATNAME | DisplayGV$SQL_PLAN_MONITORofOTHERSTAT_X_IDThe meaning of the numbers in the fields. |
| GV$OB_FLT_TRACE_CONFIG | Displays diagnostic information for end-to-end tracing. |
I/O-related
View Name |
Feature description |
|---|---|
| GV$OB_SHARED_STORAGE_QUOTA | Displays the I/O access resource information on all OBServer nodes. |
| V$OB_SHARED_STORAGE_QUOTA | Displays the I/O access resource information on the current OBServer node. |
Encryption tables
View Name |
Feature description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with encryption enabled. |
Memory-related
View Name |
Feature description |
|---|---|
| GV$OB_MEMORY | Displays memory statistics at the tenant level. |
| V$OB_MEMORY | Displays memory statistics at the tenant level. |
| GV$OB_MEMSTORE | This API is used to display the memory usage of the MemTable for all tenants on all servers. |
| V$OB_MEMSTORE | Displays the statistics of the tenant-level MemStore. |
| GV$OB_MEMSTORE_INFO | Displays detailed information about the MemTables of all partitions for all tenants on all servers. |
| V$OB_MEMSTORE_INFO | Displays detailed information about the MemTables of all partitions for all tenants on all servers. |
| GV$OB_SSTABLES | Displays the SSTable information of a tenant. |
| V$OB_SSTABLES | Displays the SSTable information of a tenant. |
| GV$OB_TENANT_MEMORY | This API is used to display the memory usage of each tenant in a cluster. |
| V$OB_TENANT_MEMORY | This API is used to display the memory usage of each tenant in the current observer process. |
Session-related
View Name |
Feature description |
|---|---|
| GV$SESSION_LONGOPS | Displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | Displays the execution status and progress of DDL operations on the current OBServer node. |
Lock-related
Database-related
View Name |
Feature description |
|---|---|
| GV$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameter information on all OBServer nodes where the tenant resides. |
| GV$OB_SERVER_SCHEMA_INFO | Displays schema information on all servers. |
| GV$OB_UNITS | Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster. |
| V$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameter information on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays schema information on all servers. |
| V$OB_UNITS | Displays the unit information of the current OBServer node. |
| GV$DML_STATS | Displays DML information in the current user's tables. |
| V$DML_STATS | Displays DML information in the current user's tables. |
| V$OB_COMPATIBILITY_CONTROL | This topic describes the features that can be controlled for compatibility with product behaviors based on the OceanBase Database release version. |
Workarea-related
View Name |
Feature description |
|---|---|
| GV$SQL_WORKAREA | Workarea statistics for all operators previously executed by the SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays statistics from all workareas executed previously, such as the number of times processing was done entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This API is used to query general information about SQL Workarea, such as the maximum available memory, current memory usage, and current held memory. |
| V$SQL_WORKAREA | Workarea statistics for all operators previously executed by the SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| V$SQL_WORKAREA_HISTOGRAM | Displays statistics from all previous workareas, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This API is used to query general information about the SQL workarea, including the maximum available memory, current memory usage, and current held memory. |
WR-related
View Name |
Feature description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | A histogram that shows the query execution time of all nodes in the current tenant. |
| GV$OB_RES_MGR_SYSSTAT | This API is used to display the statistical information of resource groups on all OBServer nodes in the current tenant. |
| GV$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements in a cluster. Each SQL statement is represented by one row (that is, eachSQL_ID + Plan_HashEach unique value corresponds to one 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 (that is, eachSQL_ID + Plan_HashEach unique value corresponds to one row). |
| GV$OB_SESS_TIME_MODEL | Displays time model statistics at the session level for the cluster. |
| V$OB_SESS_TIME_MODEL | Displays the time model statistics at the session level on the current node. |
| GV$OB_SYS_TIME_MODEL | This API is used to display time series metrics at the tenant level in a cluster. |
| V$OB_SYS_TIME_MODEL | Displays time model statistics at the tenant level on the current node. |
| V$OB_RES_MGR_SYSSTAT | This API is used to display the statistical information of resource groups in the current OBServer node under the current tenant. |
Network
View Name |
Feature description |
|---|---|
| GV$OB_RPC_OUTGOING | The RPC sending statistics of all OBServer nodes. |
| GV$OB_RPC_INCOMING | This view displays statistics on RPC requests received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | This topic describes how to collect statistics on the number of RPC packets sent by different tenant RPC packet codes on an OBServer node. |
| V$OB_RPC_INCOMING | This metric is used to count the number of RPC packets received by different tenant RPC packet codes on an OBServer node. |
Thread-related
View Name |
Feature description |
|---|---|
| GV$OB_TENANT_WORKER_GROUPS | Displays the status of worker thread groups on all nodes of a tenant. |
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, view the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, view the execution information of each thread. |
Resource management
View Name |
Feature description |
|---|---|
| GV$OB_GROUP_IO_STAT | Displays the real-time status of each resource group on all OBServer nodes of the current tenant. |
| GV$OB_FUNCTION_IO_STAT | Displays the IO statistics at the function level for the current tenant across all OBServer nodes. |
| V$OB_GROUP_IO_STAT | Displays the real-time status of each resource group for the current tenant on the current OBServer node. |
| V$OB_FUNCTION_IO_STAT | Displays the IO statistics at the function level for the current tenant on the current OBServer node. |
Minor compaction and major compaction related
View Name |
Feature description |
|---|---|
| GV$OB_MERGE_INFO | Displays statistics related to completed compactions in the OceanBase cluster. |
| V$OB_MERGE_INFO | Displays statistics related to completed compactions in the OceanBase cluster. |
Overview of views in an Oracle-compatible tenant
Overview of dictionary views
Applicability
This content applies only to OceanBase Database Enterprise Edition.
Security permissions
View Name |
Feature description |
|---|---|
| ALL_USERS | Displays all database users visible to the current user. |
| DBA_USERS | Displays all users in the database. |
| USER_USERS | Displays the information of the current user. |
| ALL_COL_PRIVS | The current user has column object privileges on the object as the owner, grantor, or grantee. Column object privileges have been enabled for the role or the grantee is PUBLIC. |
| ALL_TAB_PRIVS | * The current user is the owner of the object, or the grantor of the object privilege, or the grantee of the object privilege. * The grantee of the object privilege is an activated role or the PUBLIC role. |
| DBA_COL_PRIVS | Displays all column object grants in the database. |
| DBA_SYS_PRIVS | Displays the system privileges granted to users and roles. |
| DBA_TAB_PRIVS | Displays all object grants in the database. |
| USER_TAB_PRIVS | Displays the object privileges currently held by the user. |
| USER_COL_PRIVS | Displays the columns that indicate whether the current user is the object owner, grantor, or grantee for the column object. |
| USER_ROLE_PRIVS | Displays the roles granted to the current user. |
| USER_SYS_PRIVS | Displays the system privileges granted to the current user. |
| ROLE_TAB_PRIVS | Displays the table privileges granted to a role. Provides only information about the roles that users can access. |
| ROLE_SYS_PRIVS | Displays the system privileges granted to a role. |
| ROLE_ROLE_PRIVS | Displays the roles granted to other roles. Only information about the roles that a user can access is provided. |
| DBA_ROLE_PRIVS | Displays the roles granted to all users and the roles in the database. |
| DBA_ROLES | Displays all roles existing in the database. |
| ALL_DIRECTORIES | Displays all directories accessible to the current user. |
| DBA_DIRECTORIES | Displays all directories accessible to the current user. |
| USER_PRIVILEGES | Displays the current user's permission information. |
Security policies
View Name |
Feature description |
|---|---|
| USER_POLICIES | Displays the fine-grained access control policy information of the current user. |
| USER_POLICY_CONTEXTS | Displays the policy context information of the current user. |
| USER_POLICY_GROUPS | Displays the policy group information of the current user. |
| USER_SEC_RELEVANT_COLS | Displays column information related to security policies for the current user. |
Backup and recovery
View Name |
Feature description |
|---|---|
| DBA_OB_BACKUP_VALIDATE_JOBS | Displays information about the job-level backup verification tasks initiated by the current tenant. |
| DBA_OB_BACKUP_VALIDATE_JOB_HISTORY | Displays the execution history of job-level backup verification tasks initiated by this tenant. |
| DBA_OB_BACKUP_VALIDATE_TASKS | Displays information about the backup verification task initiated by the current tenant. |
| DBA_OB_BACKUP_VALIDATE_TASK_HISTORY | Displays the execution history of backup verification tasks initiated by the current tenant. |
| DBA_OB_BACKUP_JOBS | Displays the backup job tasks of the current tenant. |
| DBA_OB_BACKUP_JOB_HISTORY | Displays the historical records of backup job tasks for the current tenant. |
| DBA_OB_BACKUP_TASKS | Displays the tenant's own task-level backup tasks. |
| DBA_OB_BACKUP_TASK_HISTORY | Displays the historical records of the tenant's own task-level backup tasks. |
| DBA_OB_BACKUP_SET_FILES | Displays the file status of the backup set. |
| DBA_OB_RESTORE_PROGRESS | Displays the ongoing restore tasks. |
| DBA_OB_RESTORE_HISTORY | Displays completed restore tasks. |
| DBA_OB_ARCHIVE_DEST | Displays the archive path configuration. |
| DBA_OB_BACKUP_STORAGE_INFO | Displays information about the backup destinations used for backup and restore operations in a tenant. |
| DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information of backup destinations used for backup and restore operations under a tenant. |
| DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies set for expiration cleanup and automatic cleanup under the tenant. |
| DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of tenant-level backup cleanup jobs. |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the historical information of backup cleanup tasks executed under a tenant. |
| DBA_OB_BACKUP_DELETE_TASKS | Displays information about the backup_set and backup_piece cleanup tasks being executed under a tenant. |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the historical information of completed backup_set and backup_piece cleanup tasks for a tenant. |
| DBA_OB_ARCHIVELOG | Displays the log backup status for each path. |
| DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log backups. |
| DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of pieces in a backup set. |
| DBA_OB_BACKUP_PARAMETER | Displays backup parameters. |
| DBA_OB_RECOVER_TABLE_JOBS | Displays information related to table-level restore tasks. |
| DBA_OB_IMPORT_TABLE_JOBS | Displays information related to the import task. |
| DBA_OB_IMPORT_TABLE_TASKS | Displays records for table-level import tasks. |
| DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of a table-level restore task. |
| DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the result of the import task. |
| DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the historical records of table-level cross-tenant import tasks. |
Tables and views
View Name |
Feature description |
|---|---|
| ALL_ALL_TABLES | Displays the object tables and relational tables that the user has access to. |
| ALL_COL_COMMENTS | Displays all column comments for the views and tables that the user has access to. |
| ALL_TABLES | Displays all tables accessible to the user. |
| ALL_TAB_COLS | Displays all columns of tables, views, and clusters that the current user has access to. |
| ALL_TAB_COLUMNS | Displays all columns of tables, views, and clusters that the current user has access to. |
| ALL_TAB_COMMENTS | Displays the comments on tables and views that the current user has access to. |
| DBA_COL_COMMENTS | Displays all column comments for all views and tables in the database. |
| DBA_TAB_COMMENTS | Displays the comments for all tables and views in the database. |
| USER_COL_COMMENTS | Displays all column comments for the views and tables owned by the current user. |
| USER_TAB_COMMENTS | Displays the comments on tables and views owned by the current user. |
| DBA_OB_TABLEGROUP_TABLES | Displays the association between TABLEGROUPs and TABLEs. TABLEs that are not part of a TABLEGROUP are not displayed. |
| DBA_TABLES | Displays all tables in the database. |
| DBA_ALL_TABLES | Displays object tables and relational tables in the database. Its fields are the same as those of ALL_ALL_TABLES. |
| DBA_TABLESPACES | Displays all tablespaces in the database. |
| DBA_TAB_COLS | Displays all columns in all tables, views, and clusters in the database. |
| DBA_TAB_COLUMNS | Displays all columns in all tables, views, and clusters in the database. |
| USER_ALL_TABLES | Displays the object tables and relational tables that the current user can access. Except for the OWNER column, its fields are the same as those in the ALL_ALL_TABLES view. |
| USER_TABLES | Displays all tables owned by the current user. |
| USER_TABLESPACES | Displays the tablespaces that the current user can access. Its columns correspond to those in theDBA_TABLESPACESThe columns in the middle are the same, and the following columns are removed:PLUGGED_INfield. |
| USER_TAB_COLS | Displays all columns of the tables, views, and clusters owned by the current user. |
| oceanbase.USER_TAB_COLS_V$ | Displays the column information for table and view objects of the current user. |
| USER_TAB_COLUMNS | Displays all columns of the tables, views, and clusters owned by the current user. |
| ALL_VIEWS | Displays the views accessible to the current user. |
| DBA_VIEWS | Displays all views in the database. Its columns are as follows:ALL_VIEWSThe columns in them are the same. |
| USER_VIEWS | Displays the views owned by the current user. |
| DICTIONARY | Displays the descriptions of data dictionary tables and views. |
| DICT | Displays the descriptions of data dictionary tables and views. |
| DBA_OB_TABLE_LOCATIONS | Displays the location of tables or partitions, including: system tables, user tables, index tables, etc. |
| DBA_OB_SPATIAL_COLUMNS | Displays the database name, table name, type, and SRS information corresponding to the spatial index column. |
Storage objects
View Name |
Feature description |
|---|---|
| ALL_ERRORS | Displays errors of the current stored object that the user can access. |
| DBA_ERRORS | Displays errors of the current stored objects in the database. |
| USER_ERRORS | Displays errors of the currently accessible storage objects. |
| DBA_SEGMENTS | Displays the storage information allocated to all segments in the database. |
| USER_SEGMENTS | Displays the storage information allocated for segments under the objects of the current user. |
Triggers
View Name |
Feature description |
|---|---|
| ALL_TRIGGERS | Displays the triggers and their descriptions on tables owned by the current user. If the user has the CREATE ANY TRIGGER privilege, this view describes all triggers in the database. |
| DBA_TRIGGERS | Displays all triggers in the database. |
| USER_TRIGGERS | Displays the triggers owned by the current user. |
| DBA_TRIGGER_ORDERING | Displays the execution sequence of triggers. |
| ALL_TRIGGER_ORDERING | Displays the execution sequence of triggers accessible to the current user. |
| USER_TRIGGER_ORDERING | Displays the trigger execution sequence information of the current user. |
Object types
View Name |
Feature description |
|---|---|
| ALL_METHOD_PARAMS | Method parameters for displaying the types of objects that users can access. |
| DBA_METHOD_PARAMS | Displays the method parameters of the object type in the database. |
| ALL_TYPE_METHODS | A method that displays the types of objects the user can access. |
| DBA_TYPE_METHODS | Displays the methods of an object type in a database. |
| USER_TYPE_METHODS | The method for displaying the types of objects a user can access, which is consistent with ALL_TYPE_METHODS in terms of field information, except that it does not contain an OWNER field. |
DBLINK
View Name |
Feature description |
|---|---|
| ALL_DB_LINKS | Displays all DBLINKs that the current user can access. |
| DBA_DB_LINKS | Displays all created DBLINKs under the current tenant. |
| USER_DB_LINKS | Displays the DBLINK created by the current user. |
Partitions
View Name |
Feature description |
|---|---|
| ALL_PART_KEY_COLUMNS | Displays the columns that make up the partitioning key for all accessible partition objects. |
| ALL_PART_TABLES | Displays the partition information of the partitioned tables that the current user can access. |
| ALL_SUBPARTITION_TEMPLATES | Displays the descriptions of all subpartition templates. |
| ALL_SUBPART_KEY_COLUMNS | Displays the columns contained in the subpartitioning key for all partition objects accessible to the user. |
| ALL_TAB_PARTITIONS | Displays the multi-level partition information, partition storage parameters, and partition statistics for all partitioned tables. |
| ALL_TAB_SUBPARTITIONS | DisplayDBMS_STATSThe package generates partition-level partition information, partition storage parameters, and partition statistics for partitions accessible to the current user. |
| DBA_OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partitioned table information of the current tenant. |
| DBA_PART_INDEXES | Displays the partition information for all partitioned indexes. |
| DBA_PART_KEY_COLUMNS | Displays the columns contained in the partitioning key for all partition objects in the database. |
| DBA_PART_TABLES | Displays the partition information of the partitioned tables that the current user can access. |
| DBA_SUBPARTITION_TEMPLATES | Displays the descriptions of all subpartition templates. |
| DBA_SUBPART_KEY_COLUMNS | Displays the columns contained in the subpartitioning key for all partition objects in the database. |
| DBA_TAB_PARTITIONS | Displays the multi-level partition information, partition storage parameters, and partition statistics that the current user has access to. |
| DBA_TAB_SUBPARTITIONS | It displays the subpartition name, the table and partition names to which it belongs, its storage attributes, andDBMS_STATSThe statistics generated by the package. |
| USER_PART_KEY_COLUMNS | Displays the columns contained in the partitioning key for all partition objects owned by the current user. |
| USER_PART_TABLES | Displays the partition information of the current user's partitioned table. |
| USER_SUBPARTITION_TEMPLATES | Displays the description of all subpartition templates. |
| USER_SUBPART_KEY_COLUMNS | Displays the columns contained in the subpartitioning key for all partition objects owned by the current user. |
| USER_TAB_SUBPARTITIONS | Displays the subpartition name, table name, partition to which it belongs, and storage attributes of each subpartition of the current user. |
| USER_TAB_PARTITIONS | Displays the multi-level partition information, partition storage parameters, and partition statistics of the current user. |
Load balancing
View Name |
Feature description |
|---|---|
| DBA_OB_OBJECT_BALANCE_WEIGHT | Displays all partitions with special weights set under the current user tenant. |
| DBA_OB_TRANSFER_PARTITION_TASKS | Displays the current partition transfer tasks being processed for the tenant. |
| DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of transfer partition tasks executed for this tenant. |
Replica logs
View Name |
Feature description |
|---|---|
| DBA_OB_CS_REPLICA_STATS | Displays the progress of converting tablets to columnar storage in the log streams of C replicas on each OBServer node of the tenant. |
| DBA_OB_LS_LOCATIONS | Displays the distribution information of log stream (LS) replicas for the current tenant. |
| DBA_OB_TABLEGROUPS | Displays the meta information of a table group, mainly its partition information. |
| DBA_OB_TABLEGROUP_PARTITIONS | Displays the partition information of a table group. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information for a table group that is partitioned. |
| DBA_OB_TABLET_REPLICAS | This view displays information about all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key:<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| DBA_OB_TABLET_TO_LS | Displays a list of all tablets for the current tenant and the log stream information to which each tablet belongs. |
| DBA_OB_LS | Displays the status and recovery progress of the log stream. |
Keywords
View name |
Feature description |
|---|---|
| V$OB_KEYWORDS | Displays keyword information. |
Keywords
View name |
Feature description |
|---|---|
| V$OB_KEYWORDS | Displays keyword information. |
Keywords
View name |
Feature description |
|---|---|
| V$OB_KEYWORDS | Displays keyword information. |
Recycle Bin
View Name |
Feature description |
|---|---|
| DBA_RECYCLEBIN | Displays information about all recycle bins in the database. |
| USER_RECYCLEBIN | Displays information about the recycle bin owned by the current user. Its columns correspond to those in theDBA_RECYCLEBINThe columns in the middle are the same, and the following columns have been removed:OWNERfield. |
I/O Performance Related
View Name |
Feature description |
|---|---|
| DBA_OB_STORAGE_IO_USAGE | Displays the I/O operation statistics of the current tenant's object storage and cloud disks. |
NLS
View Name |
Feature description |
|---|---|
| NLS_DATABASE_PARAMETERS | Displays NLS parameters at the database level (OceanBase Database tenant level). |
| NLS_INSTANCE_PARAMETERS | Displays NLS parameters at the instance level (tenant level). |
| NLS_SESSION_PARAMETERS | Displays NLS parameters at the session level. |
Outline related
View Name |
Feature description |
|---|---|
| DBA_OB_OUTLINES | Displays the execution plan outline information for the current tenant. |
| DBA_OB_CONCURRENT_LIMIT_SQL | Displays the throttling rule outline information for the current tenant. |
| DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the execution plan and throttling rule outline historical information for this tenant. |
| DBA_OB_FORMAT_OUTLINES | Records the details of the current tenant's format outline. |
Task Scheduling Manager Related
View Name |
Feature description |
|---|---|
| DBA_SCHEDULER_JOBS | Displays the scheduler job information accessible to the current user. |
| DBA_SCHEDULER_PROGRAM | Displays information about all schedulers in the database. |
| DBA_SCHEDULER_JOB_RUN_DETAILS | Displays information about all scheduler jobs in a tenant. |
| DBA_JOBS | Displays an overview of the currently submitted tasks. |
| USER_JOBS | Displays an overview of the currently submitted tasks. |
| DBA_JOBS_RUNNING | Displays the running tasks. |
PLSQL types
View Name |
Feature description |
|---|---|
| USER_PLSQL_COLL_TYPES | Displays the PL/SQL collection type information of the current user. |
| USER_PLSQL_TYPES | Displays the PL/SQL type information of the current user. |
| USER_PLSQL_TYPE_ATTRS | Displays the PL/SQL type attribute information of the current user. |
| DBA_OB_PL_OBJ_CACHE_STATUS | Displays the cache status information of PL objects. |
PL/SQL Stored Procedures
View Name |
Feature description |
|---|---|
| ALL_ARGUMENTS | Displays the parameters of functions and procedures that the current user can access. |
| ALL_PROCEDURES | Displays all functions and procedures that the current user can access, along with their related attributes. |
| ALL_SOURCE | Displays the text source of the storage object that the current user can access. |
| DBA_ARGUMENTS | Displays the parameters of functions and procedures available in the database. Its columns are as follows:ALL_ARGUMENTSThe columns in them are the same. |
| DBA_PROCEDURES | Displays all available functions and procedures in the database, along with their related attributes. Its columns are as follows:ALL_PROCEDURESThe columns in them are the same. |
| DBA_SOURCE | Displays the text source of all stored objects in the database. Its columns are as follows:ALL_SOURCEThe columns in them are the same. |
| USER_ARGUMENTS | Displays the parameters of the functions and procedures owned by the current user. Its columns are the same as those in theALL_ARGUMENTSThe columns in the middle are the same, and the following columns are removed:OWNERField. |
| USER_PROCEDURES | Displays all functions and procedures owned by the current user, along with their associated attributes. The columns are as follows:ALL_PROCEDURESThe columns in the middle are the same, and the following columns have been removed:OWNERfield. |
| USER_SOURCE | Displays the text source of the storage object currently owned by the user. Its columns correspond to those in theALL_SOURCEThe columns in the middle are the same, and the following columns are removed:OWNERfield. |
PROFILE related
View Name |
Feature description |
|---|---|
| ALL_PROFILES | Displays all the profiles and their limitations. |
| DBA_PROFILES | Displays all the profiles and their limitations. |
| USER_PROFILES | Displays all the profiles and their limitations. |
Event history monitoring related
View Name |
Feature description |
|---|---|
| DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the historical records of deadlock events. This view shows the historical records of the current tenant in non-root tenants. |
SPM-related
View Name |
Feature description |
|---|---|
| DBA_SQL_PLAN_BASELINES | Displays the plan baseline for the SQL statement in SPM. |
| DBA_SQL_MANAGEMENT_CONFIG | Displays the configuration parameters in SPM. |
Basic database information
View Name |
Feature description |
|---|---|
| DBA_OB_SYS_VARIABLE_HISTORY | Displays the modification history of system variables for the current tenant. |
| DBA_OB_SYS_VARIABLES | Displays the system variable information of the current tenant. |
| DBA_CONTEXT | Displays all context namespace information in the database. |
| DBA_OB_DATABASES | Displays the database metadata of a tenant. |
| DBA_OB_MAJOR_COMPACTION | Displays the global major compaction information for the current tenant. |
| DBA_OB_ZONE_MAJOR_COMPACTION | Displays the major compaction information for each zone in the tenant. |
| ALL_OBJECTS | Displays all database objects that the user has access to. |
| DBA_OBJECTS | Displays all database objects in the database. |
| USER_OBJECTS | Displays all database objects owned by the user. |
| ALL_DEPENDENCIES | Displays the dependencies between all objects in the database. |
| DBA_DEPENDENCIES | Displays all dependencies between objects in the database. |
| USER_DEPENDENCIES | Displays the dependencies between objects in the current user's schema. |
| DBA_OB_FREEZE_INFO | Displays the version information generated during a major freeze. |
| TENANT_VIRTUAL_GLOBAL_VARIABLE | Displays global variable information. |
| TENANT_VIRTUAL_SESSION_VARIABLE | Displays the variable information of the session. |
| DBA_OB_SOURCE | Displays the source code information for all storage objects under the current tenant. |
| USER_OB_SOURCE | Displays the source code information of the storage objects owned by the current user. |
| ALL_OB_SOURCE | Displays the source code information of the storage object that the current user has access to. |
Audit-related
View Name |
Feature description |
|---|---|
| ALL_DEF_AUDIT_OPTS | Displays the audit conditions that are audited by default for any object. |
| AUDIT_ACTIONS | Displays the action ID and its corresponding name in the audit record. |
| DBA_AUDIT_EXISTS | DisplayAUDIT EXISTSandAUDIT NOT EXISTSThe generated audit trail entry. |
| DBA_AUDIT_OBJECT | Displays the audit trail records for all objects in the database. |
| DBA_AUDIT_SESSION | Display all information aboutCONNECTandDISCONNECTaudit trail records. |
| DBA_AUDIT_STATEMENT | Display information about the database.GRANT、REVOKE、AUDIT、NOAUDITandALTER SYSTEMThe audit tracking record of the statement. |
| DBA_AUDIT_TRAIL | Displays all audit trail entries. |
| DBA_OBJ_AUDIT_OPTS | Displays the detailed configuration of object-level auditing. |
| DBA_STMT_AUDIT_OPTS | Displays the detailed configuration of statement-level auditing. |
| STMT_AUDIT_OPTION_MAP | Displays the type, name, and priority of statement-level audit. |
| USER_AUDIT_OBJECT | Displays the audit trail records of objects that the current user can access. |
| USER_AUDIT_SESSION | Displays the audit trail records of the current user's connections and disconnections. |
| USER_AUDIT_STATEMENT | Displays the commands issued by the current user.GRANT、REVOKE、AUDIT、NOAUDITandALTER SYSTEMThe audit tracking entry for the statement. |
| USER_AUDIT_TRAIL | Displays standard audit trail entries related to the current user. |
Index-related
View Name |
Feature description |
|---|---|
| ALL_INDEXES | Displays the index column information for all tables accessible to the user. |
| ALL_IND_COLUMNS | Displays the index column information for all tables accessible to the user. |
| ALL_IND_EXPRESSIONS | Displays information about the function-based indexes that users have access to in the database. |
| ALL_IND_PARTITIONS | Displays information about index partitions in the accessible databases. |
| ALL_IND_SUBPARTITIONS | Displays information about all index subpartitions that users can access in the database. |
| ALL_PART_INDEXES | Displays the partition information of the partitioned indexes that the current user can access. |
| DBA_INDEXES | Displays the index information for all tables in the database. |
| DBA_IND_COLUMNS | Displays the index column information for all tables in the database. |
| DBA_IND_EXPRESSIONS | Displays information about all function-based indexes in the database. |
| DBA_IND_PARTITIONS | Displays information about all index partitions in the database. |
| DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| USER_INDEXES | Displays the index information for all tables owned by the user. |
| USER_IND_COLUMNS | Displays the index column information for all indexes of a user's tables. |
| USER_IND_EXPRESSIONS | Displays information about the function-based indexes owned by the user in the database. |
| USER_IND_PARTITIONS | Displays information about index partitions in databases owned by the current user.ALL_IND_PARTITIONS、DBA_IND_PARTITIONSCompared with NoneINDEX_OWNERfield. |
| USER_IND_SUBPARTITIONS | Displays information about all index subpartitions owned by the user in the database, andDBA_IND_SUBPARTITIONS、ALL_IND_SUBPARTITIONSCompared with NoneINDEX_OWNERfield. |
| USER_PART_INDEXES | Displays the partition information of the current user's partitioned index. |
Statistics and histograms
View Name |
Feature description |
|---|---|
| ALL_PART_COL_STATISTICS | Displays the column statistics and histogram information of partitions in the partitioned tables that the current user has access to. |
| ALL_PART_HISTOGRAMS | Displays the histogram information for all partitions. |
| ALL_SUBPART_COL_STATISTICS | Displays the column statistics and histograms of the subpartitions in the partitioned tables that the current user has access to. |
| ALL_SUBPART_HISTOGRAMS | Displays histogram information for all subpartitions. |
| ALL_TAB_COL_STATISTICS | Displays the column statistics and histogram information of tables accessible to the current user. |
| ALL_TAB_HISTOGRAMS | Displays all table-level histogram information. |
| ALL_TAB_STATISTICS | Displays the optimizer statistics for tables accessible to the current user. |
| DBA_PART_COL_STATISTICS | Displays the column statistics and histogram information for partitions in a partitioned table. |
| DBA_PART_HISTOGRAMS | Displays the histogram information of the partitions in the current database. |
| DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histogram information for subpartitions in a partitioned table. |
| DBA_SUBPART_HISTOGRAMS | Displays the histogram information of the current database's subpartition. |
| DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms for all tables in the database. |
| DBA_TAB_HISTOGRAMS | Displays the histogram information at the table level for the current database. |
| DBA_TAB_STATISTICS | Displays optimizer statistics for all tables in the database. |
| USER_PART_COL_STATISTICS | Displays the column statistics and histogram information for the partitions in the current user's partitioned table. |
| USER_PART_HISTOGRAMS | Displays the histogram information of the current user's partitions. |
| USER_SUBPART_COL_STATISTICS | Displays the column statistics and histograms of the subpartitions in the current user's partitioned table. |
| USER_SUBPART_HISTOGRAMS | Displays the histogram information of the current user's subpartition. |
| USER_TAB_COL_STATISTICS | Displays the column statistics and histogram information for the current user's tables. |
| USER_TAB_HISTOGRAMS | Displays the histogram information at the table level for the current user. |
| USER_TAB_STATISTICS | Displays the optimizer statistics for all tables of the current user. |
| ALL_TAB_STATS_HISTORY | Displays the history of table statistics modifications for all tables accessible to the current user. |
| DBA_TAB_STATS_HISTORY | Displays the history of table statistics modifications for all tables in the database. |
| USER_TAB_STATS_HISTORY | Displays the history of table statistics modifications for all tables owned by the current user. |
| ALL_IND_STATISTICS | Displays optimizer statistics for indexes on tables that the current user has access to. |
| DBA_IND_STATISTICS | Displays the optimizer statistics for all indexes in the database. |
| USER_IND_STATISTICS | Displays the optimizer statistics for indexes on tables owned by the current user. |
| ALL_TAB_MODIFICATIONS | Displays the cumulative modification information of tables accessible to the current user. |
| DBA_TAB_MODIFICATIONS | Displays the cumulative modification information of tables in the database. |
| USER_TAB_MODIFICATIONS | Displays the cumulative modification information of tables owned by the current user. |
| DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | Query the historical collection and execution status of a table. |
Synonym related
View Name |
Feature description |
|---|---|
| ALL_SYNONYMS | Displays all synonyms that the user has access to. |
| DBA_SYNONYMS | Displays all synonyms in the database. |
| USER_SYNONYMS | Displays the synonyms owned by the current user. |
Task Scheduling Manager
View Name |
Feature description |
|---|---|
| USER_SCHEDULER_JOBS | Displays the scheduling job information of the current user. |
| ALL_SCHEDULER_JOB_ARGS | Displays the parameters of the scheduled job that users can view. |
| ALL_SCHEDULER_PROGRAM_ARGS | Displays the scheduler parameters available for user query. |
| DBA_SCHEDULER_JOB_ARGS | Displays the parameters of scheduled jobs in the database. |
| USER_SCHEDULER_JOB_ARGS | Displays the parameters of the scheduled job owned by the current user. |
| DBA_SCHEDULER_PROGRAM_ARGS | Displays the scheduler parameters in the database. |
| USER_SCHEDULER_PROGRAM_ARGS | Displays the scheduler parameters of the current user. |
WR-related
View Name |
Feature description |
|---|---|
| DBA_WR_SNAPSHOT | Displays the of the current tenant.SNAPSHOTInformation. |
| DBA_WR_ACTIVE_SESSION_HISTORY | Displays the persisted ASH data for this tenant. |
| DBA_WR_STATNAME | Displays the name of the system statistic item for this tenant. |
| DBA_WR_SYSSTAT | Displays detailed information about the system statistics of the current tenant. |
| DBA_WR_CONTROL | Displays the configuration information related to write requests. |
| DBA_WR_SYSTEM_EVENT | This API is used to display the persistent tenant-level wait event information of the current tenant. |
| DBA_WR_EVENT_NAME | Displays the names of persistent tenant-level wait events for the current tenant. |
| DBA_WR_SQLTEXT | Displays the SQL text collected for write requests of the current tenant. |
| DBA_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed by the current tenant. |
| DBA_WR_SYS_TIME_MODEL | This table displays the write data of time model statistics for the current tenant. |
Materialized view related
View Name |
Feature description |
|---|---|
| DBA_MVIEW_DEPS | Displays the dependencies of materialized views for the current tenant. |
| DBA_MVIEW_LOGS | This topic describes how to display materialized view log information. |
| DBA_MVIEW_RUNNING_JOBS | Displays the materialized view-related tasks currently in progress for the current tenant, including refresh tasks and MLOG cleanup tasks. |
| USER_MVIEWS | Displays materialized view information. |
| DBA_MVIEWS | This view displays information about all materialized views. |
| DBA_MVREF_CHANGE_STATS | This view displays statistics related to materialized view refreshes. |
| DBA_MVREF_RUN_STATS | It displays information about each refresh operation of the materialized view, with each operation identified by a REFRESH_ID. |
| DBA_MVREF_STATS | This view displays basic timing statistics for materialized view refreshes. |
| DBA_MVREF_STATS_PARAMS | Displays the refresh statistics attributes associated with each materialized view. |
| DBA_MVREF_STATS_SYS_DEFAULTS | The system-wide default value for the historical statistics refresh attribute of materialized views. |
| DBA_MVREF_STMT_STATS | Describes the information associated with the refresh statement. |
| USER_MVIEW_LOGS | Displays the materialized view log information of the current user. |
| USER_MVREF_CHANGE_STATS | Displays statistics related to materialized view refreshes for the current user. |
| USER_MVREF_RUN_STATS | Displays information about each refresh of the current user's materialized views. |
| USER_MVREF_STATS | Displays the basic timing statistics for refreshing materialized views by the current user. |
| USER_MVREF_STATS_PARAMS | Displays the refresh statistics attributes associated with each materialized view for the current user. |
| USER_MVREF_STATS_SYS_DEFAULTS | Displays the system-wide default values for the materialized view refresh history statistics attributes of the current user. |
| USER_MVREF_STMT_STATS | Displays information associated with the current user's materialized view refresh statements. |
TTL related
View Name |
Feature description |
|---|---|
| DBA_OB_TTL_TASKS | Displays the execution status of the TTL tasks for the current tenant in SQL mode. |
| DBA_OB_TTL_TASK_HISTORY | Displays the execution history of the TTL tasks for the current tenant in SQL mode. |
Source code
View Name |
Feature description |
|---|---|
| DBA_OB_SOURCE | Displays the source code of objects such as stored procedures and functions. |
| ALL_OB_SOURCE | Displays the source code of objects that the current user can access. |
| USER_OB_SOURCE | Displays the object source code of the current user. |
User-defined related
View Name |
Feature description |
|---|---|
| ALL_COLL_TYPES | Displays the user-defined collection types available in the database. Its columns are as follows:DBA_COLL_TYPESThe columns in them are the same. |
| ALL_TYPES | Displays the user-defined types available in the database. |
| ALL_TYPE_ATTRS | Displays the attribute information of user-defined types available in the database. |
| DBA_COLL_TYPES | Displays the user-defined collection types available in the database. Its columns are as follows:ALL_COLL_TYPESThe columns in them are the same. |
| DBA_TYPES | Displays the user-defined types available in the database. |
| DBA_TYPE_ATTRS | Displays the attribute information of user-defined types available in the database. |
| USER_COLL_TYPES | Displays the user-defined collection types available to the current user. |
| USER_TYPES | Displays the user-defined type of the current user. |
| USER_TYPE_ATTRS | Displays the attribute information of user-defined types available to the current user. |
Constraints
View Name |
Feature description |
|---|---|
| ALL_CONSTRAINTS | Displays the constraint information for all tables accessible to the user. |
| ALL_CONS_COLUMNS | Displays the column information in the constraints of all tables accessible to the user. |
| DBA_CONSTRAINTS | Displays the constraint information for all tables in the database. |
| DBA_CONS_COLUMNS | Displays the column information in all table constraints of the database. |
| USER_CONSTRAINTS | Displays the constraint information for all tables owned by the user. |
| USER_CONS_COLUMNS | Displays the column information in all table constraints owned by the user. |
Sequence-related
View Name |
Feature description |
|---|---|
| ALL_SEQUENCES | Displays all sequences that the user can access. |
| DBA_SEQUENCES | Displays all sequences in the database. |
| USER_SEQUENCES | Displays all sequences owned by the current user. |
Resource management
View Name |
Feature description |
|---|---|
| DBA_OB_RSRC_DIRECTIVES | Displays the resource configuration parameters of the current tenant in the Resource Manager. |
| DBA_OB_RSRC_IO_DIRECTIVES | Displays the I/O resource configuration of the current tenant in the resource manager. |
| DBA_RSRC_GROUP_MAPPINGS | Displays the binding relationship between users and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | Display information about all resource groups in the database. |
| DBA_RSRC_PLANS | Displays all system-defined resource management plans. |
| DBA_RSRC_PLAN_DIRECTIVES | Displays the details of each set of resource plan directives in the database. |
Performance view overview
ASH-related
View Name |
Feature description |
|---|---|
| GV$ACTIVE_SESSION_HISTORY | Displays the history of active sessions. |
| V$ACTIVE_SESSION_HISTORY | Displays the history of active sessions. |
| GV$OB_ACTIVE_SESSION_HISTORY | This API is used to display the active session history of all OBServer nodes in the current tenant. |
| V$OB_ACTIVE_SESSION_HISTORY | This API is used to display the active session history of the current OBServer node in the current tenant. |
Catalog-related
View Name |
Feature description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This API is used to query the HMS catalog usage of the current tenant. |
| V$OB_HMS_CLIENT_POOL_STAT | This API is used to query the HMS catalog usage of the current tenant. |
DBLINK-related
View Name |
Feature description |
|---|---|
| GV$DBLINK | This view displays all database links opened after the query session initiated on this view.IN_TRANSACTION=YES). These database links must be committed or rolled back before being closed. |
| V$DBLINK | This view displays all database links opened after the query session initiated on this view.IN_TRANSACTION=YES). These database connections must be committed or rolled back before being closed. |
DTL Tasks
View Name |
Feature description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
Replica logs
View Name |
Feature description |
|---|---|
| GV$OB_LOG_STAT | Displays the status of Palf. |
| V$OB_LOG_STAT | Displays the status of Palf. |
Partitioning
View Name |
Feature description |
|---|---|
| V$OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partitioned table information of the current tenant. |
Cache-related
View Name |
Feature description |
|---|---|
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache across all servers. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Records the status of each cached object in the plan cache on all servers for the current tenant. |
| GV$OB_PLAN_CACHE_STAT | Records the overall status of each plan cache on all servers for the current tenant. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached on the current server. |
| V$OB_PLAN_CACHE_PLAN_STAT | Records the status of each cached object in the plan cache for the current tenant on the current server. |
| V$OB_PLAN_CACHE_STAT | Records the overall status of each plan cache on all servers for the current tenant. |
| V$RSRC_PLAN | Displays the resource management plan for the current active tenant. |
I/O-related
View Name |
Feature description |
|---|---|
| GV$OB_SHARED_STORAGE_QUOTA | Displays the I/O access resource information on all OBServer nodes. |
| V$OB_SHARED_STORAGE_QUOTA | Displays the I/O access resource information on the current OBServer node. |
Encryption tables
View Name |
Feature description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with the encryption feature enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with encryption enabled. |
Memory-related
View Name |
Feature description |
|---|---|
| GV$OB_MEMORY | Displays the memory usage of each tenant on all servers. |
| GV$OB_MEMSTORE | Displays the memory usage of the MemTable for all tenants on all servers. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | It indicates the overall information of the SQL Workarea, including the maximum available memory, current memory usage, and current held memory. |
| GV$OB_SSTABLES | Displays the SSTable information of a tenant. |
| GV$OB_MEMSTORE_INFO | Displays detailed information about the MemTables of all partitions for all tenants on all servers. |
| V$OB_MEMSTORE_INFO | Displays detailed information about the MemTables of all partitions for all tenants on all servers. |
| V$OB_MEMORY | Displays memory statistics at the tenant level. |
| V$OB_MEMSTORE | Displays the memory usage of the MemTable for all tenants on the current server. |
| V$OB_SSTABLES | Displays the SSTable information of a tenant. |
| GV$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the current observer process. |
Instance-related
View Name |
Feature description |
|---|---|
| GV$INSTANCE | Displays the status of the current database instance. |
| V$INSTANCE | Displays the status of the current database instance. |
Time zone
View Name |
Feature description |
|---|---|
| V$TIMEZONE_NAMES | Displays the valid time zone names. |
Session-related
View Name |
Feature description |
|---|---|
| GV$OB_PROCESSLIST | Displays the session information on all OBServer nodes of a tenant. |
| GV$SESSION_WAIT | Displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait time. |
| GV$SESSION_WAIT_HISTORY | Displays information about the last 10 wait events for all sessions on all servers. |
| GV$SESSTAT | Displays some session-level statistics on all servers. |
| V$NLS_PARAMETERS | View NLS parameters at the session level. |
| V$OB_PROCESSLIST | Displays the session information of the current OBServer node. |
| V$SESSION_WAIT | Displays information about the current or last wait event for all sessions on the current server, including the wait event name and wait time. |
| V$SESSION_WAIT_HISTORY | Displays information about the last 10 wait events for all sessions on the current server. |
| V$SESSTAT | Displays some statistics at the session level. |
| V$EVENT_NAME | Displays the definitions of various events under a tenant. |
SQL audit related
View Name |
Feature description |
|---|---|
| GV$OB_SQL_AUDIT | Displays statistics such as the source and execution status of each SQL request across all servers. |
| V$OB_SQL_AUDIT | Displays statistics such as the source and execution status of each SQL request on the current server. |
End-to-end tracing
View Name |
Feature description |
|---|---|
| GV$OB_FLT_TRACE_CONFIG | Displays diagnostic information for end-to-end tracing. |
Statistics of statistics
View Name |
Feature description |
|---|---|
| GV$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameter information on all OBServer nodes where the tenant resides. |
| GV$OB_SERVER_SCHEMA_INFO | Displays schema information on all servers. |
| V$OB_SERVER_SCHEMA_INFO | Displays schema information on all servers. |
| GV$OB_UNITS | Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster. |
| GV$SYSSTAT | Displays system-level statistical event information on all servers. |
| GV$DML_STATS | Displays DML information in the current user's tables. |
| V$DML_STATS | Displays DML information in the current user's tables. |
| V$GLOBALCONTEXT | Displays the global context attributes accessible to the current session.CLIENT_IDENTIFIERValue. |
| V$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameter information on the current OBServer node. |
| V$SYSSTAT | Displays system-level statistical event information on the current server. |
| V$OB_UNITS | Displays the unit information of the current OBServer node. |
| V$VERSION | View the names and version information of all components in the database product. |
| V$STATNAME | Displays the name of the statistical item. |
Workarea-related
View Name |
Feature description |
|---|---|
| GV$SQL_WORKAREA | Workarea statistics for all operators previously executed by the SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | Information about the workspace of the current active operator. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the statistics of all workareas executed previously. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Query the overall information of SQL Workarea, including the maximum available memory, current memory usage, and current hold memory. |
| V$SQL_WORKAREA | Statistics on the workarea of all operators that have been executed by the automatic SQL memory management are collected. |
| V$SQL_WORKAREA_ACTIVE | Information about the workspace of the current active operator. |
| V$SQL_WORKAREA_HISTOGRAM | Displays the statistics of all workareas executed previously. |
WR-related
View Name |
Feature description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | A histogram that shows the query execution time of all nodes in the current tenant. |
| GV$OB_RES_MGR_SYSSTAT | This API is used to display the statistical information of resource groups on all OBServer nodes in the current tenant. |
| V$OB_RES_MGR_SYSSTAT | This API is used to display the statistical information of resource groups in the current OBServer node under the current tenant. |
| GV$OB_SQLSTAT | This view displays basic performance statistics for SQL statements in the cluster. Each SQL statement is represented by a row (that is, eachSQL_ID + Plan_HashThe unique value of is one 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 (that is, eachSQL_ID + Plan_HashThe unique value of the column is one row). |
| GV$OB_SESS_TIME_MODEL | Displays time model statistics at the session level for the cluster. |
| V$OB_SESS_TIME_MODEL | Displays the time model statistics at the session level on the current node. |
| GV$OB_SYS_TIME_MODEL | This API is used to display time series metrics at the tenant level in a cluster. |
| V$OB_SYS_TIME_MODEL | Displays time model statistics at the tenant level on the current node. |
| V$OB_QUERY_RESPONSE_TIME_HISTOGRAM | A histogram that shows the query execution time of the current node for the current tenant. |
Thread-related
View Name |
Feature description |
|---|---|
| GV$OB_TENANT_WORKER_GROUPS | Displays the status of worker thread groups on all nodes of a tenant. |
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, view the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, view the execution information of each thread. |
| GV$OB_PX_TARGET_MONITOR | Displays the PX thread usage on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | Displays the PX thread usage on the OBServer node. |
Execution plans
View Name |
Feature description |
|---|---|
| V$SQL_MONITOR_STATNAME | DisplayGV$SQL_PLAN_MONITORof theOTHERSTAT_X_IDThe meaning of the numbers in the fields. |
| GV$SQL_PLAN_MONITOR | This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry that also records the trace information for that plan. |
| V$SQL_PLAN_MONITOR | This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry that also records the trace information for that plan. |
Minor compaction and major compaction
View Name |
Feature description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the OBServer-level major compaction progress information of a tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the recommended information for COMPACT. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of COMPACT. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level compaction. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level compaction. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays information about transaction participants on all OBServer nodes. |
| GV$SYSTEM_EVENT | Displays system-level wait events of tenants on all servers, including statistics such as the number of occurrences, total wait time, and timeout count for each type of wait event. |
| GV$GLOBAL_TRANSACTION | Displays information about currently active global transactions. |
| V$OB_COMPACTION_PROGRESS | Displays the server-level major compaction progress information of a tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the recommended information for COMPACT. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of COMPACT. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level compaction. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level compaction. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays information about transaction participants on all OBServer nodes. |
| V$SYSTEM_EVENT | Displays some system-level wait events of tenants on the current server, and provides statistics such as the number of occurrences, total wait time, and timeout count for each type of wait event. |
| V$GLOBAL_TRANSACTION | Displays information about the currently active global transactions. |
| GV$OB_GLOBAL_TRANSACTION | Displays information about all XA transactions in the cluster. |
| V$OB_GLOBAL_TRANSACTION | Displays information about all XA transactions that have the current node as the original scheduler. |
Resource management
View Name |
Feature description |
|---|---|
| GV$OB_GROUP_IO_STAT | Displays the real-time status of each resource group on all OBServer nodes of the current tenant. |
| GV$OB_FUNCTION_IO_STAT | Displays the IO statistics at the function level for the current tenant across all OBServer nodes. |
| V$OB_GROUP_IO_STAT | Displays the real-time status of each resource group for the current tenant on the current OBServer node. |
| V$OB_FUNCTION_IO_STAT | Displays the IO statistics at the function level for the current tenant on the current OBServer node. |