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 endpoints of 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 permission information for 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 for 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 the 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 can access. |
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 tasks initiated by tenants. |
| oceanbase.CDB_OB_BACKUP_VALIDATE_TASK_HISTORY | Displays the execution history of all backup verification task-level tasks initiated by tenants. |
| oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS | Displays information related to the job-level backup verification tasks initiated by this 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 this tenant. |
| oceanbase.CDB_OB_RESTORE_PROGRESS | Displays the current execution progress of a physical restore task. |
| oceanbase.CDB_OB_RESTORE_HISTORY | Indicates the status of a physical restore task when it 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 a 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 a 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 or 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 policies set for expired 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 policies set for expired 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 or 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 of table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | Displays records of 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 cross-tenant import tasks at the table level. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the historical records of cross-tenant import tasks at the table level. |
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 of 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 in all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | Displays the column information for tables and views in 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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| oceanbase.DBA_TABLES | This API is used to display information about all tables of the current tenant. |
| oceanbase.CDB_INDEX_USAGE | Displays the index usage statistics for all tenants. |
| oceanbase.DBA_INDEX_USAGE | Displays the index usage statistics of the current tenant. |
| oceanbase.DBA_TAB_COLS_V$ | Displays the column information for table and view objects of the current tenant. |
| oceanbase.DBA_OB_TABLE_SPACE_USAGE | Displays the space usage of each table for the current tenant. |
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 of partitioned tables for all tenants. |
| oceanbase.CDB_SUBPARTITION_TEMPLATES | Displays the subpartition information of template partitioned tables for all tenants. |
| oceanbase.CDB_TAB_PARTITIONS | Displays the partition information of all tenant partitioned tables. |
| 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 partition information of a user table. |
| 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
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT | Displays all partitions with special weights set 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 under this 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 task history of load balancing tasks 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 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 information about the current tenant's transfer tasks. |
| 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 along with the log stream information to which each tablet belongs. |
| oceanbase.CDB_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:<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 partition objects (partitioned tables and partitioned indexes) of all tenants. |
| oceanbase.DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the partition information of a table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information of a table group with partitions. |
| 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 in the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the replica distribution information of log stream (LS) 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 a log stream. |
| oceanbase.DBA_OB_LS | Displays the status and recovery progress of a 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 the data dictionary information in 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 for 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 of 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 that the current user can access. |
Service management
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_SERVICES | Displays the service information for all tenants. |
| oceanbase.DBA_OB_SERVICES | Displays the service information of the current tenant. |
| oceanbase.DBA_OB_SERVER_JOBS | Displays tasks related to all OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | Displays information for all OBServer nodes. |
Shared storage related
View name |
Feature description |
|---|---|
| CDB_OB_SS_SPACE_USAGE | Records the storage space usage of each tenant's object storage. |
| DBA_OB_SS_SPACE_USAGE | Records the storage space usage of the current tenant's object storage. |
| DBA_OB_ZONE_STORAGE | Displays the object storage information of shared storage clusters configured on each zone. |
InnoDB storage engine related
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 only for compatibility with MySQL 5.7. 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 (both waiting and holding locks).
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 | 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 the statistics of the InnoDB buffer pool.
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_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 | This view displays information related to operations on InnoDB tables and indexes.
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_PER_INDEX_RESET | This view displays and resets the 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 status of operations related to compressing 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_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 for compatibility with MySQL 5.7 only. 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 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_SYS_TABLES | Displays metadata 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_TABLESPACES | Displays the metadata of InnoDB table files and general tablespaces.
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_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 virtually generated columns in 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 | Displays InnoDB performance information.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
Temporary files
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_TEMP_FILES | Displays the temporary file information for all tenants. |
| oceanbase.DBA_OB_TEMP_FILES | Displays information about temporary files. |
I/O performance related
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 active TTL tasks. |
| 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 current tenant's running TTL tasks. |
| 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 parameter information for all client connections of 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 of 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 plans and throttling rule outlines of the current tenant. |
| DBA_OB_FORMAT_OUTLINES | Records the details of the current tenant's format outline. |
PLSQL data types
View name |
Feature description |
|---|---|
| oceanbase.DBA_PLSQL_COLL_TYPES | Displays information about PL/SQL collection types. |
| 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 type information that the current user can access. |
| oceanbase.ALL_PLSQL_TYPES | Displays the PL/SQL type information accessible to the current user. |
| oceanbase.ALL_PLSQL_TYPE_ATTRS | Displays the PL/SQL type attribute information accessible to the current user. |
Full-text index related
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 | This view 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 for compatibility with MySQL 5.7 only. 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
View name |
Feature description |
|---|---|
| oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS | Displays the scheduling job runtime details for all tenants. |
| oceanbase.DBA_SCHEDULER_WINDOWS | Displays the scheduling window information. |
| oceanbase.DBA_SCHEDULER_JOB_CLASSES | Displays information about the scheduled job. |
| oceanbase.ALL_SCHEDULER_WINDOWS | Displays the scheduling window information accessible to the current user. |
Event history monitoring related
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | This view displays the historical records of deadlock events. In the root tenant, it shows the historical records of all tenants. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the historical records of deadlock events. In non-root tenants, this view shows only the historical records of the current tenant. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | Displays the event history 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 event information of a cluster. |
Basic database information
View name |
Feature description |
|---|---|
| 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.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 the optimizer statistics for all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays 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 histogram information for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays histograms for columns in all tables 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 optimizer statistics for all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the cumulative modification information of tables in a 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 execution of a table. |
| oceanbase.CDB_OB_AUX_STATISTICS | Displays auxiliary statistics for all tenants. |
| oceanbase.DBA_OB_AUX_STATISTICS | Displays auxiliary statistics for 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 historical records 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 the 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 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_SYS_FOREIGN_COLS | This view displays information about the status of InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table in the InnoDB data dictionary.
NoteThis view is for compatibility with MySQL 5.7 only. The related functionality is not supported; it can only be used to query the table structure. |
Materialized views
View name |
Feature description |
|---|---|
| oceanbase.CDB_MVIEW_RUNNING_JOBS | It displays all materialized view-related tasks currently in progress for all tenants, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.CDB_MVIEWS | Displays the materialized view information for all tenants. |
| oceanbase.CDB_MVIEW_LOGS | This API is used to display the materialized view log information for 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 API is used to display information on each refresh run of materialized views for all tenants. |
| oceanbase.CDB_MVREF_STATS | This view displays basic timing statistics for materialized view refreshes across all tenants. |
| oceanbase.CDB_MVREF_STATS_PARAMS | This view displays the refresh statistics for each materialized view associated with all tenants. |
| oceanbase.CDB_MVREF_STATS_SYS_DEFAULTS | Displays the system-wide default values for all tenants' materialized view refresh history statistics attributes. |
| oceanbase.CDB_MVREF_STMT_STATS | This API is used to display information associated with all tenant materialized view refresh statements. |
| oceanbase.DBA_MVIEW_DEPS | Displays the dependencies of materialized views for the current tenant. |
| oceanbase.DBA_MVIEW_LOGS | Displays the log information of materialized views. |
| 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 | 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 a 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 refresh history statistics attribute of materialized views. |
| oceanbase.DBA_MVREF_STMT_STATS | Describes the information associated with the refresh statement. |
| oceanbase.ALL_MVIEWS | Displays 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 persisted 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 basic performance statistics for all SQL statements executed by tenants. Each SQL statement is represented as a row (that is, eachSQL_ID + Plan_HashEach unique value must be represented by 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 | Displays the write-through data of all tenant time model statistics. |
| 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 persistent 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 view.SQL_ID + Plan_Hash(The unique value of is one row.) |
| oceanbase.DBA_WR_SQLTEXT | Displays the SQL text collected for write operations of the current tenant. |
| oceanbase.DBA_WR_STATNAME | Displays the name of the system statistics item for the current 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 system statistics for the current tenant. |
| oceanbase.DBA_WR_SYSTEM_EVENT | Displays the persistent tenant-level wait event information for 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 of 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
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 current tenant. |
| oceanbase.CDB_OB_FREEZE_INFO | Displays the version information generated by major_freeze. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major_freeze. |
Certificate management
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE | Displays 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 | Displays the basic information of all tenants. This includes the system tenant, user-created tenants (user tenants), and the Meta tenant. You can filter tenants byTENANT_TYPEColumns are used to distinguish tenant types. |
| oceanbase.DBA_OB_TENANT_JOBS | Displays task information at the tenant level. |
| oceanbase.CDB_OB_SYS_VARIABLES | Displays the system variable information of all tenants under the sys tenant. |
| oceanbase.CDB_OB_TENANT_EVENT_HISTORY | Displays the event history of all tenants. |
| oceanbase.DBA_OB_ZONES | Displays information for all zones. |
Tenant cloning related
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_CLONE_HISTORY | Displays the tenant's cloning history. |
| oceanbase.DBA_OB_CLONE_PROGRESS | Displays the tenant cloning progress information. |
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 TTL tasks for the current tenant in SQL mode. |
| oceanbase.DBA_OB_TTL_TASK_HISTORY | Displays the execution history of 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
View name |
Feature description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This API is used to display the usage of HMS Catalog clients for all tenants. |
| V$OB_HMS_CLIENT_POOL_STAT | This API is used to display 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
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, 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 stored persistently in all units. |
| V$OB_LOG_STAT | Displays the status of Palf. |
Partition-related
View name |
Feature description |
|---|---|
| V$OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partitioned table information for all tenants. |
Shared storage related
View name |
Feature description |
|---|---|
| V$OB_SS_SSTABLES | Displays the SSTable information on the shared storage of all tenants. |
| GV$OB_SS_LOCAL_CACHE | This topic displays metrics related to various cached data types in the local cache of all tenants on each OBServer node under the shared storage mode. |
| V$OB_SS_LOCAL_CACHE | This API is used to query the metrics of various cache data in the local cache of all tenants on the current OBServer node under the shared storage mode. |
| GV$OB_STORAGE_CACHE_TASKS | Displays the cache task information of each tenant on all OBServer nodes. |
| V$OB_STORAGE_CACHE_TASKS | Displays the cache task information for each tenant on the current OBServer node. |
| GV$OB_TABLET_LOCAL_CACHE | Displays the overall cache usage of each tenant across all OBServer nodes. |
| V$OB_TABLET_LOCAL_CACHE | Displays the overall cache usage of each tenant on the current OBServer node. |
| GV$OB_SERVER_STORAGE | Displays the object storage information of the shared storage cluster configured on all OBServer nodes. |
| V$OB_SERVER_STORAGE | Displays the information about the object storage configured for the shared storage cluster on the current OBServer node. |
| GV$OB_SS_LOCAL_CACHE_DIAGNOSE | This API is used to diagnose the operational status of the local cache sub-module for all tenants on each OBServer node in shared storage mode. |
| V$OB_SS_LOCAL_CACHE_DIAGNOSE | This API is used to diagnose the running status of the local cache sub-module for all tenants on the current OBServer node in shared storage mode. |
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
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 MemStore statistics at the tenant level. |
| 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 query 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 COMPACTION. |
| 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 view 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 API is used to display 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 | Session-level statistical event information 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 COMPACTION. |
| 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 | The details of each event currently being waited for by the session. By convention, each event has three parameters, each recording its corresponding value. |
| V$SESSION_WAIT_HISTORY | Details of events currently being waited for 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 a 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 on the current server for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache across all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache 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 statistical information such as the source and execution status of each SQL request across 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 plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry, which also records the trace information of that plan. |
| V$SQL_PLAN_MONITOR | Statistics at the operation level for slow queries, with one entry 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. |
Session-related
View name |
Feature description |
|---|---|
| GV$OB_SESSION | Records 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 the schema information on all servers. |
| GV$OB_SERVERS | Displays information for 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 this OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| V$OB_SERVERS | Displays information about the current OBServer node. |
| V$OB_UNITS | Displays the unit information of this 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 all features whose behavior can be controlled for compatibility with 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 API is used to display the statistics of RPC requests received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | This API is used to count 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 of all operators previously executed by the automatic SQL memory manager. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays statistics from all previous workareas, 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 the SQL Workarea, such as the maximum available memory, current memory usage, and current held memory. |
| V$SQL_WORKAREA | Workarea statistics of all operators previously executed by the automatic SQL memory manager. |
| V$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| V$SQL_WORKAREA_HISTOGRAM | Displays statistics for all workareas executed previously, 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 statistics of resource groups on all OBServer nodes in 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_Hash(The unique value of is one row.) |
| GV$OB_SYS_TIME_MODEL | This API is used to query time series metrics of tenants in a cluster. |
| V$OB_QUERY_RESPONSE_TIME_HISTOGRAM | A histogram that shows the query execution time of current nodes for all tenants. |
| 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 session-level time model statistics 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_HashThe 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_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 for a tenant. |
| V$OB_TENANT_RUNTIME_INFO | Displays information related to thread queues and thread quotas for a tenant. |
Minor compaction and major compaction
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 IO 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 IO 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 recovery
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS | Displays information related to the job-level backup verification tasks initiated by this 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 this 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 a 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 policies set for expired 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 or 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 about 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 of 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 cross-tenant import tasks at the table level. |
Tables and columns
View name |
Feature description |
|---|---|
| information_schema.COLUMNS | Record column information. |
| information_schema.STATISTICS | Records table index information. |
| information_schema.TABLES | Records table information. |
| information_schema.VIEWS | Record 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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| oceanbase.DBA_TABLES | This API is used to display information about all tables of the current tenant. |
Storage
View name |
Feature description |
|---|---|
| mysql.proc | Displays information about stored procedures. |
| 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
View name |
Feature description |
|---|---|
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | Displays the number of failed login attempts by different users. |
Partitioning
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 partition information of a user table. |
| 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, its storage attributes, andDBMS_STATSThe statistics generated by the package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays the descriptions of all subpartition templates. |
Load balancing
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 under this tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of transfer partition tasks executed for this tenant. |
Replica logs
View name |
Feature description |
|---|---|
| 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 of a table group with partitions. |
| 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 in the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the replica distribution information of log stream (LS) 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 of a table group with partitions. |
| 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 in the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the replica distribution information of log stream (LS) for the current tenant. |
Shared storage
View name |
Feature description |
|---|---|
| DBA_OB_SS_SPACE_USAGE | Records the storage space usage of the current tenant's object storage. |
Help commands
View name |
Feature description |
|---|---|
| mysql.help_topic | With the other three tablesmysql.help_category、mysql.help_relation、mysql.help_keywordCo-generated Help commands. |
| mysql.help_category | With the other three tablesmysql.help_relation、mysql.help_topic、mysql.help_keywordCo-generated Help commands. |
| mysql.help_keyword | With the other three tablesmysql.help_relation、mysql.help_topic、mysql.help_categoryGenerate help commands in collaboration. |
| mysql.help_relation | With the other three tablesmysql.help_category、mysql.help_topic、mysql.help_keywordGenerate the help command together. |
InnoDB storage engine
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 (both waiting and holding locks).
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 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 | 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 the statistics of the InnoDB buffer pool.
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_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 | This view displays information related to operations on InnoDB tables and indexes.
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_PER_INDEX_RESET | This view displays and resets the 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 status of operations related to compressing 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_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 for compatibility with MySQL 5.7 only. 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 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_SYS_TABLES | Displays metadata 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_TABLESPACES | Displays the metadata of InnoDB table files and general tablespaces.
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_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 virtually generated columns in 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 | Displays InnoDB performance information.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
I/O performance
View name |
Feature description |
|---|---|
| DBA_OB_STORAGE_IO_USAGE | Displays the I/O operation statistics of the current tenant's object storage and cloud disk. |
OBKV
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the current tenant's running TTL tasks. |
| 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 parameter information 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 plans and throttling rule outlines of the current tenant. |
| DBA_OB_FORMAT_OUTLINES | Records the details of the current tenant's format outline. |
Task Scheduling Manager
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 privileges (VIRTUAL_TABLE). |
| mysql.user | Used to record user-level privilege information (VIRTUAL_TABLE). |
| information_schema.COLUMN_PRIVILEGES | Displays column privilege information. |
| information_schema.SCHEMA_PRIVILEGES | Describes database permission information. |
| information_schema.TABLE_PRIVILEGES | Records table permission information. |
| information_schema.USER_PRIVILEGES | Records user permission information. |
Full-text index related
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 | This view 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 for compatibility with MySQL 5.7 only. 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 session status information, such as the current number of active connections and database uptime. |
| information_schema.SESSION_VARIABLES | Variable information of the session. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the historical records of deadlock events. In non-root tenants, this view shows only the historical records of the current tenant. |
Time zone
View name |
Feature description |
|---|---|
| mysql.time_zone | Used to display 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 timezone 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 |
|---|---|
| information_schema.GLOBAL_STATUS | Records the global state information of OceanBase Database. |
| information_schema.GLOBAL_VARIABLES | Records global variable information. |
| 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 current tenant. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major_freeze. |
| information_schema.events | Records all event information. |
Statistics and histograms
View name |
Feature description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays the optimizer statistics for all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays 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 histogram information for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays histograms for columns in all tables 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 optimizer statistics for all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the cumulative modification information of tables in a database. |
| information_schema.QUERY_RESPONSE_TIME | 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 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_SYS_FOREIGN_COLS | This view displays information about the status of InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table in the InnoDB data dictionary.
NoteThis view is for compatibility with MySQL 5.7 only. The related functionality is 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 persistent ASH data for this tenant. |
| oceanbase.DBA_WR_STATNAME | Displays the name of the system statistics item for the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | Displays detailed system statistics for the current tenant. |
| oceanbase.DBA_WR_CONTROL | Displays the configuration information related to write requests. |
| oceanbase.DBA_WR_SYSTEM_EVENT | Displays the persistent tenant-level wait event information for 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 operations of the current tenant. |
| oceanbase.DBA_WR_SQLSTAT | This view displays basic performance statistics for SQL statements executed in the current tenant. Each SQL statement is represented as a row (that is, eachSQL_ID + Plan_HashEach unique value must be represented by one row). |
| oceanbase.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 |
|---|---|
| oceanbase.DBA_MVIEW_DEPS | Displays the dependencies of materialized views for the current tenant. |
| oceanbase.DBA_MVIEW_LOGS | Displays the log information of materialized views. |
| 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 | 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 a 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 refresh history statistics 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 TTL tasks for the current tenant in SQL mode. |
| oceanbase.DBA_OB_TTL_TASK_HISTORY | Displays the execution history of 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 table constraints. |
Resources
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | Displays all sequences in the database. |
Resource Manager
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 | Displays 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 group 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 | Displays the basic information of all tenants, including the system tenant, user-created tenants (user tenants), and the Meta tenant. You can filter tenants byTENANT_TYPEColumns are used to distinguish tenant types. |
Character set
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 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
View name |
Feature description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This API is used to query the usage of the HMS catalog client by the current tenant. |
| V$OB_HMS_CLIENT_POOL_STAT | This API is used to query the usage of the HMS catalog client by 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 COMPACTION. |
| 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 view 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 API is used to display 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 | Session-level statistical event information 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 COMPACTION. |
| 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 | The details of each event currently being waited for by the session. By convention, each event has three parameters, each recording its corresponding value. |
| V$SESSION_WAIT_HISTORY | Details of events currently being waited for 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. |
DTL
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. |
Shared storage related
View name |
Feature description |
|---|---|
| V$OB_SS_SSTABLES | Displays the SSTable information on the shared storage of this tenant. |
| GV$OB_SS_LOCAL_CACHE | This topic displays metrics related to various cached data types in the local cache of all tenants on each OBServer node under the shared storage mode. |
| V$OB_SS_LOCAL_CACHE | This API is used to query the metrics of various cache data in the local cache of all tenants on the current OBServer node under the shared storage mode. |
| GV$OB_STORAGE_CACHE_TASKS | Displays the cache task information of the current tenant on all OBServer nodes. |
| V$OB_STORAGE_CACHE_TASKS | Displays the cache task information of the current tenant on the current OBServer node. |
| GV$OB_TABLET_LOCAL_CACHE | Displays the overall cache status of the current tenant across all OBServer nodes. |
| V$OB_TABLET_LOCAL_CACHE | Displays the overall cache status of the current tenant on the current OBServer node. |
| GV$OB_SS_LOCAL_CACHE_DIAGNOSE | This API is used to diagnose the running status of the local cache sub-module of the current tenant on each OBServer node in shared storage mode. |
| V$OB_SS_LOCAL_CACHE_DIAGNOSE | This API is used to diagnose the running status of the local cache sub-module for the current tenant on the current OBServer node in shared storage mode. |
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 on the current server for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache across all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache 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 statistical information such as the source and execution status of each SQL request across 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 plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry, which also records the trace information of that plan. |
| V$SQL_PLAN_MONITOR | Statistics at the operation level for slow queries, with one entry 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
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 MemStore statistics at the tenant level. |
| 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 query 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 a 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 the 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 this OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| V$OB_UNITS | Displays the unit information of this 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 all features whose behavior can be controlled for compatibility with the OceanBase Database release version. |
Workarea-related
View name |
Feature description |
|---|---|
| GV$SQL_WORKAREA | Workarea statistics of all operators previously executed by the automatic SQL memory manager. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays statistics from all previous workareas, 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 the SQL Workarea, such as the maximum available memory, current memory usage, and current held memory. |
| V$SQL_WORKAREA | Workarea statistics of all operators previously executed by the automatic SQL memory manager. |
| V$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| V$SQL_WORKAREA_HISTOGRAM | Displays statistics for all workareas executed previously, 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 statistics of resource groups on all OBServer nodes in 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_Hash(The 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 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 session-level time model statistics on the current node. |
| GV$OB_SYS_TIME_MODEL | This API is used to query time series metrics of tenants 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 on the current OBServer node in 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 API is used to display the statistics of RPC requests received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | This API is used to count 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_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 I/O 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 I/O statistics at the function level for the current tenant on the current OBServer node. |
Minor compaction and major compaction
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 Oracle-compatible Tenants
Overview of Dictionary Views
Applicability
This topic applies only to OceanBase Database Enterprise Edition.
Security Privileges
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 information about 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 granted to the role or the grantee with the PUBLIC role. |
| ALL_TAB_PRIVS | * The current user is the object owner, the object permission grantor, or the object permission grantee. * The object permission grantee 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 permissions currently held by the user. |
| USER_COL_PRIVS | Displays the columns to which the current user has granted access as an object owner, grantor, or grantee. |
| 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. Only information about the roles that users can access is provided. |
| ROLE_SYS_PRIVS | Displays the system privileges granted to the 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 present 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 the column information related to security policies for the current user. |
Backup and Recovery
View name |
Feature description |
|---|---|
| DBA_OB_BACKUP_VALIDATE_JOBS | Displays information related to the job-level backup verification tasks initiated by this 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 this 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 a 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 policies set for expired 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 or 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 about table-level restore tasks. |
| DBA_OB_IMPORT_TABLE_JOBS | Displays information related to the import task. |
| DBA_OB_IMPORT_TABLE_TASKS | Displays records of 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 cross-tenant import tasks at the table level. |
Tables and Views
View name |
Feature description |
|---|---|
| ALL_ALL_TABLES | Displays the object tables and relational tables that the user can access. |
| ALL_COL_COMMENTS | Displays all column comments for the views and tables that the user has access to. |
| ALL_TABLES | Displays all tables that the user has access to. |
| 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 accessible to the current user. 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 are the same as those in theDBA_TABLESPACESThe columns in the middle are the same, and the following columns have been 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 the current user's table and view objects. |
| 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 current accessible storage object. |
| DBA_SEGMENTS | Displays the storage information allocated for 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 information of triggers. |
| ALL_TRIGGER_ORDERING | Displays the execution sequence information of triggers that the current user can access. |
| USER_TRIGGER_ORDERING | Displays the trigger execution sequence information of the current user. |
Object Types
View name |
Feature description |
|---|---|
| ALL_METHOD_PARAMS | Displays the method parameters for the object types that the user 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 for object types 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 the OWNER field. |
DBLINK
View name |
Feature description |
|---|---|
| ALL_DB_LINKS | Displays all DBLINKs accessible to the current user. |
| 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 contained in the partitioning key for all partition objects accessible to the user. |
| ALL_PART_TABLES | Displays the partition information of 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 that are 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 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 descriptions 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 table subpartition owned by 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 under this 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 replica distribution information of log stream (LS) 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 of a table group with partitions. |
| 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 in the current tenant and the log stream information to which each tablet belongs. |
| DBA_OB_LS | Displays the status and recovery progress of a log stream. |
Shared storage related
View name |
Feature description |
|---|---|
| DBA_OB_SS_SPACE_USAGE | Records the storage space usage of the current tenant's object storage. |
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 are the same as 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 disk. |
NLS
View name |
Feature description |
|---|---|
| NLS_DATABASE_PARAMETERS | Displays NLS parameters at the database level (OceanBase Database tenant level). |
| NLS_INSTANCE_PARAMETERS | Displays the 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 plans and throttling rule outlines of the current tenant. |
| DBA_OB_FORMAT_OUTLINES | Records the details of the current tenant's format outline. |
Task Scheduling Manager
View name |
Feature description |
|---|---|
| DBA_SCHEDULER_JOBS | Displays the information about the scheduler jobs that the current user can access. |
| DBA_SCHEDULER_PROGRAM | Displays information about all schedulers in the database. |
| DBA_SCHEDULER_JOB_RUN_DETAILS | Displays information about all scheduler jobs under 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 caching status 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 functions and procedures available 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 correspond to those in theALL_ARGUMENTSThe columns in the middle are the same, and the following columns have been 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 are removed:OWNERfield. |
| USER_SOURCE | Displays the text source of the storage object currently owned by the user. Its columns correspond toALL_SOURCEThe columns in the middle are the same, and the following columns have been removed:OWNERfield. |
PROFILE-related
View name |
Feature description |
|---|---|
| ALL_PROFILES | Displays all profiles and their limitations. |
| DBA_PROFILES | Displays all profiles and their limitations. |
| USER_PROFILES | Displays all profiles and their limitations. |
Event history monitoring
View name |
Feature description |
|---|---|
| DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the historical records of deadlock events. In non-root tenants, this view shows only the historical records of the current tenant. |
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_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 current 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 among 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 by major_freeze. |
| TENANT_VIRTUAL_GLOBAL_VARIABLE | Displays global variable information. |
| TENANT_VIRTUAL_SESSION_VARIABLE | Displays the variable information of the session. |
Audit-related
View name |
Feature description |
|---|---|
| ALL_DEF_AUDIT_OPTS | Displays the audit conditions that are applied by default to 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 tracking 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 accessible to the current user. |
| USER_AUDIT_SESSION | Displays the audit tracking 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 indexes of tables that the user has access to. |
| ALL_IND_COLUMNS | Displays the index column information for all indexes of tables that the user has access to. |
| ALL_IND_EXPRESSIONS | Displays information about the function-based indexes that users can access 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 has access to. |
| 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. |
| 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.DBA_IND_SUBPARTITIONS、ALL_IND_SUBPARTITIONSBetter than 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 histograms of partitions in the partitioned table 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 accessible to the current user. |
| ALL_SUBPART_HISTOGRAMS | Displays the histogram information for all subpartitions. |
| ALL_TAB_COL_STATISTICS | Displays the column statistics and histograms of tables accessible to the current user. |
| ALL_TAB_HISTOGRAMS | Displays information about histograms for all tables. |
| 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 of partitions in a partitioned table. |
| DBA_PART_HISTOGRAMS | Displays the histogram information of the primary 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 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 the optimizer statistics for all tables in the database. |
| USER_PART_COL_STATISTICS | Displays the column statistics and histograms 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 histogram information of 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 histograms 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 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 the optimizer statistics for indexes on tables that the current user has access to. |
| DBA_IND_STATISTICS | Displays optimizer statistics for all indexes in the database. |
| USER_IND_STATISTICS | Displays 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 a 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 execution of a table. |
Synonym related
View name |
Feature description |
|---|---|
| ALL_SYNONYMS | Displays all synonyms accessible to the user. |
| 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 information about the current user's scheduled jobs. |
| ALL_SCHEDULER_JOB_ARGS | Displays the parameters of the scheduled job that users can view. |
| ALL_SCHEDULER_PROGRAM_ARGS | Displays the scheduler parameters that users can view. |
| 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 persistent ASH data for this tenant. |
| DBA_WR_STATNAME | Displays the name of the system statistics item for the current tenant. |
| DBA_WR_SYSSTAT | Displays detailed system statistics for the current tenant. |
| DBA_WR_CONTROL | Displays the configuration information related to write requests. |
| DBA_WR_SYSTEM_EVENT | Displays the persistent tenant-level wait event information for 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 operations 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 views
View name |
Feature description |
|---|---|
| DBA_MVIEW_DEPS | Displays the dependencies of materialized views for the current tenant. |
| DBA_MVIEW_LOGS | Displays the log information of materialized views. |
| 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 | 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 a 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 refresh history statistics 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 operation of the current user's materialized views. |
| USER_MVREF_STATS | Displays the basic timing statistics for refreshing materialized views for 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 related to the current user's materialized view refresh statements. |
TTL-related
View name |
Feature description |
|---|---|
| DBA_OB_TTL_TASKS | Displays the execution status of TTL tasks for the current tenant in SQL mode. |
| DBA_OB_TTL_TASK_HISTORY | Displays the execution history of 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 accessible to the current user. |
| 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 custom 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 constraints of a user's tables. |
Sequence-related
View name |
Feature description |
|---|---|
| ALL_SEQUENCES | Displays all sequences that the user has access to. |
| 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 | Displays 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 group 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 tenant. |
Catalog
View name |
Feature description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This API is used to query the usage of the HMS catalog client by the current tenant. |
| V$OB_HMS_CLIENT_POOL_STAT | This API is used to query the usage of the HMS catalog client by 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 links must be committed or rolled back before being closed. |
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_LOG_STAT | Displays the status of Palf. |
| V$OB_LOG_STAT | Displays the status of Palf. |
Partition-related
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 on the current server for the current tenant. |
| 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 of the current active tenant. |
Shared storage related
View name |
Feature description |
|---|---|
| V$OB_SS_SSTABLES | Displays the SSTable information on the shared storage of this tenant. |
| GV$OB_SS_LOCAL_CACHE | This topic displays metrics related to various cached data types in the local cache of all tenants on each OBServer node under the shared storage mode. |
| V$OB_SS_LOCAL_CACHE | This API is used to query the metrics of various cache data in the local cache of all tenants on the current OBServer node under the shared storage mode. |
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
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 displays general information about 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 duration. |
| 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 across 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 duration. |
| 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 on 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. |
Metadata 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 the schema information on all servers. |
| V$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| GV$OB_UNITS | Displays the unit information 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 properties 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 this OBServer node. |
| V$SYSSTAT | Displays system-level statistical event information on the current server. |
| V$OB_UNITS | Displays the unit information of this 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 of all operators previously executed by the automatic SQL memory manager. |
| GV$SQL_WORKAREA_ACTIVE | The workspace information 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 maximum available memory, current memory usage, and current held 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 | The workspace information 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 statistics 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 on the current OBServer node in 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_Hash(The 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 as a row (that is, eachSQL_ID + Plan_Hash(The unique value of 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 session-level time model statistics on the current node. |
| GV$OB_SYS_TIME_MODEL | This API is used to query time series metrics of tenants 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 distribution of the current node in the current tenant. |
Thread-related
View name |
Feature description |
|---|---|
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, view the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, view the execution information of each thread. |
| 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 plan related
View name |
Feature description |
|---|---|
| V$SQL_MONITOR_STATNAME | DisplayGV$SQL_PLAN_MONITORof theOTHERSTAT_X_IDThe meaning of the numbers in the field. |
| GV$SQL_PLAN_MONITOR | This view displays plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry, which also records the trace information of that plan. |
| V$SQL_PLAN_MONITOR | This view displays plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding entry, which also records the trace information of that plan. |
Minor compaction and major compaction related
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 COMPACTION. |
| 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, and provides 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 COMPACTION. |
| 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 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 whose original scheduler is the current node. |
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 I/O 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. |