Overview of views in the sys tenant
Dictionary views overview
Security views
| View name | Description |
|---|---|
| mysql.columns_priv | This view displays the column privileges granted to users. |
| mysql.default_roles | This view displays the default roles enabled for 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 or 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. |
AI model views
| View name | Description |
|---|---|
| oceanbase.CDB_OB_AI_MODELS | This view displays the AI models in 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 models in the current tenant. |
| oceanbase.DBA_OB_AI_MODEL_ENDPOINTS | This view displays the model access information of the current tenant. |
Backup and restore
| View name | Description |
|---|---|
| oceanbase.CDB_OB_RESTORE_PROGRESS | This view displays the current execution progress of a physical restore task. |
| oceanbase.CDB_OB_RESTORE_HISTORY | This view displays the status of a physical restore task upon completion. |
| oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of pieces in a backup set. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | This view displays the file status of a backup set. |
| oceanbase.CDB_OB_BACKUP_JOBS | This view displays backup jobs for all tenants in a cluster. A backup task generates a job record. |
| oceanbase.CDB_OB_BACKUP_JOB_HISTORY | This view displays the history of backup jobs for all tenants in a cluster. |
| oceanbase.CDB_OB_BACKUP_TASKS | This view displays task-level backup tasks for all tenants in a cluster. A task record corresponds to one backup set. Task records and job records are in one-to-one correspondence. |
| oceanbase.CDB_OB_BACKUP_TASK_HISTORY | This view displays the history of task-level backup tasks for all tenants in a 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 task-level backup tasks 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 file status of 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 executed backup cleanup tasks 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 completed backup_set/backup_piece cleanup tasks in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_POLICY | This view displays the cleanup policies set for expiration cleanup and automatic cleanup in the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | This view displays the information about the backup destination used for backup and restore in the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the history of the backup destination used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | This view displays the information about the backup destination used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the history of the backup destination used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | This view displays the cleanup policies set for expiration cleanup and 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 executed backup cleanup tasks 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 completed backup_set/backup_piece cleanup tasks in the tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | This view displays the log backup status on each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | This view displays the status of all log backups, including historical and current ones. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of pieces in a backup set. |
| oceanbase.CDB_OB_ARCHIVELOG | This view displays the log archiving status on each path. |
| oceanbase.CDB_OB_ARCHIVELOG_SUMMARY | This view displays the status of all log archives, including historical and current ones. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOBS | This view displays information about table-level restore tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOBS | This view displays information about table-level restore tasks. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOBS | This view displays information about import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | This view displays information about import tasks. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASKS | This view displays records of table-level cross-tenant 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 tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | This view displays the results of table-level restore tasks. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY | This view displays the results of import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | This view displays the results of import tasks. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the historical records of table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the historical records of table-level cross-tenant import tasks. |
| oceanbase.CDB_OB_LS_HISTORY | This view displays the log streams that 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 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. |
Tables and columns
| View name | Description |
|---|---|
| oceanbase.CDB_IND_COLUMNS | This view displays the column information of index tables for all tenants. |
| oceanbase.CDB_INDEXES | This view displays the INDEX information for all tenants. |
| oceanbase.CDB_TABLES | This view displays the TABLE information for all tenants. |
| oceanbase.CDB_OB_TABLEGROUP_TABLES | This view displays the association between TABLEGROUP and TABLE for 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 tables and views for all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | This view displays the column information of tables and views for all tenants. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | This view displays the association between TABLEGROUP and TABLE. Tables not in a TABLEGROUP are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | This view displays the columns in the partitioning key of all partitioning objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | This view displays the columns in the subpartitioning key of all subpartitioning objects in the database. |
| oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO | This view displays the column checksum inconsistency information between index tables (global and local indexes) and the primary tables. |
| oceanbase.CDB_OB_TABLE_LOCATIONS | This view displays the location of tables or partitions, including system tables, user tables, and index tables. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | This view displays the location of tables or partitions, 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 you can only query the table structure. |
CCL views
| View name | Description |
|---|---|
| oceanbase.CDB_OB_CCL_RULES | This view records the throttling rules for all tenants. |
| oceanbase.DBA_OB_CCL_RULES | This view records the throttling rules for all tenants. |
Replica log related
| View name | Description |
|---|---|
| oceanbase.CDB_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 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 information 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 focusing on the partition information of the table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | This view displays the primary partition information of partitioned table groups for all tenants under the sys tenant. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of partitioned table groups for all tenants under the sys tenant. |
| oceanbase.CDB_OB_TABLET_TO_LS | This view displays the list of tablets and the log stream information to which each tablet belongs for all tenants under the sys tenant. |
| oceanbase.CDB_OB_TABLET_REPLICAS | This view displays all tablet replicas for 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 all tablet replicas for the current tenant. Each tablet replica is uniquely identified by the composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | This view displays the list of tablets and the log stream information to which each tablet belongs for the current tenant. |
| oceanbase.DBA_OB_LS_LOCATIONS | This view displays the distribution information of log streams (LS) replicas for 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 pruning operation for all tenants in the cluster. |
| oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN | This view displays information about each log pruning operation for the current tenant. |
Partitioning
| 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 partitions 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 in 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 partitions of all tables accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | This view displays the subpartition names, table names, partition names, 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 partition information of partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the subpartition information of partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUPS | This view displays the metadata of a table group, mainly the partition information of the table group. |
Load balancing
| View name | Description |
|---|---|
| oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT | This view displays all partitions with special weights set in all user tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS | This view displays all partition transfer tasks being processed by all tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of partition transfer tasks executed by all tenants. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | This view displays all partition transfer tasks being processed by the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of partition transfer tasks executed by the current tenant. |
| oceanbase.CDB_OB_BALANCE_JOBS | This view displays all load balancing jobs being executed by all tenants. Each tenant can run only one load balancing job at a time. Each load balancing job generates multiple load balancing tasks to perform specific 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 all 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 all 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 all load balancing jobs being executed by the current tenant. Each tenant can run only one load balancing job at a time. Each load balancing job generates multiple load balancing tasks to perform specific 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 all load balancing tasks being executed by the current tenant. Each tenant can run multiple load balancing tasks at a time, and these tasks belong to the same load balancing 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 all 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 | This view records the storage space usage of each tenant on the object storage. |
| DBA_OB_SS_SPACE_USAGE | This view records the storage space usage of the current tenant on the object storage. |
| DBA_OB_ZONE_STORAGE | This view displays the information about the object storage configured for the shared storage cluster on each zone. |
| oceanbase.CDB_OB_SPACE_USAGE | In the shared-storage (SS) mode, this view records the storage 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 | This view 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 as API nodes to the NDB cluster.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_TRX | This view displays the information about active transactions.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_LOCK_WAITS | This view displays 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 only the table structure can be queried. |
| 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 only the table structure can be queried. |
| 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 only the table structure can be queried. |
| 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 only the table structure can be queried. |
| 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 only the table structure can be queried. |
| information_schema.INNODB_CMP | This view displays the operation status information about compressing InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_CMP_PER_INDEX | This view displays the information about operations related to compressing InnoDB tables and indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | This view displays the reset time information about operations related to compressing InnoDB tables and indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_CMP_RESET | This view displays the operation status about compressing InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_CMPMEM | This view displays the status of compressed pages in the InnoDB buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_CMPMEM_RESET | This view displays the reset time of compressed pages in the InnoDB buffer pool.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_SYS_DATAFILES | This view displays the data file 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 only the table structure can be queried. |
| information_schema.INNODB_SYS_INDEXES | This view displays the metadata about InnoDB indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_SYS_TABLES | This view displays the metadata about InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_SYS_COLUMNS | This view has no description. |
| 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 only the table structure can be queried. |
| 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 only the table structure can be queried. |
| information_schema.INNODB_SYS_VIRTUAL | This view displays the metadata about InnoDB virtual generated columns.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_TEMP_TABLE_INFO | This view displays information about InnoDB temporary tables created by users.
NoteThis view is available starting with MySQL 5.7. The related functionality is not supported, and only the table structure can be queried. |
| information_schema.INNODB_METRICS | This view displays InnoDB performance information.
NoteThis view is available starting with MySQL 5.7. The related functionality is not supported, and only the table structure can be queried. |
Temporary files
| View name | Description |
|---|---|
| oceanbase.CDB_OB_TEMP_FILES | The CDB_OB_TEMP_FILES view displays information about temporary files. |
| oceanbase.DBA_OB_TEMP_FILES | The DBA_OB_TEMP_FILES 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 under the sys tenant. |
| oceanbase.CDB_OB_KV_TTL_TASK_HISTORY | This view displays the historical TTL tasks of all tenants under the sys tenant. |
| oceanbase.DBA_OB_KV_TTL_TASKS | This view displays the TTL tasks that are being executed by the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | This view displays the historical TTL tasks of the current tenant. |
| V$OB_KV_CLIENT_INFO | This view displays the configuration parameters of all OBKV tenant clients that are connected to the current node. |
| GV$OB_KV_CLIENT_INFO | This view displays the configuration parameters of all OBKV tenant clients that are connected to all nodes. |
| oceanbase.CDB_OB_KV_REDIS_TABLE | This view stores the unique commands of various data structures of Redis for all tenants and the corresponding storage table names. |
| oceanbase.DBA_OB_KV_REDIS_TABLE | This view stores the unique commands of various data structures of Redis for the current tenant and the corresponding storage table names. |
Outline
| View name | Description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | This view displays the execution plan outline information of the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | This view displays the outline 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 format outline of the current tenant. |
Full-text index
| View name | Description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | This view displays information about full-text indexes that are being deleted.
NoteThis view is provided for compatibility with MySQL 5.7. The related features are not supported, and 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 for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_FT_DELETED | This view displays information about full-text indexes that are marked for deletion.
NoteThis view is provided for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_FT_INDEX_CACHE | This view displays the cache status information of InnoDB full-text indexes.
NoteThis view is provided for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_FIELDS | This view displays the metadata information of key columns (fields) of InnoDB indexes, which is equivalent to the information of the SYS_FIELDS table in the InnoDB data dictionary.
NoteThis view is provided for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
Other index views
| View name | Description |
|---|---|
| oceanbase.DBA_INDEX_USAGE | This view displays index usage data. |
| oceanbase.CDB_INDEX_USAGE | This view displays index usage data. |
Task scheduling views
| View name | 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 views
| View name | 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 the 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 replica-level disaster recovery tasks 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 all tenant disaster recovery tasks. |
| 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 the 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 views
| View name | Description |
|---|---|
| oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY | This view displays the event history of the Root Service. |
SPM views
| View name | Description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | This view displays the SQL plan baselines in the SPM. |
| oceanbase.DBA_SQL_MANAGEMENT_CONFIG | This view displays the configuration parameters in the 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 views
| View name | Description | | oceanbase.DBA_OB_USER_DEFINED_RULES | This view records the rules for rewriting SQL statements in the current tenant. |
Upgrade views
| View name | Description |
|---|---|
| oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY | This view displays important cluster-level events, currently only supporting the display of cluster upgrade events. Only the system tenant can access this view. |
Event history monitoring
| View name | Description |
|---|---|
| information_schema.events | Records all event information. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | Displays the event history of an OBServer node. |
| oceanbase.CDB_OB_TENANT_EVENT_HISTORY | Displays the historical operation records of all tenants in the cluster. |
| oceanbase.DBA_OB_TENANT_EVENT_HISTORY | Displays the historical operation records of the current tenant. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the historical records of deadlock events. This view displays the historical records of the current tenant in a non-root tenant. |
Database basic information
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DATABASES | Displays the database metadata of all tenants under the sys tenant. |
| oceanbase.DBA_OB_DATABASES | Displays the database metadata of the current tenant. |
| oceanbase.DBA_OB_ZONES | Displays the information of all zones. |
Data dictionary
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG | Records the location range of the data dictionary in the system log stream to facilitate data dictionary consumption by CDC. |
| oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG | Records the location range of the data dictionary in the system log stream to facilitate data dictionary consumption by CDC. |
Locks
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | Displays the historical records of deadlock events. This view displays the historical records of all tenants in the root tenant. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the historical records of deadlock events. This view displays the historical records of the current tenant in a non-root tenant. |
Statistics and histograms
| 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 execution status of table statistics collection. |
| 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 status of historical statistics collection tasks in the current tenant. |
External resources
| 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 lists of all external tables created in all tenants. |
| oceanbase.DBA_OB_EXTERNAL_RESOURCES | This view displays all uploaded resource files. |
| oceanbase.DBA_OB_EXTERNAL_TABLE_FILES | This view displays the file lists of all external tables created in the current tenant. |
WR related
| View name | Description |
|---|---|
| oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data persisted for all tenants. |
| oceanbase.CDB_WR_CONTROL | This view displays the WR-related configuration information. |
| oceanbase.CDB_WR_EVENT_NAME | This view displays the tenant-level waiting event names persisted for all tenants. |
| oceanbase.CDB_WR_SNAPSHOT | This view displays the SNAPSHOT information for all tenants. |
| oceanbase.CDB_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed for all tenants. Each SQL statement is represented by 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 text 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 system statistics for all tenants. |
| oceanbase.CDB_WR_SYSTEM_EVENT | This view displays the tenant-level waiting event information persisted for all tenants. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data persisted for the current tenant. |
| oceanbase.DBA_WR_CONTROL | This view displays the WR-related configuration information. |
| oceanbase.DBA_WR_EVENT_NAME | This view displays the tenant-level waiting event names persisted for the current tenant. |
| oceanbase.DBA_WR_SNAPSHOT | This view displays the SNAPSHOT information for the current tenant. |
| oceanbase.DBA_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed for 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_SQLTEXT | This view displays the SQL text 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 system statistics for the current tenant. |
| oceanbase.DBA_WR_SYSTEM_EVENT | This view displays the persisted tenant-level wait events 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 key related
| View name | Description |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | This view displays metadata about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table of the InnoDB data dictionary.
NoteThis view is available starting with MySQL 5.7. It is only for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_FOREIGN_COLS | This view displays status information about InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table of the InnoDB data dictionary.
NoteThis view is available starting with MySQL 5.7. It is only for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
Materialized view related
| View name | Description |
|---|---|
| oceanbase.CDB_MVIEW_RUNNING_JOBS | This view displays the current materialized view-related tasks for all tenants, including refresh tasks and MLOG cleanup tasks. |
| 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 current materialized view-related tasks for the current tenant, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.DBA_MVIEWS | This view displays information about all materialized views. |
| oceanbase.DBA_MVREF_CHANGE_STATS | This view displays statistics about materialized view refreshes. |
| oceanbase.DBA_MVREF_RUN_STATS | This view displays information about each refresh run of materialized views. Each run is identified by a REFRESH_ID. |
| oceanbase.DBA_MVREF_STATS | This view displays 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 materialized view refresh history statistics attributes. |
| oceanbase.DBA_MVREF_STMT_STATS | This view displays 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 information about all materialized views. |
| oceanbase.CDB_MVREF_CHANGE_STATS | This view displays statistics about materialized view refreshes. |
| oceanbase.CDB_MVREF_RUN_STATS | This view displays information about each refresh run of materialized views. Each run is identified by a REFRESH_ID. |
| oceanbase.CDB_MVREF_STATS | This view displays 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 materialized view refresh history statistics attributes. |
| oceanbase.CDB_MVREF_STMT_STATS | This view displays information about the refresh statements. |
Vector index related
| View name | Description |
|---|---|
| oceanbase.CDB_OB_VECTOR_INDEX_TASKS | This view displays the information about 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 vector index partition rebuild tasks in all tenants of the cluster. |
| oceanbase.DBA_OB_VECTOR_INDEX_TASKS | This view displays the information about vector index partition rebuild tasks in the current tenant. |
| oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY | This view displays the historical information about vector index partition rebuild tasks in the current tenant. |
Dump (mini and minor compaction) and merge (major compaction) related
| View name | 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 related
| View name | Description |
|---|---|
| oceanbase.DBA_OBJECTS | This view displays all database objects in the database. The definition of this view is consistent with that of ALL_OBJECTS. |
| oceanbase.CDB_OBJECTS | This view displays the object information of all tenants under the sys tenant. |
| oceanbase.DBA_OB_TENANTS | This view displays the basic information of all tenants, including the sys tenant, user-created tenants (user tenants), and the meta tenant. You can use the TENANT_TYPE column to distinguish between different tenant types. |
| 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 configurations of system variables (including hidden variables that start with an underscore) of the current tenant. |
Resource management
| View name | Purpose |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | This view displays 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 unit information of all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | This view displays unit specifications of all tenants. |
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | This view displays all SEQUENCE objects in the database. |
| CDB_OB_RSRC_DIRECTIVES | This view displays resource configuration parameters of all tenants in the Resource Manager. |
Auto-increment column
| View name | Purpose |
|---|---|
| oceanbase.CDB_OB_AUTO_INCREMENT | This view displays auto-increment column information of all tables in the cluster. Only the sys tenant can query this view. |
| oceanbase.DBA_OB_AUTO_INCREMENT | This view displays auto-increment column information of all tables in the current tenant. |
Arbitration service
| View name | Purpose |
|---|---|
| oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS | This view displays arbitration service tasks running in the current tenant and corresponding user tenants. Only the sys tenant can query this view. |
| oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY | This view displays the history of arbitration service tasks executed by all tenants. Only the sys tenant can query this view. |
| oceanbase.DBA_OB_ARBITRATION_SERVICE | This view displays arbitration service configurations of the current cluster. Only the sys tenant can query this view. |
| oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS | This view displays 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 for all OBServer nodes of all tenants. |
| V$OB_ACTIVE_SESSION_HISTORY | Displays the active session history for the current OBServer node of all tenants. |
Catalog related
| View name | Description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | Displays the usage of HMS Catalog clients for all tenants. |
| V$OB_HMS_CLIENT_POOL_STAT | Displays the usage of HMS Catalog clients for 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 of 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 dynamic partition table information for all tenants. |
Shared storage
| View name | Description |
|---|---|
| V$OB_SS_SSTABLES | This view displays the SSTable information on shared storage for 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 for all tenants in shared storage mode. |
| V$OB_SS_LOCAL_CACHE | This view displays the metrics of various types of cached data in the local cache of the current OBServer node for all tenants in shared storage mode. |
| 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 status for all tenants on all OBServer nodes. |
| V$OB_TABLET_LOCAL_CACHE | This view displays the overall cache status for all tenants on the current OBServer node. |
| GV$OB_SERVER_STORAGE | This view displays the information about the object storage configured for the shared storage cluster on all OBServer nodes. |
| V$OB_SERVER_STORAGE | This view displays the information about the object storage configured for the shared storage cluster on the current OBServer node. |
| GV$OB_SS_OBJECT_TYPE_IO_STAT | This view displays the usage of read, write, or delete operations on objects of different types on each node of the tenant. |
| V$OB_SS_OBJECT_TYPE_IO_STAT | This view displays the usage of read, write, or delete operations on objects of different types 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 I/O calibration tasks. |
| V$OB_IO_CALIBRATION_STATUS | This view displays the execution status of I/O calibration tasks. |
| 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 in the plan cache on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans 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 memory statistics at the tenant level. |
| V$OB_MEMORY | This view displays memory statistics at the tenant level. |
| GV$OB_MEMSTORE | This view displays the memory usage of MemTables for all tenants on all servers. |
| V$OB_MEMSTORE | This view displays memory statistics at the tenant level. |
| GV$OB_MEMSTORE_INFO | This view displays detailed information about MemTables for all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | This view displays detailed information about MemTables for all partitions of all tenants on all servers. |
| GV$OB_SSTABLES | This view displays SSTable information for the tenant. |
| V$OB_SSTABLES | This view displays SSTable information for the 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 | Description |
|---|---|
| GV$OB_KV_GROUP_COMMIT_STATUS | In the sys tenant, the GV$OB_KV_GROUP_COMMIT_STATUS view displays the group commit status of all client connections of all OBKV tenants. |
| V$OB_KV_GROUP_COMMIT_STATUS | In the sys tenant, the V$OB_KV_GROUP_COMMIT_STATUS view displays the group commit status of all client connections of all OBKV tenants on the current node. |
| V$OB_VECTOR_MEMORY | This view displays the detailed statistics of vector index data memory usage for all tenants. |
PS
| View | Description |
|---|---|
| GV$OB_PS_STAT | This view displays the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | This view displays 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 and displays the basic information of all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | This view provides monitoring capabilities for prepared statements and displays the basic information of all prepared statements in the PS cache. |
PX
| View | 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 PX thread usage on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | This view displays the PX thread usage on the OBServer node. |
End-to-end tracing
| View | Description |
|---|---|
| GV$OB_FLT_TRACE_CONFIG | This view displays diagnostic information about end-to-end tracing. |
Lock
| View | Description |
|---|---|
| GV$LATCH | This view displays the latch information of all OBServer nodes in the cluster. |
| V$LATCH | This view displays the latch information of all OBServer nodes in the cluster. |
Overview of views in a MySQL-compatible tenant
Dictionary views overview
Security and privileges
| View | Description |
|---|---|
| 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 table-level privileges granted to active roles in the current session and table-level privileges granted to other roles by these roles. |
| information_schema.ROLE_COLUMN_GRANTS | This view displays column-level privileges granted to active roles in the current session and column-level privileges granted to other roles by these roles. |
| information_schema.ROLE_ROUTINE_GRANTS | This view displays routine-level privileges granted to active roles in the current session and routine-level 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. |
Backup and restore
| View name | Description |
|---|---|
| oceanbase.DBA_OB_BACKUP_JOBS | This view displays the backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | This view displays the history of backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | This view displays the task-level backup tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | This view displays the history of task-level backups of 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 cleanup policy set for expired/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 tasks executed in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | This view displays information about backup_set/backup_piece cleanup tasks being executed in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of backup_set/backup_piece cleanup tasks completed 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 restore 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 restore 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. |
Tables and columns
| View | Description |
|---|---|
| information_schema.COLUMNS | This view records column information. |
| information_schema.STATISTICS | This view records table index information. |
| information_schema.TABLES | This view records table information. |
| information_schema.VIEWS | This view records view information. |
| information_schema.VIEW_TABLE_USAGE | This view displays the information about tables and views used in the view definition. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | This view displays the association between a tablegroup and a table. A table not in a tablegroup is not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | This view displays the columns in the partitioning key of all partitioning objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | This view displays the columns in the subpartitioning key of all partitioning objects in the database. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | This view displays the locations of tables and partitions, including system tables, user tables, and index tables. |
| oceanbase.DBA_OB_TABLE_SPACE_USAGE | This view displays the sizes of all user tables in the current tenant (in a multi-replica environment, the leader replica is used as the reference). |
| information_schema.TABLESPACES | This view displays information about tablespaces.
NoteThis view is available starting with MySQL 5.7. However, the related features are not supported. You can only query the table structure. |
Triggers
| View | Description |
|---|---|
| information_schema.TRIGGERS | This view displays the CREATE TRIGGER statement used to create a trigger. |
Storage
| View | Description |
|---|---|
| mysql.proc | This view displays information about stored procedures. |
| mysql.func | No description is provided. |
| information_schema.ENGINES | This view records information about storage engines. |
| information_schema.PARAMETERS | This view provides information about the parameters and return values of stored procedures. |
| information_schema.ROUTINES | This view provides 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. |
Partitioning
| 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 tables 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 user table partitions. |
| oceanbase.DBA_TAB_PARTITIONS | This view displays the multi-level partition information, partition storage parameters, and partition statistics that are accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | This view displays the subpartition names, table names, names of the partitions to which the subpartitions belong, their storage attributes, and the statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | This view displays the descriptions 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 groups. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of the partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUPS | This view displays the metadata of the table groups, mainly the partition information of the table groups. |
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 streams 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 streams to which they belong. |
| 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, together with the mysql.help_category, mysql.help_relation, and mysql.help_keyword tables, generates Help commands. |
| mysql.help_category | This view, together with the mysql.help_relation, mysql.help_topic, and mysql.help_keyword tables, generates Help commands. |
| mysql.help_keyword | This view, together with the mysql.help_relation, mysql.help_topic, and mysql.help_category tables, generates Help commands. |
| mysql.help_relation | This view, together with the mysql.help_category, mysql.help_topic, and mysql.help_keyword tables, generates Help commands. |
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 locks that are waiting for a lock conflict.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for 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 can only be queried for table structure. |
| information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP | This view displays the mapping information between NDB transactions, NDB transaction coordinators, and MySQL servers that are attached as API nodes to an NDB cluster.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for 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 can only be queried for 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 can only be queried for table structure. |
| information_schema.INNODB_BUFFER_PAGE_LRU | This view displays the LRU-ordered 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 be queried for 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 can only be queried for table structure. |
| information_schema.INNODB_CMP | This view displays the operation status of compressing InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for table structure. |
| information_schema.INNODB_CMP_PER_INDEX | This view displays information about operations related to compressing InnoDB tables and indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for table structure. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | This view displays the reset time of operations related to compressing InnoDB tables and indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for table structure. |
| information_schema.INNODB_CMP_RESET | This view displays the operation status of compressing InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for 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 be queried for table structure. |
| information_schema.INNODB_CMPMEM_RESET | This view displays the reset time 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 be queried for table structure. |
| information_schema.INNODB_SYS_DATAFILES | This view displays the data file path information for each table and general tablespace.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for table structure. |
| information_schema.INNODB_SYS_INDEXES | This view displays metadata about InnoDB indexes.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for table structure. |
| information_schema.INNODB_SYS_TABLES | This view displays metadata about InnoDB tables.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for table structure. |
| information_schema.INNODB_SYS_TABLESPACES | This view displays metadata about InnoDB table files and general tablespaces.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for table structure. |
| information_schema.INNODB_SYS_TABLESTATS | This view displays 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 be queried for table structure. |
| information_schema.INNODB_SYS_VIRTUAL | This view displays metadata about InnoDB virtual generated columns.
NoteThis view is available starting with MySQL 5.7. The related features are not supported and can only be queried for 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. The related features are not supported, and only the table structure can be queried. |
| information_schema.INNODB_METRICS | This view displays InnoDB performance information.
NoteThis view is available starting with MySQL 5.7. The related features are not supported, and only the table structure can be queried. |
Spatial
| View name | Description |
|---|---|
| information_schema.ST_GEOMETRY_COLUMNS | This view displays the 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 to the OBKV tenant on the current node. |
| GV$OB_KV_CLIENT_INFO | This view displays the configuration parameters of the client connections to the OBKV tenant. |
| oceanbase.DBA_OB_KV_REDIS_TABLE | This view stores the specific commands for various data structures of 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 outlines and throttling rule outlines of the current tenant. |
| DBA_OB_FORMAT_OUTLINES | This view records the detailed information of the Format outlines of the current tenant. |
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 provided for compatibility with MySQL 5.7. The related features are not supported, and 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 for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_FT_DELETED | This view displays the information of the full-text indexes that are marked for deletion.
NoteThis view is provided for compatibility with MySQL 5.7. The related features are not supported, and 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 for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| 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 provided for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
Job 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 time zone information (SYSTEM_VIEW). |
| mysql.time_zone_name | This view records the name of a timezone (SYSTEM_VIEW). |
| mysql.time_zone_transition | mysql.time_zone_transition is a system view that records timezone conversion information. |
| mysql.time_zone_transition_type | This view records the type of a timezone conversion (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 the global variables. |
| information_schema.SCHEMATA | This view records the database metadata. |
| oceanbase.DBA_OB_DATABASES | This view displays the database metadata of a tenant. |
Audit related
| View name | Description |
|---|---|
| mysql.audit_log_filter | This view displays the definition of an audit filter. |
| mysql.audit_log_user | This view displays the mapping between an audit filter and a user. |
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 a tenant in SPM. |
Session related
| View name | Description |
|---|---|
| information_schema.SESSION_STATUS | This view records the session status information, such as the number of active connections and the database uptime. |
| information_schema.SESSION_VARIABLES | This view records the session variables. |
Statistics and histograms
| View | Purpose |
|---|---|
| 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 the response time, for Prometheus monitoring. |
| oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | This view queries the historical collection execution of a table. |
| oceanbase.CDB_OB_AUX_STATISTICS | This view displays the auxiliary statistics of all tenants. |
| information_schema.OPTIMIZER_TRACE | This view is available only for MySQL 5.7 compatibility. The related features are not supported. You can only query the table structure. |
Materialized views
| View | Description |
|---|---|
| oceanbase.DBA_MVIEW_DEPS | This view displays the dependencies of materialized views in the current tenant. |
| oceanbase.DBA_MVIEW_LOGS | This view displays the logs of materialized views. |
| oceanbase.DBA_MVIEW_RUNNING_JOBS | This view displays the running tasks of materialized views in the current tenant, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.DBA_MVIEWS | This view displays the information of all materialized views. |
| oceanbase.DBA_MVREF_CHANGE_STATS | This view displays the statistics related to materialized view refreshes. |
| oceanbase.DBA_MVREF_RUN_STATS | This view displays the information of 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 attributes associated with each materialized view. |
| oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS | This view displays the system-level default values of the statistics attributes of materialized view refreshes. |
| oceanbase.DBA_MVREF_STMT_STATS | This view displays the information of the refresh statements. |
WR views
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | This view displays the SNAPSHOT information of the current tenant. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data of the current tenant. |
| oceanbase.DBA_WR_STATNAME | This view displays the names of the system statistics 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. |
| oceanbase.DBA_WR_EVENT_NAME | This view displays the tenant-level wait event names of the current tenant. |
| oceanbase.DBA_WR_SQLTEXT | This view displays the SQL texts collected by WR of the current tenant. |
| oceanbase.DBA_WR_SQLSTAT | This view displays the basic performance statistics of the SQL statements executed by the current tenant. Each SQL statement is displayed as a row (i.e., each unique value of SQL_ID + 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 views
| 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 views
| View name | Description |
|---|---|
| information_schema.PROCESSLIST | This view displays the information of running threads. |
Constraint views
| 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 information of major compactions in the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the information of major compactions in each zone of 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 mapping 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 that of 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 of the current tenant. |
Shared storage
| View name | Description |
|---|---|
| V$OB_SS_SSTABLES | This view displays the SSTable information on the shared storage of the current tenant. |
| GV$OB_SS_LOCAL_CACHE | This view displays the metrics of various types of cached data in the local cache of each OBServer node for all tenants in the shared storage mode. |
| V$OB_SS_LOCAL_CACHE | This view displays the metrics of various types of cached data in the local cache of the current OBServer node for all tenants in the shared storage mode. |
| GV$OB_STORAGE_CACHE_TASKS | This view displays the cache task information for the current tenant on all OBServer nodes. |
| V$OB_STORAGE_CACHE_TASKS | This view displays the cache task information for the current tenant on the current OBServer node. |
| GV$OB_TABLET_LOCAL_CACHE | This view displays the overall cache information for the current tenant on all OBServer nodes. |
| V$OB_TABLET_LOCAL_CACHE | This view displays the overall cache information for the current tenant on the current OBServer node. |
I/O
| View name | Description |
|---|---|
| GV$OB_SHARED_STORAGE_QUOTA | This view displays the I/O resource information on all OBServer nodes. |
| V$OB_SHARED_STORAGE_QUOTA | This view displays the I/O resource information 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 views
| 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 detailed information about MemTables for all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | This view displays detailed information about MemTables for all partitions of all tenants on all servers. |
| GV$OB_SSTABLES | This view displays 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 views
| 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 views
| 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 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 definitions of all statistical events. |
| V$EVENT_NAME | This view displays definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | This view displays details of current waiting events for each session. As per the agreement, each waiting event will have three parameters, each of which will record the corresponding value. |
| V$SESSION_WAIT_HISTORY | This view displays details of current waiting events for each session, including the most recent 10 waiting events. |
| V$SESSTAT | This view displays an 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 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 information of a database
| 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 nodes 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 current 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 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 OceanBase Database release version. |
| GV$OB_KV_CONNECTIONS | This view displays the statistics of OBKV connections held by all servers. |
| V$OB_KV_CONNECTIONS | This view displays the statistics of OBKV connections held by 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 views
| View | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | This view displays the overall status of each plan cache for the current tenant on all OBServer nodes. |
| V$OB_PLAN_CACHE_STAT | This view records the overall status of each plan cache for the current tenant on all servers. |
| GV$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache for the current tenant on all servers. |
| V$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache for the current tenant on the current server. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache of all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache of the current server. |
| GV$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | This view provides monitoring capabilities for prepared statements, 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. |
| 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 end-to-end 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
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | The statistics of the workarea of all operators executed under automatic memory management for SQL statements. |
| GV$SQL_WORKAREA_ACTIVE | The statistics of the workarea of the active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | The statistics of the workarea of all operators executed under automatic memory management for SQL statements, such as the number of times the workarea is fully processed in memory in the range of 1 MB to 2 MB and the number of one-pass operations. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | The overall information of the SQL workarea, such as the maximum available memory, current used memory, and current held memory. |
| V$SQL_WORKAREA | The statistics of the workarea of all operators executed under automatic memory management for SQL statements. |
| V$SQL_WORKAREA_ACTIVE | The statistics of the workarea of the active operators. |
| V$SQL_WORKAREA_HISTOGRAM | The statistics of the workarea of all operators executed under automatic memory management for SQL statements, such as the number of times the workarea is fully processed in memory in the range of 1 MB to 2 MB and the number of one-pass operations. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | The overall information of 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 | The histogram of the execution time of all queries on all nodes of the current tenant. |
| GV$OB_RES_MGR_SYSSTAT | The statistics of the resource groups on all OBServer nodes of the current tenant. |
| GV$OB_SQLSTAT | 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 | 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 | The session-level time model statistics in the cluster. |
| V$OB_SESS_TIME_MODEL | The session-level time model statistics on the current node. |
| GV$OB_SYS_TIME_MODEL | The tenant-level time model statistics in the cluster. |
| V$OB_SYS_TIME_MODEL | The tenant-level time model statistics on the current node. |
| V$OB_RES_MGR_SYSSTAT | The statistics of the resource groups on the current OBServer node of the current tenant. |
Network views
| View Name | Description |
|---|---|
| GV$OB_RPC_OUTGOING | This view displays the statistics of RPCs sent by all OBServer nodes. |
| GV$OB_RPC_INCOMING | This view displays the statistics of RPCs received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | This view displays the statistics of RPCs sent by different tenants on each OBServer node. |
| V$OB_RPC_INCOMING | This view displays the statistics of RPCs received by different tenants on each OBServer node. |
Thread views
| 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. |
Overview of views in an Oracle-compatible tenant
Dictionary views
Applicability
This topic applies only to OceanBase Database Enterprise Edition.
Security privileges
| View name | 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. It also displays column object privileges granted to enabled roles or the PUBLIC role. |
| ALL_TAB_PRIVS |
|
| DBA_COL_PRIVS | This view displays all column object privileges granted in the database. |
| DBA_SYS_PRIVS | This view displays system privileges granted to users and roles. |
| DBA_TAB_PRIVS | This view displays all object privileges granted in the database. |
| USER_TAB_PRIVS | This view displays object privileges owned by the current user. |
| USER_COL_PRIVS | This view displays column object privileges granted to the current user 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. It provides information about roles that users can access. |
| ROLE_SYS_PRIVS | This view displays system privileges granted to roles. |
| ROLE_ROLE_PRIVS | This view displays roles granted to other roles. It provides information about roles that users can access. |
| 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 to control the current user. |
| DBMS_LOCK_ALLOCATED | This view displays the DBMS_LOCK information that has been applied for and 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. |
Security policy views
| View | Purpose |
|---|---|
| ALL_POLICIES | This view displays the access control policies accessible to the current user. When access control is applied to a table, multiple policies can be created for the table. |
| ALL_POLICY_CONTEXTS | This view displays the context information of views accessible to the current user. When accessing a view, the corresponding strategy group is selected based on the context value. |
| ALL_POLICY_GROUPS | This view displays the strategy group information of all views accessible to the current user. It works with the strategy context to apply different strategies to different users. |
| ALL_SEC_RELEVANT_COLS | This view displays the information of all columns associated with strategies in tables or views accessible to the current user. When a column is associated with a column-level strategy, the corresponding strategy is applied when accessing the column. |
| USER_POLICIES | This view displays the access control policies owned by the current user. When access control is applied to a table, multiple policies can be created for the table. |
| USER_POLICY_CONTEXTS | This view displays the context information of views owned by the current user. When accessing a view, the corresponding strategy group is selected based on the context value. |
| USER_POLICY_GROUPS | This view displays the strategy group information of views owned by the current user. It works with the strategy context to apply different strategies to different users. |
| USER_SEC_RELEVANT_COLS | This view displays the information of all columns associated with strategies in tables or views owned by the current user. When a column is associated with a column-level strategy, the corresponding strategy is applied when accessing the column. |
| DBA_POLICIES | This view displays the access control policies of all tables or views in the current tenant. When access control is applied to a table, multiple policies can be created for the table. |
| DBA_POLICY_CONTEXTS | This view displays the context information of all views in the current tenant. When accessing a view, the corresponding strategy group is selected based on the context value. |
| DBA_POLICY_GROUPS | This view displays the strategy group information of all views in the current tenant. It works with the strategy context to apply different strategies to different users. |
| DBA_SEC_RELEVANT_COLS | This view displays the information of all columns associated with strategies in tables or views in the current tenant. When a column is associated with a column-level strategy, the corresponding strategy is applied when accessing the column. |
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 backup jobs of the current tenant. |
| DBA_OB_BACKUP_TASKS | This view displays the task-level backup tasks of the current tenant. |
| DBA_OB_BACKUP_TASK_HISTORY | This view displays the history of task-level backup tasks of the current tenant. |
| DBA_OB_BACKUP_SET_FILES | This view displays the file status of a backup set. |
| DBA_OB_RESTORE_PROGRESS | This view displays the progress of ongoing restore tasks. |
| DBA_OB_RESTORE_HISTORY | This view displays the history of completed restore tasks. |
| DBA_OB_ARCHIVE_DEST | This view displays the archive destination configuration. |
| DBA_OB_BACKUP_STORAGE_INFO | This view displays the information about the backup destination used for backup and restore in the current tenant. |
| DBA_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the history of the information about the backup destination used for backup and restore in the current tenant. |
| DBA_OB_BACKUP_DELETE_POLICY | This view displays the deletion policy set for expired or automatic deletion in the current tenant. |
| DBA_OB_BACKUP_DELETE_JOBS | This view displays the progress of tenant-level backup deletion jobs. |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of backup deletion tasks executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASKS | This view displays the information about backup_set/backup_piece deletion tasks being executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of backup_set/backup_piece deletion tasks completed in the current tenant. |
| DBA_OB_ARCHIVELOG | This view displays the status of log backups on each path. |
| DBA_OB_ARCHIVELOG_SUMMARY | This view displays the status of all log backups in the history and current time. |
| DBA_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of pieces in a backup set. |
| DBA_OB_BACKUP_PARAMETER | This view displays backup parameters. |
| DBA_OB_RECOVER_TABLE_JOBS | This view displays information about table-level 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 the object tables and relational tables accessible to the current user. |
| ALL_COL_COMMENTS | This view displays the comments on all columns of the views and tables accessible to the current user. |
| ALL_TABLES | This view displays all tables accessible to the current user. |
| ALL_TAB_COLS | This view displays all columns of the tables, views, and clusters accessible to the current user. |
| ALL_TAB_COLUMNS | This view displays all columns of the tables, views, and clusters accessible to the current user. |
| ALL_TAB_COMMENTS | This view displays the comments on the tables and views accessible to the current user. |
| DBA_COL_COMMENTS | This view displays the comments on all columns of all views and tables in the database. |
| DBA_TAB_COMMENTS | This view displays the comments on all tables and views in the database. |
| USER_COL_COMMENTS | This view displays the comments on all columns of the views and tables owned by the current user. |
| USER_TAB_COMMENTS | This view displays the comments on the tables and views owned by the current user. |
| DBA_OB_TABLEGROUP_TABLES | This view displays the associations between the TABLEGROUP and TABLE. It does not display tables that are not in a TABLEGROUP. |
| DBA_TABLES | This view displays all tables in the database. |
| DBA_ALL_TABLES | This view displays the object tables and relational tables in the database. Its fields are the same as those of the ALL_ALL_TABLES view. |
| DBA_TABLESPACES | This view displays all tablespaces in the database. |
| DBA_TAB_COLS | This view displays all columns of the tables, views, and clusters in the database. |
| DBA_TAB_COLUMNS | This view displays all columns of the tables, views, and clusters in the database. |
| USER_ALL_TABLES | This view displays the object tables and relational tables accessible to the current user. Except for the OWNER field, its other fields are the same as those of the ALL_ALL_TABLES view. |
| USER_TABLES | This view displays all tables owned by the current user. |
| USER_TABLESPACES | This view displays the tablespaces accessible to the current user. Its columns are the same as those of the DBA_TABLESPACES view, except for the PLUGGED_IN field. |
| USER_TAB_COLS | This view displays all columns of the tables, views, and clusters owned by the current user. |
| USER_TAB_COLUMNS | This view displays all columns of the tables, views, and clusters owned by the current user. |
| ALL_VIEWS | This view displays the views accessible to the current user. |
| DBA_VIEWS | This view displays all views in the database. Its columns are the same as those in ALL_VIEWS. |
| USER_VIEWS | This view displays the 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 or 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 (based on the leader replica in a multi-replica environment) in the current tenant. |
CCL
| View | Description |
|---|---|
| DBA_OB_CCL_RULES | This view records all the throttling rules for the current user tenant. |
Storage objects
| View | Description |
|---|---|
| ALL_ERRORS | This view displays the errors of the current storage objects that the user can access. |
| DBA_ERRORS | This view displays the errors of the current storage objects in the database. |
| USER_ERRORS | This view displays the errors of the current storage objects that the user can access. |
| DBA_SEGMENTS | This view displays the storage information of all segments in the database. |
| USER_SEGMENTS | This view displays the storage information of the segments of the objects in the current user's schema. |
| DBA_OB_SOURCE | This view displays the source code information of all storage objects in the current tenant. |
| USER_OB_SOURCE | This view displays the source code information of the storage objects owned by the current user. |
| ALL_OB_SOURCE | This view displays the source code information of the storage objects that the current user can access. |
Triggers
| View | Description |
|---|---|
| ALL_TRIGGERS | This view displays the triggers and descriptions of 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 | This view displays all triggers in the database. |
| USER_TRIGGERS | This view displays the triggers owned by the current user. |
| ALL_TRIGGER_ORDERING | This view displays the ordering of all triggers that the current user can access. |
| DBA_TRIGGER_ORDERING | This view displays the ordering of all triggers in the current tenant. |
| USER_TRIGGER_ORDERING | This view displays the ordering of the triggers owned by the current user. |
Object management
| View | Description |
|---|---|
| ALL_OBJECTS | This view displays all database objects that the current user can access. |
| DBA_OBJECTS | This view displays all database objects in the database. |
| USER_OBJECTS | This view displays all database objects owned by the current user. |
| ALL_DEPENDENCIES | This view displays the dependencies between all objects in the database. |
| DBA_DEPENDENCIES | This view displays all dependencies between objects in the database. |
| USER_DEPENDENCIES | This view displays the dependencies between objects in the current user's schema. |
Object type views
| View name | Description |
|---|---|
| ALL_METHOD_PARAMS | This view displays the method parameters of all object types that the current user can access. |
| ALL_TYPE_METHODS | This view displays the methods of all object types that the current user can access. |
| 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 that the current user can access, except for the OWNER field. The field information is consistent with that of ALL_TYPE_METHODS. |
DBLINK views
| View name | Description |
|---|---|
| ALL_DB_LINKS | This view displays all DBLINKs that the current user can access. |
| 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 views
| View name | Description |
|---|---|
| DBA_OB_SERVICES | This view displays all SERVICE_NAME information in the current tenant. |
Auxiliary statistics views
| 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 processed in the current tenant. Each tenant can have only one load balancing job (JOB) running at the same time. Each load balancing job generates multiple load balancing tasks (TASK) for specific load balancing 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 processed in the current tenant. Each tenant can have multiple load balancing tasks being processed at the same time, and these 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 processed in the current tenant. |
| DBA_OB_TRANSFER_TASK_HISTORY | This view displays the history of Transfer tasks executed in the current tenant. |
Replica log
| View name | Description |
|---|---|
| DBA_OB_CS_REPLICA_STATS | This view displays the progress of converting tablets into columnar storage in the C replica log streams on each OBServer in the current tenant. |
| DBA_OB_LS_LOCATIONS | This view displays the distribution 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 tablets in the current tenant and the log stream information to which each tablet belongs. |
| DBA_OB_LS | This view displays the status and restore 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 log streams that have existed in the current tenant in the past. |
| 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 the information about each log pruning operation in the current tenant. |
Partition views
| View name | Description |
|---|---|
| ALL_PART_KEY_COLUMNS | This view displays the columns in the partition keys of all partitioned objects accessible to the current user. |
| ALL_PART_TABLES | This view displays the partition information of all partitioned tables accessible to the current user. |
| ALL_SUBPARTITION_TEMPLATES | This view displays the descriptions of all subpartition templates. |
| ALL_SUBPART_KEY_COLUMNS | This view displays the columns in the subpartition keys of all partitioned objects accessible to the current user. |
| ALL_TAB_PARTITIONS | This view displays the partition information, partition storage parameters, and partition statistics of all partitioned tables. |
| ALL_TAB_SUBPARTITIONS | This view displays the partition information, partition storage parameters, and partition statistics of the partitions generated for the current user by the DBMS_STATS package. |
| DBA_OB_DYNAMIC_PARTITION_TABLES | This view displays the information about dynamic partition tables in the current tenant. |
| DBA_PART_INDEXES | This view displays the partition information of all partitioned indexes. |
| DBA_PART_KEY_COLUMNS | This view displays the columns in the partition keys of all partitioned objects in the database. |
| DBA_PART_TABLES | This view displays the partition information of all partitioned tables accessible to the current user. |
| DBA_SUBPARTITION_TEMPLATES | This view displays the descriptions of all subpartition templates. |
| DBA_SUBPART_KEY_COLUMNS | This view displays the columns in the subpartition keys of all partitioned objects in the database. |
| DBA_TAB_PARTITIONS | This view displays the partition information, partition storage parameters, and partition statistics of all partitioned tables accessible to the current user. |
| DBA_TAB_SUBPARTITIONS | This view displays the subpartition names, table names, names of their parent partitions, storage attributes, and statistics generated by the DBMS_STATS package. |
| USER_PART_KEY_COLUMNS | This view displays the columns in the partition keys of all partitioned objects owned by the current user. |
| USER_PART_TABLES | This view displays the partition information of all partitioned tables owned by the current user. |
| USER_SUBPARTITION_TEMPLATES | This view displays the descriptions of all subpartition templates. |
| USER_SUBPART_KEY_COLUMNS | This view displays the columns in the subpartition keys of all partitioned objects owned by the current user. |
| USER_TAB_SUBPARTITIONS | This view displays the subpartition names, table names, names of their parent partitions, and storage attributes of each subpartition in the tables owned by the current user. |
| USER_TAB_PARTITIONS | This view displays the partition information, partition storage parameters, and partition statistics of all partitioned tables owned by the current user. |
| DBA_OB_TABLEGROUPS | This view displays the metadata of a table group, mainly the partition information of the table group. |
| 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 | Description |
|---|---|
| DBA_OB_SS_SPACE_USAGE | This view records the storage space usage on the object storage of the current tenant. |
Recyclebin
| View name | Description |
|---|---|
| DBA_RECYCLEBIN | This view displays information about all recyclebins in the database. |
| USER_RECYCLEBIN | This view displays information about the recyclebins owned by the current user. The columns are the same as those in DBA_RECYCLEBIN, except that the OWNER column is removed. |
Functions and procedures
| View name | Description |
|---|---|
| ALL_ARGUMENTS | This view displays the parameters of the functions and procedures that the current user can access. |
| ALL_PROCEDURES | This view displays all functions and procedures that the current user can access, along with their related attributes. |
| ALL_SOURCE | This view displays the text sources of the stored objects that the current user can access. |
| 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, along with 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 that the OWNER column is removed. |
| USER_PROCEDURES | This view displays all functions and procedures owned by the current user, along with their related attributes. The columns are the same as those in ALL_PROCEDURES, except that the OWNER column is removed. |
| 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 that the OWNER column is removed. |
| 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 | Description |
|---|---|
| DBA_OB_STORAGE_IO_USAGE | This view displays the I/O operations on the object storage and cloud disks of the current tenant. |
Temporary files
| View name | Description |
|---|---|
| DBA_OB_TEMP_FILES | This view displays information about temporary files. |
NLS related
| View name | Purpose |
|---|---|
| NLS_DATABASE_PARAMETERS | This view displays NLS parameters at the database level (OceanBase Database tenant level). |
| NLS_INSTANCE_PARAMETERS | This view displays NLS parameters at the instance level (tenant level). |
| NLS_SESSION_PARAMETERS | This view displays NLS parameters at the session level. |
Outline related
| View name | Purpose |
|---|---|
| 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-related 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 | Description |
|---|---|
| ALL_PLSQL_COLL_TYPES | The ALL_PLSQL_COLL_TYPES view displays the general information about collection types defined in packages. |
| ALL_PLSQL_TYPES | The ALL_PLSQL_TYPES view displays the general information about package types. |
| ALL_PLSQL_TYPE_ATTRS | The ALL_PLSQL_TYPE_ATTRS view displays the general information about record types defined in packages. |
| USER_PLSQL_COLL_TYPES | The USER_PLSQL_COLL_TYPES view displays the general information about collection types defined in the current user's packages. Only when the package is successfully compiled can the types in the package be displayed in this view. |
| USER_PLSQL_TYPES | The USER_PLSQL_TYPES view displays the general information about package types in the current user's packages. Only when the package is successfully compiled can the types in the package be displayed in this view. |
| USER_PLSQL_TYPE_ATTRS | The USER_PLSQL_TYPE_ATTRS view displays the general information about record types defined in the current user's packages. Only when the package is successfully compiled can the types in the package be displayed in this view. |
| DBA_PLSQL_COLL_TYPES | The DBA_PLSQL_COLL_TYPES view displays the general information about collection types defined in the current tenant's packages. Only when the package is successfully compiled can the types in the package be displayed in this view. |
| DBA_PLSQL_TYPES | The DBA_PLSQL_TYPES view displays the general information about package types in the current tenant's packages. Only when the package is successfully compiled can the types in the package be displayed in this view. |
| DBA_PLSQL_TYPE_ATTRS | The DBA_PLSQL_TYPE_ATTRS view displays the general information about record types defined in the current tenant's packages. Only when the package is successfully compiled can the types in the package be displayed in this view. |
PROFILE related
| View | Description |
|---|---|
| ALL_PROFILES | This view displays all profiles and their restrictions. |
| DBA_PROFILES | This view displays all profiles and their restrictions. |
| USER_PROFILES | This view displays all profiles and their restrictions. |
Disaster recovery related
| View | Description |
|---|---|
| DBA_OB_ACCESS_POINT | This view displays the list of OBServer nodes in the current tenant. In a physical standby database scenario, it is primarily 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 | This view displays the ongoing disaster recovery tasks at the replica level for the current tenant. |
| DBA_OB_LS_REPLICA_TASK_HISTORY | This view displays the execution history of all disaster recovery tasks across all tenants. |
Task scheduling
| View | Purpose |
|---|---|
| DBA_SCHEDULER_JOBS | This view displays the information about scheduler jobs accessible to the current user. |
| DBA_SCHEDULER_PROGRAM | This view displays the information about all scheduler programs in the database. |
| DBA_SCHEDULER_JOB_RUN_DETAILS | This view displays the information about all scheduler jobs in the tenant. |
| ALL_SCHEDULER_JOB_ARGS | This view displays the information about scheduler job arguments accessible to the current user. |
| ALL_SCHEDULER_PROGRAM_ARGS | This view displays the information about scheduler program arguments accessible to the current user. |
| DBA_SCHEDULER_JOB_ARGS | This view displays the information about scheduler job arguments in the database. |
| USER_SCHEDULER_JOB_ARGS | This view displays the information about scheduler job arguments owned by the current user. |
| DBA_SCHEDULER_PROGRAM_ARGS | This view displays the information about scheduler program arguments in the database. |
| USER_SCHEDULER_PROGRAM_ARGS | This view displays the information about scheduler program arguments owned by the current user. |
| USER_SCHEDULER_JOBS | This view displays the information about scheduler jobs accessible to the current user. |
| ALL_SCHEDULER_WINDOWS | This view displays the information about all scheduler windows accessible to the current user. |
| DBA_SCHEDULER_WINDOWS | This view displays the information about all scheduler windows in the current tenant. |
Audit views
| 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 the corresponding name in 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, name, and priority of the statement-level audit. |
| USER_AUDIT_OBJECT | This view displays the audit tracking records for objects that the current user can access. |
| 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 views
| View Name | Purpose |
|---|---|
| DBA_SQL_PLAN_BASELINES | This view displays the plan baselines of SQL statements in SPM. |
| DBA_SQL_MANAGEMENT_CONFIG | This view displays the configuration parameters in SPM. |
| DBA_OB_SPM_EVO_RESULT | This view displays the plan evolution information of the current tenant in SPM. |
Index views
| View | Purpose |
|---|---|
| ALL_INDEXES | This view displays the index column information for all tables accessible to the current user. |
| ALL_IND_COLUMNS | This view displays the index column information for all tables accessible to the current user. |
| ALL_IND_EXPRESSIONS | This view displays the information about function-based indexes accessible to the current user. |
| ALL_IND_PARTITIONS | This view displays the information about index partitions accessible to the current user. |
| ALL_IND_SUBPARTITIONS | This view displays the information about index subpartitions accessible to the current user. |
| ALL_PART_INDEXES | This view displays the partition information for partition indexes accessible to the current user. |
| DBA_INDEXES | This view displays the index information for all tables in the database. |
| DBA_IND_COLUMNS | This view displays the index column information for all tables in the database. |
| DBA_IND_EXPRESSIONS | This view displays the information about all function-based indexes in the database. |
| DBA_IND_PARTITIONS | This view displays the information about all index partitions in the database. |
| DBA_IND_SUBPARTITIONS | This view displays the information about all index subpartitions in the database. |
| USER_INDEXES | This view displays the index information for all tables owned by the current user. |
| USER_IND_COLUMNS | This view displays the index column information for all tables owned by the current user. |
| USER_IND_EXPRESSIONS | This view displays the information about function-based indexes owned by the current user. |
| USER_IND_PARTITIONS | This view displays the information about index partitions owned by the current user. This view does not contain the INDEX_OWNER column. |
| USER_IND_SUBPARTITIONS | This view displays the information about index subpartitions owned by the current user. This view does not contain the INDEX_OWNER column. |
| USER_PART_INDEXES | This view displays the partition information for partition indexes owned by the current user. |
| DBA_INDEX_USAGE | This view displays the index usage data. |
Data dictionary views
| View | Purpose |
|---|---|
| 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 that start with an underscore. |
Locks
| View name | Purpose |
|---|---|
| DBA_OB_DEADLOCK_EVENT_HISTORY | This view displays the history of deadlock events. In non-root tenants, this view displays the history of events in the current tenant. |
Views related to statistics and histograms
| View name | Description |
|---|---|
| ALL_PART_COL_STATISTICS | This view displays the column statistics and histogram information of the partitions in the partitioned tables accessible to the current user. |
| ALL_PART_HISTOGRAMS | This view displays the histogram information of all partitions. |
| ALL_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information of the subpartitions in the partitioned tables accessible to the current user. |
| ALL_SUBPART_HISTOGRAMS | This view displays the histogram information of all subpartitions. |
| ALL_TAB_COL_STATISTICS | This view displays the column statistics and histogram information of the tables accessible to the current user. |
| ALL_TAB_HISTOGRAMS | This view displays the histogram information of all tables. |
| ALL_TAB_STATISTICS | This view displays the optimizer statistics of the tables accessible to the current user. |
| DBA_PART_COL_STATISTICS | This view displays the column statistics and histogram information of the partitions in the partitioned tables of the database. |
| DBA_PART_HISTOGRAMS | This view displays the histogram information of all partitions in the database. |
| DBA_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information of the subpartitions in the partitioned tables of the database. |
| DBA_SUBPART_HISTOGRAMS | This view displays the histogram information of all subpartitions in the database. |
| DBA_TAB_COL_STATISTICS | This view displays the column statistics and histogram information of all tables in the database. |
| DBA_TAB_HISTOGRAMS | This view displays the histogram information of all tables in the database. |
| DBA_TAB_STATISTICS | This view displays the optimizer statistics of all tables in the database. |
| USER_PART_COL_STATISTICS | This view displays the column statistics and histogram information of the partitions in the partitioned tables of the current user. |
| USER_PART_HISTOGRAMS | This view displays the histogram information of all partitions of the current user. |
| USER_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information of the subpartitions in the partitioned tables of the current user. |
| USER_SUBPART_HISTOGRAMS | This view displays the histogram information of all subpartitions of the current user. |
| USER_TAB_COL_STATISTICS | This view displays the column statistics and histogram information of the tables of the current user. |
| USER_TAB_HISTOGRAMS | This view displays the histogram information of all tables of 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 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 tables owned by the current user. |
| ALL_TAB_MODIFICATIONS | This view displays the cumulative modification information of tables accessible to the current user. |
| DBA_TAB_MODIFICATIONS | This view displays the cumulative modification information of tables in the database. |
| USER_TAB_MODIFICATIONS | This view displays the cumulative modification information of 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 that the current user can access. |
| 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 of external tables that the current user can access. |
| DBA_OB_EXTERNAL_TABLE_FILES | This view displays the list of files of 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 configuration information related to WR. |
| DBA_WR_SYSTEM_EVENT | This view displays the persistent tenant-level waiting event information of the current tenant. |
| DBA_WR_EVENT_NAME | This view displays the persistent tenant-level waiting event names of the current tenant. |
| DBA_WR_SQLTEXT | This view displays the SQL texts collected by WR of the current tenant. |
| DBA_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed in 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 materialized view-related tasks that are being executed 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 related to materialized view refreshes. |
| 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. |
| DBA_MVREF_STATS | This view displays the basic timing statistics of materialized view refreshes. |
| DBA_MVREF_STATS_PARAMS | This view displays the refresh statistics attributes associated with each materialized view. |
| DBA_MVREF_STATS_SYS_DEFAULTS | This view displays the system-wide default values for the statistics attributes of materialized view refreshes. |
| DBA_MVREF_STMT_STATS | This view displays the information about the statements associated with materialized view refreshes. |
| 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 related to materialized view refreshes. These statistics show how many data changes occurred in the base tables associated with each refresh and the information required to load these changes. |
| USER_MVREF_RUN_STATS | This view displays the information about each refresh run of a materialized view. Each run is identified by a REFRESH_ID. This information includes the timing statistics and parameters specified for the run. |
| USER_MVREF_STATS | This view displays the basic timing statistics of 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-wide default values for the statistics attributes of materialized view refreshes. |
| USER_MVREF_STMT_STATS | This view displays the information about the statements associated with materialized view refreshes. |
Sequences
| 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 information about global variables. |
| TENANT_VIRTUAL_SESSION_VARIABLE | This view displays information about session variables. |
User-defined types
| View Name | Description |
|---|---|
| ALL_COLL_TYPES | This view displays all user-defined collection types available in the database. Its 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 information about all user-defined types available in the database. |
| DBA_COLL_TYPES | This view displays all user-defined collection types available in the database. Its 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 information about all user-defined types 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 information about all user-defined types available to the current user. |
Constraints
| 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 in 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 in 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 in all tables owned by the current user. |
Major compaction
| View name | Purpose |
|---|---|
| DBA_OB_MAJOR_COMPACTION | This view displays the global information of the major compaction for the current tenant. |
| DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the information of the major compaction for each zone of the current tenant. |
| DBA_OB_FREEZE_INFO | This view displays the version information generated by the major freeze. |
Resource management
| View name | Purpose |
|---|---|
| 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 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. |
Arbitration service
| View name | Purpose |
|---|---|
| DBA_OB_LS_ARB_REPLICA_TASKS | This view displays the arbitration service tasks running for the current tenant. |
| DBA_OB_LS_ARB_REPLICA_TASK_HISTORY | This view displays the history of arbitration service tasks executed for the current tenant. |
Tenant management
| View name | Purpose |
|---|---|
| DBA_OB_TENANTS | This view displays the basic information of tenants. |
| 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. |
Performance views overview
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 throttling rules at the current moment across all nodes in the current tenant. This information is used to observe the impact of the throttling rules set in the current system. |
| V$OB_SQL_CCL_STATUS | This view records the number of SQL statements that hit the throttling rules at the current moment on the current node in the current tenant. This information is used to observe the impact of the throttling rules set in the current system. |
Catalog related
| View name | Description |
|---|---|
| GV$OB_HMS_CLIENT_POOL_STAT | This view displays the usage of the HMS Catalog client in the current tenant. |
| V$OB_HMS_CLIENT_POOL_STAT | This view displays the usage of the HMS Catalog client in the current tenant. |
DML related
| View name | Description |
|---|---|
| GV$DML_STATS | This view displays the DML information of the current user table. |
| V$DML_STATS | This view displays the DML information of 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 a query session initiated on this view. These database links must be committed or rolled back before they are closed. |
| V$DBLINK | This view displays all database links (IN_TRANSACTION=YES) opened after a query session initiated on this 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 tasks related to all OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | This view displays information about all OBServer nodes. |
| oceanbase.CDB_OB_SERVICES | This view displays information about all SERVICE_NAME in all tenants. |
| oceanbase.DBA_OB_SERVICES | This view displays information about all SERVICE_NAME 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 replication links (OBCDC or network standby databases) under all OBServer nodes in the current tenant. |
| V$OB_ARCHIVE_DEST_STATUS | This view displays the status of each archive destination in the current tenant. |
| V$OB_LOG_TRANSPORT_DEST_STAT | The V$OB_LOG_TRANSPORT_DEST_STAT view displays information about all downstream log replication links (OBCDC or network standby databases) under the current OBServer node in the current tenant. |
| V$OB_LS_LOG_RESTORE_STATUS | This view displays the log restore status at the log stream level in 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 yet 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 node. |
Partition
| 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 for each tenant on each node. |
Cache views
| 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 views
| 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 views
| 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 views
| 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 a 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 a 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 views
| 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 views
| View name | Description |
|---|---|
| GV$OB_PS_ITEM_INFO | This view provides monitoring capabilities for Prepared Statements, including basic information about 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 basic information about 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 an OBServer node. |
| V$OB_PX_P2P_DATAHUB | This view displays information about data transfer operations in parallel execution. |
End-to-end tracing related
| View Name | Description |
|---|---|
| GV$OB_FLT_TRACE_CONFIG | This view displays diagnostic information about end-to-end tracing. |
Lock related
| View Name | Description |
|---|---|
| GV$OB_LOCKS | This view displays the locks held or requested for each table of the current user. |
| V$OB_LOCKS | This view displays the locks held or requested for each table of the current user. |
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 statistics the number of occurrences, waiting time, and timeout count of 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 statistics the number of occurrences, waiting time, and timeout count of each type of wait event. |
| V$GLOBAL_TRANSACTION | This view displays the information about the current active global transaction. |
| GV$OB_GLOBAL_TRANSACTION | This view displays the information about all XA transactions in the cluster. |
| V$OB_GLOBAL_TRANSACTION | This view displays the 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 views
| View | 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 views
| View | 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 the information of 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 of the last 10 wait events of all sessions on all servers. |
| GV$SESSTAT | This view displays some session-level statistics 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 of 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 of the last 10 wait events of all sessions on the current server. |
| V$SESSTAT | This view displays some session-level statistics. |
| V$EVENT_NAME | This view displays the definitions of various events under the tenant. |
| GV$OPEN_CURSOR | This view displays the information of the open session cursors on all nodes. |
| V$OB_SESSION | This view records the session information created on the current server. |
| V$OPEN_CURSOR | This view displays the information of the open session cursors. |
SQL audit views
| View | Description |
|---|---|
| GV$OB_SQL_AUDIT | This view displays the statistics of each SQL request on all servers, including the source and execution status. |
| V$OB_SQL_AUDIT | This view displays the statistics of each SQL request on the current server, including the source and execution status. |
Statistics and histogram views
| View | Purpose |
|---|---|
| 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 views
| View | Purpose |
|---|---|
| GV$OB_NIC_INFO | This view displays the NIC information of all OBServer nodes where the tenant is located, primarily focusing on the NIC speed. |
| V$OB_NIC_INFO | This view displays the NIC information of the current OBServer node, primarily focusing on the NIC speed. |
Workarea views
| View | Purpose |
|---|---|
| GV$SQL_WORKAREA | This view displays the statistics of the workarea for all operators executed under SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | This view displays the workarea information for the current active operator. |
| GV$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of all previous workarea executions. |
| 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 hold memory. |
| V$SQL_WORKAREA | This view displays the statistics of the workarea for all operators executed under SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | This view displays the workarea information for the current active operator. |
| V$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of all previous workarea executions. |
WR related
| View name | Description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view is available starting with OceanBase Database V2.1. |
| GV$OB_RES_MGR_SYSSTAT | This view is available starting with OceanBase Database V2.1. |
| V$OB_RES_MGR_SYSSTAT | This view is available starting with OceanBase Database V2.1. |
| GV$OB_SQLSTAT | This view is available starting with OceanBase Database V2.1. |
| V$OB_SQLSTAT | This view is available starting with OceanBase Database V2.1. |
| GV$OB_SESS_TIME_MODEL | This view is available starting with OceanBase Database V2.1. |
| V$OB_SESS_TIME_MODEL | This view is available starting with OceanBase Database V2.1. |
| GV$OB_SYS_TIME_MODEL | This view is available starting with OceanBase Database V2.1. |
| V$OB_SYS_TIME_MODEL | This view is available starting with OceanBase Database V2.1. |
| V$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view is available starting with OceanBase Database V2.1. |
Basic database 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 all OBServer nodes where the tenant is located. The sys tenant can view the unit information on all OBServer nodes in the cluster. |
| GV$SYSSTAT | This view displays the system-level statistical events on all servers. |
| V$GLOBALCONTEXT | This view displays the CLIENT_IDENTIFIER value of the global context attributes 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 views
| 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. For a user tenant, this view displays the threads of the current tenant. |
| V$OB_THREAD | This view displays the status information of all threads in the observer process on the current OBServer node. For a user tenant, this view displays the threads of the current tenant. |
Views related to major compactions
| View | Purpose |
|---|---|
| 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 current 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 | Purpose |
|---|---|
| V$SQL_MONITOR_STATNAME | This view displays the meaning of the numbers in the OTHERSTAT_X_ID column of GV$SQL_PLAN_MONITOR. |
| GV$SQL_PLAN_MONITOR | This view displays the plan statistics for slow queries on all OBServer nodes. Each slow query has a corresponding statistical record, and the trace information of the plan is also recorded. |
| V$SQL_PLAN_MONITOR | This view displays the plan statistics for slow queries on all OBServer nodes. Each slow query has a corresponding statistical record, and the trace information of the plan is also 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 | Description |
|---|---|
| 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 is used to query the cgroup configurations of all OBServer nodes. |
| V$OB_CGROUP_CONFIG | This view is used to query the cgroup configuration of 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 restriction conditions, and maximum usage after a reboot or 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, as well as the upper limits for each restriction. |
| V$OB_TENANT_RESOURCE_LIMIT | This view displays the logical resource usage, upper limits, effective restriction conditions, and maximum usage after a reboot or 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, as well as the upper limits for each restriction. |
Arbitration service
| View name | Description |
|---|---|
| GV$OB_ARBITRATION_MEMBER_INFO | This view displays the arbitration member information of the current tenant. |
| GV$OB_ARBITRATION_SERVICE_STATUS | This view displays the communication status between the current tenant's nodes and the arbitration service. |
| V$OB_ARBITRATION_MEMBER_INFO | This view displays the arbitration member information of the current tenant. |
| V$OB_ARBITRATION_SERVICE_STATUS | This view displays the communication status between the current tenant's current node and the arbitration service. |