Overview of views in the sys tenant
Dictionary views overview
Security privileges
| View name | Description |
|---|---|
| mysql.columns_priv | This view displays the column privileges granted to users. |
| mysql.default_roles | This view displays the default enabled roles of users. |
| mysql.procs_priv | This view stores the privileges of stored procedures and functions. |
| mysql.role_edges | This view displays the grant relationships between roles and users. |
| oceanbase.CDB_OB_DATABASE_PRIVILEGE | This view displays the database privileges of users in each tenant. |
| oceanbase.CDB_OB_USERS | This view displays the users and roles in all tenants of the cluster. |
| oceanbase.DBA_OB_DATABASE_PRIVILEGE | This view displays the database privileges of users in the current tenant. |
| oceanbase.DBA_OB_USERS | This view displays the users and roles in the current tenant. |
| oceanbase.CDB_OB_SENSITIVE_COLUMNS | This view displays all columns protected by sensitive rules. |
| oceanbase.CDB_OB_SENSITIVE_RULES | This view displays the definitions and attributes of all sensitive rules. |
| oceanbase.CDB_OB_SENSITIVE_RULE_PLAINACCESS_USERS | This view displays all users or roles that have the plaintext data access privilege for columns associated with a sensitive rule. |
AI models
| View name | Description |
|---|---|
| oceanbase.CDB_OB_AI_MODELS | This view displays the AI model information of all tenants. |
| oceanbase.CDB_OB_AI_MODEL_ENDPOINTS | This view displays the model access information of all tenants. |
| oceanbase.DBA_OB_AI_MODELS | This view displays the AI model information of the current tenant. |
| oceanbase.DBA_OB_AI_MODEL_ENDPOINTS | This view displays the model access information of the current tenant. |
Backup and restore
| View | Description |
|---|---|
| oceanbase.CDB_OB_RESTORE_PROGRESS | This view displays the execution progress of physical restore tasks. |
| oceanbase.CDB_OB_RESTORE_HISTORY | This view displays the status of physical restore tasks upon completion. |
| oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of pieces in a backup. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | This view displays the status of files in a backup set. |
| oceanbase.CDB_OB_BACKUP_JOBS | This view displays backup jobs for all tenants in the cluster. A backup job is recorded when a user initiates a backup task. |
| oceanbase.CDB_OB_BACKUP_JOB_HISTORY | This view displays the history of backup jobs for all tenants in the cluster. |
| oceanbase.CDB_OB_BACKUP_TASKS | This view displays task-level backup tasks for all tenants in the cluster. Each task record corresponds to one backup set. Task records and job records are in a one-to-one correspondence. |
| oceanbase.CDB_OB_BACKUP_TASK_HISTORY | This view displays the history of task-level backup tasks for all tenants in the cluster. |
| oceanbase.DBA_OB_BACKUP_JOBS | This view displays backup jobs for the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | This view displays the history of backup jobs for the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | This view displays the history of backup jobs for the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | This view displays the history of task-level backup tasks for the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | This view displays the status of files in a backup set. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | This view displays the progress of ongoing restore tasks. |
| oceanbase.DBA_OB_RESTORE_HISTORY | This view displays the history of completed restore tasks. |
| oceanbase.DBA_OB_ARCHIVE_DEST | This view displays archive path configurations. |
| oceanbase.CDB_OB_ARCHIVE_DEST | This view displays archive path configurations. |
| oceanbase.CDB_OB_BACKUP_PARAMETER | This view displays backup parameters. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOBS | This view displays the progress of tenant-level backup cleanup jobs. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of backup cleanup tasks executed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | This view displays the information about backup_set/backup_piece cleanup tasks being executed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of backup_set/backup_piece cleanup tasks completed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_POLICY | This view displays the cleanup policies set for expired/automatic cleanup in the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | This view displays the information about backup destinations used for backup and restore in the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the history of backup destinations used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | This view displays the information about backup destinations used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the history of backup destinations used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | This view displays the cleanup policies set for expired/automatic cleanup in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | This view displays the execution progress of tenant-level backup cleanup jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of backup cleanup tasks executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | This view displays the information about backup_set/backup_piece cleanup tasks being executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of backup_set/backup_piece cleanup tasks completed in the tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | This view displays the status of log backups on each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | This view displays the status of all historical and current log backups. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of pieces in a backup set. |
| oceanbase.CDB_OB_ARCHIVELOG | This view displays the status of log archiving on each path. |
| oceanbase.CDB_OB_ARCHIVELOG_SUMMARY | This view displays the status of all historical and current log archiving. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOBS | This view displays information about table-level restore jobs. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOBS | This view displays information about table-level restore jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOBS | This view displays information about import jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | This view displays information about import jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASKS | This view displays records of cross-tenant table-level import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | This view displays records of table-level import tasks. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY | This view displays the results of table-level restore jobs. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | This view displays the results of table-level restore jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY | This view displays the results of import jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | This view displays the results of import jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the history of cross-tenant table-level import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the history of cross-tenant table-level import tasks. |
| oceanbase.CDB_OB_LS_HISTORY | This view displays the log streams that have existed in all tenants in the past. Only the sys tenant can access this view. |
| oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS | This view displays the log stream archiving progress of all tenants. |
| oceanbase.DBA_OB_LS_HISTORY | This view displays the log streams that have existed in the current tenant in the past. |
| oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS | This view displays the log stream archiving progress of the current tenant. |
| oceanbase.DBA_OB_LS_REPLICA_TASKS | This view displays the disaster recovery tasks at the Replica level that are running in the current tenant. |
| oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY | This view displays the execution history of disaster recovery tasks in the current tenant. |
Views and columns
| View name | Purpose |
|---|---|
| oceanbase.CDB_IND_COLUMNS | This view displays the column information of the index tables of all tenants. |
| oceanbase.CDB_INDEXES | This view displays the INDEX information of all tenants. |
| oceanbase.CDB_TABLES | This view displays the TABLE information of all tenants. |
| oceanbase.CDB_OB_TABLEGROUP_TABLES | This view displays the association between the TABLEGROUP and TABLE of all tenants under the sys tenant. Tables not in a TABLEGROUP are not displayed. |
| oceanbase.CDB_TAB_COLS | This view displays the column information of the tables and views of all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | This view displays the column information of the tables and views of all tenants. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | This view displays the association between the TABLEGROUP and TABLE. Tables not in a TABLEGROUP are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | This view displays the columns included in the partition keys of all partitioned objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | This view displays the columns included in the subpartition keys of all partitioned objects in the database. |
| oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO | This view displays the column checksum inconsistency information between the index tables (including global indexes and local indexes) and the base tables. |
| oceanbase.CDB_OB_TABLE_LOCATIONS | This view displays the location of a table or partition, including system tables, user tables, and index tables. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | This view displays the location of a table or partition, including system tables, user tables, and index tables. |
| information_schema.TABLESPACES | This view displays information about tablespaces.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and only the table structure can be queried. |
CCL
| View name | Purpose |
|---|---|
| oceanbase.CDB_OB_CCL_RULES | This view records the throttling rules of all tenants. |
| oceanbase.DBA_OB_CCL_RULES | This view records the throttling rules of all tenants. |
Replica log related
| View name | Description |
|---|---|
| oceanbase.CDB_OB_CS_REPLICA_STATS | This view displays the progress of converting tablets in the log stream of C replicas on all OBServer nodes for all tenants. |
| oceanbase.CDB_IND_SUBPARTITIONS | This view displays information about all index subpartitions in the database. |
| oceanbase.CDB_OB_LS_LOCATIONS | This view displays the distribution of log streams (LS) replicas for all tenants. |
| oceanbase.CDB_OB_TABLEGROUPS | This view displays the metadata of all table groups for all tenants under the sys tenant, mainly the partition information of the table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | This view displays the primary partition information of partitioned table groups for all tenants under the sys tenant. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of partitioned table groups for all tenants under the sys tenant. |
| oceanbase.CDB_OB_TABLET_TO_LS | This view displays the list of tablets and the log stream information for each tablet for all tenants under the sys tenant. |
| oceanbase.CDB_OB_TABLET_REPLICAS | This view displays the information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays the information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | This view displays the list of tablets and the log stream information for each tablet in the current tenant. |
| oceanbase.DBA_OB_LS_LOCATIONS | This view displays the distribution of log streams (LS) replicas in the current tenant. |
| oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO | This view displays information about data inconsistencies between tablet replicas. |
| oceanbase.CDB_OB_LS | This view displays the status and recovery progress of log streams. |
| oceanbase.DBA_OB_LS | This view displays the status and recovery progress of log streams. |
| oceanbase.CDB_OB_TABLE_SPACE_USAGE | This view displays the sizes of all user tables (based on the leader replica in a multi-replica environment) for all tenants. |
| oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN | This view displays information about each log truncation for all tenants in the current cluster. |
| oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN | This view displays information about each log truncation for the current tenant. |
Partition-related
| View | Purpose |
|---|---|
| oceanbase.CDB_IND_PARTITIONS | This view displays the primary partitions of all index tables in all tenants. |
| oceanbase.CDB_IND_SUBPARTITIONS | This view displays the subpartitions of all indexes in the database. |
| oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES | This view displays the dynamic partition tables in all tenants. |
| oceanbase.CDB_PART_INDEXES | This view displays the partitions of all index tables in all tenants. |
| oceanbase.CDB_PART_TABLES | This view displays the partitions of all partitioned tables in all tenants. |
| oceanbase.CDB_SUBPARTITION_TEMPLATES | This view displays the secondary partition templates of all partitioned tables in all tenants. |
| oceanbase.CDB_TAB_PARTITIONS | This view displays the primary partitions of all partitioned tables in all tenants. |
| oceanbase.CDB_TAB_SUBPARTITIONS | This view displays the secondary partitions of all partitioned tables in all tenants. |
| oceanbase.DBA_IND_PARTITIONS | This view displays the primary partitions of all indexes. |
| oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES | This view displays the dynamic partition tables of the current tenant. |
| oceanbase.DBA_PART_INDEXES | This view displays the partitions of all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | This view displays the partitions of all user tables. |
| oceanbase.DBA_TAB_PARTITIONS | This view displays the hierarchical partitions, storage parameters, and statistics of all partitions accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | This view displays the subpartition name, table name, partition name, storage attributes, and statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | This view displays the descriptions of all subpartition templates. |
| oceanbase.CDB_PART_KEY_COLUMNS | This view displays the primary partition keys of all partitioned objects (partitioned tables and partitioned indexes) in all tenants. |
| oceanbase.CDB_SUBPART_KEY_COLUMNS | This view displays the secondary partition keys of all partitioned objects (partitioned tables and partitioned indexes) in all tenants. |
| oceanbase.DBA_IND_SUBPARTITIONS | This view displays the subpartitions of all indexes in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | This view displays the primary partitions of the partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the subpartition information of a table group. |
| oceanbase.DBA_OB_TABLEGROUPS | This view displays the metadata of a table group, mainly the partition information. |
Load balancing
| View name | Purpose |
|---|---|
| oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT | This view displays all partitions with special weights in all user tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS | This view displays the current Transfer Partition tasks being processed by all tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of Transfer Partition tasks executed by all tenants. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | This view displays the current Transfer Partition tasks being processed by the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of Transfer Partition tasks executed by the current tenant. |
| oceanbase.CDB_OB_BALANCE_JOBS | This view displays the current load balancing jobs being executed by all tenants. Each tenant can only run one load balancing job (JOB) at a time. Each load balancing job generates multiple load balancing tasks (TASK), which are used to implement specific load balancing operations. |
| oceanbase.CDB_OB_BALANCE_JOB_HISTORY | This view displays the history of load balancing jobs executed by all tenants. |
| oceanbase.CDB_OB_BALANCE_TASKS | This view displays the current load balancing tasks being executed by all tenants. |
| oceanbase.CDB_OB_BALANCE_TASK_HISTORY | This view displays the history of load balancing tasks executed by all tenants. |
| oceanbase.CDB_OB_TRANSFER_TASKS | This view displays the current Transfer tasks being executed by all tenants. |
| oceanbase.CDB_OB_TRANSFER_TASK_HISTORY | This view displays the history of Transfer tasks executed by all tenants. |
| oceanbase.DBA_OB_BALANCE_JOBS | This view displays the current load balancing jobs being executed by the current tenant. Each tenant can only run one load balancing job (JOB) at a time. Each load balancing job generates multiple load balancing tasks (TASK), which are used to implement specific load balancing operations. |
| oceanbase.DBA_OB_BALANCE_JOB_HISTORY | This view displays the history of load balancing jobs executed by the current tenant. |
| oceanbase.DBA_OB_BALANCE_TASKS | This view displays the current load balancing tasks being executed by the current tenant. Each tenant can run multiple load balancing tasks at a time, and these tasks (TASK) belong to the same load balancing job (JOB). |
| oceanbase.DBA_OB_BALANCE_TASK_HISTORY | This view displays the history of load balancing tasks executed by the current tenant. |
| oceanbase.DBA_OB_TRANSFER_TASKS | This view displays the current Transfer tasks being executed by the current tenant. |
| oceanbase.DBA_OB_TRANSFER_TASK_HISTORY | This view displays the history of Transfer tasks executed by the current tenant. |
Shared storage
| View name | Purpose |
|---|---|
| CDB_OB_SS_SPACE_USAGE | Records the storage space occupied by each tenant on the object storage. |
| DBA_OB_SS_SPACE_USAGE | Records the storage space occupied by the current tenant on the object storage. |
| DBA_OB_ZONE_STORAGE | Displays the information about the object storage configured in the shared storage cluster for each zone. |
| oceanbase.CDB_OB_SPACE_USAGE | In the shared-storage (SS) mode, records the space occupied by different types of data in different Endpoints and Paths for each tenant. |
I/O performance
| View name | Purpose |
|---|---|
| CDB_OB_STORAGE_IO_USAGE | Displays the I/O operations of the object storage and cloud disks for all tenants. |
InnoDB storage engine
| View name | Description |
|---|---|
| information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP | This view displays the mapping information between NDB transactions, NDB transaction coordinators, and MySQL servers attached to the NDB cluster as API nodes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_TRX | This view displays the information about active transactions.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_LOCK_WAITS | This view displays the information about locks that are waiting for conflicts.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_LOCKS | This view displays the information about all locks (waiting and held).
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE | This view displays the information about all cached pages in the buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE_LRU | This view displays the LRU information about pages in the InnoDB buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_BUFFER_POOL_STATS | This view displays the statistics about the InnoDB buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_CMP | This view displays the operation status information about compressed InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX | This view displays the operation information about compressed InnoDB tables and indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | This view displays the reset time information about operations related to compressed InnoDB tables and indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_CMP_RESET | This view displays the operation status about compressed InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and 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 available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_CMPMEM_RESET | This view displays the reset time status of compressed pages in the InnoDB buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_SYS_DATAFILES | This view displays the data file path information for each table and the general tablespace.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_SYS_INDEXES | This view displays the metadata information about InnoDB indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_SYS_TABLES | This view displays the metadata information about InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_SYS_COLUMNS | The document does not provide a description of the function. |
| information_schema.INNODB_SYS_TABLESPACES | This view displays the metadata about InnoDB table files and the general tablespace.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_SYS_TABLESTATS | This view displays the low-level status information about InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_SYS_VIRTUAL | This view displays the metadata about virtual generated columns in InnoDB.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only query the table structure. |
| information_schema.INNODB_TEMP_TABLE_INFO | This view displays information about InnoDB temporary tables created by users.
NoteThis view is available starting with MySQL 5.7. |
| information_schema.INNODB_METRICS | This view displays InnoDB performance information.
NoteThis view is available starting with MySQL 5.7. |
Temporary files
| View name | Description |
|---|---|
| oceanbase.CDB_OB_TEMP_FILES | This view displays information about temporary files. |
| oceanbase.DBA_OB_TEMP_FILES | This view displays information about temporary files. |
OBKV
| View name | Description |
|---|---|
| oceanbase.CDB_OB_KV_TTL_TASKS | This view displays all TTL tasks that are being executed by all tenants in the sys tenant. |
| oceanbase.CDB_OB_KV_TTL_TASK_HISTORY | This view displays all historical TTL tasks that are being executed by all tenants in the sys tenant. |
| oceanbase.DBA_OB_KV_TTL_TASKS | This view displays all TTL tasks that are being executed by the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | This view displays all historical TTL tasks that are being executed by the current tenant. |
| V$OB_KV_CLIENT_INFO | This view displays the configuration parameters of all OBKV tenants that are connected to the current node. |
| GV$OB_KV_CLIENT_INFO | This view displays the configuration parameters of all OBKV tenants that are connected to all nodes. |
| oceanbase.CDB_OB_KV_REDIS_TABLE | This view stores the names of the storage tables corresponding to the Redis commands for all tenants. |
| oceanbase.DBA_OB_KV_REDIS_TABLE | This view stores the names of the storage tables corresponding to the Redis commands for the current tenant. |
Outline
| View name | Description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | This view displays the outline information of the execution plans of the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | This view displays the outline information of the throttling rules of the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | This view displays the outline information of the execution plans and throttling rules of the current tenant. |
| DBA_OB_FORMAT_OUTLINES | This view records the detailed information of the format outline of the current tenant. |
Full-text index
| View name | Description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | This view displays the information about full-text indexes that are being deleted.
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_FT_CONFIG | This view displays the configuration information of the InnoDB full-text search engine.
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_FT_DELETED | This view displays the information about full-text indexes that are marked for deletion.
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_FT_INDEX_CACHE | This view displays the cache status information of the InnoDB full-text indexes.
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_SYS_FIELDS | This view displays the metadata information about the key columns (fields) of the InnoDB indexes, which is equivalent to the information in the SYS_FIELDS table of the InnoDB data dictionary.
NoteThis view is provided only for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
Other index-related views
| View | Description |
|---|---|
| oceanbase.DBA_INDEX_USAGE | This view displays index usage data. |
| oceanbase.CDB_INDEX_USAGE | This view displays index usage data. |
Task scheduling-related views
| View | Description |
|---|---|
| oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS | The CDB_SCHEDULER_JOB_RUN_DETAILS view displays information about all scheduler jobs in all tenants. |
| oceanbase.DBA_SCHEDULER_WINDOWS | This view displays information about all scheduler windows in the current tenant. |
Disaster recovery-related views
| View | Description |
|---|---|
| oceanbase.CDB_OB_ACCESS_POINT | This view displays the list of servers for the tenant entry. In a physical standby database scenario based on network, it is mainly used to obtain the IP address and SQL port number of the OBServer node in the primary tenant's replica. |
| oceanbase.CDB_OB_LOG_RESTORE_SOURCE | This view displays the log restore sources of all physical restore tenants and standby tenants. |
| oceanbase.CDB_OB_LS_REPLICA_TASKS | This view displays the ongoing disaster recovery tasks at the Replica level for all tenants. Only the system tenant can view this view. |
| oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY | This view displays the execution history of disaster recovery tasks for all tenants. |
| oceanbase.DBA_OB_LOG_RESTORE_SOURCE | This view displays the log restore sources of the current tenant. |
| oceanbase.DBA_OB_ACCESS_POINT | This view displays the list of servers for the tenant entry of the current tenant. In a physical standby database scenario based on network, it is mainly used to obtain the IP address and SQL port number of the OBServer node in the primary tenant's replica. |
Root Service-related views
| View | Description |
|---|---|
| oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY | This view displays the event history of Root Service. |
SPM-related views
| View | Description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | This view displays the SQL plan baselines in SPM. |
| oceanbase.DBA_SQL_MANAGEMENT_CONFIG | This view displays the configuration parameters in SPM. |
| oceanbase.CDB_OB_SPM_EVO_RESULT | This view displays the SPM plan evolution information for all tenants. |
| oceanbase.DBA_OB_SPM_EVO_RESULT | This view displays the SPM plan evolution information for the tenant. |
SQL query-related views
| View | Description | | oceanbase.DBA_OB_USER_DEFINED_RULES | This view records the rules for rewriting SQL statements in the current tenant. |
Upgrade-related views
| View | Description |
|---|---|
| oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY | Only the system tenant can access this view, which displays important cluster-level events. Currently, it only supports displaying cluster upgrade-related events. |
Event history monitoring
| View name | Purpose |
|---|---|
| information_schema.events | Records all Event information. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | This view displays OBServer node event history information. |
| oceanbase.CDB_OB_TENANT_EVENT_HISTORY | This view displays the historical operation records of all tenants in the cluster. |
| oceanbase.DBA_OB_TENANT_EVENT_HISTORY | This view displays the historical operation records of the current tenant. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | This view displays the historical records of deadlock events. In a non-root tenant, this view displays the historical records of the current tenant. |
Basic database information
| View name | Purpose |
|---|---|
| oceanbase.CDB_OB_DATABASES | This view displays the database metadata of all tenants in the sys tenant. |
| oceanbase.DBA_OB_DATABASES | This view displays the database metadata of the current tenant. |
| oceanbase.DBA_OB_ZONES | This view displays the information of all zones. |
Data dictionary
| View name | Purpose |
|---|---|
| oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG | This view records the location range of the data dictionary in the system log stream to facilitate CDC consumption of the data dictionary. |
| oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG | This view records the location range of the data dictionary in the system log stream to facilitate CDC consumption of the data dictionary. |
Locks
| View name | Purpose |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | This view displays the historical records of deadlock events. In the root tenant, this view displays the historical records of all tenants. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | This view displays the historical records of deadlock events. In a non-root tenant, this view displays the historical records of the current tenant. |
Statistics and histogram related
| View name | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | This view displays the optimizer statistics of all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | This view displays the column statistics and histogram information of all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | This view displays the column statistics and histogram information of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | This view displays the histograms of all columns in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | This view displays the histogram data (endpoints) of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | This view displays the histogram data (endpoints) of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | This view displays the table statistics history of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | This view displays the optimizer statistics of all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | This view displays the cumulative modification information of tables in the database. |
| oceanbase.CDB_TAB_COL_STATISTICS | This view displays the column-level statistics in the system tenant. |
| oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | This view queries the historical collection execution of tables. |
| oceanbase.DBA_OB_TABLE_STAT_STALE_INFO | This view displays the number of DML operations performed on each table since the last statistics collection and whether the current statistics are stale. |
| oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY | This view displays the execution of historical collection tasks in the current tenant. |
External resources related
| View name | Description |
|---|---|
| oceanbase.CDB_OB_EXTERNAL_RESOURCES | This view displays all uploaded resource files in the system tenant. |
| oceanbase.CDB_OB_EXTERNAL_TABLE_FILES | This view displays the file list of all external tables created by all tenants. |
| oceanbase.DBA_OB_EXTERNAL_RESOURCES | This view displays the uploaded resource files. |
| oceanbase.DBA_OB_EXTERNAL_TABLE_FILES | This view displays the file list of all external tables created in the current tenant. |
WR-related views
| View name | Description |
|---|---|
| oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data of all tenants after persistence. |
| oceanbase.CDB_WR_CONTROL | This view displays the WR-related configuration information. |
| oceanbase.CDB_WR_EVENT_NAME | This view displays the tenant-level wait event names of all tenants after persistence. |
| oceanbase.CDB_WR_SNAPSHOT | This view displays the SNAPSHOT information of all tenants. |
| oceanbase.CDB_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed by all tenants. Each SQL statement is represented as a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
| oceanbase.CDB_WR_SQLTEXT | This view displays the SQL texts collected by WR for all tenants. |
| oceanbase.CDB_WR_STATNAME | This view displays the names of system statistics for all tenants. |
| oceanbase.CDB_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics for all tenants. |
| oceanbase.CDB_WR_SYSSTAT | This view displays the details of the system statistics for all tenants. |
| oceanbase.CDB_WR_SYSTEM_EVENT | This view displays the tenant-level wait event information of all tenants after persistence. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data of the current tenant after persistence. |
| oceanbase.DBA_WR_CONTROL | This view displays the WR-related configuration information. |
| oceanbase.DBA_WR_EVENT_NAME | This view displays the tenant-level wait event names of the current tenant after persistence. |
| oceanbase.DBA_WR_SNAPSHOT | This view displays the SNAPSHOT information of the current tenant. |
| oceanbase.DBA_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed by the current tenant. Each SQL statement is represented as a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
| oceanbase.DBA_WR_SQLTEXT | This view displays the SQL texts collected by WR for the current tenant. |
| oceanbase.DBA_WR_STATNAME | This view displays the names of system statistics for the current tenant. |
| oceanbase.DBA_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics for the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | This view displays the details of the system statistics for the current tenant. |
| oceanbase.DBA_WR_SYSTEM_EVENT | This view displays the persistent tenant-level wait event information of the current tenant. |
| oceanbase.CDB_WR_SQL_PLAN | This view displays the GV$OB_SQL_PLAN data collected by WR. |
| oceanbase.DBA_WR_SQL_PLAN | This view displays the GV$OB_SQL_PLAN data collected by WR. |
Foreign keys
| View name | Description |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | This view displays metadata information about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table of the InnoDB data dictionary.
NoteThis view is available only for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_SYS_FOREIGN_COLS | This view displays status information about InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table of the InnoDB data dictionary.
NoteThis view is available only for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
Materialized views
| View name | Description |
|---|---|
| oceanbase.CDB_MVIEW_RUNNING_JOBS | This view displays the materialized view-related tasks that are currently running for all tenants, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.DBA_MVIEW_DEPS | This view displays the dependencies of materialized views for the current tenant. |
| oceanbase.DBA_MVIEW_LOGS | This view displays the logs of materialized views. |
| oceanbase.DBA_MVIEW_RUNNING_JOBS | This view displays the materialized view-related tasks that are currently running for the current tenant, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.DBA_MVIEWS | This view displays the information about all materialized views. |
| oceanbase.DBA_MVREF_CHANGE_STATS | This view displays the statistics related to materialized view refreshes. |
| oceanbase.DBA_MVREF_RUN_STATS | This view displays the information about each refresh run of a materialized view. Each run is identified by a REFRESH_ID. |
| oceanbase.DBA_MVREF_STATS | This view displays the basic timing statistics about materialized view refreshes. |
| oceanbase.DBA_MVREF_STATS_PARAMS | This view displays the refresh statistics attributes associated with each materialized view. |
| oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS | This view displays the system-wide default values for the statistics attributes of materialized view refreshes. |
| oceanbase.DBA_MVREF_STMT_STATS | This view displays the information about the refresh statements. |
| oceanbase.CDB_MVIEW_LOGS | This view displays the logs of materialized views for all tenants. |
| oceanbase.CDB_MVIEWS | This view displays the information about all materialized views. |
| oceanbase.CDB_MVREF_CHANGE_STATS | This view displays the statistics related to materialized view refreshes. |
| oceanbase.CDB_MVREF_RUN_STATS | This view displays the information about each refresh run of a materialized view. Each run is identified by a REFRESH_ID. |
| oceanbase.CDB_MVREF_STATS | This view displays the basic timing statistics about materialized view refreshes. |
| oceanbase.CDB_MVREF_STATS_PARAMS | This view displays the refresh statistics attributes associated with each materialized view. |
| oceanbase.CDB_MVREF_STATS_SYS_DEFAULTS | This view displays the system-wide default values for the statistics attributes of materialized view refreshes. |
| oceanbase.CDB_MVREF_STMT_STATS | This view displays the information about the refresh statements. |
Vector index
| View | Description |
|---|---|
| oceanbase.CDB_OB_VECTOR_INDEX_TASKS | This view displays information about all vector index partition rebuild tasks in all tenants of the cluster. |
| oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY | This view displays the historical information about all vector index partition rebuild tasks in all tenants of the cluster. |
| oceanbase.DBA_OB_VECTOR_INDEX_TASKS | This view displays information about all vector index partition rebuild tasks in the current tenant. |
| oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY | This view displays the historical information about all vector index partition rebuild tasks in the current tenant. |
Major compaction
| View | Description |
|---|---|
| oceanbase.CDB_OB_MAJOR_COMPACTION | This view displays the global information about major compactions in all tenants under the sys tenant. |
| oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION | This view displays the information about major compactions in each zone of all tenants under the sys tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the information about major compactions in each zone of the current tenant. |
| oceanbase.CDB_OB_FREEZE_INFO | This view displays the version information generated by major compactions. |
| oceanbase.DBA_OB_FREEZE_INFO | This view displays the version information generated by major compactions. |
Tenant management
| View | Description |
|---|---|
| oceanbase.DBA_OBJECTS | This view displays all database objects in the database. The view definition is consistent with that of ALL_OBJECTS. |
| oceanbase.CDB_OBJECTS | This view displays the object information of all tenants under the sys tenant. |
| oceanbase.DBA_OB_TENANTS | This view displays the basic information about all tenants, including the sys tenant, user-created tenants (user tenants), and the meta tenant. You can use the TENANT_TYPE column to distinguish the types of tenants. |
| oceanbase.DBA_OB_TENANT_JOBS | This view displays the information about tasks at the tenant level. |
| oceanbase.CDB_OB_SYS_VARIABLES | This view displays the system variable information of all tenants under the sys tenant. |
| oceanbase.DBA_OB_CLONE_HISTORY | This view displays the information about completed clone tasks. |
| oceanbase.DBA_OB_CLONE_PROGRESS | This view displays the information about running clone tasks. |
| oceanbase.DBA_OB_SYS_VARIABLES | This view displays the configuration of system variables (including hidden variables whose names start with an underscore) of the current tenant. |
Resource management
| View name | Description |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | This view displays the resource pool information of all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | This view displays all unit-related tasks. |
| oceanbase.DBA_OB_UNITS | This view displays the unit information of all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | This view displays the unit specifications of all tenants. |
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | This view displays all SEQUENCEs in the database. |
| CDB_OB_RSRC_DIRECTIVES | This view displays the resource configuration parameters of all tenants in the Resource Manager. |
Auto-increment column
| View name | Description |
|---|---|
| oceanbase.CDB_OB_AUTO_INCREMENT | This view displays the information of all auto-increment columns in the current cluster. Only the sys tenant can view this view. |
| oceanbase.DBA_OB_AUTO_INCREMENT | This view displays the information of all auto-increment columns in the current tenant. |
Arbitration service
| View name | Description |
|---|---|
| oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS | Only the sys tenant can access this view. This view displays the arbitration service tasks running in the current tenant and corresponding user tenants. |
| oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY | Only the sys tenant can access this view. This view displays the history of arbitration service tasks executed by all tenants. |
| oceanbase.DBA_OB_ARBITRATION_SERVICE | Only the sys tenant can access this view. This view displays the arbitration service configuration information of the current cluster. |
| oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS | This view displays the arbitration service tasks running in the current tenant. |
| oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY | This view displays the history of arbitration service tasks executed by the current tenant. |
Overview of performance views
ASH related
| View name | Description |
|---|---|
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| GV$OB_ACTIVE_SESSION_HISTORY | Displays the active session history of all OBServer nodes in all tenants. |
| V$OB_ACTIVE_SESSION_HISTORY | Displays the active session history of the current OBServer node in all tenants. |
Catalog related
| View name | Description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | Displays the usage of the HMS Catalog clients in all tenants. |
| V$OB_HMS_CLIENT_POOL_STAT | Displays the usage of the HMS Catalog clients in all tenants. |
DTL related
| View name | Description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
Log replica related
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | Displays the status of Palf. |
| GV$OB_LS_SNAPSHOTS | Displays the information about the log stream snapshots stored in the persistent storage of all units. |
| V$OB_LOG_STAT | Displays the status of Palf. |
Partition related
| View name | Description |
|---|---|
| V$OB_DYNAMIC_PARTITION_TABLES | Displays the information about dynamic partition tables in all tenants. |
Shared storage
| View name | Description |
|---|---|
| V$OB_SS_SSTABLES | This view displays the SSTable information on the shared storage of all tenants. |
| GV$OB_SS_LOCAL_CACHE | This view displays the metrics of various types of cached data in the local cache of each OBServer node in shared storage mode for all tenants. |
| V$OB_SS_LOCAL_CACHE | This view displays the metrics of various types of cached data in the local cache of the current OBServer node in shared storage mode for all tenants. |
| GV$OB_STORAGE_CACHE_TASKS | This view displays the cache task information for all tenants on all OBServer nodes. |
| V$OB_STORAGE_CACHE_TASKS | This view displays the cache task information for all tenants on the current OBServer node. |
| GV$OB_TABLET_LOCAL_CACHE | This view displays the overall cache information for all tenants on all OBServer nodes. |
| V$OB_TABLET_LOCAL_CACHE | This view displays the overall cache information for all tenants on the current OBServer node. |
| GV$OB_SERVER_STORAGE | This view displays the information about the object storage configured in the shared storage cluster on all OBServer nodes. |
| V$OB_SERVER_STORAGE | This view displays the information about the object storage configured in the shared storage cluster on the current OBServer node. |
| GV$OB_SS_OBJECT_TYPE_IO_STAT | This view displays the read, write, or delete usage of different types of objects on each node of the tenant. |
| V$OB_SS_OBJECT_TYPE_IO_STAT | This view displays the read, write, or delete usage of different types of objects on the current node of the tenant. |
I/O performance
| View name | Description |
|---|---|
| GV$OB_SHARED_STORAGE_QUOTA | This view displays the I/O access resource information on all OBServer nodes. |
| V$OB_SHARED_STORAGE_QUOTA | This view displays the I/O access resource information on the current OBServer node. |
| GV$OB_IO_CALIBRATION_STATUS | This view displays the execution status of the I/O calibration task. |
| V$OB_IO_CALIBRATION_STATUS | This view displays the execution status of the I/O calibration task. |
| GV$OB_IO_BENCHMARK | This view displays the disk calibration data used by the I/O module. |
| V$OB_IO_BENCHMARK | This view displays the disk calibration data used by the I/O module. |
Plan cache
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | This view displays the overall status of each plan cache on all OBServer nodes for the current tenant. |
| V$OB_PLAN_CACHE_STAT | This view records the overall status of each plan cache on all servers for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache on all servers for the current tenant. |
| V$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache on the current server for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan caches on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache on the current server. |
Encrypted tables
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | This view displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | This view displays the encryption status of tablespaces with encryption enabled. |
Memory
| View name | Description |
|---|---|
| GV$OB_MEMORY | This view displays tenant-level memory statistics. |
| V$OB_MEMORY | This view displays tenant-level memory statistics. |
| GV$OB_MEMSTORE | This view displays the memory usage of MemTables for all tenants on all servers. |
| V$OB_MEMSTORE | This view displays tenant-level MemStore statistics. |
| GV$OB_MEMSTORE_INFO | This view displays the details of MemTables for all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | This view displays the details of MemTables for all partitions of all tenants on all servers. |
| GV$OB_SSTABLES | This view displays the SSTable information for the current tenant. |
| V$OB_SSTABLES | This view displays the SSTable information for the current tenant. |
| GV$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the current observer process. |
OBKV
| View name | Description |
|---|---|
| GV$OB_KV_GROUP_COMMIT_STATUS | In the sys tenant, the GV$OB_KV_GROUP_COMMIT_STATUS view can access the group commit status information of all OBKV tenant clients. |
| V$OB_KV_GROUP_COMMIT_STATUS | In the sys tenant, the V$OB_KV_GROUP_COMMIT_STATUS view can access the group commit status information of all OBKV tenant clients on the current node. |
| V$OB_VECTOR_MEMORY | This view displays detailed statistics of vector index data memory usage for all tenants. |
PS
| View name | Description |
|---|---|
| GV$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | This view provides monitoring capabilities for prepared statements, containing basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | This view provides monitoring capabilities for prepared statements, containing basic information about all prepared statements in the PS cache. |
PX
| View name | Description |
|---|---|
| GV$OB_PX_P2P_DATAHUB | This view displays information about parallel execution data transfer operations. |
| GV$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on OBServer nodes. |
Full-Link Tracing
| View name | Description |
|---|---|
| GV$OB_FLT_TRACE_CONFIG | This view displays diagnostic information about full-link tracing. |
Locks
| View name | Description |
|---|---|
| GV$LATCH | This view displays latch information for all OBServer nodes in the cluster. |
| V$LATCH | This view displays latch information for all OBServer nodes in the cluster. |
Event-related
| View name | Description |
|---|---|
| GV$OB_PROCESSLIST | This view displays session information on all OBServer nodes of the tenant. |
| GV$OB_TRANSACTION_PARTICIPANTS | This view displays transaction participant information on all OBServer nodes. |
| GV$SESSION_EVENT | This view displays session-level waiting events on all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | This view displays information about the current or previous waiting events of all sessions on all servers, including the waiting event name and waiting time. |
| GV$SESSION_WAIT_HISTORY | This view displays information about the last 10 waiting events of all sessions on all servers. |
| GV$SYSTEM_EVENT | This view displays tenant-level waiting events in the cluster. |
| GV$SESSTAT | This view displays session-level statistical events on all OBServer nodes. |
| GV$SYSSTAT | This view displays tenant-level statistical events on all servers. |
| V$OB_PROCESSLIST | This view displays session information on the current OBServer node. |
| V$OB_TRANSACTION_PARTICIPANTS | This view displays transaction participant information on all OBServer nodes. |
| V$STATNAME | This view displays the definitions of all statistical events. |
| V$EVENT_NAME | This view displays the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | This view displays the details of the current waiting events of each session. According to the agreement, each waiting event has three parameters, which will record the corresponding values. |
| V$SESSION_WAIT_HISTORY | This view displays the details of the current waiting events of each session, including the last 10 waiting events. |
| V$SESSTAT | This view displays the overview of session-level statistical events. |
| V$SYSSTAT | This view displays tenant-level statistical events on the current server. |
| V$SYSTEM_EVENT | This view displays tenant-level waiting events. |
| GV$SESSION_LONGOPS | This view displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | This view displays the execution status and progress of DDL operations on the current OBServer node. |
SQL audit
| View name | Description |
|---|---|
| GV$OB_SQL_AUDIT | This view displays the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | This view displays the source and execution status of each SQL request on the current server. |
Session
| View name | Description |
|---|---|
| GV$OB_SESSION | This view records the session information created on all servers. |
| V$SESSION_EVENT | This view displays the wait events of each session. |
Basic database information
| View name | Description |
|---|---|
| GV$OB_KVCACHE | This view displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | This view displays the configuration information on all OBServer nodes where the tenant is located. |
| GV$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| GV$OB_SERVERS | This view displays the information of all OBServer nodes. |
| GV$OB_UNITS | This view displays the unit information of the OBServer node where the tenant is located. The system tenant can view the unit information of all OBServer nodes in the cluster. |
| V$OB_KVCACHE | This view displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | This view displays the configuration information on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| V$OB_SERVERS | This view displays the information of the current OBServer node. |
| V$OB_UNITS | This view displays the unit information of the current OBServer node. |
| GV$DML_STATS | This view displays the DML information in the current user table. |
| V$DML_STATS | This view displays the DML information in the current user table. |
| V$OB_COMPATIBILITY_CONTROL | This view displays the features that can be controlled for compatibility with the product behavior of the OceanBase Database release version. |
Network-related views
| View name | Description |
|---|---|
| GV$OB_RPC_OUTGOING | This view displays the statistics of RPC packets sent from all OBServer nodes. |
| GV$OB_RPC_INCOMING | This view displays the statistics of RPC packets received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | This view displays the statistics of RPC packets sent from all OBServer nodes for different tenants. |
| V$OB_RPC_INCOMING | This view displays the statistics of RPC packets received by all OBServer nodes for different tenants. |
Workarea-related views
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | This view displays the statistics of workareas for all operators executed by SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | This view displays the statistics of workareas for active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of workareas executed in the past, such as the number of times full in-memory processing is performed in the 1M-2M range and the number of one-pass operations. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This view displays some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory. |
| V$SQL_WORKAREA | This view displays the statistics of workareas for all operators executed by SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | This view displays the statistics of workareas for active operators. |
| V$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of workareas executed in the past, such as the number of times full in-memory processing is performed in the 1M-2M range and the number of one-pass operations. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This view displays some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory. |
WR-related
| View name | Description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view is available starting with OceanBase Database V2.2. |
| GV$OB_RES_MGR_SYSSTAT | This view is available starting with OceanBase Database V2.2. |
| GV$OB_SESS_TIME_MODEL | This view is available starting with OceanBase Database V2.2. |
| GV$OB_SQLSTAT | This view is available starting with OceanBase Database V2.2. |
| GV$OB_SYS_TIME_MODEL | This view is available starting with OceanBase Database V2.2. |
| V$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view is available starting with OceanBase Database V2.2. |
| V$OB_RES_MGR_SYSSTAT | This view is available starting with OceanBase Database V2.2. |
| V$OB_SESS_TIME_MODEL | This view is available starting with OceanBase Database V2.2. |
| V$OB_SQLSTAT | This view is available starting with OceanBase Database V2.2. |
| V$OB_SYS_TIME_MODEL | This view is available starting with OceanBase Database V2.2. |
Vector index-related
| View name | Description |
|---|---|
| GV$OB_HNSW_INDEX_INFO | This view is available starting with OceanBase Database V2.2. |
| GV$OB_IVF_INDEX_INFO | This view is available starting with OceanBase Database V2.2. |
| GV$OB_VECTOR_MEMORY | This view is available starting with OceanBase Database V2.2. |
| V$OB_HNSW_INDEX_INFO | This view is available starting with OceanBase Database V2.2. |
| V$OB_IVF_INDEX_INFO | This view is available starting with OceanBase Database V2.2. |
Thread-related
| View Name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | This view displays the execution information of each thread in parallel execution scenarios. |
| V$OB_PX_WORKER_STAT | This view displays the execution information of each thread in parallel execution scenarios. |
| GV$OB_TENANT_RUNTIME_INFO | This view displays the information about queues and thread limits in tenant threads. |
| V$OB_TENANT_RUNTIME_INFO | This view displays the information about queues and thread limits in tenant threads. |
Execution plan-related
| View Name | Description |
|---|---|
| GV$SQL_PLAN_MONITOR | This view displays the statistics of slow queries on all OBServer nodes at the plan level. Each slow query has one statistical record, and the trace information of the plan is recorded. |
| V$SQL_PLAN_MONITOR | This view displays the statistics of slow queries at the operation level. Each operation has one statistical record. |
| V$SQL_MONITOR_STATNAME | This view displays the meaning of the numbers in the OTHERSTAT_X_ID field of the GV$SQL_PLAN_MONITOR view. |
Views related to major compactions
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | This view displays the statistics of major compactions completed in the OceanBase cluster. |
| V$OB_MERGE_INFO | This view displays the statistics of major compactions completed in the OceanBase cluster. |
| GV$OB_COMPACTION_PROGRESS | This view displays the OBServer-level major compaction progress of the tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | This view displays the suggestions for major compactions. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | This view displays the diagnostic information of major compactions. |
| GV$OB_TABLET_COMPACTION_HISTORY | This view displays the historical information of tablet-level major compactions. |
| GV$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress of tablet-level major compactions. |
| V$OB_COMPACTION_PROGRESS | This view displays the server-level major compaction progress of the tenant. |
| V$OB_COMPACTION_SUGGESTIONS | This view displays the suggestions for major compactions. |
| V$OB_COMPACTION_DIAGNOSE_INFO | This view displays the diagnostic information of major compactions. |
| V$OB_TABLET_COMPACTION_HISTORY | This view displays the historical information of tablet-level major compactions. |
| V$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress of tablet-level major compactions. |
Views related to resource management
| View name | Description |
|---|---|
| GV$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on all OBServer nodes for all tenants. |
| GV$OB_FUNCTION_IO_STAT | This view displays the function-level I/O statistics on all OBServer nodes for all tenants. |
| V$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on the current OBServer node for all tenants. |
| V$OB_FUNCTION_IO_STAT | This view displays the function-level I/O statistics on the current OBServer node for all tenants. |
Views in a MySQL tenant
Dictionary views overview
Security and privileges
| View | Purpose |
|---|---|
| mysql.db | This view displays database-level privileges (VIRTUAL_TABLE). |
| mysql.user | This view records user-level privileges (VIRTUAL_TABLE). |
| information_schema.COLUMN_PRIVILEGES | This view displays column privileges. |
| information_schema.SCHEMA_PRIVILEGES | This view describes database privileges. |
| information_schema.TABLE_PRIVILEGES | This view records table privileges. |
| information_schema.USER_PRIVILEGES | This view records user privileges. |
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | This view displays the number of failed login attempts for different users. |
| information_schema.ROLE_TABLE_GRANTS | This view displays the table-level privileges granted to activated roles for the current session, as well as the table-level privileges granted to other roles by these roles. |
| information_schema.ROLE_COLUMN_GRANTS | This view displays the column privileges granted to activated roles for the current session, as well as the column privileges granted to other roles by these roles. |
| information_schema.ROLE_ROUTINE_GRANTS | This view displays the routine privileges granted to activated roles for the current session, as well as the routine privileges granted to other roles by these roles. |
| oceanbase.DBA_OB_TRUSTED_ROOT_CERTIFICATE | This view displays the list of trusted CA root certificates in the OBServer cluster and their expiration times. |
| oceanbase.DBA_OB_SENSITIVE_COLUMNS | This view displays all columns protected by sensitive rules. |
| oceanbase.DBA_OB_SENSITIVE_RULES | This view displays the definitions and attributes of all sensitive rules. |
| oceanbase.DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS | This view displays all users or roles with plain-text data access permissions for columns associated with a sensitive rule. |
Backup and restore
| View name | Description |
|---|---|
| oceanbase.DBA_OB_BACKUP_JOBS | This view displays backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | This view displays the history of backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | This view displays the history of backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | This view displays the history of task-level backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | This view displays the status of files in a backup set. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | This view displays the progress of ongoing restore tasks. |
| oceanbase.DBA_OB_RESTORE_HISTORY | This view displays the history of completed restore tasks. |
| oceanbase.DBA_OB_ARCHIVE_DEST | This view displays the archive path configuration. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | This view displays information about the backup destination used for backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the history of information about the backup destination used for backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | This view displays the deletion policy set for expired or automatic cleanup in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | This view displays the progress of tenant-level backup cleanup jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of backup cleanup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | This view displays information about backup_set/backup_piece cleanup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of completed backup_set/backup_piece cleanup tasks in the current tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | This view displays the status of log backups on each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | This view displays the status of all log backups, including historical and current ones. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of pieces in a backup set. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOBS | This view displays information about table-level recovery tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | This view displays information about import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | This view displays records of table-level import tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | This view displays the results of table-level recovery tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | This view displays the results of import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the history of cross-tenant table-level import tasks. |
Views and columns
| View name | Description |
|---|---|
| information_schema.COLUMNS | Records column information. |
| information_schema.STATISTICS | Records table index information. |
| information_schema.TABLES | Records table information. |
| information_schema.VIEWS | Records view information. |
| information_schema.VIEW_TABLE_USAGE | Displays information about tables and views used in view definitions. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the association between TABLEGROUP and TABLE. Tables not in a TABLEGROUP are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays columns in the partitioning keys of all partitioning objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays columns in the subpartitioning keys of all partitioning objects in the database. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the location of a table or partition, including system tables, user tables, and index tables. |
| oceanbase.DBA_OB_TABLE_SPACE_USAGE | Displays the size of all user tables (based on the leader replica in a multi-replica environment) in the current tenant. |
| information_schema.TABLESPACES | Information about tablespaces.
NoteThis view is provided only for MySQL 5.7 compatibility. You can query only the table structure. |
Triggers
| View name | Description |
|---|---|
| information_schema.TRIGGERS | Displays the CREATE TRIGGER statement used to create a trigger. |
Storage
| View name | Description |
|---|---|
| mysql.proc | Displays information about stored procedures. |
| mysql.func | Not provided. |
| information_schema.ENGINES | Records information about storage engines. |
| information_schema.PARAMETERS | Displays information about parameters and return values of stored procedures. |
| information_schema.ROUTINES | Displays information about stored procedures. |
Load balancing
| View name | Description |
|---|---|
| oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT | This view displays all partitions with special weights in the current user tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | This view displays the Transfer Partition tasks being processed in the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of Transfer Partition tasks executed in the current tenant. |
Partition
| View name | Description |
|---|---|
| information_schema.PARTITIONS | This view records partition information. |
| oceanbase.DBA_IND_PARTITIONS | This view displays the primary partitions of indexes. |
| oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES | This view displays the dynamic partition table information in the current tenant. |
| oceanbase.DBA_PART_INDEXES | This view displays the partition information of all partition indexes. |
| oceanbase.DBA_PART_TABLES | This view displays the partition information of user tables. |
| oceanbase.DBA_TAB_PARTITIONS | This view displays the multi-level partition information, partition storage parameters, and partition statistics of partitions accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | This view displays the subpartition name, table name, partition name, storage attributes, and statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | This view displays the description information of all subpartition templates. |
| oceanbase.DBA_IND_SUBPARTITIONS | This view displays the information of all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | This view displays the primary partition information of the partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of the partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUPS | This view displays the metadata of the table group, mainly the partition information of the table group. |
Replica log related
| View name | Description |
|---|---|
| oceanbase.DBA_OB_CS_REPLICA_STATS | This view displays the progress of converting tablets to columnar storage in the log stream of C replicas on all OBServer nodes of the current tenant. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays all tablet replicas of the current tenant. Each tablet replica is uniquely identified by the joint key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | This view displays all tablets of the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | This view displays the distribution of log stream (LS) replicas of the current tenant. |
Shared storage related
| View name | Description |
|---|---|
| DBA_OB_SS_SPACE_USAGE | This view records the storage space usage on the object storage of the current tenant. |
Help command related
| View name | Description |
|---|---|
| mysql.help_topic | This view generates the Help command in conjunction with the three tables mysql.help_category, mysql.help_relation, and mysql.help_keyword. |
| mysql.help_category | This view generates the Help command in conjunction with the three tables mysql.help_relation, mysql.help_topic, and mysql.help_keyword. |
| mysql.help_keyword | This view generates the Help command in conjunction with the three tables mysql.help_relation, mysql.help_topic, and mysql.help_category. |
| mysql.help_relation | This view generates the Help command in conjunction with the three tables mysql.help_category, mysql.help_topic, and mysql.help_keyword. |
I/O performance related
| View name | Description |
|---|---|
| DBA_OB_STORAGE_IO_USAGE | This view displays the I/O operations on the object storage and cloud disks of the current tenant. |
InnoDB storage engine
| View name | Description |
|---|---|
| information_schema.INNODB_LOCK_WAITS | This view displays information about the locks that are being waited on when lock conflicts occur.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_LOCKS | This view displays information about all current locks (waiting and held).
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP | This view displays the mapping information between NDB transactions, NDB transaction coordinators, and MySQL servers connected as API nodes to the NDB cluster.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_TRX | This view displays information about active transactions.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE | This view displays information about all cached pages in the buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE_LRU | This view displays the LRU-sorted information about pages in the InnoDB buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_BUFFER_POOL_STATS | This view displays statistics about the InnoDB buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMP | This view displays the operation status information related to compressing InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX | This view displays the operation information related to compressing InnoDB tables and indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | This view displays the reset time information related to operations on compressed InnoDB tables and indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMP_RESET | This view displays the operation status related to compressing InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMPMEM | This view displays the status of compressed pages in the InnoDB buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMPMEM_RESET | This view displays the reset time status of compressed pages in the InnoDB buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_DATAFILES | This view displays the data file path information for each table and general tablespace in the InnoDB file.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_INDEXES | This view displays the InnoDB index metadata information.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_TABLES | This view displays the InnoDB table metadata information.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_TABLESPACES | This view displays the metadata of InnoDB table files and general tablespaces.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_TABLESTATS | This view displays the low-level status information of InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_VIRTUAL | This view displays the metadata of InnoDB virtual generated columns.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_TEMP_TABLE_INFO | This view displays information about active InnoDB temporary tables created by users.
NoteThis view is available starting with MySQL 5.7. |
| information_schema.INNODB_METRICS | This view displays InnoDB performance information.
NoteThis view is available starting with MySQL 5.7. |
Spatial
| View name | Description |
|---|---|
| information_schema.ST_GEOMETRY_COLUMNS | This view displays tables that contain spatial data columns and spatial data types. |
| information_schema.ST_SPATIAL_REFERENCE_SYSTEMS | This view displays the spatial reference coordinate systems supported by the system. |
OBKV
| View name | Description |
|---|---|
| oceanbase.DBA_OB_KV_TTL_TASKS | This view displays the TTL tasks that are being executed in the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | This view displays the historical TTL tasks in the current tenant. |
| V$OB_KV_CLIENT_INFO | This view displays the configuration parameters of the client connections for the OBKV tenant on the current node. |
| GV$OB_KV_CLIENT_INFO | This view displays the configuration parameters of the client connections for the OBKV tenant. |
| oceanbase.DBA_OB_KV_REDIS_TABLE | This view stores the specific commands of various data structures in the Redis tenant and the corresponding storage table names. |
Outline
| View name | Description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | This view displays the execution plan outlines of the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | This view displays the outline information of the throttling rules of the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | This view displays the execution plan and throttling rule outline history information of the current tenant. |
| DBA_OB_FORMAT_OUTLINES | This view records the detailed information of the current tenant's format outline. |
Full-text index
| View name | Description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | This view displays the information of the full-text indexes that are being deleted.
NoteThis view is for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_FT_CONFIG | This view displays the configuration information of the InnoDB full-text search engine.
NoteThis view is for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_FT_DELETED | This view displays the information of the full-text indexes that have been marked for deletion.
NoteThis view is for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_FT_INDEX_CACHE | This view displays the cache status information of the InnoDB full-text indexes.
NoteThis view is for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_SYS_FIELDS | This view displays the metadata information of the key columns (fields) of the InnoDB indexes, which is equivalent to the information in the SYS_FIELDS table of the InnoDB data dictionary.
NoteThis view is for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
Task scheduling
| View name | Description |
|---|---|
| oceanbase.DBA_SCHEDULER_JOBS | This view displays the information of all scheduler jobs in the database. |
Event history monitoring
| View name | Description |
|---|---|
| information_schema.events | This view records the information of all events. |
Time zone-related
| View name | Description |
|---|---|
| mysql.time_zone | This view displays information related to time zones (SYSTEM_VIEW). |
| mysql.time_zone_name | This view records the names of time zones (SYSTEM_VIEW). |
| mysql.time_zone_transition | mysql.time_zone_transition is a system view that records information about time zone transitions. |
| mysql.time_zone_transition_type | This view records the types of time zone transitions (SYSTEM_VIEW). |
Basic database information-related
| View name | Description |
|---|---|
| information_schema.GLOBAL_STATUS | This view records the global status information of OceanBase Database. |
| information_schema.GLOBAL_VARIABLES | This view records global variables. |
| information_schema.SCHEMATA | This view records database metadata. |
| oceanbase.DBA_OB_DATABASES | This view displays the metadata of databases in a tenant. |
Audit-related
| View name | Description |
|---|---|
| mysql.audit_log_filter | This view displays the definitions of audit filters. |
| mysql.audit_log_user | This view displays the mapping between audit filters and users. |
SPM-related
| View name | Description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | This view displays the plan baselines of SQL statements in SPM. |
| oceanbase.DBA_SQL_MANAGEMENT_CONFIG | This view displays the configuration parameters in SPM. |
| oceanbase.DBA_OB_SPM_EVO_RESULT | This view displays the plan evolution information of SPM in a tenant. |
Session-related
| View name | Description |
|---|---|
| information_schema.SESSION_STATUS | This view records the status information of a session, such as the number of active connections and the database uptime. |
| information_schema.SESSION_VARIABLES | This view records the variable information of a session. |
Statistics and histogram related
| View name | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | This view displays the optimizer statistics of all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | This view displays the column statistics and histogram information of all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | This view displays the column statistics and histogram information of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | This view displays the histograms of all columns in all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | This view displays the histogram data (endpoints of each histogram) of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | This view displays the histogram data (endpoints of each histogram) of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | This view displays the table statistics history of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | This view displays the optimizer statistics of all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | This view displays the cumulative modification information of tables in the database. |
| information_schema.QUERY_RESPONSE_TIME | This view displays the histogram data (such as response time) for Prometheus monitoring. |
| oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | This view queries the historical collection execution status of tables. |
| oceanbase.CDB_OB_AUX_STATISTICS | This view displays the auxiliary statistics of all tenants. |
| information_schema.OPTIMIZER_TRACE | This view is only for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
Materialized view views
| View | Purpose |
|---|---|
| oceanbase.DBA_MVIEW_DEPS | This view displays the dependencies of materialized views in the current tenant. |
| oceanbase.DBA_MVIEW_LOGS | This view displays the logs of materialized views. |
| oceanbase.DBA_MVIEW_RUNNING_JOBS | This view displays the running materialized view-related tasks, including refresh tasks and MLOG cleanup tasks, in the current tenant. |
| oceanbase.DBA_MVIEWS | This view displays the information of all materialized views. |
| oceanbase.DBA_MVREF_CHANGE_STATS | This view displays the statistics related to materialized view refreshes. |
| oceanbase.DBA_MVREF_RUN_STATS | This view displays the information about each refresh run of a materialized view. Each refresh run is identified by a REFRESH_ID. |
| oceanbase.DBA_MVREF_STATS | This view displays the basic timing statistics of materialized view refreshes. |
| oceanbase.DBA_MVREF_STATS_PARAMS | This view displays the refresh statistics properties associated with each materialized view. |
| oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS | This view displays the system-wide default values of the statistics properties of materialized view refreshes. |
| oceanbase.DBA_MVREF_STMT_STATS | This view displays the information about the refresh statements. |
WR related
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | This view displays the SNAPSHOT information of the current tenant. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data of the current tenant after persistence. |
| oceanbase.DBA_WR_STATNAME | This view displays the names of the system statistics of the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | This view displays the details of the system statistics of the current tenant. |
| oceanbase.DBA_WR_CONTROL | This view displays the configuration information related to WR. |
| oceanbase.DBA_WR_SYSTEM_EVENT | This view displays the tenant-level wait event information of the current tenant after persistence. |
| oceanbase.DBA_WR_EVENT_NAME | This view displays the tenant-level wait event names of the current tenant after persistence. |
| oceanbase.DBA_WR_SQLTEXT | This view displays the SQL texts collected by WR for the current tenant. |
| oceanbase.DBA_WR_SQLSTAT | This view displays the basic performance statistics of the SQL statements executed by the current tenant. Each SQL statement is represented by a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
| oceanbase.DBA_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics of the current tenant. |
| oceanbase.DBA_WR_SQL_PLAN | This view displays the GV$OB_SQL_PLAN data collected by WR. |
Foreign key related
| View name | Description |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | This view displays the metadata information of InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table of the InnoDB data dictionary.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_SYS_FOREIGN_COLS | This view displays the status information of InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table of the InnoDB data dictionary.
NoteThis view is only for compatibility with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
Thread related
| View name | Description |
|---|---|
| information_schema.PROCESSLIST | This view displays the information of running threads. |
Constraint related
| View name | Description |
|---|---|
| information_schema.CHECK_CONSTRAINTS | This view displays the constraint information of tables and columns during the CREATE TABLE operation. |
| information_schema.KEY_COLUMN_USAGE | This view records the constraint information of keys in the Column. |
| information_schema.REFERENTIAL_CONSTRAINTS | This view displays the metadata of foreign key constraints. |
| information_schema.TABLE_CONSTRAINTS | This view describes the table constraint information. |
Major compaction
| View name | Description |
|---|---|
| oceanbase.DBA_OB_MAJOR_COMPACTION | This view displays the global major compaction information of the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the major compaction information of each zone in the current tenant. |
| oceanbase.DBA_OB_FREEZE_INFO | This view displays the version information generated by major freeze. |
Resource management
| View name | Description |
|---|---|
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | This view displays all SEQUENCE objects in the database. |
| DBA_OB_RSRC_DIRECTIVES | This view displays the resource configuration parameters of the current tenant in the Resource Manager. |
| DBA_OB_RSRC_IO_DIRECTIVES | This view displays the IO resource configuration of the current tenant in the Resource Manager. |
| DBA_RSRC_GROUP_MAPPINGS | This view displays the binding relationships between users and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | This view displays the information of all resource groups in the database. |
| DBA_RSRC_PLANS | This view displays all resource management plans defined by the system. |
| DBA_RSRC_PLAN_DIRECTIVES | This view displays the detailed information of each resource plan directive in the database. |
Tenant management
| View name | Description |
|---|---|
| oceanbase.DBA_OBJECTS | This view displays all database objects in the database. The view definition is consistent with ALL_OBJECTS. |
| oceanbase.DBA_OB_TENANTS | This view displays the basic information of all tenants, including the sys tenant, user-created tenants (user tenants), and the meta tenant. You can use the TENANT_TYPE column to distinguish the types of tenants. |
| oceanbase.DBA_OB_LICENSE | This view displays the license information currently loaded by the user. |
Character set
| View name | Description |
|---|---|
| information_schema.CHARACTER_SETS | This view records the character set information of OceanBase Database. |
| information_schema.COLLATIONS | This view records the collation method information of each character set. |
| information_schema.COLLATION_CHARACTER_SET_APPLICABILITY | This view records the correspondence between Character and Collation. |
Overview of performance views
ASH related
| View name | Purpose |
|---|---|
| GV$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$OB_ACTIVE_SESSION_HISTORY | This view displays the active session history of the current OBServer node in the current tenant. |
| GV$OB_ACTIVE_SESSION_HISTORY | This view displays the active session history of all OBServer nodes in the current tenant. |
Catalog related
| View name | Purpose |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This view displays the usage of the HMS Catalog client in the current tenant. |
| V$OB_HMS_CLIENT_POOL_STAT | This view displays the usage of the HMS Catalog client in the current tenant. |
DTL related
| View name | Purpose |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | This view displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | This view displays the monitoring information of the DTL intermediate result manager. |
Log replica related
| View name | Purpose |
|---|---|
| GV$OB_LOG_STAT | This view displays the status of Palf. |
| V$OB_LOG_STAT | This view displays the status of Palf. |
Partition related
| View name | Purpose |
|---|---|
| V$OB_DYNAMIC_PARTITION_TABLES | This view displays the dynamic partition table information in the current tenant. |
Shared storage
| View name | Description |
|---|---|
| V$OB_SS_SSTABLES | This view displays information about SSTables on shared storage for the current tenant. |
| GV$OB_SS_LOCAL_CACHE | This view displays metrics about various types of cached data in the local cache of each OBServer node for all tenants in shared storage mode. |
| V$OB_SS_LOCAL_CACHE | This view displays metrics about various types of cached data in the local cache of the current OBServer node for all tenants in shared storage mode. |
| GV$OB_STORAGE_CACHE_TASKS | This view displays information about cache tasks on all OBServer nodes for the current tenant. |
| V$OB_STORAGE_CACHE_TASKS | This view displays information about cache tasks on the current OBServer node for the current tenant. |
| GV$OB_TABLET_LOCAL_CACHE | This view displays overall cache information on all OBServer nodes for the current tenant. |
| V$OB_TABLET_LOCAL_CACHE | This view displays overall cache information on the current OBServer node for the current tenant. |
I/O
| View name | Description |
|---|---|
| GV$OB_SHARED_STORAGE_QUOTA | This view displays information about I/O access resources on all OBServer nodes. |
| V$OB_SHARED_STORAGE_QUOTA | This view displays information about I/O access resources on the current OBServer node. |
Encrypted tables
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | This view displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | This view displays the encryption status of tablespaces with encryption enabled. |
Memory-related
| View name | Description |
|---|---|
| GV$OB_MEMORY | This view displays the memory statistics at the tenant level. |
| V$OB_MEMORY | This view displays the memory statistics at the tenant level. |
| GV$OB_MEMSTORE | This view displays the memory usage of MemTables for all tenants on all servers. |
| V$OB_MEMSTORE | This view displays the MemStore statistics at the tenant level. |
| GV$OB_MEMSTORE_INFO | This view displays the details of MemTables for all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | This view displays the details of MemTables for all partitions of all tenants on all servers. |
| GV$OB_SSTABLES | This view displays the SSTable information of a tenant. |
| V$OB_SSTABLES | This view displays the SSTable information of a tenant. |
| GV$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the current observer process. |
OBKV-related
| View name | Description |
|---|---|
| GV$OB_KVCACHE | This view displays the KVCACHE information on each OBServer node. |
| V$OB_KVCACHE | This view displays the KVCACHE information on each OBServer node. |
Event-related
| View name | Description |
|---|---|
| GV$OB_PROCESSLIST | This view displays session information on all OBServer nodes of the tenant. |
| GV$OB_TRANSACTION_PARTICIPANTS | This view displays transaction participant information on all OBServer nodes. |
| GV$SESSION_EVENT | This view displays session-level waiting events on all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | This view displays information about the current or previous waiting events of all sessions on all servers, including the event name and waiting time. |
| GV$SESSION_WAIT_HISTORY | This view displays information about the most recent 10 waiting events of all sessions on all servers. |
| GV$SYSTEM_EVENT | This view displays waiting events at the tenant level in the cluster. |
| GV$SESSTAT | This view displays session-level statistical events on all OBServer nodes. |
| GV$SYSSTAT | This view displays tenant-level statistical events on all servers. |
| V$OB_PROCESSLIST | This view displays session information on the current OBServer node. |
| V$STATNAME | This view displays the definitions of all statistical events. |
| V$EVENT_NAME | This view displays the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | This view displays the details of the current waiting events of each session. Each waiting event has three parameters, and each parameter records a corresponding value. |
| V$SESSION_WAIT_HISTORY | This view displays the details of the current waiting events of each session and the most recent 10 waiting events. |
| V$SESSTAT | This view displays the statistical events at the session level. |
| V$SYSSTAT | This view displays tenant-level statistical events on the current server. |
| V$SYSTEM_EVENT | This view displays tenant-level waiting event statistics. |
| GV$SESSION_LONGOPS | This view displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | This view displays the execution status and progress of DDL operations on the current OBServer node. |
Basic database information
| View name | Description |
|---|---|
| GV$OB_PARAMETERS | This view displays the parameter information on all OBServer nodes of the tenant. |
| GV$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| GV$OB_UNITS | This view displays the unit information on the OBServer node of the tenant. The system tenant can view the unit information on all OBServer nodes in the cluster. |
| V$OB_PARAMETERS | This view displays the parameter information on the OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| V$OB_UNITS | This view displays the unit information on the OBServer node. |
| GV$DML_STATS | This view displays the DML information in the current user table. |
| V$DML_STATS | This view displays the DML information in the current user table. |
| V$OB_COMPATIBILITY_CONTROL | This view displays the features that can be controlled for compatibility with the OceanBase Database release version. |
| GV$OB_KV_CONNECTIONS | This view displays the statistics of OBKV connections on all servers. |
| V$OB_KV_CONNECTIONS | This view displays the statistics of OBKV connections on the current server. |
Locks
| View name | Description |
|---|---|
| GV$LATCH | This view displays the latch information on all OBServer nodes in the cluster. |
| V$LATCH | This view displays the latch information on all OBServer nodes in the cluster. |
SQL related
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | This view displays the overall status of each plan cache on all OBServer nodes for the current tenant. |
| V$OB_PLAN_CACHE_STAT | This view records the overall status of each plan cache on all servers for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache on all servers for the current tenant. |
| V$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache on the current server for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache on the current server. |
| GV$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | This view provides monitoring functionality for prepared statements, containing basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | This view provides monitoring functionality for prepared statements, containing basic information about all prepared statements in the PS cache. |
| GV$OB_SESSION_PS_INFO | This view displays the PS information opened by all sessions for the current tenant. |
| V$OB_SESSION_PS_INFO | This view displays the PS information opened by all sessions for the current OBServer tenant. |
| GV$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on the OBServer node. |
| GV$OB_SQL_AUDIT | This view displays the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | This view displays the source and execution status of each SQL request on the current server. |
| GV$SQL_PLAN_MONITOR | This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistic, and the trace information of the plan is recorded. |
| V$SQL_PLAN_MONITOR | This view displays the operation-level statistics of slow queries. Each operation has a corresponding statistic. |
| V$SQL_MONITOR_STATNAME | This view displays the meaning of the numbers in the OTHERSTAT_X_ID column of GV$SQL_PLAN_MONITOR. |
| GV$OB_FLT_TRACE_CONFIG | This view displays the diagnostic information of full-link tracing. |
| GV$OB_PLAN_CACHE_REFERENCE_INFO | This view displays the plan cache reference information of all tenants on all OBServer nodes. |
| V$OB_PLAN_CACHE_REFERENCE_INFO | This view displays the plan cache reference information of all tenants on the current OBServer node. |
Workarea-related views
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | This view displays the workarea statistics for all operators that were executed under SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | This view displays the workarea information for the currently active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | This view displays the statistics for all workarea executions, such as the number of times full in-memory processing occurred between 1 MB and 2 MB, and the number of one-pass operations. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory. |
| V$SQL_WORKAREA | This view displays the workarea statistics for all operators that were executed under SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | This view displays the workarea information for the currently active operators. |
| V$SQL_WORKAREA_HISTOGRAM | This view displays the statistics for all workarea executions, such as the number of times full in-memory processing occurred between 1 MB and 2 MB, and the number of one-pass operations. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some overall information about the SQL workarea, including the maximum available memory, current used memory, and current held memory. |
WR-related views
| View name | Description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view queries the histogram information of the query execution time for all nodes in the current tenant. |
| GV$OB_RES_MGR_SYSSTAT | This view displays the statistics of resource groups in all OBServer nodes of the current tenant. |
| GV$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row (each unique combination of SQL_ID and Plan_Hash is a row). |
| V$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (each unique combination of SQL_ID and Plan_Hash is a row). |
| GV$OB_SESS_TIME_MODEL | This view displays the session-level Time Model statistics in the cluster. |
| V$OB_SESS_TIME_MODEL | This view displays the session-level Time Model statistics on the current node. |
| GV$OB_SYS_TIME_MODEL | This view displays the tenant-level Time Model statistics in the cluster. |
| V$OB_SYS_TIME_MODEL | This view displays the tenant-level Time Model statistics on the current node. |
| V$OB_RES_MGR_SYSSTAT | This view displays the statistics of resource groups in the current OBServer node of the current tenant. |
Network-related
| View Name | Description |
|---|---|
| GV$OB_RPC_OUTGOING | This view displays the statistics of RPC packets sent by all OBServer nodes. |
| GV$OB_RPC_INCOMING | This view displays the statistics of RPC packets received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | This view displays the statistics of RPC packets sent by different tenants on each OBServer node. |
| V$OB_RPC_INCOMING | This view displays the statistics of RPC packets received by different tenants on each OBServer node. |
Thread-related
| View Name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | This view displays the execution information of each thread in parallel execution scenarios. |
| V$OB_PX_WORKER_STAT | This view displays the execution information of each thread in parallel execution scenarios. |
Views related to major compactions
| View | Purpose |
|---|---|
| GV$OB_MERGE_INFO | This view displays the statistics of major compactions completed in the OceanBase cluster. |
| V$OB_MERGE_INFO | This view displays the statistics of major compactions completed in the OceanBase cluster. |
| GV$OB_COMPACTION_PROGRESS | This view displays the OBServer-level major compaction progress of a tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | This view displays the suggestions for major compactions. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | This view displays the diagnostic information of major compactions. |
| GV$OB_TABLET_COMPACTION_HISTORY | This view displays the historical information of tablet-level major compactions. |
| GV$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress of tablet-level major compactions. |
| V$OB_COMPACTION_PROGRESS | This view displays the server-level major compaction progress of a tenant. |
| V$OB_COMPACTION_SUGGESTIONS | This view displays the suggestions for major compactions. |
| V$OB_COMPACTION_DIAGNOSE_INFO | This view displays the diagnostic information of major compactions. |
| V$OB_TABLET_COMPACTION_HISTORY | This view displays the historical information of tablet-level major compactions. |
| V$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress of tablet-level major compactions. |
| V$OB_TRANSACTION_PARTICIPANTS | This view displays the information about transaction participants on all OBServer nodes. |
Resource management
| View name | Purpose |
|---|---|
| GV$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on all OBServer nodes in the current tenant. |
| GV$OB_FUNCTION_IO_STAT | This view displays the I/O statistics at the Function level on all OBServer nodes in the current tenant. |
| V$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on the current OBServer node in the current tenant. |
| V$OB_FUNCTION_IO_STAT | This view displays the I/O statistics at the Function level on the current OBServer node in the current tenant. |
| GV$OB_CGROUP_CONFIG | This view allows you to quickly query the cgroup configurations of all OBServer nodes. |
| V$OB_CGROUP_CONFIG | This view allows you to quickly query the cgroup configurations of the current OBServer node. |
Views in an Oracle tenant
Dictionary views
Applicability
This topic applies only to OceanBase Database Enterprise Edition.
Security privileges
| View | Description |
|---|---|
| ALL_USERS | This view displays all database users visible to the current user. |
| DBA_USERS | This view displays all database users. |
| USER_USERS | This view displays information about the current user. |
| ALL_COL_PRIVS | This view displays column object privileges granted to the current user as the owner, grantor, or grantee. Column object privileges granted to enabled roles or PUBLIC are also displayed. |
| ALL_TAB_PRIVS |
|
| DBA_COL_PRIVS | This view displays all column object grants in the database. |
| DBA_SYS_PRIVS | This view displays system privileges granted to users and roles. |
| DBA_TAB_PRIVS | This view displays all object grants in the database. |
| USER_TAB_PRIVS | This view displays object privileges owned by the current user. |
| USER_COL_PRIVS | This view displays column object privileges granted to the current user as the owner, grantor, or grantee. |
| USER_ROLE_PRIVS | This view displays roles granted to the current user. |
| USER_SYS_PRIVS | This view displays system privileges granted to the current user. |
| ROLE_TAB_PRIVS | This view displays table privileges granted to roles. Only information about roles accessible to users is provided. |
| ROLE_SYS_PRIVS | This view displays system privileges granted to roles. |
| ROLE_ROLE_PRIVS | This view displays roles granted to other roles. Only information about roles accessible to users is provided. |
| DBA_ROLE_PRIVS | This view displays roles granted to all users and roles in the database. |
| DBA_ROLES | This view displays all roles existing in the database. |
| ALL_DIRECTORIES | This view displays all directories accessible to the current user. |
| DBA_DIRECTORIES | This view displays all directories accessible to the current user. |
| DBA_OB_DATABASE_PRIVILEGE | This view displays the privileges that the current tenant has over the current user. |
| DBMS_LOCK_ALLOCATED | This view displays information about DBMS_LOCK that has been applied but has not expired. |
| PROXY_USERS | This view displays proxy information between users. |
| DBA_OB_USER_DEFINED_RULES | This view records the rules for rewriting SQL statements in the current tenant. |
| DBA_OB_SENSITIVE_COLUMNS | This view displays all columns protected by sensitive rules. |
| DBA_OB_SENSITIVE_RULES | This view displays the definitions and attributes of all sensitive rules. |
| DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS | This view displays all users or roles with plaintext data access permissions for columns associated with a sensitive rule. |
Security policy-related
| View | Description |
|---|---|
| ALL_POLICIES | This view displays the access control policies that the current user can access. When you apply access control to a table, you can create multiple policies for the table. |
| ALL_POLICY_CONTEXTS | This view displays the context information of the views that the current user can access. When you access a view, the corresponding policy group is selected based on the context value. |
| ALL_POLICY_GROUPS | This view displays the policy groups of all views that the current user can access. The policy groups are combined with the policy context to apply different policies to different users. |
| ALL_SEC_RELEVANT_COLS | This view displays the columns associated with policies in the tables or views that the current user can access. When a column is associated with a column-level policy, the corresponding policy is applied when the column is accessed. |
| USER_POLICIES | This view displays the access control policies that the current user owns. When you apply access control to a table, you can create multiple policies for the table. |
| USER_POLICY_CONTEXTS | This view displays the context information of the views that the current user owns. When you access a view, the corresponding policy group is selected based on the context value. |
| USER_POLICY_GROUPS | This view displays the policy groups of the views that the current user owns. The policy groups are combined with the policy context to apply different policies to different users. |
| USER_SEC_RELEVANT_COLS | This view displays the columns associated with policies in the tables or views that the current user owns. When a column is associated with a column-level policy, the corresponding policy is applied when the column is accessed. |
| DBA_POLICIES | This view displays the access control policies of all tables or views in the current tenant. When you apply access control to a table, you can create multiple policies for the table. |
| DBA_POLICY_CONTEXTS | This view displays the context information of all views in the current tenant. When you access a view, the corresponding policy group is selected based on the context value. |
| DBA_POLICY_GROUPS | This view displays the policy groups of all views in the current tenant. The policy groups are combined with the policy context to apply different policies to different users. |
| DBA_SEC_RELEVANT_COLS | This view displays the columns associated with policies in the tables or views of the current tenant. When a column is associated with a column-level policy, the corresponding policy is applied when the column is accessed. |
Backup and restore
| View Name | Description |
|---|---|
| DBA_OB_BACKUP_JOBS | This view displays the backup jobs of the current tenant. |
| DBA_OB_BACKUP_JOB_HISTORY | This view displays the history of the backup jobs of the current tenant. |
| DBA_OB_BACKUP_TASKS | This view displays the task-level backup jobs of the current tenant. |
| DBA_OB_BACKUP_TASK_HISTORY | This view displays the history of the task-level backup jobs of the current tenant. |
| DBA_OB_BACKUP_SET_FILES | This view displays the file status of the backup set. |
| DBA_OB_RESTORE_PROGRESS | This view displays the progress of the ongoing restore tasks. |
| DBA_OB_RESTORE_HISTORY | This view displays the history of the completed restore tasks. |
| DBA_OB_ARCHIVE_DEST | This view displays the archive destination configurations. |
| DBA_OB_BACKUP_STORAGE_INFO | This view displays the backup destination information used for backup and restore in the current tenant. |
| DBA_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the historical backup destination information used for backup and restore in the current tenant. |
| DBA_OB_BACKUP_DELETE_POLICY | This view displays the deletion policy set for expired or automatic deletion in the current tenant. |
| DBA_OB_BACKUP_DELETE_JOBS | This view displays the progress of the tenant-level backup deletion jobs. |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of the backup deletion jobs in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASKS | This view displays the information about the backup_set/backup_piece deletion tasks being executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of the completed backup_set/backup_piece deletion tasks in the current tenant. |
| DBA_OB_ARCHIVELOG | This view displays the log backup status on each path. |
| DBA_OB_ARCHIVELOG_SUMMARY | This view displays the status of all log backups in the history and current. |
| DBA_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of the pieces in the backup set. |
| DBA_OB_BACKUP_PARAMETER | This view displays the backup parameters. |
| DBA_OB_RECOVER_TABLE_JOBS | This view displays information about table-level restore tasks. |
| DBA_OB_IMPORT_TABLE_JOBS | This view displays information about import tasks. |
| DBA_OB_IMPORT_TABLE_TASKS | This view displays records of table-level import tasks. |
| DBA_OB_RECOVER_TABLE_JOB_HISTORY | This view displays results of table-level restore tasks. |
| DBA_OB_IMPORT_TABLE_JOB_HISTORY | This view displays results of import tasks. |
| DBA_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the history of cross-tenant table-level import tasks. |
Views and tables
| View | Description |
|---|---|
| ALL_ALL_TABLES | This view displays object tables and relational tables that the current user can access. |
| ALL_COL_COMMENTS | This view displays column comments of views and tables that the current user can access. |
| ALL_TABLES | This view displays all tables that the current user can access. |
| ALL_TAB_COLS | This view displays all columns of tables, views, and clusters that the current user can access. |
| ALL_TAB_COLUMNS | This view displays all columns of tables, views, and clusters that the current user can access. |
| ALL_TAB_COMMENTS | This view displays comments of tables and views that the current user can access. |
| DBA_COL_COMMENTS | This view displays column comments of all views and tables in the database. |
| DBA_TAB_COMMENTS | This view displays comments of all tables and views in the database. |
| USER_COL_COMMENTS | This view displays column comments of views and tables owned by the current user. |
| USER_TAB_COMMENTS | This view displays comments of tables and views owned by the current user. |
| DBA_OB_TABLEGROUP_TABLES | This view displays the association between TABLEGROUP and TABLE. It does not display tables not in a table group. |
| DBA_TABLES | This view displays all tables in the database. |
| DBA_ALL_TABLES | This view displays object tables and relational tables in the database. Its fields are the same as those of ALL_ALL_TABLES. |
| DBA_TABLESPACES | This view displays all tablespaces in the database. |
| DBA_TAB_COLS | This view displays all columns of tables, views, and clusters in the database. |
| DBA_TAB_COLUMNS | This view displays all columns of tables, views, and clusters in the database. |
| USER_ALL_TABLES | This view displays object tables and relational tables that the current user can access. Except for the OWNER field, its fields are the same as those of ALL_ALL_TABLES. |
| USER_TABLES | This view displays all tables owned by the current user. |
| USER_TABLESPACES | This view displays tablespaces that the current user can access. Its columns are the same as those of DBA_TABLESPACES, except for the PLUGGED_IN field. |
| USER_TAB_COLS | This view displays all columns of tables, views, and clusters owned by the current user. |
| USER_TAB_COLUMNS | This view displays all columns of tables, views, and clusters owned by the current user. |
| ALL_VIEWS | This view displays views that the current user can access. |
| DBA_VIEWS | This view displays all views in the database. The columns are the same as those in ALL_VIEWS. |
| USER_VIEWS | This view displays views owned by the current user. |
| DICTIONARY | This view displays the descriptions of data dictionary tables and views. |
| DICT | This view displays the descriptions of data dictionary tables and views. |
| DBA_OB_TABLE_LOCATIONS | This view displays the locations of tables and partitions, including system tables, user tables, index tables, and so on. |
| DBA_OB_SPATIAL_COLUMNS | This view displays the database name, table name, type, and SRS information of spatial index columns. |
| DBA_OB_TABLE_SPACE_USAGE | This view displays the sizes of all user tables in the current tenant (based on the leader replica in a multi-replica environment). |
CCL related
| View name | Description |
|---|---|
| DBA_OB_CCL_RULES | Records all throttling rules for the current user tenant. |
Storage object related
| View name | Description |
|---|---|
| ALL_ERRORS | Displays errors of the current storage objects that the user can access. |
| DBA_ERRORS | Displays errors of the current storage objects in the database. |
| USER_ERRORS | Displays errors of the current storage objects that the user can access. |
| DBA_SEGMENTS | Displays storage information of all segments in the database. |
| USER_SEGMENTS | Displays storage information of segments of the objects in the current user schema. |
| DBA_OB_SOURCE | Displays source code information of all storage objects in the current tenant. |
| USER_OB_SOURCE | Displays source code information of storage objects owned by the current user. |
| ALL_OB_SOURCE | Displays source code information of storage objects accessible to the current user. |
Trigger related
| View name | Description |
|---|---|
| ALL_TRIGGERS | Displays triggers and their descriptions on the tables owned by the current user. If the user has the CREATE ANY TRIGGER privilege, this view describes all triggers in the database. |
| DBA_TRIGGERS | Displays all triggers in the database. |
| USER_TRIGGERS | Displays triggers owned by the current user. |
| ALL_TRIGGER_ORDERING | Displays the ordering of all triggers accessible to the current user. |
| DBA_TRIGGER_ORDERING | Displays the ordering of all triggers in the current tenant. |
| USER_TRIGGER_ORDERING | Displays the ordering of triggers owned by the current user. |
Object management related
| View name | Description |
|---|---|
| ALL_OBJECTS | Displays all database objects accessible to the current user. |
| DBA_OBJECTS | Displays all database objects in the database. |
| USER_OBJECTS | Displays all database objects owned by the current user. |
| ALL_DEPENDENCIES | Displays dependencies between all objects in the database. |
| DBA_DEPENDENCIES | Displays all dependencies between objects in the database. |
| USER_DEPENDENCIES | Displays dependencies between objects in the current user schema. |
Object type-related
| View name | Description |
|---|---|
| ALL_METHOD_PARAMS | This view displays the method parameters of all object types accessible to the current user. |
| ALL_TYPE_METHODS | This view displays the methods of all object types accessible to the current user. |
| DBA_METHOD_PARAMS | This view displays the method parameters of all object types in the database. |
| DBA_TYPE_METHODS | This view displays the methods of all object types in the database. |
| USER_TYPE_METHODS | This view displays the methods of all object types accessible to the current user, except that it does not contain the OWNER column. The column information is the same as that in ALL_TYPE_METHODS. |
DBLINK-related
| View name | Description |
|---|---|
| ALL_DB_LINKS | This view displays all DBLINKs accessible to the current user. |
| DBA_DB_LINKS | This view displays all DBLINKs created in the current tenant. |
| USER_DB_LINKS | This view displays the DBLINKs created by the current user. |
Service-related
| View name | Description |
|---|---|
| DBA_OB_SERVICES | This view displays all SERVICE_NAME information for the current tenant. |
Auxiliary statistics-related
| View name | Description |
|---|---|
| DBA_OB_AUX_STATISTICS | This view displays the auxiliary statistics of each tenant. |
Load balancing
| View name | Description |
|---|---|
| DBA_OB_OBJECT_BALANCE_WEIGHT | This view displays all partitions with special weights in the current user tenant. |
| DBA_OB_TRANSFER_PARTITION_TASKS | This view displays the Transfer Partition tasks being processed in the current tenant. |
| DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of Transfer Partition tasks executed in the current tenant. |
| DBA_OB_BALANCE_JOBS | This view displays the load balancing jobs being executed in the current tenant. Each tenant can have only one load balancing job (JOB) running at a time. Each load balancing job generates multiple load balancing tasks (TASK) for specific operations. |
| DBA_OB_BALANCE_JOB_HISTORY | This view displays the history of load balancing jobs executed in the current tenant. |
| DBA_OB_BALANCE_TASKS | This view displays the load balancing tasks being executed in the current tenant. Each tenant can have multiple load balancing tasks (TASK) running at a time, and all tasks (TASK) belong to the same load balancing job (JOB). |
| DBA_OB_BALANCE_TASK_HISTORY | This view displays the history of load balancing tasks executed in the current tenant. |
| DBA_OB_TRANSFER_TASKS | This view displays the Transfer tasks being executed in the current tenant. |
| DBA_OB_TRANSFER_TASK_HISTORY | This view displays the history of Transfer tasks executed in the current tenant. |
Log replica-related
| View name | Description |
|---|---|
| DBA_OB_CS_REPLICA_STATS | This view displays the progress of converting tablets to columnar storage in the C replica log stream on each OBServer in the current tenant. |
| DBA_OB_LS_LOCATIONS | This view displays the distribution information of log streams (LS) replicas in the current tenant. |
| DBA_OB_TABLET_REPLICAS | This view displays all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| DBA_OB_TABLET_TO_LS | This view displays all tablet lists and the log stream information to which each tablet belongs. |
| DBA_OB_LS | This view displays the status and recovery progress of log streams. |
| DBA_OB_LOG_RESTORE_SOURCE | This view displays the log restore sources in the current tenant. |
| DBA_OB_LS_HISTORY | This view displays the history of log streams in the current tenant. |
| DBA_OB_LS_LOG_ARCHIVE_PROGRESS | This view displays the log stream archiving progress in the current tenant. |
| DBA_OB_TENANT_FLASHBACK_LOG_SCN | This view displays information about each log pruning operation in the current tenant. |
Partition-related views
| View name | Description |
|---|---|
| ALL_PART_KEY_COLUMNS | This view displays columns in the partition keys of all partitioned objects accessible to the current user. |
| ALL_PART_TABLES | This view displays partition information of partitioned tables accessible to the current user. |
| ALL_SUBPARTITION_TEMPLATES | This view displays descriptions of all subpartition templates. |
| ALL_SUBPART_KEY_COLUMNS | This view displays columns in the subpartition keys of all partitioned objects accessible to the current user. |
| ALL_TAB_PARTITIONS | This view displays multi-level partition information, partition storage parameters, and partition statistics of all partitioned tables. |
| ALL_TAB_SUBPARTITIONS | This view displays partition-level partition information, partition storage parameters, and partition statistics generated by the DBMS_STATS package for partitioned tables accessible to the current user. |
| DBA_OB_DYNAMIC_PARTITION_TABLES | This view displays dynamic partition table information of the current tenant. |
| DBA_PART_INDEXES | This view displays partition information of all partitioned indexes. |
| DBA_PART_KEY_COLUMNS | This view displays columns in the partition keys of all partitioned objects in the database. |
| DBA_PART_TABLES | This view displays partition information of partitioned tables accessible to the current user. |
| DBA_SUBPARTITION_TEMPLATES | This view displays descriptions of all subpartition templates. |
| DBA_SUBPART_KEY_COLUMNS | This view displays columns in the subpartition keys of all partitioned objects in the database. |
| DBA_TAB_PARTITIONS | This view displays multi-level partition information, partition storage parameters, and partition statistics of partitioned tables accessible to the current user. |
| DBA_TAB_SUBPARTITIONS | This view displays the subpartition name, table name, name of the partition to which the subpartition belongs, storage attributes, and statistics generated by the DBMS_STATS package. |
| USER_PART_KEY_COLUMNS | This view displays columns in the partition keys of all partitioned objects owned by the current user. |
| USER_PART_TABLES | This view displays partition information of partitioned tables owned by the current user. |
| USER_SUBPARTITION_TEMPLATES | This view displays descriptions of all subpartition templates. |
| USER_SUBPART_KEY_COLUMNS | This view displays columns in the subpartition keys of all partitioned objects owned by the current user. |
| USER_TAB_SUBPARTITIONS | This view displays the subpartition name, table name, name of the partition to which the subpartition belongs, and storage attributes of each subpartition of a table owned by the current user. |
| USER_TAB_PARTITIONS | This view displays multi-level partition information, partition storage parameters, and partition statistics of partitioned tables owned by the current user. |
| DBA_OB_TABLEGROUPS | This view displays the metadata of table groups, mainly the partition information of table groups. |
| DBA_OB_TABLEGROUP_PARTITIONS | This view displays the primary partition information of a partitioned table group. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of a partitioned table group. |
Shared storage
| View name | Purpose |
|---|---|
| DBA_OB_SS_SPACE_USAGE | This view records the storage space usage on the object storage of the current tenant. |
Recycle bin
| View name | Purpose |
|---|---|
| DBA_RECYCLEBIN | This view displays information about all recycle bins in the database. |
| USER_RECYCLEBIN | This view displays information about the recycle bins owned by the current user. The columns are the same as those in DBA_RECYCLEBIN, except the OWNER column. |
Functions and procedures
| View name | Purpose |
|---|---|
| ALL_ARGUMENTS | This view displays the parameters of the functions and procedures accessible to the current user. |
| ALL_PROCEDURES | This view displays all functions and procedures accessible to the current user and their related attributes. |
| ALL_SOURCE | This view displays the text sources of the stored objects accessible to the current user. |
| DBA_ARGUMENTS | This view displays the parameters of the functions and procedures available in the database. The columns are the same as those in ALL_ARGUMENTS. |
| DBA_PROCEDURES | This view displays all functions and procedures available in the database and their related attributes. The columns are the same as those in ALL_PROCEDURES. |
| DBA_SOURCE | This view displays the text sources of all stored objects in the database. The columns are the same as those in ALL_SOURCE. |
| USER_ARGUMENTS | This view displays the parameters of the functions and procedures owned by the current user. The columns are the same as those in ALL_ARGUMENTS, except the OWNER column. |
| USER_PROCEDURES | This view displays all functions and procedures owned by the current user and their related attributes. The columns are the same as those in ALL_PROCEDURES, except the OWNER column. |
| USER_SOURCE | This view displays the text sources of the stored objects owned by the current user. The columns are the same as those in ALL_SOURCE, except the OWNER column. |
| DBA_OB_PL_OBJ_CACHE_STATUS | This view displays the status information of PL cache objects. |
| DBA_JOBS | This view displays an overview of the submitted tasks. |
| USER_JOBS | This view displays an overview of the submitted tasks. |
| DBA_JOBS_RUNNING | This view displays the running tasks. |
I/O performance
| View name | Purpose |
|---|---|
| DBA_OB_STORAGE_IO_USAGE | This view displays the types of I/O operations on the object storage and cloud disks of the current tenant. |
Temporary files
| View name | Purpose |
|---|---|
| DBA_OB_TEMP_FILES | The DBA_OB_TEMP_FILES view displays information about temporary files. |
NLS related
| View name | Description |
|---|---|
| NLS_DATABASE_PARAMETERS | This view displays the NLS parameters at the database level (OceanBase Database tenant level). |
| NLS_INSTANCE_PARAMETERS | This view displays the NLS parameters at the instance level (tenant level). |
| NLS_SESSION_PARAMETERS | This view displays the NLS parameters at the session level. |
Outline related
| View name | Description |
|---|---|
| DBA_OB_OUTLINES | This view displays the execution plan outline information of the current tenant. |
| DBA_OB_CONCURRENT_LIMIT_SQL | This view displays the outline information of the throttling rules of the current tenant. |
| DBA_OB_OUTLINE_CONCURRENT_HISTORY | This view displays the execution plan and throttling rule outline history information of the current tenant. |
| DBA_OB_FORMAT_OUTLINES | This view records the detailed information of the current tenant's format outline. |
PLSQL related
| View name | Description |
|---|---|
| ALL_PLSQL_COLL_TYPES | ALL_PLSQL_COLL_TYPES view displays the overall information about collection types defined in packages. |
| ALL_PLSQL_TYPES | ALL_PLSQL_TYPES view displays the overall information about package types. |
| ALL_PLSQL_TYPE_ATTRS | ALL_PLSQL_TYPE_ATTRS view displays the overall information about record types defined in packages. |
| USER_PLSQL_COLL_TYPES | USER_PLSQL_COLL_TYPES view displays the overall information about collection types defined in the current user's packages. Only when the package is successfully compiled, the types in the package can be displayed in this view. |
| USER_PLSQL_TYPES | USER_PLSQL_TYPES view displays the overall information about package types in the current user's packages. Only when the package is successfully compiled, the types in the package can be displayed in this view. |
| USER_PLSQL_TYPE_ATTRS | USER_PLSQL_TYPE_ATTRS view displays the overall information about record types defined in the current user's packages. Only when the package is successfully compiled, the types in the package can be displayed in this view. |
| DBA_PLSQL_COLL_TYPES | DBA_PLSQL_COLL_TYPES view displays the overall information about collection types defined in the current tenant's packages. Only when the package is successfully compiled, the types in the package can be displayed in this view. |
| DBA_PLSQL_TYPES | DBA_PLSQL_TYPES view displays the overall information about package types in the current tenant. Only when the package is successfully compiled, the types in the package can be displayed in this view. |
| DBA_PLSQL_TYPE_ATTRS | DBA_PLSQL_TYPE_ATTRS view displays the overall information about record types defined in the current tenant's packages. Only when the package is successfully compiled, the types in the package can be displayed in this view. |
PROFILE related
| View name | Description |
|---|---|
| ALL_PROFILES | Displays all profiles and their limitations. |
| DBA_PROFILES | Displays all profiles and their limitations. |
| USER_PROFILES | Displays all profiles and their limitations. |
Disaster recovery related
| View name | Description |
|---|---|
| DBA_OB_ACCESS_POINT | Displays the list of OBServer nodes in the current tenant. In a physical standby database scenario based on network, it is mainly used to obtain the IP address and SQL port number of the OBServer node in the primary tenant's replica. |
| DBA_OB_LS_REPLICA_TASKS | Displays the ongoing disaster recovery tasks at the Replica level for the current tenant. |
| DBA_OB_LS_REPLICA_TASK_HISTORY | Displays the execution history of all tenants' disaster recovery tasks. |
Job scheduling
| View | Purpose |
|---|---|
| DBA_SCHEDULER_JOBS | This view displays the scheduler job information accessible to the current user. |
| DBA_SCHEDULER_PROGRAM | This view displays the scheduler program information in the database. |
| DBA_SCHEDULER_JOB_RUN_DETAILS | This view displays the scheduler job information in the tenant. |
| ALL_SCHEDULER_JOB_ARGS | This view displays the scheduler job argument information accessible to the current user. |
| ALL_SCHEDULER_PROGRAM_ARGS | This view displays the scheduler program argument information accessible to the current user. |
| DBA_SCHEDULER_JOB_ARGS | This view displays the scheduler job argument information in the database. |
| USER_SCHEDULER_JOB_ARGS | This view displays the scheduler job argument information owned by the current user. |
| DBA_SCHEDULER_PROGRAM_ARGS | This view displays the scheduler program argument information in the database. |
| USER_SCHEDULER_PROGRAM_ARGS | This view displays the scheduler program argument information owned by the current user. |
| USER_SCHEDULER_JOBS | This view displays the scheduler job information accessible to the current user. |
| ALL_SCHEDULER_WINDOWS | This view displays the scheduler window information accessible to the current user. |
| DBA_SCHEDULER_WINDOWS | This view displays the scheduler window information in the current tenant. |
Audit-related
| View name | Purpose |
|---|---|
| ALL_DEF_AUDIT_OPTS | This view displays the audit conditions for objects that are audited by default. |
| AUDIT_ACTIONS | This view displays the Action ID and corresponding name in the audit records. |
| DBA_AUDIT_EXISTS | This view displays the audit tracking entries generated by AUDIT EXISTS and AUDIT NOT EXISTS. |
| DBA_AUDIT_OBJECT | This view displays the audit tracking records for all objects in the database. |
| DBA_AUDIT_SESSION | This view displays the audit tracking records for CONNECT and DISCONNECT. |
| DBA_AUDIT_STATEMENT | This view displays the audit tracking records for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements in the database. |
| DBA_AUDIT_TRAIL | This view displays all audit tracking entries. |
| DBA_OBJ_AUDIT_OPTS | This view displays the detailed audit configurations at the object level. |
| DBA_STMT_AUDIT_OPTS | This view displays the detailed audit configurations at the statement level. |
| STMT_AUDIT_OPTION_MAP | This view displays the Type, corresponding name, and priority for statement-level audit. |
| USER_AUDIT_OBJECT | This view displays the audit tracking records for objects accessible to the current user. |
| USER_AUDIT_SESSION | This view displays the audit tracking records for the current user's connections and disconnections. |
| USER_AUDIT_STATEMENT | This view displays the audit tracking entries for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements issued by the current user. |
| USER_AUDIT_TRAIL | This view displays the standard audit tracking entries related to the current user. |
SPM-related
| View name | Purpose |
|---|---|
| DBA_SQL_PLAN_BASELINES | This view displays the plan baselines for SQL in SPM. |
| DBA_SQL_MANAGEMENT_CONFIG | This view displays the configuration parameters in SPM. |
| DBA_OB_SPM_EVO_RESULT | This view displays the SPM plan evolution information for the current tenant. |
Index-related
| View Name | Description |
|---|---|
| ALL_INDEXES | This view displays the index column information of all tables accessible to the user. |
| ALL_IND_COLUMNS | This view displays the index column information of all tables accessible to the user. |
| ALL_IND_EXPRESSIONS | This view displays the information of function-based indexes accessible to the user in the database. |
| ALL_IND_PARTITIONS | This view displays the information of index partitions accessible to the user in the database. |
| ALL_IND_SUBPARTITIONS | This view displays the information of all index subpartitions accessible to the user in the database. |
| ALL_PART_INDEXES | This view displays the partition information of partition indexes accessible to the current user. |
| DBA_INDEXES | This view displays the index information of all tables in the database. |
| DBA_IND_COLUMNS | This view displays the index column information of all tables in the database. |
| DBA_IND_EXPRESSIONS | This view displays the information of all function-based indexes in the database. |
| DBA_IND_PARTITIONS | This view displays the information of all index partitions in the database. |
| DBA_IND_SUBPARTITIONS | This view displays the information of all index subpartitions in the database. |
| USER_INDEXES | This view displays the index information of all tables owned by the user. |
| USER_IND_COLUMNS | This view displays the index column information of all tables owned by the user. |
| USER_IND_EXPRESSIONS | This view displays the information of function-based indexes owned by the user in the database. |
| USER_IND_PARTITIONS | This view displays the information of index partitions owned by the current user in the database. This view does not contain the INDEX_OWNER column, unlike ALL_IND_PARTITIONS and DBA_IND_PARTITIONS. |
| USER_IND_SUBPARTITIONS | This view displays the information of all index subpartitions owned by the user in the database. This view does not contain the INDEX_OWNER column, unlike DBA_IND_SUBPARTITIONS and ALL_IND_SUBPARTITIONS. |
| USER_PART_INDEXES | This view displays the partition information of partition indexes owned by the current user. |
| DBA_INDEX_USAGE | This view displays the index usage data. |
Data dictionary-related
| View Name | Description |
|---|---|
| DBA_OB_DATA_DICTIONARY_IN_LOG | This view records the location range of the data dictionary in the system log stream to facilitate CDC consumption of the data dictionary. |
Basic database information
| View name | Purpose |
|---|---|
| DBA_CONTEXT | This view displays all context namespaces in the database. |
| DBA_OB_SYS_VARIABLES | This view displays the configurations of system variables in the current tenant, including hidden variables whose names start with "_". |
Locks
| View name | Purpose |
|---|---|
| DBA_OB_DEADLOCK_EVENT_HISTORY | This view displays the history of deadlock events. In a non-root tenant, this view displays the history of deadlock events in the current tenant. |
Statistics and histogram related
| View name | Description |
|---|---|
| ALL_PART_COL_STATISTICS | This view displays column statistics and histogram information for partitions of all partitioned tables accessible to the current user. |
| ALL_PART_HISTOGRAMS | This view displays histogram information for all partitions. |
| ALL_SUBPART_COL_STATISTICS | This view displays column statistics and histogram information for subpartitions of all partitioned tables accessible to the current user. |
| ALL_SUBPART_HISTOGRAMS | This view displays histogram information for all subpartitions. |
| ALL_TAB_COL_STATISTICS | This view displays column statistics and histogram information for all tables accessible to the current user. |
| ALL_TAB_HISTOGRAMS | This view displays histogram information for all tables. |
| ALL_TAB_STATISTICS | This view displays optimizer statistics for all tables accessible to the current user. |
| DBA_PART_COL_STATISTICS | This view displays column statistics and histogram information for partitions of all partitioned tables in the database. |
| DBA_PART_HISTOGRAMS | This view displays histogram information for all partitions. |
| DBA_SUBPART_COL_STATISTICS | This view displays column statistics and histogram information for subpartitions of all partitioned tables in the database. |
| DBA_SUBPART_HISTOGRAMS | This view displays histogram information for all subpartitions. |
| DBA_TAB_COL_STATISTICS | This view displays column statistics and histogram information for all tables in the database. |
| DBA_TAB_HISTOGRAMS | This view displays histogram information for all tables in the database. |
| DBA_TAB_STATISTICS | This view displays optimizer statistics for all tables in the database. |
| USER_PART_COL_STATISTICS | This view displays column statistics and histogram information for partitions of all partitioned tables accessible to the current user. |
| USER_PART_HISTOGRAMS | This view displays histogram information for all partitions accessible to the current user. |
| USER_SUBPART_COL_STATISTICS | This view displays column statistics and histogram information for subpartitions of all partitioned tables accessible to the current user. |
| USER_SUBPART_HISTOGRAMS | This view displays histogram information for all subpartitions accessible to the current user. |
| USER_TAB_COL_STATISTICS | This view displays column statistics and histogram information for all tables accessible to the current user. |
| USER_TAB_HISTOGRAMS | This view displays histogram information for all tables accessible to the current user. |
| USER_TAB_STATISTICS | This view displays the optimizer statistics of all tables in the current user. |
| ALL_TAB_STATS_HISTORY | This view displays the table statistics modification history of all tables accessible to the current user. |
| DBA_TAB_STATS_HISTORY | This view displays the table statistics modification history of all tables in the database. |
| USER_TAB_STATS_HISTORY | This view displays the table statistics modification history of all tables owned by the current user. |
| ALL_IND_STATISTICS | This view displays the optimizer statistics of indexes on all tables accessible to the current user. |
| DBA_IND_STATISTICS | This view displays the optimizer statistics of all indexes in the database. |
| USER_IND_STATISTICS | This view displays the optimizer statistics of indexes on all tables owned by the current user. |
| ALL_TAB_MODIFICATIONS | This view displays the cumulative modification information of all tables accessible to the current user. |
| DBA_TAB_MODIFICATIONS | This view displays the cumulative modification information of all tables in the database. |
| USER_TAB_MODIFICATIONS | This view displays the cumulative modification information of all tables owned by the current user. |
| DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | This view queries the historical execution of table statistics collection. |
| DBA_OB_TABLE_STAT_STALE_INFO | This view displays the number of DML operations performed on each table since the last statistics collection and whether the current statistics are stale. |
| DBA_OB_TASK_OPT_STAT_GATHER_HISTORY | This view displays the execution of historical collection tasks in the current tenant. |
Synonyms
| View name | Description |
|---|---|
| ALL_SYNONYMS | This view displays all synonyms accessible to the current user. |
| DBA_SYNONYMS | This view displays all synonyms in the database. |
| USER_SYNONYMS | This view displays all synonyms owned by the current user. |
External resources
| View name | Description |
|---|---|
| ALL_OB_EXTERNAL_TABLE_FILES | This view displays the list of files for external tables that the current user has access to. |
| DBA_OB_EXTERNAL_TABLE_FILES | This view displays the list of files for all external tables created in the current tenant. |
WR
| View name | Description |
|---|---|
| DBA_WR_SNAPSHOT | This view displays the SNAPSHOT information of the current tenant. |
| DBA_WR_ACTIVE_SESSION_HISTORY | This view displays the persistent ASH data of the current tenant. |
| DBA_WR_STATNAME | This view displays the names of system statistics of the current tenant. |
| DBA_WR_SYSSTAT | This view displays the details of system statistics of the current tenant. |
| DBA_WR_CONTROL | This view displays the WR-related configuration information. |
| DBA_WR_SYSTEM_EVENT | This view displays the persistent tenant-level wait event information of the current tenant. |
| DBA_WR_EVENT_NAME | This view displays the persistent tenant-level wait event names of the current tenant. |
| DBA_WR_SQLTEXT | This view displays the SQL texts collected by WR of the current tenant. |
| DBA_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed by the current tenant. |
| DBA_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics of the current tenant. |
| DBA_WR_SQL_PLAN | This view displays the GV$OB_SQL_PLAN data collected by WR. |
Materialized views
| View | Purpose |
|---|---|
| DBA_MVIEW_DEPS | This view displays the dependencies of materialized views in the current tenant. |
| DBA_MVIEW_LOGS | This view displays the information about materialized view logs. |
| DBA_MVIEW_RUNNING_JOBS | This view displays the running materialized view-related tasks in the current tenant, including refresh tasks and MLOG cleanup tasks. |
| USER_MVIEWS | This view displays the information about materialized views. |
| DBA_MVIEWS | This view displays the information about all materialized views. |
| DBA_MVREF_CHANGE_STATS | This view displays the statistics about materialized view refreshes. |
| DBA_MVREF_RUN_STATS | This view displays the information about each run of a materialized view refresh, which is identified by the REFRESH_ID. |
| DBA_MVREF_STATS | This view displays the basic timing statistics about materialized view refreshes. |
| DBA_MVREF_STATS_PARAMS | This view displays the refresh statistics attributes associated with each materialized view. |
| DBA_MVREF_STATS_SYS_DEFAULTS | This view displays the system-level default values of the statistics attributes of the materialized view refresh history. |
| DBA_MVREF_STMT_STATS | This view displays the information about the statements associated with a materialized view refresh. |
| ALL_MVIEWS | This view displays the information about materialized views. |
| ALL_MVIEW_LOGS | This view displays the information about all materialized view logs. |
| USER_MVIEW_LOGS | This view displays the information about materialized view logs. |
| USER_MVREF_CHANGE_STATS | This view displays the statistics about materialized view refreshes. These statistics display the number of data changes in the base tables associated with each materialized view refresh and the information required to load these changes. |
| USER_MVREF_RUN_STATS | This view displays the information about each run of a materialized view refresh, which is identified by the REFRESH_ID. The information includes the timing statistics and parameters specified for the run. |
| USER_MVREF_STATS | This view displays the basic timing statistics about materialized view refreshes. |
| USER_MVREF_STATS_PARAMS | This view displays the refresh statistics attributes associated with each materialized view. |
| USER_MVREF_STATS_SYS_DEFAULTS | This view displays the system-level default values of the statistics attributes of the materialized view refresh history. |
| USER_MVREF_STMT_STATS | This view displays the information about the statements associated with a materialized view refresh. |
Sequence-related
| View name | Description |
|---|---|
| ALL_SEQUENCES | This view displays all SEQUENCEs accessible to the current user. |
| DBA_SEQUENCES | This view displays all SEQUENCEs in the database. |
| USER_SEQUENCES | This view displays all SEQUENCEs owned by the current user. |
| TENANT_VIRTUAL_GLOBAL_VARIABLE | This view displays global variable information. |
| TENANT_VIRTUAL_SESSION_VARIABLE | This view displays session variable information. |
User-defined type-related
| View name | Description |
|---|---|
| ALL_COLL_TYPES | This view displays all user-defined collection types available in the database. The columns are the same as those in DBA_COLL_TYPES. |
| ALL_TYPES | This view displays all user-defined types available in the database. |
| ALL_TYPE_ATTRS | This view displays all user-defined type attributes available in the database. |
| DBA_COLL_TYPES | This view displays all user-defined collection types available in the database. The columns are the same as those in ALL_COLL_TYPES. |
| DBA_TYPES | This view displays all user-defined types available in the database. |
| DBA_TYPE_ATTRS | This view displays all user-defined type attributes available in the database. |
| USER_COLL_TYPES | This view displays all user-defined collection types available to the current user. |
| USER_TYPES | This view displays all user-defined types of the current user. |
| USER_TYPE_ATTRS | This view displays all user-defined type attributes available to the current user. |
Constraint-related
| View name | Description |
|---|---|
| ALL_CONSTRAINTS | This view displays constraint information for all tables accessible to the current user. |
| ALL_CONS_COLUMNS | This view displays column information for all constraints of all tables accessible to the current user. |
| DBA_CONSTRAINTS | This view displays constraint information for all tables in the database. |
| DBA_CONS_COLUMNS | This view displays column information for all constraints of all tables in the database. |
| USER_CONSTRAINTS | This view displays constraint information for all tables owned by the current user. |
| USER_CONS_COLUMNS | This view displays column information for all constraints of all tables owned by the current user. |
Major compaction-related views
| View name | Description |
|---|---|
| DBA_OB_MAJOR_COMPACTION | This view displays the global information of the major compaction of the current tenant. |
| DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the information of the major compaction of each zone of the current tenant. |
| DBA_OB_FREEZE_INFO | This view displays the version information generated by the major freeze. |
Resource management-related views
| View name | Description |
|---|---|
| DBA_OB_RSRC_DIRECTIVES | This view displays the resource configuration parameters of the current tenant in the Resource Manager. |
| DBA_OB_RSRC_IO_DIRECTIVES | This view displays the IO resource configuration of the current tenant in the Resource Manager. |
| DBA_RSRC_GROUP_MAPPINGS | This view displays the binding relationship between users and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | This view displays the information of all resource groups in the database. |
| DBA_RSRC_PLANS | This view displays all the resource management plans defined in the system. |
| DBA_RSRC_PLAN_DIRECTIVES | This view displays the detailed information of each resource plan directive in the database. |
Arbitration service-related views
| View name | Description |
|---|---|
| DBA_OB_LS_ARB_REPLICA_TASKS | This view displays the arbitration service tasks that are running in the current tenant. |
| DBA_OB_LS_ARB_REPLICA_TASK_HISTORY | This view displays the history of arbitration service tasks executed in the current tenant. |
Tenant management-related views
| View name | Description |
|---|---|
| DBA_OB_TENANTS | This view displays the basic information of the tenant. |
| DBA_OB_TENANT_EVENT_HISTORY | This view displays the historical operation records of the current tenant. |
| DBA_OB_DATABASES | This view displays the database metadata of the tenant. |
Overview of performance views
ASH related
| View name | Description |
|---|---|
| GV$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| GV$OB_ACTIVE_SESSION_HISTORY | This view displays the active session history of all OBServer nodes in the current tenant. |
| V$OB_ACTIVE_SESSION_HISTORY | This view displays the active session history of the current OBServer node in the current tenant. |
CCL related
| View name | Description |
|---|---|
| GV$OB_SQL_CCL_STATUS | This view records the number of SQL statements that hit the corresponding throttling rules on all nodes of the current tenant at the current moment. This information is used to observe the impact of the throttling rules set in the system. |
| V$OB_SQL_CCL_STATUS | This view records the number of SQL statements that hit the corresponding throttling rules on the current node of the current tenant at the current moment. This information is used to observe the impact of the throttling rules set in the system. |
Catalog related
| View name | Description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This view displays the usage of the HMS Catalog client of the current tenant. |
| V$OB_HMS_CLIENT_POOL_STAT | This view displays the usage of the HMS Catalog client of the current tenant. |
DML related
| View name | Description |
|---|---|
| GV$DML_STATS | This view displays the DML information in the current user table. |
| V$DML_STATS | This view displays the DML information in the current user table. |
DTL related
| View name | Description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | This view displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | This view displays the monitoring information of the DTL intermediate result manager. |
DBLINK related
| View name | Description |
|---|---|
| GV$DBLINK | This view displays all database links ( IN_TRANSACTION=YES ) opened after the query session that issued the view. These database links must be committed or rolled back before they are closed. |
| V$DBLINK | This view displays all database links ( IN_TRANSACTION=YES ) opened after the query session that issued the view. These database links must be committed or rolled back before they are closed. |
Service management
| View name | Description |
|---|---|
| oceanbase.DBA_OB_SERVER_JOBS | This view displays all tasks on all OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | This view displays information about all OBServer nodes. |
| oceanbase.CDB_OB_SERVICES | This view displays all SERVICE_NAME information in all tenants. |
| oceanbase.DBA_OB_SERVICES | This view displays all SERVICE_NAME information in the current tenant. |
Log replica
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | This view displays the status of Palf. |
| V$OB_LOG_STAT | This view displays the status of Palf. |
| GV$OB_LOG_TRANSPORT_DEST_STAT | The GV$OB_LOG_TRANSPORT_DEST_STAT view displays information about all downstream log synchronization links (OBCDC/network standby database) of all OBServer nodes in the current tenant. |
| V$OB_ARCHIVE_DEST_STATUS | This view displays the status of each archive destination of the current tenant. |
| V$OB_LOG_TRANSPORT_DEST_STAT | The V$OB_LOG_TRANSPORT_DEST_STAT view displays information about all downstream log synchronization links (OBCDC/network standby database) of all OBServer nodes in the current tenant. |
| V$OB_LS_LOG_RESTORE_STATUS | This view displays the log restore status at the log stream level for the current tenant. |
| V$OB_LS_REPLICA_TASK_PLAN | This view displays all tasks that should be generated (including those that have been generated and those that have not been generated). |
| V$OB_LS_SNAPSHOTS | This view displays information about all log stream snapshots stored in the persistent storage of all units on the current OBServer. |
Partitioning
| View name | Description |
|---|---|
| V$OB_DYNAMIC_PARTITION_TABLES | This view displays information about dynamic partition tables in the current tenant. |
Shared storage
| View name | Description |
|---|---|
| V$OB_SS_SSTABLES | This view displays information about SSTables on the shared storage of the current tenant. |
| GV$OB_SS_LOCAL_CACHE | This view displays various cache data metrics in the local cache of each OBServer node for all tenants in shared storage mode. |
| V$OB_SS_LOCAL_CACHE | This view displays various cache data metrics in the local cache of the current OBServer node for all tenants in shared storage mode. |
| oceanbase.CDB_OB_SERVER_SPACE_USAGE | This view displays detailed information about storage space usage by each tenant on each node. |
Cache-related
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache of all servers. |
| GV$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache of all servers for the current tenant. |
| GV$OB_PLAN_CACHE_STAT | This view records the status of each plan cache in all servers for the current tenant. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache of the current server. |
| V$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache of the current server for the current tenant. |
| V$OB_PLAN_CACHE_STAT | This view records the status of each plan cache in all servers for the current tenant. |
| GV$OB_PL_CACHE_OBJECT | The GV$OB_PL_CACHE_OBJECT view displays the basic information of all PL-related cached objects in all servers for the current tenant. |
| GV$OB_RESULT_CACHE_OBJECTS | This view displays the cached objects in the result cache created during the execution of udf marked with result_cache on all OBServer nodes. |
| V$OB_PL_CACHE_OBJECT | The V$OB_PL_CACHE_OBJECT view displays the basic information of all PL-related cached objects in the current server for the current tenant. |
| V$OB_RESULT_CACHE_OBJECTS | This view displays the cached objects in the result cache created during the execution of udf marked with result_cache on the current OBServer node. |
I/O performance-related
| View name | Description |
|---|---|
| GV$OB_SHARED_STORAGE_QUOTA | This view displays the I/O access resource information on all OBServer nodes. |
| V$OB_SHARED_STORAGE_QUOTA | This view displays the I/O access resource information on the current OBServer node. |
Encrypted table-related
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | This view displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | This view displays the encryption status of tablespaces with encryption enabled. |
Memory-related
| View name | Description |
|---|---|
| GV$OB_MEMORY | This view displays the memory usage of each tenant on all servers. |
| GV$OB_MEMSTORE | This view displays the memory usage of MemTables for all tenants on all servers. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This view displays information about the SQL Workarea, including the maximum available memory, current used memory, and current held memory. |
| GV$OB_SSTABLES | This view displays the SSTable information of the tenant. |
| GV$OB_MEMSTORE_INFO | This view displays the details of MemTables for all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | This view displays the details of MemTables for all partitions of all tenants on all servers. |
| V$OB_MEMORY | This view displays the memory statistics at the tenant level. |
| V$OB_MEMSTORE | This view displays the memory usage of MemTables for all tenants on the current server. |
| V$OB_SSTABLES | This view displays the SSTable information of the tenant. |
| GV$OB_TENANT_MEMORY | This view displays the memory usage of each tenant on the cluster. |
| V$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the current observer process. |
OBKV-related
| View name | Description |
|---|---|
| GV$OB_KVCACHE | This view displays the KVCACHE information on each OBServer node. |
| V$OB_KVCACHE | This view displays the KVCACHE information on each OBServer node. |
PS-related
| View name | Description |
|---|---|
| GV$OB_PS_ITEM_INFO | This view provides monitoring capabilities for Prepared Statements, including the basic information of all Prepare Statements in the PS Cache. |
| GV$OB_PS_STAT | This view monitors the overall status of the PS Cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_ITEM_INFO | This view provides monitoring capabilities for Prepared Statements, including the basic information of all Prepared Statements in the PS Cache. |
| V$OB_PS_STAT | This view monitors the overall status of the PS Cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_SESSION_PS_INFO | This view displays the PS information opened by all sessions in the current tenant. |
| V$OB_SESSION_PS_INFO | This view displays the PS information opened by all sessions in the current OBServer tenant. |
PX related
| View name | Description |
|---|---|
| GV$OB_PX_TARGET_MONITOR | This view displays the PX thread usage on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | This view displays the PX thread usage on the OBServer node. |
| V$OB_PX_P2P_DATAHUB | This view displays information about parallel execution data transfer operations. |
Full-link tracing related
| View name | Description |
|---|---|
| GV$OB_FLT_TRACE_CONFIG | This view displays diagnostic information about full-link tracing. |
Lock related
| View name | Description |
|---|---|
| GV$OB_LOCKS | This view displays the locks held or requested by the current user for each table. |
| V$OB_LOCKS | This view displays the locks held or requested by the current user for each table. |
Time zone and date related
| View name | Description |
|---|---|
| V$TIMEZONE_NAMES | This view displays the valid time zone names. |
| V$OB_TIMESTAMP_SERVICE | This view displays the GTS/STS values of the GTS service of the tenant. |
Transaction related
| View name | Description |
|---|---|
| GV$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participant information on all OBServer nodes. |
| GV$SYSTEM_EVENT | This view displays some wait events at the tenant system level on all servers, and counts the number of occurrences, wait time, and timeout count for each type of wait event. |
| V$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participant information on all OBServer nodes. |
| V$SYSTEM_EVENT | This view displays some wait events at the tenant system level on the current server, and counts the number of occurrences, wait time, and timeout count for each type of wait event. |
| V$GLOBAL_TRANSACTION | This view displays information about the active global transaction. |
| GV$OB_GLOBAL_TRANSACTION | This view displays information about all XA transactions in the cluster. |
| V$OB_GLOBAL_TRANSACTION | This view displays information about all XA transactions with the current node as the original Scheduler. |
| GV$OB_TRANSACTION_SCHEDULERS | GV$OB_TRANSACTION_SCHEDULERS is used to query the transaction Scheduler information of all servers. |
| V$OB_TRANSACTION_SCHEDULERS | V$OB_TRANSACTION_SCHEDULERS is used to query the transaction Scheduler information of all servers. |
Instance-related
| View Name | Description |
|---|---|
| GV$INSTANCE | This view displays the status of the current database instance. |
| V$INSTANCE | This view displays the status of the current database instance. |
Session-related
| View Name | Description |
|---|---|
| GV$OB_PROCESSLIST | This view displays the session information of all OBServer nodes where the tenant is located. |
| GV$SESSION_WAIT | This view displays some information about the current or last wait event of all sessions on all servers, including the wait event name and wait time. |
| GV$SESSION_WAIT_HISTORY | This view displays the information about the last 10 wait events of all sessions on all servers. |
| GV$SESSTAT | This view displays some statistics at the session level on all servers. |
| V$NLS_PARAMETERS | This view displays the NLS parameters at the session level. |
| V$OB_PROCESSLIST | This view displays the session information of the current OBServer node. |
| V$SESSION_WAIT | This view displays the information about the current or last wait event of all sessions on the current server, including the wait event name and wait time. |
| V$SESSION_WAIT_HISTORY | This view displays the information about the last 10 wait events of all sessions on the current server. |
| V$SESSTAT | This view displays some statistics at the session level. |
| V$EVENT_NAME | This view displays the definitions of various events under the tenant. |
| GV$OPEN_CURSOR | This view displays the information about the open session cursors on all nodes. |
| V$OB_SESSION | This view records the session information created in the current server. |
| V$OPEN_CURSOR | This view displays the information about the open session cursors. |
SQL audit-related
| View Name | Description |
|---|---|
| GV$OB_SQL_AUDIT | This view displays the statistics about the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | This view displays the statistics about the source and execution status of each SQL request on the current server. |
Statistics and histogram
| View name | Description |
|---|---|
| GV$OB_OPT_STAT_GATHER_MONITOR | This view displays the real-time status of statistics collection tasks for the current tenant on all OBServer nodes. |
| V$OB_OPT_STAT_GATHER_MONITOR | This view displays the real-time status of statistics collection tasks for the current tenant on the current OBServer node. |
Network
| View name | Description |
|---|---|
| GV$OB_NIC_INFO | This view displays the NIC information of all OBServer nodes where the tenant resides, mainly the NIC speed. |
| V$OB_NIC_INFO | This view displays the NIC information of the current OBServer node, mainly the NIC speed. |
Workarea
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | This view displays the workarea information of the current active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some overall information about SQL workarea, including the maximum available memory, current used memory, and current hold memory. |
| V$SQL_WORKAREA | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | This view displays the workarea information of the current active operators. |
| V$SQL_WORKAREA_HISTOGRAM | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
WR related
| View name | Description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view displays the histogram information of the execution time of all queries in the current tenant. |
| GV$OB_RES_MGR_SYSSTAT | This view displays the statistics of resource groups in all OBServer nodes of the current tenant. |
| V$OB_RES_MGR_SYSSTAT | This view displays the statistics of resource groups in the current OBServer node of the current tenant. |
| GV$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is a row (each unique combination of SQL_ID and Plan_Hash is a row). |
| V$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is a row (each unique combination of SQL_ID and Plan_Hash is a row). |
| GV$OB_SESS_TIME_MODEL | This view displays the Session-level Time Model statistics in the cluster. |
| V$OB_SESS_TIME_MODEL | This view displays the Session-level Time Model statistics on the current node. |
| GV$OB_SYS_TIME_MODEL | This view displays the tenant-level Time Model statistics in the cluster. |
| V$OB_SYS_TIME_MODEL | This view displays the tenant-level Time Model statistics on the current node. |
| V$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view displays the histogram information of the execution time of all queries in the current tenant. |
Database basic information
| View name | Description |
|---|---|
| GV$OB_PARAMETERS | This view displays the configuration information on all OBServer nodes where the tenant is located. |
| GV$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| V$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| GV$OB_UNITS | This view displays the unit information on the OBServer node where the tenant is located. The system tenant can view the unit information on all OBServer nodes in the cluster. |
| GV$SYSSTAT | This view displays the system-level statistical events on all servers. |
| V$GLOBALCONTEXT | This view displays the CLIENT_IDENTIFIER value of the global context attribute accessible to the current session. |
| V$OB_PARAMETERS | This view displays the configuration information on the current OBServer node. |
| V$SYSSTAT | This view displays the system-level statistical events on the current server. |
| V$OB_UNITS | This view displays the unit information on the current OBServer node. |
| V$VERSION | This view displays the names and versions of all components of the database product. |
| V$STATNAME | This view displays the names of statistical items. |
Thread-related
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | In a parallel execution scenario, this view displays the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In a parallel execution scenario, this view displays the execution information of each thread. |
| GV$OB_THREAD | This view displays the status information of all threads in the observer process on each OBServer node. In a user tenant, this view displays the threads related to the current tenant. |
| V$OB_THREAD | This view displays the status information of all threads in the observer process on the current OBServer node. In a user tenant, this view displays the threads related to the current tenant. |
Views related to major compactions
| View Name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | This view displays the major compaction progress at the OBServer level for the current tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | This view displays the major compaction suggestions. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | This view displays the major compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | This view displays the major compaction history at the tablet level. |
| GV$OB_TABLET_COMPACTION_PROGRESS | This view displays the major compaction progress at the tablet level. |
| GV$GLOBAL_TRANSACTION | This view displays the information about the active global transactions. |
| V$OB_COMPACTION_PROGRESS | This view displays the major compaction progress at the server level for the current tenant. |
| V$OB_COMPACTION_SUGGESTIONS | This view displays the major compaction suggestions. |
| V$OB_COMPACTION_DIAGNOSE_INFO | This view displays the major compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | This view displays the major compaction history at the tablet level. |
| V$OB_TABLET_COMPACTION_PROGRESS | This view displays the major compaction progress at the tablet level. |
Views related to execution plans
| View Name | Description |
|---|---|
| V$SQL_MONITOR_STATNAME | This view displays the meaning of the numeric values in the OTHERSTAT_X_ID column of GV$SQL_PLAN_MONITOR. |
| GV$SQL_PLAN_MONITOR | This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has one statistic record, and the trace information of the plan is recorded. |
| V$SQL_PLAN_MONITOR | This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has one statistic record, and the trace information of the plan is recorded. |
| GV$OB_SQL_PLAN | This view displays the plan information collected by executing the EXPLAIN PLAN statement on all OBServer nodes for the current tenant. |
| GV$SQL_JOIN_FILTER | This view dynamically displays the Join Filter execution information on all OBServer nodes for the current tenant. |
| V$OB_SQL_PLAN | This view displays the plan information collected by executing the EXPLAIN PLAN statement on the current OBServer node for the current tenant. |
| V$SQL_JOIN_FILTER | This view dynamically displays the Join Filter execution information on the current OBServer node for the current tenant. |
Resource management
| View Name | Purpose |
|---|---|
| GV$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on all OBServer nodes for the current tenant. |
| GV$OB_FUNCTION_IO_STAT | This view displays the I/O statistics at the function level on all OBServer nodes for the current tenant. |
| V$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on the current OBServer node for the current tenant. |
| V$OB_FUNCTION_IO_STAT | This view displays the I/O statistics at the function level on the current OBServer node for the current tenant. |
| GV$OB_CGROUP_CONFIG | This view allows you to quickly query the cgroup configurations on all OBServer nodes. |
| V$OB_CGROUP_CONFIG | This view allows you to quickly query the cgroup configurations on the current OBServer node. |
| V$RSRC_PLAN | This view displays the resource management plan of the current active tenant. |
| GV$OB_TENANT_RESOURCE_LIMIT | This view displays the logical resource usage, upper limits, effective restrictions, and maximum usage after a restart on all OBServer nodes for the current tenant. |
| GV$OB_TENANT_RESOURCE_LIMIT_DETAIL | This view displays the restrictions on logical resources for the current tenant on all OBServer nodes, along with the upper limits for each restriction. |
| V$OB_TENANT_RESOURCE_LIMIT | This view displays the logical resource usage, upper limits, effective restrictions, and maximum usage after a restart on the current OBServer node for the current tenant. |
| V$OB_TENANT_RESOURCE_LIMIT_DETAIL | This view displays the restrictions on logical resources for the current tenant on the current OBServer node, along with the upper limits for each restriction. |
Arbitration service
| View Name | Purpose |
|---|---|
| GV$OB_ARBITRATION_MEMBER_INFO | This view displays the arbitration member information for the current tenant. |
| GV$OB_ARBITRATION_SERVICE_STATUS | This view displays the communication status between the arbitration service and each node of the current tenant. |
| V$OB_ARBITRATION_MEMBER_INFO | This view displays the arbitration member information for the current tenant. |
| V$OB_ARBITRATION_SERVICE_STATUS | This view displays the communication status between the arbitration service and the current node of the current tenant. |