Overview of views in the sys tenant
Overview of dictionary views
AI models
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_AI_BATCH_TASK_HISTORY | Displays the history of completed or failed AI batch tasks for all tenants. |
| oceanbase.CDB_OB_AI_BATCH_TASKS | Displays all current AI batch tasks for all tenants. |
| oceanbase.CDB_OB_AI_GATEWAY_ENDPOINTS | Displays the endpoint details of all tenants. |
| oceanbase.CDB_OB_AI_GATEWAYS | Displays the AI gateway configuration information for all tenants. |
| oceanbase.CDB_OB_AI_MODEL_ENDPOINTS | Displays the AI model endpoints of all tenants. |
| oceanbase.CDB_OB_AI_MODEL_PROFILES | Displays the AI model parameter configuration information for all tenants. |
| oceanbase.CDB_OB_AI_MODEL_PROVIDERS | Displays the AI vendor configuration information for all tenants. |
| oceanbase.CDB_OB_AI_MODELS | Displays the AI model information for all tenants. |
| oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY | Displays the history of completed or failed AI batch tasks for the current tenant. |
| oceanbase.DBA_OB_AI_BATCH_TASKS | Displays the ongoing AI batch tasks for the current tenant. |
| oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS | Displays the endpoint details of the current tenant's AI gateway. |
| oceanbase.DBA_OB_AI_GATEWAYS | Displays the AI gateway configuration information of the current tenant. |
| oceanbase.DBA_OB_AI_MODEL_ENDPOINTS | Displays the AI model endpoint information of the current tenant. |
| oceanbase.DBA_OB_AI_MODEL_PROFILES | Displays the AI model parameter configuration information of the current tenant. |
| oceanbase.DBA_OB_AI_MODEL_PROVIDERS | Displays the AI vendor configuration information of the current tenant. |
| oceanbase.DBA_OB_AI_MODELS | Displays the AI model information of the current tenant. |
Logical tables
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASKS | Displays all background delete tasks for logical tables being executed by tenants. |
| oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS | Displays the background deletion tasks of logical tables currently being executed by the current tenant. |
| oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASK_HISTORY | Displays the history of all completed background logical table deletion tasks for tenants. |
| oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY | Displays the history of completed background deletion tasks for logical tables in the current tenant. |
Security permissions
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_USERS | Display the user information of all tenants. |
| oceanbase.CDB_OB_DATABASE_PRIVILEGE | Displays the database-level privileges of all tenants. |
| oceanbase.DBA_OB_AUTO_INCREMENT | Displays the auto-increment column information for the current tenant. |
| oceanbase.DBA_OB_USERS | Displays the user information of the current tenant. |
| oceanbase.DBA_OB_DATABASE_PRIVILEGE | Displays the database-level privilege information of the current tenant. |
| oceanbase.DBA_OB_USER_DEFINED_RULES | Displays user-defined rule information. |
Backup and recovery
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_RESTORE_PROGRESS | Displays the current execution progress of a physical restore task. |
| oceanbase.CDB_OB_RESTORE_HISTORY | Indicates the status when a physical restore task is completed. |
| oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES | Displays the status of pieces in a backup set. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | Displays the file status of the backup set. |
| oceanbase.CDB_OB_BACKUP_JOBS | Displays the backup job tasks for all tenants in the cluster. Each time a user initiates a backup task, a corresponding job record is created. |
| oceanbase.CDB_OB_BACKUP_JOB_HISTORY | Displays the historical records of backup job tasks for all tenants in the cluster. |
| oceanbase.CDB_OB_BACKUP_TASKS | Displays the task-level backup tasks for all tenants in the cluster. Each task record corresponds to 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 the tenant's own task-level backup tasks. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | Displays the file status of the backup set. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | Displays the ongoing restore tasks. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays completed restore tasks. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the archive path configuration. |
| oceanbase.CDB_OB_ARCHIVE_DEST | Displays the archive path configuration. |
| oceanbase.CDB_OB_BACKUP_PARAMETER | Displays backup parameters. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOBS | Displays the execution progress of tenant-level backup cleanup jobs. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY | Displays the historical information of backup cleanup tasks executed under a tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | Displays information about the backup_set 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 strategies set for expired cleanup and automatic cleanup under a tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | Displays the backup destination information 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 the backup destination information used for backup and restore operations in a tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information of backup destinations used for backup and restore operations under a tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies set for expired cleanup and automatic cleanup under a 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 cross-tenant import tasks at the table level. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | Displays records for table-level import tasks. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of a table-level restore task. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of a table-level restore task. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY | Displays the result of the import task. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the result of the import task. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY | Displays the historical records of table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the historical records of table-level cross-tenant import tasks. |
Tables and columns
View name |
Feature description |
|---|---|
| oceanbase.CDB_IND_COLUMNS | Displays the column information of index tables for all tenants. |
| oceanbase.CDB_INDEXES | Displays the index information for all tenants. |
| oceanbase.CDB_TABLES | Displays the TABLE information for all tenants. |
| oceanbase.CDB_OB_TABLEGROUP_TABLES | The system tenant displays the TABLEGROUP and TABLE relationships for all tenants. TABLES that are not part of a TABLEGROUP are not displayed. |
| oceanbase.CDB_TAB_COLS | Displays the column information for tables and views of all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | Displays the column information for tables and views of all tenants. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the association between TABLEGROUPs and TABLEs. TABLEs that are not part of a TABLEGROUP are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the columns contained in the partitioning key for all partition objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | View the columns contained in the subpartitioning key for all partition objects in the database. |
| oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO | Displays column validation and inconsistency information between index tables (including global indexes and local indexes) and the primary table. |
| oceanbase.CDB_OB_TABLE_LOCATIONS | Displays the location of tables or partitions, including: system tables, user tables, index tables, etc. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the location of tables or partitions, including: system tables, user tables, index tables, etc. |
| information_schema.TABLESPACES | Information related to tablespaces.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| oceanbase.DBA_TABLES | Displays information about all tables in the current tenant. |
| oceanbase.CDB_INDEX_USAGE | Displays the index usage statistics for all tenants. |
| oceanbase.DBA_INDEX_USAGE | Displays the index usage statistics for the current tenant. |
| oceanbase.DBA_TAB_COLS_V$ | Displays the column information of table and view objects for the current tenant. |
| oceanbase.CDB_OB_TABLE_SPACE_USAGE | Displays the space usage of each table for the current tenant. |
Catalog
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS | This API is used to query partition-level statistics of external catalog external tables. |
| oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS | This API is used to query column-level statistics of external tables in a catalog. |
| oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS | This API is used to query table-level statistics of external tables in a catalog. |
CCL
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_CCL_RULES | Displays the concurrency control and throttling rules for all tenants. |
| oceanbase.DBA_OB_CCL_RULES | Displays the concurrency control and throttling rules for the current tenant. |
Storage space
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_SPACE_USAGE | Displays the space usage of all tenants. |
| oceanbase.CDB_OB_SERVER_SPACE_USAGE | Displays the space usage of all OBServer nodes. |
| oceanbase.CDB_OB_TABLE_SPACE_USAGE | Displays the space usage of each table for all tenants. |
Access control
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_ACCESS_POINT | Displays the access endpoint information for all tenants. |
| oceanbase.DBA_OB_ACCESS_POINT | Displays the access endpoint information of the current tenant. |
Partitions
View name |
Feature description |
|---|---|
| oceanbase.CDB_IND_PARTITIONS | Displays the partition information of all tenant index tables. |
| oceanbase.CDB_IND_SUBPARTITIONS | View information about 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 the partitioned tables for all tenants. |
| oceanbase.CDB_TAB_PARTITIONS | Displays the partition information of all tenant's 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 the index. |
| oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partitioned table information for 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, their storage attributes, and DBMS_STATS The package generates statistics. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays the description of all subpartition templates. |
Load balancing
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT | Displays all partitions with special weights under all user tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS | Displays the partition transfer tasks currently in progress for all tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of all partition transfer tasks executed by tenants. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the current partition transfer tasks being processed 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 CLB task history for all tenants. |
| oceanbase.CDB_OB_TRANSFER_TASKS | Displays the transfer task information for all tenants. |
| oceanbase.CDB_OB_TRANSFER_TASK_HISTORY | Displays the transfer task history for all tenants. |
| oceanbase.DBA_OB_BALANCE_JOBS | Displays the load balancing job tasks of the current tenant. |
| oceanbase.DBA_OB_BALANCE_JOB_HISTORY | Displays the historical records of 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 historical records of load balancing tasks for the current tenant. |
| oceanbase.DBA_OB_TRANSFER_TASKS | Displays the transfer task information of the current tenant. |
| oceanbase.DBA_OB_TRANSFER_TASK_HISTORY | Displays the transfer task history of the current tenant. |
Replica logs
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_CS_REPLICA_STATS | Displays the progress of converting tablets to columnar storage in the log streams of C replicas on each OBServer node for all tenants. |
| oceanbase.CDB_OB_LS_LOCATIONS | Displays the replica distribution information of log stream (LS) for all tenants. |
| oceanbase.CDB_OB_TABLEGROUPS | The system tenant displays the meta information of table groups for all tenants, primarily showing the partition information of the table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | The system tenant displays the partition information of all tenant's partitioned table groups. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | The system tenant displays the subpartition information for all tenant's partitioned table groups. |
| oceanbase.CDB_OB_TABLET_TO_LS | The system tenant displays the tablet list for all tenants and the log stream information to which each tablet belongs. |
| oceanbase.CDB_OB_TABLET_REPLICAS | This view displays information 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 tenants' partition objects (partitioned tables and partitioned indexes). |
| oceanbase.CDB_SUBPART_KEY_COLUMNS | Displays the subpartitioning key information for all tenant's partition objects (partitioned tables and partitioned indexes). |
| oceanbase.DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the partition information of a table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information for a table group that is partitioned. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the meta information of a table group, mainly its partition information. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays information about all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays a list of all tablets for the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the 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 the log stream. |
| oceanbase.DBA_OB_LS | Displays the status and recovery progress of the log stream. |
| oceanbase.CDB_OB_LS_HISTORY | Displays the log stream history information for all tenants. |
| oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS | Displays the log stream archiving progress for all tenants. |
| oceanbase.CDB_OB_LS_REPLICA_TASKS | Displays the log stream replication tasks for all tenants. |
| oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY | Displays the task history of log stream replication for all tenants. |
| oceanbase.CDB_OB_LOG_RESTORE_SOURCE | Displays the log restore source information for all tenants. |
| oceanbase.CDB_OB_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_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 of 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 about all OBServer nodes. |
Shared storage related
View name |
Feature description |
|---|---|
| CDB_OB_STORAGE_SPACE_USAGE | Records the storage space usage of each tenant's object storage. |
| DBA_OB_STORAGE_SPACE_USAGE | Records the storage space usage of the current tenant's object storage. |
| CDB_OB_SHARED_MACRO_BLOCK_GC_STAT | Displays the number of shared data GC-deleted macroblocks per tenant per day, categorized by storage type. |
| DBA_OB_SHARED_MACRO_BLOCK_GC_STAT | Displays the number of shared data GC-deleted macroblocks per day for each storage type in the current tenant. |
| DBA_OB_ZONE_STORAGE | Displays the object storage information of shared storage clusters configured in 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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_TRX | This view displays information about active transactions.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_LOCK_WAITS | This view displays information about the lock transactions and lock objects that are waiting when a lock conflict occurs.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_LOCKS | This view displays information about all locks currently held or waiting to be acquired.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE | This view displays information about all cached pages in the buffer pool.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE_LRU | Displays the LRU sorted information of pages in the InnoDB buffer pool.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_POOL_STATS | This view displays statistics of the InnoDB buffer pool.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP | Displays and compresses the status information related to InnoDB tables.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX | Displays information related to operations on InnoDB tables and indexes.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | This view displays 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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_TABLES | Displays the metadata information of an InnoDB table.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_TABLESPACES | Displays the metadata of InnoDB table files and general tablespaces.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; 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 only for compatibility with MySQL 5.7. 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 tables.
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_TEMP_TABLE_INFO | Displays information about InnoDB temporary tables created by active users.
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_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 temporary file information. |
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 running 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 TTL tasks currently being executed by the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks of the current tenant. |
| V$OB_KV_CLIENT_INFO | Displays the configuration parameter information for 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 plan and throttling rule outline historical information for this tenant. |
| DBA_OB_FORMAT_OUTLINES | Records the details of the current tenant's format outline. |
Full-text indexes
View name |
Feature description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | Displays information about full-text indexes being dropped.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_CONFIG | Displays the configuration information of the InnoDB full-text search engine.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_DELETED | Displays information about full-text indexes that have been marked for deletion.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_INDEX_CACHE | This view displays the cache status information of InnoDB full-text indexes.
NoteThis view is 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) in an InnoDB index, which is equivalent to the information in the SYS_FIELDS table in the InnoDB data dictionary.
NoteThis view is provided 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 running details of scheduled jobs for all tenants. |
| oceanbase.DBA_SCHEDULER_WINDOWS | Displays the scheduling window information. |
| oceanbase.DBA_SCHEDULER_JOB_CLASSES | Displays information about the scheduled job. |
Event history monitoring related
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. This view shows the history of all tenants under the root tenant. |
| 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 the column statistics and histograms for all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays the column statistics and histogram information for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histogram information for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays histograms for all columns in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays the histogram data (the endpoints of each histogram) for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays the histogram data (the endpoints of each histogram) on all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the historical table statistics for all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays the optimizer statistics for all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the cumulative modification information of tables in the database. |
| oceanbase.CDB_TAB_COL_STATISTICS | Column-level statistics are displayed under the sys tenant. |
| oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | Query the historical collection execution of a table. |
| CDB_OB_AUX_STATISTICS | Displays auxiliary statistics for all tenants. |
| DBA_OB_AUX_STATISTICS | Displays the auxiliary statistics of the current tenant. |
| oceanbase.DBA_OB_TABLE_STAT_STALE_INFO | Displays the expiration status of statistics. |
| oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY | Displays the history of table statistics collection tasks. |
External resources
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_EXTERNAL_RESOURCES | Displays all uploaded resource files. |
| oceanbase.CDB_OB_EXTERNAL_TABLE_FILES | Displays the file list of external tables created by all tenants. |
| oceanbase.DBA_OB_EXTERNAL_RESOURCES | Displays the uploaded resource files. |
| oceanbase.DBA_OB_EXTERNAL_TABLE_FILES | Displays the file list corresponding to all external tables created under the current tenant. |
| oceanbase.ALL_OB_EXTERNAL_TABLE_FILES | Displays a list of files for external tables to which the current user has access. |
Foreign key related
View name |
Feature description |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | Displays metadata information about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table in the InnoDB data dictionary.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_FOREIGN_COLS | This view displays 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 only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure. |
Materialized view related
View name |
Feature description |
|---|---|
| oceanbase.CDB_MVIEW_RUNNING_JOBS | This API is used to display all current materialized view-related tasks of all tenants, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.CDB_MVIEWS | This API is used to display the materialized view information of all tenants. |
| oceanbase.CDB_MVIEW_LOGS | This API is used to display the materialized view log information of all tenants. |
| CDB_MVREF_CHANGE_STATS | This view displays statistics related to materialized view refreshes for all tenants. |
| oceanbase.CDB_MVREF_RUN_STATS | This view displays information about each refresh operation of materialized views for all tenants. |
| oceanbase.CDB_MVREF_STATS | This view displays basic timing statistics for materialized view refreshes across all tenants. |
| CDB_MVREF_STATS_PARAMS | This view displays the refresh statistics for each materialized view associated with all tenants. |
| CDB_MVREF_STATS_SYS_DEFAULTS | Displays the system-wide default values for all tenants' materialized view refresh history statistics. |
| CDB_MVREF_STMT_STATS | This view displays information related to all tenant materialized view refresh statements. |
| oceanbase.DBA_MVIEW_DEPS | Displays the dependencies of materialized views for the current tenant. |
| oceanbase.DBA_MVIEW_LOGS | 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 historical statistics refresh attribute of materialized views. |
| oceanbase.DBA_MVREF_STMT_STATS | Describes the information associated with the refresh statement. |
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' SNAPSHOT information. |
| oceanbase.CDB_WR_SQLSTAT | This view displays the basic performance statistics of all SQL statements executed by tenants. Each SQL statement is represented as a row in the table. SQL_ID + Plan_Hash (The unique value of is one row.) |
| oceanbase.CDB_WR_SQLTEXT | Displays the SQL text collected for write operations of all tenants. |
| oceanbase.CDB_WR_STATNAME | Displays the names of system statistics for all tenants. |
| oceanbase.CDB_WR_SYS_TIME_MODEL | This API is used to display the write data of all tenants' 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 persisted ASH data for this tenant. |
| oceanbase.DBA_WR_CONTROL | Displays the configuration information related to write requests. |
| oceanbase.DBA_WR_EVENT_NAME | Displays the names of persistent tenant-level wait events for the current tenant. |
| oceanbase.DBA_WR_SNAPSHOT | Display the of this tenant. SNAPSHOT Information. |
| oceanbase.DBA_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed by the current tenant. Each SQL statement is represented as a row in the table. SQL_ID + Plan_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 names of system statistics for the current tenant. |
| oceanbase.DBA_WR_SYS_TIME_MODEL | Displays the write data of time model statistics for the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | Displays the detailed system statistics of 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 historical information 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 of the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays the major compaction information for each zone in the tenant. |
| oceanbase.CDB_OB_FREEZE_INFO | Displays the version information generated during a major freeze. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated during a major freeze. |
Certificate Management
View name |
Feature description |
|---|---|
| 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 | This API is used to display the basic information of all tenants, including the system tenant, user-created tenants (user tenants), and the Meta tenant. You can filter tenants by TENANT_TYPE Columns 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. |
TTL related
View name |
Feature description |
|---|---|
| oceanbase.CDB_OB_TTL_TASKS | Displays the execution status of all user tenant TTL tasks in SQL mode. |
| oceanbase.CDB_OB_TTL_TASK_HISTORY | Displays the execution history of all user tenant TTL tasks in SQL mode. |
| oceanbase.DBA_OB_TTL_TASKS | Displays the execution status of the TTL tasks for the current tenant in SQL mode. |
| oceanbase.DBA_OB_TTL_TASK_HISTORY | Displays the execution history of the TTL tasks for the current tenant in SQL mode. |
Performance view overview
ASH-related
View name |
Feature description |
|---|---|
| GV$ACTIVE_SESSION_HISTORY | Displays the history of active sessions. |
| V$ACTIVE_SESSION_HISTORY | Displays the history of active sessions. |
| GV$OB_ACTIVE_SESSION_HISTORY | This API is used to display the active session history of all OBServer nodes under all tenants. |
| V$OB_ACTIVE_SESSION_HISTORY | This API is used to display the active session history on the current OBServer node for all tenants. |
Catalog-related
View name |
Feature description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This API is used to 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 related
View name |
Feature description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
Replica logs
View name |
Feature description |
|---|---|
| GV$OB_TABLET_REPLICA_INFO | Displays the basic information of all tablet replicas on each node of all tenants, including the tenant to which they belong, log stream, table, database, and disk usage. |
| V$OB_TABLET_REPLICA_INFO | Displays the basic information of all tablet replicas for all tenants on the current node, including details such as 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. |
Partitioning
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_SHARED_SSTABLES | Displays the SSTable information on the shared storage of all tenants. |
| GV$OB_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_LOCAL_CACHE | This topic displays metrics related to various cached data types in the local cache of all tenants on the current OBServer node under 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 of 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 configuration on all OBServer nodes. |
| V$OB_SERVER_STORAGE | Displays the object storage information of the shared storage cluster configured on the current OBServer node. |
| GV$OB_LOCAL_CACHE_DIAGNOSE | This API is used to diagnose the running status of the local cache sub-module for all tenants on each OBServer node in shared storage mode. |
| V$OB_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-related
View name |
Feature description |
|---|---|
| GV$OB_MEMORY | Displays memory statistics at the tenant level. |
| V$OB_MEMORY | Displays memory statistics at the tenant level. |
| GV$OB_MEMSTORE | This API is used to display the memory usage of the MemTable for all tenants on all servers. |
| V$OB_MEMSTORE | This API is used to display tenant-level MemStore statistics. |
| 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 view displays the memory usage of each tenant in the current observer process. |
Event-related
View name |
Feature description |
|---|---|
| GV$OB_PROCESSLIST | Displays the session information on all OBServer nodes of a tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of COMPACT. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level compaction. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level compaction. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays information about transaction participants on all OBServer nodes. |
| GV$SESSION_EVENT | This view displays session-level wait events for all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | This view displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait time. |
| GV$SESSION_WAIT_HISTORY | This view displays information about the last 10 wait events for all sessions on all servers. |
| GV$SYSTEM_EVENT | Displays wait events at the tenant level for all tenants in the cluster. |
| GV$SESSTAT | Statistics on session-level events for all OBServer nodes. |
| GV$SYSSTAT | Displays tenant-level statistical event information on all servers. |
| V$OB_COMPACTION_PROGRESS | Displays the server-level major compaction progress information of a tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the recommended information for COMPACT. |
| V$OB_PROCESSLIST | Displays the session information of the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of COMPACT. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level compaction. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level compaction. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays information about transaction participants on all OBServer nodes. |
| V$STATNAME | This topic describes all statistical events. |
| V$EVENT_NAME | The following table describes the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | The following table describes the parameters of each event. |
| V$SESSION_WAIT_HISTORY | Details of the events currently being waited for by each session, including the last 10 such events. |
| V$SESSTAT | Displays the overview of statistical events at the session level. |
| V$SYSSTAT | Displays tenant-level statistical event information on the current server. |
| V$SYSTEM_EVENT | Statistics on tenant-level wait events. |
| GV$SESSION_LONGOPS | Displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | Displays the execution status and progress of DDL operations on the current OBServer node. |
Cache-related
View name |
Feature description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache on all OBServer nodes for the current tenant. |
| V$OB_PLAN_CACHE_STAT | Records the overall status of each plan cache on all servers for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Records the status of each cached object in the plan cache on all servers for the current tenant. |
| V$OB_PLAN_CACHE_PLAN_STAT | Records the status of each cached object in the plan cache for the current tenant on the current server. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache of the current server. |
| GV$OB_PS_STAT | Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache. |
| GV$OB_PX_P2P_DATAHUB | Displays information related to data transfer operations during parallel execution. |
| GV$OB_PX_TARGET_MONITOR | Displays the PX thread usage on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | Displays the PX thread usage on the OBServer node. |
| GV$OB_SQL_AUDIT | It displays statistical information such as the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | It displays statistical information such as the source and execution status of each SQL request on the current server. |
| GV$SQL_PLAN_MONITOR | This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding record that also includes the trace information of that plan. |
| V$SQL_PLAN_MONITOR | Statistics at the operation level for slow queries, with one statistic record per operation. |
| V$SQL_MONITOR_STATNAME | Display GV$SQL_PLAN_MONITOR of OTHERSTAT_X_ID The 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 schema information on all servers. |
| GV$OB_SERVERS | Displays information about all OBServer nodes. |
| GV$OB_UNITS | Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster. |
| V$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameter information on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays schema information on all servers. |
| V$OB_SERVERS | Displays information about the current OBServer node. |
| V$OB_UNITS | Displays the unit information of 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 product behavior can be controlled for compatibility with the OceanBase AI 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 | Statistics on the number of RPC packets sent by different tenant RPC packet codes on the 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 the OBServer node. |
Workarea-related
View name |
Feature description |
|---|---|
| GV$SQL_WORKAREA | Workarea statistics of all operators previously executed by the SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the statistics of all previous workareas, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This API is used to query general information about SQL Workarea, such as the maximum available memory, current memory usage, and current held memory. |
| V$SQL_WORKAREA | Workarea statistics of all operators previously executed by the SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| V$SQL_WORKAREA_HISTOGRAM | Displays statistics from all previous workareas, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This API is used to query general information about the SQL workarea, including the maximum available memory, current memory usage, and current held memory. |
WR-related
View name |
Feature description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | A histogram that shows the query execution time of all nodes in all tenants. |
| GV$OB_RES_MGR_SYSSTAT | This API is used to display the statistics of resource groups in all OBServer nodes of all tenants. |
| GV$OB_SESS_TIME_MODEL | This API is used to display time model statistics at the session level in a 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, each SQL_ID + Plan_Hash (The unique value of is one row.) |
| GV$OB_SYS_TIME_MODEL | This API is used to display time series metrics at the tenant level in a cluster. |
| V$OB_QUERY_RESPONSE_TIME_HISTOGRAM | A histogram that shows the query execution time of current nodes for all tenants. |
| V$OB_RES_MGR_SYSSTAT | This API is used to display the statistics of resource groups in the current OBServer for all tenants. |
| V$OB_SESS_TIME_MODEL | Displays the time model statistics at the session level on the current node. |
| V$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (that is, each SQL_ID + Plan_Hash (The unique value of is one row.) |
| V$OB_SYS_TIME_MODEL | Displays the 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 for the OceanBase AI Database cluster. |
| V$OB_MERGE_INFO | Displays statistics related to completed compactions for the OceanBase AI Database cluster. |
| GV$OB_COMPACTION_PROGRESS | Displays the OBServer-level major compaction progress information of a tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the recommended information for COMPACT. |
Resource management
View name |
Feature description |
|---|---|
| GV$OB_GROUP_IO_STAT | Displays the real-time status of each resource group on all OBServer nodes of all tenants. |
| GV$OB_FUNCTION_IO_STAT | Displays the I/O statistics at the function level for all tenants across all OBServer nodes. |
| V$OB_GROUP_IO_STAT | Displays the real-time status of each resource group for all tenants on the current OBServer node. |
| V$OB_FUNCTION_IO_STAT | Displays the IO statistics at the function level for all tenants on the current OBServer node. |
User Tenant View Overview
Dictionary View Overview
Logical Tables
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS | Displays the background deletion tasks of logical tables currently being executed by the current tenant. |
| oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY | Displays the history of completed background deletion tasks for logical tables in the current tenant. |
Backup and Recovery
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup job tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the historical records of backup job tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the historical records of backup job tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup job tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the historical records of backup job tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the historical records of backup job tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | Displays the historical records of the tenant's own task-level backup tasks. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | Displays the file status of the backup set. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | Displays the ongoing restore tasks. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays completed restore tasks. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the archive path configuration. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays the backup destination information used for backup and restore operations in a tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information of backup destinations used for backup and restore operations under a tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies set for expired cleanup and automatic cleanup under a 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 for table-level import tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of a table-level restore task. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the result of the import task. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the historical records of table-level cross-tenant import tasks. |
Tables and Columns
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 only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| oceanbase.DBA_TABLES | Displays information about all tables in the current tenant. |
Storage
View name |
Feature description |
|---|---|
| mysql.proc | Displays information about the stored procedure. |
| information_schema.ENGINES | Records information related to the storage engine. |
| information_schema.PARAMETERS | Provides information about stored procedure parameters and return values. |
| information_schema.ROUTINES | Provides information related to stored procedures. |
Access Control
View name |
Feature description |
|---|---|
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | Displays the number of failed login attempts by different users. |
| oceanbase.DBA_RLS_POLICIES | Displays the row-level security (RLS) policy configuration of the current user tenant. |
Partitioning
View name |
Feature description |
|---|---|
| information_schema.PARTITIONS | Records partition information. |
| oceanbase.DBA_IND_PARTITIONS | Displays the partition information of the index. |
| oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partitioned table information for 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, and DBMS_STATS The statistics generated by the package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays the description 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 the C replicas on each OBServer node of the tenant. |
| oceanbase.DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the partition information of a table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information for a table group that is partitioned. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the meta information of a table group, mainly its partition information. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays information about all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays a list of all tablets for the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the 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 the C replicas on each OBServer node of the tenant. |
| oceanbase.DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the partition information of a table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information for a table group that is partitioned. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the meta information of a table group, mainly its partition information. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays information for all tablet replicas of the current tenant. Each tablet replica is uniquely identified by its composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays a list of all tablets for the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the replica distribution information of log stream (LS) for the current tenant. |
Shared Storage
View name |
Feature description |
|---|---|
| DBA_OB_STORAGE_SPACE_USAGE | Records the storage space usage of the current tenant's object storage. |
| DBA_OB_SHARED_MACRO_BLOCK_GC_STAT | Displays the number of shared data GC-deleted macroblocks per day for each storage type in the current tenant. |
Help Commands
View name |
Feature description |
|---|---|
| mysql.help_topic | With the other three tables mysql.help_category, mysql.help_relation, mysql.help_keyword Generate the help command together. |
| mysql.help_category | With the other three tables mysql.help_relation, mysql.help_topic, mysql.help_keyword Co-create help commands. |
| mysql.help_keyword | With the other three tables mysql.help_relation, mysql.help_topic, mysql.help_category Generate help commands in collaboration. |
| mysql.help_relation | With the other three tables mysql.help_category, mysql.help_topic, mysql.help_keyword Collaborate to generate Help commands. |
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 or waiting to be acquired.
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.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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_TRX | This view displays information about active transactions.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE | This view displays information about all cached pages in the buffer pool.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE_LRU | Displays the LRU sorted information of pages in the InnoDB buffer pool.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_BUFFER_POOL_STATS | This view displays statistics of the InnoDB buffer pool.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP | Displays and compresses the status information related to InnoDB tables.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX | Displays information related to operations on InnoDB tables and indexes.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | This view displays 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 for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_TABLES | Displays the metadata information of an InnoDB table.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_TABLESPACES | Displays the metadata of InnoDB table files and general tablespaces.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; 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 only for compatibility with MySQL 5.7. 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 tables.
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_TEMP_TABLE_INFO | Displays information about InnoDB temporary tables created by active users.
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_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-related
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the TTL tasks currently being executed by the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks of the current tenant. |
| V$OB_KV_CLIENT_INFO | Displays the configuration parameter information of the current node's OBKV tenant client connection. |
| GV$OB_KV_CLIENT_INFO | Displays the configuration 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 plan and throttling rule outline historical information for this tenant. |
| DBA_OB_FORMAT_OUTLINES | Records the details of the current tenant's format outline. |
Task Scheduling Manager Related
View name |
Feature description |
|---|---|
| oceanbase.DBA_SCHEDULER_JOBS | Displays information about all scheduler jobs in the database. |
Permissions
View name |
Feature description |
|---|---|
| mysql.db | Displays database-level privileges (VIRTUAL_TABLE). |
| mysql.user | Used to record user-level privilege information (VIRTUAL_TABLE). |
| information_schema.COLUMN_PRIVILEGES | Displays column permission information. |
| information_schema.SCHEMA_PRIVILEGES | Describes database permission information. |
| information_schema.TABLE_PRIVILEGES | Records table privilege information. |
| information_schema.USER_PRIVILEGES | Records user permission information. |
| oceanbase.DBA_JAVA_POLICY | Displays the Java permission policy for all users in the current tenant. |
| oceanbase.USER_JAVA_POLICY | Displays the Java permission policy of the currently logged-in user. |
Full-text indexes
View name |
Feature description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | Displays information about full-text indexes being dropped.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_CONFIG | Displays the configuration information of the InnoDB full-text search engine.
NoteThis view is for compatibility with MySQL 5.7 only. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_DELETED | Displays information about full-text indexes that have been marked for deletion.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_FT_INDEX_CACHE | This view displays the cache status information of InnoDB full-text indexes.
NoteThis view is 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) in an InnoDB index, which is equivalent to the information in the SYS_FIELDS table in the InnoDB data dictionary.
NoteThis view is provided 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 | Displays time zone-related information (SYSTEM_VIEW). |
| mysql.time_zone_name | Used to record the name of the time zone (SYSTEM_VIEW). |
| mysql.time_zone_transition | mysql.time_zone_transition is a system view used to record time zone conversion information. |
| mysql.time_zone_transition_type | Used to record the time zone conversion type (SYSTEM_VIEW). |
SPM-related
View name |
Feature description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | Displays the plan baseline of 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 AI 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 of the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays the major compaction information for each zone in the tenant. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated during a major freeze. |
| information_schema.events | Records all event information. |
Statistics and histograms
View name |
Feature description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays the optimizer statistics for all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms for all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays the column statistics and histogram information for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histogram information for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays histograms for all columns in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays the histogram data (the endpoints of each histogram) for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays the histogram data (the endpoints of each histogram) on all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the historical table statistics for all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays the optimizer statistics for all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the cumulative modification information of tables in the database. |
| information_schema.QUERY_RESPONSE_TIME | It displays data types such as RESPONSE TIME histograms for monitoring by Prometheus. |
| oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | Query the historical collection execution of a table. |
Foreign key related
View name |
Feature description |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | Displays metadata information about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table in the InnoDB data dictionary.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported; you can only query the table structure. |
| information_schema.INNODB_SYS_FOREIGN_COLS | This view displays 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 only for compatibility with MySQL 5.7. The related features are not supported; it can only be used to query the table structure. |
WR-related
View name |
Feature description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | Display the of this tenant. SNAPSHOT Information. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | Displays the persisted ASH data for this tenant. |
| oceanbase.DBA_WR_STATNAME | Displays the names of system statistics for the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | Displays the detailed system statistics of 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 the basic performance statistics of SQL statements executed by the current tenant. Each SQL statement is represented as a row in the table. SQL_ID + Plan_Hash Each unique value corresponds to 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 historical statistics refresh attribute of materialized views. |
| oceanbase.DBA_MVREF_STMT_STATS | Describes the information associated with the refresh statement. |
TTL-related
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_TTL_TASKS | Displays the execution status of the TTL tasks for the current tenant in SQL mode. |
| oceanbase.DBA_OB_TTL_TASK_HISTORY | Displays the execution history of the TTL tasks for the current tenant in SQL mode. |
Thread-related
View name |
Feature description |
|---|---|
| information_schema.PROCESSLIST | Provides information about running threads. |
Constraints
View name |
Feature description |
|---|---|
| information_schema.CHECK_CONSTRAINTS | Display CREATE TABLE Constraints 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. |
Resource-related
View name |
Feature description |
|---|---|
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | Displays all sequences in the database. |
Resource Manager-related
View name |
Feature description |
|---|---|
| DBA_OB_RSRC_DIRECTIVES | Displays the resource configuration parameters of the current tenant in the Resource Manager. |
| DBA_OB_RSRC_IO_DIRECTIVES | Displays the I/O resource configuration of the current tenant in the Resource Manager. |
| DBA_RSRC_GROUP_MAPPINGS | Displays the binding relationship between users and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | Display information about all resource groups in the database. |
| DBA_RSRC_PLANS | Displays all system-defined resource management plans. |
| DBA_RSRC_PLAN_DIRECTIVES | Displays the details of each resource plan directive 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. This includes the system tenant, user-created tenants (user tenants), and the Meta tenant. You can filter tenants by TENANT_TYPE Columns are used to distinguish tenant types. |
Character set
View name |
Feature description |
|---|---|
| information_schema.CHARACTER_SETS | Records the character set information of OceanBase AI 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-related
View name |
Feature description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This API is used to query the HMS catalog usage of the current tenant. |
| V$OB_HMS_CLIENT_POOL_STAT | This API is used to query the HMS catalog usage of the current tenant. |
| GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT | Retrieves the catalog pooling information of all OBServer nodes. |
| V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT | Retrieves the catalog pooling information of the OBServer node that executed the SQL statement. |
Wait for Events
View name |
Feature description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the OBServer-level major compaction progress information of a tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the recommended information for COMPACT. |
| GV$OB_PROCESSLIST | Displays the session information on all OBServer nodes of a tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of COMPACT. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level compaction. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level compaction. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays information about transaction participants on all OBServer nodes. |
| GV$SESSION_EVENT | This view displays session-level wait events for all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | This view displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait time. |
| GV$SESSION_WAIT_HISTORY | This view displays information about the last 10 wait events for all sessions on all servers. |
| GV$SYSTEM_EVENT | Displays wait events at the tenant level for all tenants in the cluster. |
| GV$SESSTAT | Statistics on session-level events for all OBServer nodes. |
| GV$SYSSTAT | Displays tenant-level statistical event information on all servers. |
| V$OB_COMPACTION_PROGRESS | Displays the server-level major compaction progress information of a tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the recommended information for COMPACT. |
| V$OB_PROCESSLIST | Displays the session information of the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of COMPACT. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level compaction. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level compaction. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays information about transaction participants on all OBServer nodes. |
| V$STATNAME | This topic describes all statistical events. |
| V$EVENT_NAME | The following table describes the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | The following table describes the parameters of each event. |
| V$SESSION_WAIT_HISTORY | Details of the events currently being waited for by each session, including the last 10 such events. |
| V$SESSTAT | Displays the overview of statistical events 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-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. |
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_SHARED_SSTABLES | Displays the SSTable information on the shared storage of the current tenant. |
| GV$OB_LOCAL_CACHE | This topic describes the metrics for various cache data types stored locally in the cache memory of each OBServer node for all tenants under the shared storage mode. |
| V$OB_LOCAL_CACHE | This topic displays metrics related to various cached data types in the local cache of all tenants on the current OBServer node under 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_TABLET_MACRO_CACHE_STAT | Displays the tablet macroblock cache statistics of the current tenant across all OBServer nodes. |
| V$OB_TABLET_MACRO_CACHE_STAT | Displays the tablet macroblock cache statistics of the current tenant on the current OBServer node. |
| GV$OB_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_LOCAL_CACHE_DIAGNOSE | This API is used to diagnose the running status of the local cache sub-module of 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 for the current tenant on the current server. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache of the current server. |
| GV$OB_PS_STAT | Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | Monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Provides monitoring capabilities for prepared statements, including basic information about all prepared statements in the PS cache. |
| GV$OB_PX_TARGET_MONITOR | Displays the PX thread usage on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | Displays the PX thread usage on the OBServer node. |
| GV$OB_SQL_AUDIT | It displays statistical information such as the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | It displays statistical information such as the source and execution status of each SQL request on the current server. |
| GV$SQL_PLAN_MONITOR | This view displays the plan statistics for all slow queries on OBServer nodes. Each slow query has a corresponding record that also includes the trace information of that plan. |
| V$SQL_PLAN_MONITOR | Statistics at the operation level for slow queries, with one statistic record per operation. |
| V$SQL_MONITOR_STATNAME | Display GV$SQL_PLAN_MONITOR of OTHERSTAT_X_ID The 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 | This API is used to display tenant-level MemStore statistics. |
| 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 view displays the memory usage of each tenant in the current observer process. |
Session-related
View name |
Feature description |
|---|---|
| GV$SESSION_LONGOPS | Displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | Displays the execution status and progress of DDL operations on the current OBServer node. |
Lock-related
Database-related
View name |
Feature description |
|---|---|
| GV$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameter information on all OBServer nodes where the tenant resides. |
| GV$OB_SERVER_SCHEMA_INFO | Displays schema information on all servers. |
| GV$OB_UNITS | Displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information of all OBServer nodes in the cluster. |
| V$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameter information on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays schema information on all servers. |
| V$OB_UNITS | Displays the unit information of 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 product behavior can be controlled for compatibility with the OceanBase AI Database release version. |
Workarea-related
View name |
Feature description |
|---|---|
| GV$SQL_WORKAREA | Workarea statistics of all operators previously executed by the SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the statistics of all previous workareas, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This API is used to query general information about SQL Workarea, such as the maximum available memory, current memory usage, and current held memory. |
| V$SQL_WORKAREA | Workarea statistics of all operators previously executed by the SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workspace information of the current active operator. |
| V$SQL_WORKAREA_HISTOGRAM | Displays statistics from all previous workareas, such as the number of times data was processed entirely in-memory within the 1 MB to 2 MB range and the number of one-pass executions. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This API is used to query general information about the SQL workarea, including the maximum available memory, current memory usage, and current held memory. |
WR-related
View name |
Feature description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | A histogram that shows the query execution time of all nodes in the current tenant. |
| GV$OB_RES_MGR_SYSSTAT | This API is used to display the 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, each SQL_ID + Plan_Hash The unique value of the primary key 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, each SQL_ID + Plan_Hash (The unique value of is one row.) |
| GV$OB_SESS_TIME_MODEL | This API is used to display time model statistics at the session level in a cluster. |
| V$OB_SESS_TIME_MODEL | Displays the time model statistics at the session level on the current node. |
| GV$OB_SYS_TIME_MODEL | This API is used to display time series metrics at the tenant level in a cluster. |
| V$OB_SYS_TIME_MODEL | Displays the time model statistics at the tenant level on the current node. |
| V$OB_RES_MGR_SYSSTAT | This view displays the statistical metrics of resource groups in the current OBServer node under the current tenant. |
Network
View name |
Feature description |
|---|---|
| GV$OB_RPC_OUTGOING | The RPC sending statistics of all OBServer nodes. |
| GV$OB_RPC_INCOMING | This API is used to display the statistics of RPC requests received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | Statistics on the number of RPC packets sent by different tenant RPC packet codes on the 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 the 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 related
View name |
Feature description |
|---|---|
| GV$OB_MERGE_INFO | Displays statistics related to completed compactions for the OceanBase AI Database cluster. |
| V$OB_MERGE_INFO | Displays statistics related to completed compactions for the OceanBase AI Database cluster. |