Overview of views in the SYS tenant
Overview of dictionary views
Tables and columns
| View name | Description |
|---|---|
| oceanbase.CDB_IND_COLUMNS | Displays the column information of all index tables in all tenants. |
| oceanbase.CDB_INDEXES | Displays the index information of all tenants. |
| oceanbase.CDB_TABLES | Displays the table information of all tenants. |
| oceanbase.CDB_OB_TABLEGROUP_TABLES | Displays the tablegroup and table association of all tenants in the sys tenant. Tables not in a tablegroup are not displayed. |
| oceanbase.CDB_TAB_COLS | Displays the columns of all tables and views in all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | Displays the columns of all tables and views in all tenants. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the association between tablegroups and tables. Tables not in a tablegroup are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the columns that are part of the partitioning key of all partitioned objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays the columns that are part of the subpartitioning key of all subpartitioned objects in the database. |
| oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO | Displays the information about column checksum inconsistencies between index tables (including global indexes and local indexes) and their primary tables. |
| oceanbase.CDB_OB_TABLE_LOCATIONS | Displays the locations of tables or partitions, including system tables, user tables, and index tables. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the locations of tables or partitions, including system tables, user tables, and index tables. |
Outline
| View name | Description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | Displays the outline information of execution plans for the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | Displays the outline information of concurrency limit rules for the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history of execution plans and concurrency limit rules outlines for the current tenant. |
Basic information about the databases
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DATABASES | Displays the metadata of all tenants in the sys tenant. |
| oceanbase.CDB_OB_MAJOR_COMPACTION | Displays the global major compaction information of all tenants in the sys tenant. |
| oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION | Displays the major compaction information of all zones of all tenants in the sys tenant. |
| oceanbase.DBA_OB_DATABASES | Displays the metadata of the tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the global major compaction information of the tenant. |
| oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY | Displays the event history of the Root Service. |
| oceanbase.DBA_OB_SERVER_JOBS | Displays the tasks of all OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | Displays the information of all OBServer nodes. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays the major compaction information of all zones of the tenant. |
| oceanbase.DBA_OB_ZONES | Displays the information of all zones. |
| oceanbase.CDB_OB_FREEZE_INFO | Displays the version information generated by major compactions (major_freeze). |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major compactions (major_freeze). |
Partition-related views
| View name | Description |
|---|---|
| oceanbase.CDB_IND_PARTITIONS | Displays the partition information of index tables of all tenants. |
| oceanbase.CDB_PART_INDEXES | Displays the partition information of index tables of all tenants. |
| oceanbase.CDB_PART_TABLES | Displays the partition information of partitioned tables of all tenants. |
| oceanbase.CDB_SUBPARTITION_TEMPLATES | Displays the template-based subpartition information of partitioned tables of all tenants. |
| oceanbase.CDB_TAB_PARTITIONS | Displays the partition information of partitioned tables of all tenants. |
| oceanbase.CDB_TAB_SUBPARTITIONS | Displays the subpartition information of partitioned tables of all tenants. |
| oceanbase.DBA_IND_PARTITIONS | Displays the partition and subpartition information of indexes. |
| oceanbase.DBA_PART_INDEXES | Displays the partition information of all indexes. |
| oceanbase.DBA_PART_TABLES | Displays the partition information of user tables. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the partition and subpartition information that the current user has access to, along with the storage parameters and statistics of partitions and subpartitions. |
| oceanbase.DBA_TAB_SUBPARTITIONS | Displays the subpartition name, the table name, the partition name to which the subpartition belongs, the storage attributes of the subpartition, and the statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays the description of all subpartition templates. |
Load balancing related
| View name | Description |
|---|---|
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS | Displays the partition transfer tasks being processed in all tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of partition transfer tasks in all tenants. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the partition transfer tasks being processed in the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of partition transfer tasks in the current tenant. |
Session related
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlocks. This view shows the history of all tenants in the root tenant. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlocks. This view shows the history of the current tenant in a non-root tenant. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | Displays the event history of OBServer nodes. |
Views related to backup and restore
| View name | Description |
|---|---|
| oceanbase.CDB_OB_RESTORE_PROGRESS | Displays the execution progress of ongoing physical restore tasks. |
| oceanbase.CDB_OB_RESTORE_HISTORY | Displays the status of completed physical restore tasks. |
| oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES | Displays the status of pieces in backup sets. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | Displays the status of files in backup sets. |
| oceanbase.CDB_OB_BACKUP_JOBS | Displays the backup jobs of all tenants in the cluster. A backup job record is generated after a backup job is initiated. |
| oceanbase.CDB_OB_BACKUP_JOB_HISTORY | Displays the job history of backup jobs of all tenants in the cluster. |
| oceanbase.CDB_OB_BACKUP_TASKS | Displays the task-level backup tasks of all tenants in the cluster. A task record is generated after a backup_set is backed up. A task record corresponds to a job record. |
| oceanbase.CDB_OB_BACKUP_TASK_HISTORY | Displays the history of task-level backup tasks of all tenants in the cluster. |
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the job history of backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the job history of backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | Displays the history of task-level backup tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | Displays the status of files in backup sets. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | Displays the restore tasks in progress. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays the completed restore tasks. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the configurations of archive paths. |
| oceanbase.CDB_OB_ARCHIVE_DEST | Displays the configurations of archive paths. |
| oceanbase.CDB_OB_BACKUP_PARAMETER | Displays the backup parameters. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOBS | Displays the execution progress of tenant-level backup deletion jobs. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of completed backup deletion jobs. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | Displays the information about backup_set/backup_piece deletion tasks that are being executed. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of completed backup_set/backup_piece deletion tasks. |
| oceanbase.CDB_OB_BACKUP_DELETE_POLICY | Displays the deletion policies that are set for automatic or expiration-based deletion. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations used for backup and restore. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations used for backup and restore. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations used for backup and restore. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations used for backup and restore. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the deletion policies that are set for automatic or expiration-based deletion. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of tenant-level backup deletion jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of completed backup deletion jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays the information about backup_set/backup_piece deletion tasks that are being executed. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of completed backup_set/backup_piece deletion tasks. |
| oceanbase.DBA_OB_ARCHIVELOG | Displays the status of log backup for each archive path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all log backups, both historical and current. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of pieces in backup sets. |
| oceanbase.CDB_OB_ARCHIVELOG | Displays the status of log archiving for each archive path. |
| oceanbase.CDB_OB_ARCHIVELOG_SUMMARY | Displays the status of all log archivings, both historical and current. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOBS | Displays information about table-level restore jobs. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOBS | Displays information about table-level restore jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOBS | Displays information about import jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | Displays information about import jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASKS | Displays records of table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | Displays records of table-level import tasks. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of table-level restore jobs. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of table-level restore jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY | Displays the results of import jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the results of import jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY | Displays the history of table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the history of table-level cross-tenant import tasks. |
Statistics and histograms
| View name | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays optimizer statistics for all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays column statistics and histogram information for all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays column statistics and histogram information for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays column statistics and histogram information for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays histograms for all columns in all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays histogram endpoint data for all partitions in all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays histogram endpoint data for all subpartitions in all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the statistics history of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays optimizer statistics for all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the modification information of all tables in the database since the last time statistics were collected for these tables. |
| oceanbase.CDB_TAB_COL_STATISTICS | Displays column-level statistics in the sys tenant. |
Tenant-related
| View name | Description |
|---|---|
| oceanbase.DBA_OBJECTS | Displays all database objects in the tenant. The view definition is the same as that of ALL_OBJECTS. |
| oceanbase.CDB_OBJECTS | Displays the objects of all tenants in the sys tenant. |
| oceanbase.DBA_OB_TENANTS | Displays basic information about all tenants, including system tenants, user-created tenants (user tenants), and meta tenants. You can identify the tenant type by using the TENANT_TYPE column. |
| oceanbase.DBA_OB_TENANT_JOBS | Displays information about tenant-level jobs. |
| oceanbase.CDB_OB_SYS_VARIABLES | Displays the system variables of all tenants in the sys tenant. |
Resource-related
| View name | Description |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | Displays the resource pools of all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | Displays all unit-related jobs. |
| oceanbase.DBA_OB_UNITS | Displays the units of all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | Displays the specifications of all units. |
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | Displays all sequences in the database. |
Views related to replicas and logs
| View name | Description |
|---|---|
| oceanbase.CDB_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| oceanbase.CDB_OB_LS_LOCATIONS | Displays the distribution information of log stream (LS) replicas for all tenants. |
| oceanbase.CDB_OB_TABLEGROUPS | Displays the metadata of all tenant table groups in the sys tenant, including the partition information of the table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | Displays the partition information of all tenant partitioned table groups in the sys tenant. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information of all tenant partitioned table groups in the sys tenant. |
| oceanbase.CDB_OB_TABLET_TO_LS | Displays the tablet lists and the LS information to which each tablet belongs for all tenants in the sys tenant. |
| oceanbase.CDB_OB_TABLET_REPLICAS | Displays the replicas of all tablets in the current tenant. A tablet replica is uniquely identified by a composite key: <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.CDB_PART_KEY_COLUMNS | Displays the partitioning keys of partitioned objects (partitioned tables and partitioned indexes) in all tenants. |
| oceanbase.CDB_SUBPART_KEY_COLUMNS | Displays the subpartitioning keys of partitioned objects (partitioned tables and partitioned indexes) in all tenants. |
| oceanbase.DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the partitions of partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartitions of partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the metadata of table groups, including the partition information of the table groups. |
| oceanbase.DBA_OB_TABLET_REPLICAS | Displays the replicas of all tablets in the current tenant. A tablet replica is uniquely identified by a composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID> . |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays the tablet lists and the LS information to which each tablet belongs for all tenants in the sys tenant. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution information of log stream (LS) replicas for the current tenant. |
| oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO | Displays information about data inconsistencies between tablet replicas. |
| oceanbase.CDB_OB_LS | Displays the status and recovery progress of log streams. |
| oceanbase.DBA_OB_LS | Displays the status and recovery progress of log streams. |
WR-related views
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | Displays the SNAPSHOT information of the current tenant. |
| oceanbase.CDB_WR_SNAPSHOT | Displays the SNAPSHOT information of all tenants. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | Displays the ASH data of the current tenant after it is persisted. |
| oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY | Displays the ASH data of all tenants after it is persisted. |
| oceanbase.DBA_WR_STATNAME | Displays the names of the system statistics of the current tenant. |
| oceanbase.CDB_WR_STATNAME | Displays the names of the system statistics of all tenants. |
| oceanbase.DBA_WR_SYSSTAT | Displays the details of the system statistics of the current tenant. |
| oceanbase.CDB_WR_SYSSTAT | Displays the details of the system statistics of all tenants. |
| oceanbase.DBA_WR_CONTROL | Displays the configuration information related to WR. |
| oceanbase.CDB_WR_CONTROL | Displays the configuration information related to WR. |
| oceanbase.CDB_WR_SYSTEM_EVENT | Displays the tenant-level wait events of all tenants after they are persisted. |
| oceanbase.DBA_WR_SYSTEM_EVENT | Displays the tenant-level wait events of the current tenant after they are persisted. |
| oceanbase.CDB_WR_EVENT_NAME | Displays the tenant-level wait event names of all tenants after they are persisted. |
| oceanbase.DBA_WR_EVENT_NAME | Displays the tenant-level wait event names of the current tenant after they are persisted. |
| oceanbase.CDB_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed in all tenants. Each SQL statement is represented by a row (that is, each unique value of the SQL_ID and Plan_Hash columns is assigned a row). |
| oceanbase.DBA_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed in the current tenant. Each SQL statement is represented by a row (that is, each unique value of the SQL_ID and Plan_Hash columns is assigned a row). |
| oceanbase.CDB_WR_SYS_TIME_MODEL | Displays the WR data of the time model statistics of all tenants. |
| oceanbase.DBA_WR_SYS_TIME_MODEL | Displays the WR data of the time model statistics of the current tenant. |
| oceanbase.CDB_WR_SQLTEXT | Displays the SQL texts collected by WR for all tenants. |
| oceanbase.DBA_WR_SQLTEXT | Displays the SQL texts collected by WR for the current tenant. |
Privilege-related
| View name | Description |
|---|---|
| mysql.procs_priv | Stores the privilege information of stored procedures and functions. |
System variable-related
| View name | Description |
|---|---|
| oceanbase.DBA_OB_SYS_VARIABLES | Displays the configurations of system variables in the current tenant. |
OBKV-related
| View name | Description |
|---|---|
| oceanbase.CDB_OB_KV_TTL_TASKS | Displays the TTL tasks being executed in all tenants in the system tenant. |
| oceanbase.CDB_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks of all tenants in the system tenant. |
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the TTL tasks being executed in the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks of the current tenant. |
Overview of the performance view
Cgroup-related views
| View name | Description |
|---|---|
| GV$OB_CGROUP_CONFIG | Allows you to quickly query the cgroup configurations of an OBServer node. |
| V$OB_CGROUP_CONFIG | Allows you to quickly query the cgroup configurations of an OBServer node. |
Event-related statistics
| View name | Description |
|---|---|
| GV$OB_COMPACTION_SUGGESTIONS | Displays suggestions for major compactions. |
| GV$OB_PROCESSLIST | Displays the session information of all OBServer nodes in the tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of major compactions. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level major compactions. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level major compactions. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays the transaction participants on all OBServer nodes. |
| GV$SESSION_EVENT | Displays the wait events of sessions on all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | Displays the name and duration of the current or last wait event of all sessions on all servers, including the idle session. |
| GV$SESSION_WAIT_HISTORY | Displays the information of the last 10 wait events of all sessions on all servers. |
| GV$SYSTEM_EVENT | Displays the tenant-level wait events in the cluster. |
| GV$SESSTAT | The statistics of wait events on the session level on all OBServer nodes. |
| GV$SYSSTAT | Displays the tenant-level statistics of wait events on all servers. |
| GV$ACTIVE_SESSION_HISTORY | Displays the ASH data. |
| V$ACTIVE_SESSION_HISTORY | Displays the ASH data. |
| V$OB_COMPACTION_PROGRESS | Displays the major compaction progress information of each OBServer node in the tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays suggestions for major compactions. |
| V$OB_PROCESSLIST | Displays the session information of the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of major compactions. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level major compactions. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level major compactions. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays the transaction participants on all OBServer nodes. |
| V$STATNAME | Displays the definitions of all statistics events. |
| V$EVENT_NAME | Displays the definitions of all statistics events on the current OBServer node. |
| V$SESSION_WAIT | Detailed information on the current wait events for each session. According to the convention, each wait event will have three parameters, and their corresponding values will be recorded. |
| V$SESSION_WAIT_HISTORY | Displays the details of the current wait event of each session and the 10 most recent wait events of the session. |
| V$SESSTAT | Displays the statistics of wait events on the session level. |
| V$SYSSTAT | Displays the tenant-level statistics of wait events on the current server. |
| V$SYSTEM_EVENT | Displays the tenant-level wait events. |
| GV$SESSION_LONGOPS | Displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | Displays the execution status and progress of DDL operations on the current OBServer node. |
Monitoring-related statistics
| 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. |
I/O-related statistics
| View name | Description |
|---|---|
| GV$OB_IO_CALIBRATION_STATUS | Displays the execution status of I/O calibration tasks. |
| V$OB_IO_CALIBRATION_STATUS | Displays the execution status of I/O calibration tasks. |
| GV$OB_IO_BENCHMARK | Displays the calibration data of disks used by the I/O module. |
| V$OB_IO_BENCHMARK | Displays the calibration data of disks used by the I/O module. |
Cache-related statistics
| View name | Description |
|---|---|
| GV$OB_MEMORY | Displays memory statistics at the tenant level. |
| V$OB_MEMORY | Displays memory statistics at the tenant level. |
| GV$OB_MEMSTORE | Displays the memory usage of MemTables on all servers and all tenants. |
| V$OB_MEMSTORE | Displays the statistics of MemStores at the tenant level. |
| GV$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all servers. |
| GV$OB_SSTABLES | Displays the information about SSTables of a tenant. |
| V$OB_SSTABLES | Displays the information about SSTables of a tenant. |
| GV$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the current observer process. |
| GV$OB_PL_CACHE_OBJECT | Displays basic information about cache objects related to PL of all tenants. |
| V$OB_PL_CACHE_OBJECT | Displays basic information about cache objects related to PL of the current tenant. |
SQL-related statistics
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache on all OBServer nodes of the current tenant. |
| V$OB_PLAN_CACHE_STAT | Records the overall status of each plan cache on all servers of the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Records the status of each cached object in the plan caches on all servers of the current tenant. |
| V$OB_PLAN_CACHE_PLAN_STAT | Records the status of each cached object in the plan cache on the current server. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in all servers of the plan caches. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache on the current server. |
| GV$OB_PS_STAT | Monitors the overall status of the PS cache, including the hit ratio, memory usage, and number of cached items. |
| V$OB_PS_STAT | Monitors the overall status of the PS cache, including the hit ratio, memory usage, and number of cached items. |
| GV$OB_PS_ITEM_INFO | Provides monitoring functionality for prepared statements. It contains basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Provides monitoring functionality for prepared statements. It contains basic information about all prepared statements in the PS cache. |
| GV$OB_PX_TARGET_MONITOR | Displays the usage of PX threads on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | Displays the usage of PX threads on the OBServer node. |
| GV$OB_SQL_AUDIT | Displays the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | Displays the source and execution status of each SQL request on the current server. |
| GV$SQL_PLAN_MONITOR | Displays the plan-level statistics of slow queries on all OBServer nodes. A statistics record is generated for each slow query, and the trace information of the plan is recorded. |
| V$SQL_PLAN_MONITOR | Displays the operation-level statistics of slow queries. A statistics record is generated for each operation. |
| V$SQL_MONITOR_STATNAME | Explains the meaning of numbers in the OTHERSTAT_X_ID field of the GV$SQL_PLAN_MONITOR view. |
| GV$OB_FLT_TRACE_CONFIG | Displays diagnostic information for full-featured trace. |
| GV$OB_SQLSTAT | Displays basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row (namely, each unique combination of SQL_ID and Plan_Hash). |
| V$OB_SQLSTAT | Displays basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (namely, each unique combination of SQL_ID and Plan_Hash). |
Log-related statistics
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | Displays the status of the PALF. |
| V$OB_LOG_STAT | Displays the status of the PALF. |
Network-related statistics
| View name | Description |
|---|---|
| GV$OB_RPC_OUTGOING | Statistics on RPC requests sent by all OBServer nodes. |
| GV$OB_RPC_INCOMING | Statistics on RPC requests received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | Statistics on RPC data of different RPC packet codes for different tenants on OBServer nodes. |
| V$OB_RPC_INCOMING | Statistics on RPC data of different RPC packet codes for different tenants on OBServer nodes. |
Database-related statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | Displays the KVCACHE information of each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameter information of all OBServer nodes where the tenant resides. |
| GV$OB_SERVER_SCHEMA_INFO | Displays the schema information of all servers. |
| GV$OB_SERVERS | Displays the information of all OBServer nodes. |
| GV$OB_UNITS | Displays the unit information of OBServer nodes where the tenant resides. The sys tenant can view the units of all OBServer nodes in the cluster. |
| V$OB_KVCACHE | Displays the KVCACHE information of each OBServer node. |
| V$OB_PARAMETERS | Displays the parameter information of the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays the schema information of all servers. |
| V$OB_SERVERS | Displays the information of the current OBServer node. |
| V$OB_UNITS | Displays the units of the current OBServer node. |
| GV$DML_STATS | Displays the DML information in the user table. |
| V$DML_STATS | Displays the DML information in the user table. |
| GV$OB_KV_CONNECTIONS | Displays the statistics of OBKV connections held by all servers. |
| V$OB_KV_CONNECTIONS | Displays the statistics of OBKV connections held by the current server. |
Statistics on the time model
| View name | Description |
|---|---|
| GV$OB_SESS_TIME_MODEL | Displays the session-level time model statistics of sessions in the cluster. |
| V$OB_SESS_TIME_MODEL | Displays the session-level time model statistics of sessions on the current node. |
| GV$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistics of tenants in the cluster. |
| V$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistics of tenants on the current node. |
Statistics on dumps
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | Displays the statistics of completed major compactions in the OceanBase cluster. |
| V$OB_MERGE_INFO | Displays the statistics of completed major compactions in the OceanBase cluster. |
Thread-related statistics
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | View the execution information of each thread in parallel execution scenarios. |
| V$OB_PX_WORKER_STAT | View the execution information of each thread in parallel execution scenarios. |
| GV$OB_TENANT_RUNTIME_INFO | Displays information about queue lengths and thread limits of tenant threads. |
| V$OB_TENANT_RUNTIME_INFO | Displays information about queue lengths and thread limits of tenant threads. |
Workarea-related statistics
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | Statistics on the workareas of all operators managed by SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | Information about the workareas of active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Statistics on all workareas executed previously, such as the number of times that data in the range of 1 MB to 2 MB was fully processed in memory and the number of one-pass operations. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Information about memory usage of SQL workareas, such as the maximum available memory, the current memory usage, and the memory held. |
| V$SQL_WORKAREA | Statistics on the workareas of all operators managed by SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | Information about the workareas of active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Statistics on all workareas executed previously, such as the number of times that data in the range of 1 MB to 2 MB was fully processed in memory and the number of one-pass operations. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Information about memory usage of SQL workareas, such as the maximum available memory, the current memory usage, and the memory held. |
Statistics on encrypted tables
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with the encryption feature enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with the encryption feature enabled. |
Transaction-related statistics
| View name | Description |
|---|---|
| GV$LATCH | The latch information view of all OBServer nodes in the cluster. |
| V$LATCH | The latch information view of all OBServer nodes in the cluster. |
ASH-related statistics
| View name | Description |
|---|---|
| GV$OB_ACTIVE_SESSION_HISTORY | Displays the ASH data of active sessions. |
| V$OB_ACTIVE_SESSION_HISTORY | Displays the ASH data of current active sessions. |
Views in a MySQL tenant
Overview of dictionary views
Help command
| View name | Description |
|---|---|
| mysql.help_topic | Works with the other three tables mysql.help_category, mysql.help_relation, and mysql.help_keyword to generate the Help command. |
| mysql.help_category | Works with the other three tables mysql.help_relation, mysql.help_topic, and mysql.help_keyword to generate the Help command. |
| mysql.help_keyword | Works with the other three tables mysql.help_relation, mysql.help_topic, and mysql.help_category to generate the Help command. |
| mysql.help_relation | Works with the other three tables mysql.help_category, mysql.help_topic, and mysql.help_keyword to generate the Help command. |
SPM-related
| View name | Description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | Displays the plan baselines of SQL statements in SPM. |
| oceanbase.DBA_SQL_MANAGEMENT_CONFIG | Displays the configuration parameters in SPM. |
Privilege-related
| View name | Description |
|---|---|
| mysql.db | Displays database-level privilege information (VIRTUAL_TABLE). |
| mysql.user | Records user-level privilege information (VIRTUAL_TABLE). |
| information_schema.COLUMN_PRIVILEGES | Displays column privilege information. |
| information_schema.SCHEMA_PRIVILEGES | Describes database privilege information. |
| information_schema.TABLE_PRIVILEGES | Records table privilege information. |
| information_schema.USER_PRIVILEGES | Records user privilege information. |
| mysql.procs_priv | Stores privilege information about stored procedures and functions. |
OBKV-related
| View name | Description |
|---|---|
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the TTL tasks that are currently being executed in the tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the TTL tasks that have been executed in the tenant. |
Scheduler
| View name | Description |
|---|---|
| oceanbase.DBA_SCHEDULER_JOBS | Displays information about all scheduled jobs in the database. |
Storage-related
| View name | Description |
|---|---|
| mysql.proc | Displays information about stored procedures. |
| information_schema.ENGINES | Records information about storage engines. |
| information_schema.PARAMETERS | Provides information about parameters and return values of stored procedures. |
| information_schema.ROUTINES | Provides information about stored procedures. |
Time zone-related
| View name | Description |
|---|---|
| mysql.time_zone | Displays time zone-related information (SYSTEM_VIEW). |
| mysql.time_zone_name | Records the names of time zones (SYSTEM_VIEW). |
| mysql.time_zone_transition | The mysql.time_zone_transition view records the time zone transition information. |
| mysql.time_zone_transition_type | Records the types of time zone transitions (SYSTEM_VIEW). |
Character sets
| View name | Description |
|---|---|
| information_schema.CHARACTER_SETS | Records the character sets supported by OceanBase Database. |
| information_schema.COLLATIONS | Records the collations for each character set. |
| information_schema.COLLATION_CHARACTER_SET_APPLICABILITY | Records the relationships between character sets and collations. |
Tables and columns
| View name | Description |
|---|---|
| information_schema.COLUMNS | Records column information. |
| information_schema.STATISTICS | Records index information of tables. |
| information_schema.TABLES | Records information about tables. |
| information_schema.VIEWS | Records information about views. |
| information_schema.VIEW_TABLE_USAGE | Displays information about tables and views used in view definitions. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the relationship between table groups and tables. Tables not belonging to any table group are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the columns that are part of the partitioning key of all partitioned objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays the columns that are part of the subpartitioning key of all subpartitioned objects in the database. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the locations of tables or partitions, including system tables, user tables, and index tables. |
Outline
| View | 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 outline information of the execution plans and throttling rules of the current tenant. |
Basic information about databases
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DATABASES | This view displays the metadata of all databases of all tenants in the sys tenant. |
| oceanbase.CDB_OB_MAJOR_COMPACTION | This view displays the global major compaction information of all tenants in the sys tenant. |
| oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION | This view displays the major compaction information of all zones of all tenants in the sys tenant. |
| oceanbase.DBA_OB_DATABASES | This view displays the metadata of all databases of the current tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | This view displays the global major compaction information of the current tenant. |
| oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY | This view displays the event history of the Root Service. |
| oceanbase.DBA_OB_SERVER_JOBS | This view displays the tasks related to all OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | This view displays the information of all OBServer nodes. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the major compaction information of all zones of the current tenant. |
| oceanbase.DBA_OB_ZONES | This view displays the information of all zones. |
| oceanbase.CDB_OB_FREEZE_INFO | This view displays the version information generated by major freeze. |
| oceanbase.DBA_OB_FREEZE_INFO | This view displays the version information generated by major freeze. |
Partition related
| View | Description |
|---|---|
| oceanbase.CDB_IND_PARTITIONS | This view displays information about partitions of index tables in all tenants. |
| oceanbase.CDB_PART_INDEXES | This view displays the partition information of all index tables in all tenants. |
| oceanbase.CDB_PART_TABLES | This view displays the partition information for all tenant partitions. |
| oceanbase.CDB_SUBPARTITION_TEMPLATES | This view displays subpartition templates of partitioned tables of all tenants. |
| oceanbase.CDB_TAB_PARTITIONS | This view displays the primary partition information for all tenant partition tables. |
| oceanbase.CDB_TAB_SUBPARTITIONS | This view displays subpartition information for partitioned tables on all tenants. |
| oceanbase.DBA_IND_PARTITIONS | This view displays information about indexes partitioned by primary or secondary partitions. |
| oceanbase.DBA_PART_INDEXES | This view displays partition information of all partition indexes. |
| oceanbase.DBA_PART_TABLES | This view displays the information of table partitions. |
| oceanbase.DBA_TAB_PARTITIONS | This view displays the information, storage parameters, and statistics about subpartitions. |
| 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 | Description |
Load balancing-related
| View | Description |
|---|---|
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS | This view displays all the partition transfer tasks currently being processed for all tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the execution history of the Transfer Partition tasks of all tenants. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | This view displays all Transfer Partition tasks that are being processed in the current system tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of Transfer Partition tasks executed in this tenant. |
Session related
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | This view displays the history of deadlock events. In the root tenant, this view displays the history of all tenants. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | This view displays the history of deadlock events. In a non-root tenant, this view displays the history of the current tenant. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | This view displays the event history of OBServer nodes. |
Backup and restore
| View name | Description |
|---|---|
| oceanbase.CDB_OB_RESTORE_PROGRESS | This view displays the execution progress of a physical restore task. |
| oceanbase.CDB_OB_RESTORE_HISTORY | This view displays the status of a physical restore task when it is completed. |
| oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of a piece in a backup set. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | This view displays the file status in a backup set. |
| oceanbase.CDB_OB_BACKUP_JOBS | This view displays the backup jobs of all tenants in the cluster. A backup job is recorded when a backup task is initiated. |
| oceanbase.CDB_OB_BACKUP_JOB_HISTORY | This view displays the historical records of backup jobs of all tenants in the cluster. |
| oceanbase.CDB_OB_BACKUP_TASKS | This view displays the task-level backup tasks of all tenants in the cluster. A task record corresponds to a backup set. The task records and job records are in a one-to-one correspondence. |
| oceanbase.CDB_OB_BACKUP_TASK_HISTORY | This view displays the historical records of task-level backup tasks of all tenants in the cluster. |
| 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 historical records 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 historical records of task-level backup tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | This view displays the file status in a backup set. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | This view displays the progress of a restore task. |
| oceanbase.DBA_OB_RESTORE_HISTORY | This view displays the historical records of completed restore tasks. |
| oceanbase.DBA_OB_ARCHIVE_DEST | This view displays the archive path configuration. |
| oceanbase.CDB_OB_ARCHIVE_DEST | This view displays the archive path configuration. |
| oceanbase.CDB_OB_BACKUP_PARAMETER | This view displays the backup parameters. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOBS | This view displays the execution progress of tenant-level backup cleanup jobs. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the historical information of backup cleanup jobs executed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | This view displays the information of backup_set/backup_piece cleanup tasks being executed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the historical information of backup_set/backup_piece cleanup tasks completed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_POLICY | This view displays the cleanup policies set for expired/automatic cleanup in the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | This view displays the backup destination information used for backup and restore in the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the historical information of the backup destination used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | This view displays the backup destination information used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the historical information 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 expired/automatic cleanup in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | This view displays the execution progress of tenant-level backup cleanup jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the historical information of backup cleanup jobs executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | This view displays the information of backup_set/backup_piece cleanup tasks being executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the historical information of backup_set/backup_piece cleanup tasks completed in the tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | This view displays the status of log backups on each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | This view displays the status of all 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 log archiving status for all historical and current paths. |
| 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. |
Statistics and histogram
| View | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | This view displays optimizer statistics for 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 subpartitions 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 histogram data on all partitioned tables in the database (endpoints of each histogram). |
| oceanbase.DBA_SUBPART_HISTOGRAMS | This view displays histogram data for all subpartitioned tables in the database. It displays each histogram's endpoints. |
| oceanbase.DBA_TAB_STATS_HISTORY | This view displays the table statistic history of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | This view displays the optimizer statistics for all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | This view displays the modification information of all tables in the database since the last statistics collection in these tables. |
| oceanbase.CDB_TAB_COL_STATISTICS | This view displays statistics for columns in the system tenant. |
Tenant-related
| View | Description |
|---|---|
| oceanbase.DBA_OBJECTS | This view displays all database objects. The view definition is the same as that of ALL_OBJECTS. |
| oceanbase.CDB_OBJECTS | This view displays information about all objects of all tenants in the system tenant. |
| oceanbase.DBA_OB_TENANTS | Type |
| oceanbase.DBA_OB_TENANT_JOBS | This view displays the information about tenant-level jobs. |
| oceanbase.CDB_OB_SYS_VARIABLES | This view displays the system variable information of all tenants in the system tenant. |
Resource-related
| View name | Description |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | This view displays the resource pool information of all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | This view displays all unit-related tasks. |
| oceanbase.DBA_OB_UNITS | This view displays the unit information of all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | This view displays the unit specifications of all tenants. |
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | This view displays all SEQUENCE objects in the database. |
Replica and log-related
| View name | Description |
|---|---|
| oceanbase.CDB_IND_SUBPARTITIONS | This view displays information about all index subpartitions in the database. |
| oceanbase.CDB_OB_LS_LOCATIONS | This view displays the distribution of log streams (LS) replicas for all tenants. |
| oceanbase.CDB_OB_TABLEGROUPS | This view displays the metadata of all table groups for all tenants, mainly focusing on the partition information of the table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | This view displays the primary partition information of all partitioned table groups for all tenants. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of all partitioned table groups for all tenants. |
| oceanbase.CDB_OB_TABLET_TO_LS | This view displays the list of all tablets and the log stream information to which each tablet belongs for all tenants. |
| oceanbase.CDB_OB_TABLET_REPLICAS | This view displays the information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.CDB_PART_KEY_COLUMNS | This view displays the primary partition key information for all tenants' partitioned objects (partitioned tables and partitioned indexes). |
| oceanbase.CDB_SUBPART_KEY_COLUMNS | This view displays the secondary partition key information for all tenants' partitioned objects (partitioned tables and partitioned indexes). |
| oceanbase.DBA_IND_SUBPARTITIONS | This view displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | This view displays the primary partition information of all partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of all partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUPS | This view displays the metadata of all table groups, mainly focusing on the partition information of the table groups. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays the information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | This view displays the list of all 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 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 restore progress of log streams. |
| oceanbase.DBA_OB_LS | This view displays the status and restore progress of log streams. |
WR-related views
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | This view displays the SNAPSHOT information of the current tenant. |
| oceanbase.CDB_WR_SNAPSHOT | This view displays the SNAPSHOT information of all tenants. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data of the current tenant after persistence. |
| oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data of all tenants after persistence. |
| oceanbase.DBA_WR_STATNAME | This view displays the names of the system statistics of the current tenant. |
| oceanbase.CDB_WR_STATNAME | This view displays the names of the system statistics of all tenants. |
| oceanbase.DBA_WR_SYSSTAT | This view displays the details of the system statistics of the current tenant. |
| oceanbase.CDB_WR_SYSSTAT | This view displays the details of the system statistics of all tenants. |
| oceanbase.DBA_WR_CONTROL | This view displays the WR-related configuration information. |
| oceanbase.CDB_WR_CONTROL | This view displays the WR-related configuration information. |
| oceanbase.CDB_WR_SYSTEM_EVENT | This view displays the persistent tenant-level waiting event information of all tenants. |
| oceanbase.DBA_WR_SYSTEM_EVENT | This view displays the persistent tenant-level waiting event information of the current tenant. |
| oceanbase.CDB_WR_EVENT_NAME | This view displays the persistent tenant-level waiting event names of all tenants. |
| oceanbase.DBA_WR_EVENT_NAME | This view displays the persistent tenant-level waiting event names of the current tenant. |
| oceanbase.CDB_WR_SQLSTAT | This view displays the basic performance statistics of the SQL statements executed by all tenants. Each SQL statement is a row (each unique combination of SQL_ID and Plan_Hash is a row). |
| oceanbase.DBA_WR_SQLSTAT | This view displays the basic performance statistics of the SQL statements executed by the current tenant. Each SQL statement is a row (each unique combination of SQL_ID and Plan_Hash is a row). |
| oceanbase.CDB_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics of all tenants. |
| oceanbase.DBA_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics of the current tenant. |
| oceanbase.CDB_WR_SQLTEXT | This view displays the SQL texts collected by WR for all tenants. |
| oceanbase.DBA_WR_SQLTEXT | This view displays the SQL texts collected by WR for the current tenant. |
Privilege-related
| View name | Description |
|---|---|
| mysql.procs_priv | Stores the privilege information of stored procedures and functions. |
System variable-related
| View name | Description |
|---|---|
| oceanbase.DBA_OB_SYS_VARIABLES | Displays the configuration of system variables for the current tenant. |
OBKV-related
| View name | Description |
|---|---|
| oceanbase.CDB_OB_KV_TTL_TASKS | Displays all TTL tasks being executed by all tenants under the sys tenant. |
| oceanbase.CDB_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks of all tenants under the sys tenant. |
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the TTL tasks being executed by the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks of the current tenant. |
Overview of performance views
Cgroup related
| View name | Description |
|---|---|
| GV$OB_CGROUP_CONFIG | This view queries the cgroup configurations of an OBServer. |
| V$OB_CGROUP_CONFIG | This view queries the cgroup configurations of an OBServer. |
Event-related statistics
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | This view displays the major compaction progress at the OBServer level for the tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | This view displays the compaction suggestions. |
| GV$OB_PROCESSLIST | This view displays the session information on all OBServer nodes where the tenant is located. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | This view displays the compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | This view displays the historical information of tablet-level major compactions. |
| GV$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress information of tablet-level major compactions. |
| GV$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participant information on all OBServer nodes. |
| GV$SESSION_EVENT | This view displays the session-level waiting events on all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | This view displays the current or previous waiting events of all sessions on all servers, including the waiting event name and waiting time. |
| GV$SESSION_WAIT_HISTORY | This view displays the information about the 10 most recent waiting events of all sessions on all servers. |
| GV$SYSTEM_EVENT | This view displays the waiting events at the tenant level in the cluster. |
| GV$SESSTAT | This view displays the session-level statistical events on all OBServer nodes. |
| GV$SYSSTAT | This view displays the tenant-level statistical events on all servers. |
| GV$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$OB_COMPACTION_PROGRESS | This view displays the major compaction progress at the server level for the tenant. |
| V$OB_COMPACTION_SUGGESTIONS | This view displays the compaction suggestions. |
| V$OB_PROCESSLIST | This view displays the session information on the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | This view displays the compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | This view displays the history information of tablet-level compactions. |
| V$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress information of tablet-level compactions. |
| V$OB_TRANSACTION_PARTICIPANTS | This view displays the information of transaction participants on all OBServer nodes. |
| V$STATNAME | This view displays the definitions of all statistics events. |
| V$EVENT_NAME | This view displays the definitions of all statistics events on the current OBServer node. |
| V$SESSION_WAIT | This view displays the details of the current waiting events for each session. According to the convention, each waiting event has three parameters, and each parameter records the corresponding value. |
| V$SESSION_WAIT_HISTORY | This view displays the details of the current waiting events for each session, including the last 10 waiting events. |
| V$SESSTAT | This view displays the statistics events at the session level. |
| V$SYSSTAT | This view displays the statistics events at the tenant level on the current server. |
| V$SYSTEM_EVENT | This view displays the statistics events at the tenant level. |
| 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. |
Statistics related to monitoring
| 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. |
Cache related statistics
| View name | Description |
|---|---|
| GV$OB_MEMORY | This view displays the memory statistics at the tenant level. |
| V$OB_MEMORY | This view displays the memory statistics at the tenant level. |
| GV$OB_MEMSTORE | This view displays the memory usage of MemTables for all tenants on all servers. |
| V$OB_MEMSTORE | This view displays the MemStore statistics at the tenant level. |
| GV$OB_MEMSTORE_INFO | This view displays the detailed information of MemTables for all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | This view displays the detailed information of MemTables for all partitions of all tenants on all servers. |
| GV$OB_SSTABLES | This view displays the SSTable information of a tenant. |
| V$OB_SSTABLES | This view displays the SSTable information of a tenant. |
| GV$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the current observer process. |
| GV$OB_PL_CACHE_OBJECT | This view displays the basic information of PL-related cache objects for all tenants. |
| V$OB_PL_CACHE_OBJECT | This view displays the basic information of PL-related cache objects for the current tenant. |
SQL statistics
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | This view displays the status of each plan cache in the current tenant on all OBServer nodes. |
| V$OB_PLAN_CACHE_STAT | This view records the status of each plan cache in 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 of 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 of 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 the hit rate, memory usage, and number of cached items. |
| V$OB_PS_STAT | This view monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items. |
| GV$OB_PS_ITEM_INFO | This view provides monitoring capabilities for prepared statements and contains basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | This view provides monitoring capabilities for prepared statements and contains basic information about all prepared statements in the PS cache. |
| 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 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. |
| 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 the GV$SQL_PLAN_MONITOR view. |
| GV$OB_FLT_TRACE_CONFIG | This view displays the diagnostic information of end-to-end tracing. |
| GV$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row, where each row corresponds to a unique combination of SQL_ID and Plan_Hash. |
| V$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row, where each row corresponds to a unique combination of SQL_ID and Plan_Hash. |
Log statistics
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | This view displays the status of a Palf. |
| V$OB_LOG_STAT | This view displays the status of a Palf. |
Network statistics
| View name | Description |
|---|---|
| GV$OB_RPC_OUTGOING | The outgoing RPC statistics for all OBServer nodes. |
| GV$OB_RPC_INCOMING | This view displays the incoming RPC statistics for all OBServer nodes. |
| V$OB_RPC_OUTGOING | This view displays the outgoing RPC statistics for different packet codes of different tenants on OBServer nodes. |
| V$OB_RPC_INCOMING | This view displays the incoming RPC statistics for different packet codes of different tenants on OBServer nodes. |
Database-related statistics
| View | Description |
|---|---|
| GV$OB_KVCACHE | This view displays KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | This view displays the configuration information on all OBServer nodes where the tenant is located. |
| GV$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| GV$OB_SERVERS | This view displays the information of all OBServer nodes. |
| GV$OB_UNITS | This view displays the unit information of the OBServer node where the tenant is located. The system tenant can view the unit information of all OBServer nodes in the cluster. |
| V$OB_KVCACHE | This view displays KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | This view displays the configuration information on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| V$OB_SERVERS | This view displays the information of the current OBServer node. |
| V$OB_UNITS | This view displays the unit information of the current OBServer node. |
| GV$DML_STATS | This view displays the DML information in the current user table. |
| V$DML_STATS | This view displays the DML information in the current user table. |
| GV$OB_KV_CONNECTIONS | This view displays the statistics of the OBKV connections held by all servers. |
| V$OB_KV_CONNECTIONS | This view displays the statistics of the OBKV connections held by the current server. |
Time Model-related statistics
| View | Description |
|---|---|
| GV$OB_SESS_TIME_MODEL | This view displays the session-level Time Model statistics in the cluster. |
| V$OB_SESS_TIME_MODEL | This view displays the session-level Time Model statistics on the current node. |
| GV$OB_SYS_TIME_MODEL | This view displays the tenant-level Time Model statistics in the cluster. |
| V$OB_SYS_TIME_MODEL | This view displays the tenant-level Time Model statistics on the current node. |
Statistics related to dumps
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | This view displays the statistics related to completed compactions in the OceanBase cluster. |
| V$OB_MERGE_INFO | This view displays the statistics related to completed compactions in the OceanBase cluster. |
Statistics related to threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, this view displays the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, this view displays the execution information of each thread. |
| GV$OB_TENANT_RUNTIME_INFO | This view displays the information about queues and thread limits in the tenant threads. |
| V$OB_TENANT_RUNTIME_INFO | This view displays the information about queues and thread limits in the tenant threads. |
Statistics related to workareas
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | This view displays the statistics of workareas for all operators executed by SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | This view displays the workarea information of the currently active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of all workareas executed, such as the number of times full in-memory processing occurred in the range of 1 M to 2 M and the number of one-pass operations. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory. |
| V$SQL_WORKAREA | This view displays the statistics of workareas for all operators executed by SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | This view displays the workarea information of the currently active operators. |
| V$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of all workareas executed, such as the number of times full in-memory processing occurred in the range of 1 M to 2 M and the number of one-pass operations. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some overall information about the SQL workarea, including the maximum available memory, current used memory, and current held memory. |
Statistics related to 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. |
Statistics related to transactions
| View name | 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. |
ASH related statistics
| View name | Description |
|---|---|
| GV$OB_ACTIVE_SESSION_HISTORY | This view displays the history of active sessions. |
| V$OB_ACTIVE_SESSION_HISTORY | This view displays the current history of active sessions. |
Overview of views in a MySQL tenant
Dictionary views overview
Help command
| View | Description |
|---|---|
| mysql.help_topic | This view, along with the views mysql.help_category, mysql.help_relation, and mysql.help_keyword, generates the commands for the Help system. |
| mysql.help_category | Generates the help commands with the mysql.help_relation, mysql.help_topic, and mysql.help_keyword tables. |
| mysql.help_keyword | Together with the mysql.help_relation, mysql.help_topic, and mysql.help_category tables, it generates help commands. |
| mysql.help_relation | Generates help commands by cooperating with the three tables, mysql.help_category, mysql.help_topic, and mysql.help_keyword. |
SPM related
| View | Description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | This view displays SQL plan baselines in SQL Plan Management (SPM). |
| oceanbase.DBA_SQL_MANAGEMENT_CONFIG | This view displays the configuration parameters in SPM. |
Privilege related
| View | Description |
|---|---|
| mysql.db | This view displays database-level privileges (VIRTUAL_TABLE). |
| mysql.user | This view records the permissions at the user level. (VIRTUAL_TABLE). |
| information_schema.COLUMN_PRIVILEGES | This view displays column privileges. |
| information_schema.SCHEMA_PRIVILEGES | Description |
| information_schema.TABLE_PRIVILEGES | This view records table privileges. |
| information_schema.USER_PRIVILEGES | This view displays the privilege information of users. |
| mysql.procs_priv | Stores the privileges of stored procedures and functions. |
OBKV-specific
| View | Description |
|---|---|
| oceanbase.DBA_OB_KV_TTL_TASKS | This view displays the TTL tasks that are being executed for the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | This view displays the history of TTL tasks of the current tenant. |
Scheduler
| View | Description |
|---|---|
| oceanbase.DBA_SCHEDULER_JOBS | This view displays information about all scheduler jobs in the database. |
Storage-related
| View | Description |
|---|---|
| mysql.proc | This view displays the information of stored procedures. |
| information_schema.ENGINES | Records information about storage engines. |
| information_schema.PARAMETERS | Provides information about the parameters and return values of stored procedures. |
| information_schema.ROUTINES | This view provides information about stored procedures. |
Time zone related
| View | Description |
|---|---|
| mysql.time_zone | This view displays time zone information (SYSTEM_VIEW). |
| mysql.time_zone_name | This view records the name of the timezone (SYSTEM_VIEW). |
| mysql.time_zone_transition | mysql.time_zone_transition is a system view for recording time zone transition information. |
| mysql.time_zone_transition_type | Type |
Character set
| View | Description |
|---|---|
| information_schema.CHARACTER_SETS | This view displays the character sets of OceanBase Database. |
| information_schema.COLLATIONS | Records the comparison method information for each character set. |
| information_schema.COLLATION_CHARACTER_SET_APPLICABILITY | Describes the mapping between Character sets and Collations. |
Tables and columns
| View name | Description |
|---|---|
| information_schema.COLUMNS | Records column information. |
| information_schema.STATISTICS | Records table index information. |
| information_schema.TABLES | Records table information. |
| information_schema.VIEWS | Records view information. |
| information_schema.VIEW_TABLE_USAGE | Displays information about tables and views used in the view definition. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the association between a tablegroup and a table. Tables not in a tablegroup are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays columns included in the partitioning key of all partition objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays columns included in the subpartitioning key of all partition objects in the database. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the location of a table or partition, including system tables, user tables, and index tables. |
Outline
| View name | Description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | Displays the outline information of the execution plan for the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | Displays the outline information of the throttling rules for the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the outline information of the execution plan and throttling rules for the current tenant. |
Database information
| View | Description |
|---|---|
| information_schema.GLOBAL_STATUS | This view records the global status information of OceanBase Database. |
| information_schema.GLOBAL_VARIABLES | This view displays the global variables. |
| information_schema.SCHEMATA | Records metadata of databases. |
| oceanbase.DBA_OB_DATABASES | This view displays database metadata of tenants. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | This view displays the global compaction information of the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the major compaction information for each zone in the current tenant. |
| oceanbase.DBA_OB_FREEZE_INFO | This view displays the version information generated during the major freeze operation. |
Partition-related
| View | Description |
|---|---|
| information_schema.PARTITIONS | Records partition information. |
| oceanbase.DBA_IND_PARTITIONS | This view displays the primary and secondary partitions of indexes. |
| oceanbase.DBA_PART_INDEXES | This view displays the information of all partition indexes. |
| oceanbase.DBA_PART_TABLES | This view displays the partitioning information of user tables. |
| oceanbase.DBA_TAB_PARTITIONS | This view displays information about, storage parameters, and statistics of partitions that are accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | This view displays the names of subpartitions, tables, and partitions, and their storage attributes, as well as statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Description |
Load balancing related
| View | Description |
|---|---|
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | This view displays Transfer Partition tasks being processed in the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the Transfer Partition task history. |
Thread-related
| View | Description |
|---|---|
| information_schema.PROCESSLIST | Provides information about running threads. |
Constraints
| View | Description |
|---|---|
| information_schema.CHECK_CONSTRAINTS | This view displays information about constraints of tables and columns when the CREATE TABLE operation is executed. |
| information_schema.KEY_COLUMN_USAGE | Records the constraints on the keys in the Column. |
| information_schema.REFERENTIAL_CONSTRAINTS | This view displays metadata about foreign key constraints. |
| information_schema.TABLE_CONSTRAINTS | Description |
Session-related
| View | Description |
|---|---|
| information_schema.SESSION_STATUS | This view displays the status of a session, such as current active connections and database uptime. |
| information_schema.SESSION_VARIABLES | This view records the session variable information. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | This view displays the historical records of deadlock events. If you are not the tenant administrator, this view displays the historical records of the current tenant. |
User login related
| View | Description |
|---|---|
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | This view displays failed login attempts of different users. |
Backup and restore
| View name | Description |
|---|---|
| oceanbase.DBA_OB_BACKUP_JOBS | This view displays 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 history of backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | This view displays the history of task-level backup jobs 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 destination configuration. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | This view displays the 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 the 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 or automatic cleanup in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | This view displays the execution progress of tenant-level backup cleanup jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of backup cleanup jobs executed in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | This view displays the information about the 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 records of cross-tenant table-level import tasks. |
Statistics and Histograms
| View | 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 column statistics and histogram information for all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | This view displays the statistics and histogram information of columns in all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | This view displays histograms for all columns of all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | This view displays the histogram data (endpoint values) of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | This view displays the histogram data for all subpartitioned tables in the database (endpoints of each histogram). |
| 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 statistics collected for all indexes. |
| oceanbase.DBA_TAB_MODIFICATIONS | This view displays modification information of all tables in the database since the last statistics collection for the table. |
| information_schema.QUERY_RESPONSE_TIME | Type |
Tenant related
| View | Description |
|---|---|
| oceanbase.DBA_OBJECTS | This view displays all database objects. The definition is the same as that of ALL_OBJECTS. |
| oceanbase.DBA_OB_TENANTS | Type |
Resource-related
| View | Description |
|---|---|
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | This view displays all SEQUENCE objects in the database. |
Replica and log-related views
| View name | Description |
|---|---|
| oceanbase.DBA_IND_SUBPARTITIONS | This view displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | This view displays the primary partitions of a table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the subpartitions of a table group. |
| oceanbase.DBA_OB_TABLEGROUPS | This view displays the metadata of a table group, including the partition information. |
| oceanbase.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>. |
| oceanbase.DBA_OB_TABLET_TO_LS | This view displays the list of tablets in the current tenant and the log stream to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | This view displays the distribution of log stream (LS) replicas in the current tenant. |
WR-related 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 persistent ASH data of the current tenant. |
| oceanbase.DBA_WR_STATNAME | This view displays the names of system statistics of the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | This view displays the details of 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 persistent tenant-level wait event information of the current tenant. |
| oceanbase.DBA_WR_EVENT_NAME | This view displays the names of persistent tenant-level wait events of the current tenant. |
| oceanbase.DBA_WR_SQLTEXT | This view displays the SQL text collected by WR for the current tenant. |
SQLSTAT-related views
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed in the current tenant. Each SQL statement is displayed as a row (i.e., each unique value of SQL_ID + Plan_Hash is a row). |
Time Model-related views
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics of the current tenant. |
System variable-related views
| View name | Description |
|---|---|
| oceanbase.DBA_OB_SYS_VARIABLES | This view displays the configuration of system variables of the current tenant. |
Overview of performance views
ASH-related statistics
| View Name | Description |
|---|---|
| GV$OB_ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$OB_ACTIVE_SESSION_HISTORY | This view displays the active session history. |
Cgroup-related statistics
| View Name | Description |
|---|---|
| GV$OB_CGROUP_CONFIG | This view displays the cgroup configuration of an OBServer node. |
| V$OB_CGROUP_CONFIG | This view displays the cgroup configuration of an OBServer node. |
Event-related statistics
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | This view displays the OBServer-level major compaction progress of the tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | This view displays the major compaction suggestions. |
| GV$OB_PROCESSLIST | This view displays the session information of all OBServer nodes where the tenant resides. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | This view displays the major compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | This view displays the historical information about tablet-level major compactions. |
| GV$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress information about tablet-level major compactions. |
| GV$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participant information of all OBServer nodes. |
| GV$SESSION_EVENT | This view displays the session-level waiting events of all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | This view displays the information about the current or previous waiting events of all sessions on all servers, including the waiting event name and waiting time. |
| GV$SESSION_WAIT_HISTORY | This view displays the information about the most recent 10 waiting events of all sessions on all servers. |
| GV$SYSTEM_EVENT | This view displays the waiting events at the tenant level in the cluster. |
| GV$SESSTAT | This view displays the session-level statistical events of all OBServer nodes. |
| GV$SYSSTAT | This view displays the tenant-level statistical events on all servers. |
| GV$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$OB_COMPACTION_PROGRESS | This view displays the server-level major compaction progress of the tenant. |
| V$OB_COMPACTION_SUGGESTIONS | This view displays the major compaction suggestions. |
| V$OB_PROCESSLIST | This view displays the session information of the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | This view displays the major compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | This view displays the history information of tablet-level compactions. |
| V$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress information of tablet-level compactions. |
| V$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participant information on all OBServer nodes. |
| V$STATNAME | This view displays the definitions of all statistical events. |
| V$EVENT_NAME | This view displays the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | This view displays the details of the current wait event for each session. Each wait event has three parameters, which will be recorded. |
| V$SESSION_WAIT_HISTORY | This view displays the details of the current wait event for each session, including the last 10 wait events. |
| V$SESSTAT | This view displays the statistical event overview at the session level. |
| V$SYSSTAT | This view displays the statistical event information at the tenant level on the current server. |
| V$SYSTEM_EVENT | This view displays the wait event statistics at the tenant level. |
| 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. |
Statistics related to monitoring
| 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. |
Cache related statistics
| View name | Description |
|---|---|
| GV$OB_MEMORY | This view displays the memory statistics at the tenant level. |
| V$OB_MEMORY | This view displays the memory statistics at the tenant level. |
| GV$OB_MEMSTORE | This view displays the memory usage of MemTables for all tenants on all servers. |
| V$OB_MEMSTORE | This view displays the MemStore statistics at the tenant level. |
| GV$OB_MEMSTORE_INFO | This view displays the details of MemTables for all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | This view displays the details of MemTables for all partitions of all tenants on all servers. |
| GV$OB_SSTABLES | This view displays the SSTable information of a tenant. |
| V$OB_SSTABLES | This view displays the SSTable information of a tenant. |
| GV$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the current observer process. |
| GV$OB_PL_CACHE_OBJECT | This view displays the basic information of PL-related cache objects for all tenants. |
| V$OB_PL_CACHE_OBJECT | This view displays the basic information of PL-related cache objects for the current tenant. |
SQL-related statistics
| View Name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | This view displays the outline information of the current tenant, primarily for outline migration. |
| V$OB_PLAN_CACHE_STAT | This view records the overall status of each plan cache on all servers for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache on all servers for the current tenant. |
| V$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache on the current server for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache on the current server. |
| GV$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | This view provides monitoring functionality for prepared statements, containing basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | This view provides monitoring functionality for prepared statements, containing basic information about all prepared statements in the PS cache. |
| GV$OB_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 statistical information such as the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | This view displays statistical information such as the source and execution status of each SQL request on the current server. |
| GV$SQL_PLAN_MONITOR | This view displays plan-level 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 operation-level statistics for slow queries. Each operation has a corresponding statistical record. |
| V$SQL_MONITOR_STATNAME | This view displays the meaning of the numeric values in the OTHERSTAT_X_ID column of GV$SQL_PLAN_MONITOR. |
| GV$OB_FLT_TRACE_CONFIG | This view displays diagnostic information for end-to-end tracing. |
Log-related statistics
| 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. |
Network-related statistics
| View name | Description |
|---|---|
| GV$OB_RPC_OUTGOING | This view displays the statistics of RPC packets sent from all OBServer nodes. |
| GV$OB_RPC_INCOMING | This view displays the statistics of RPC packets received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | This view displays the statistics of RPC packets sent from different tenants on different OBServer nodes. |
| V$OB_RPC_INCOMING | This view displays the statistics of RPC packets received by different tenants on different OBServer nodes. |
Database-related statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | This view displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | This view displays the configuration information on all OBServer nodes where the tenant resides. |
| GV$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| GV$OB_UNITS | This view displays the unit information on the OBServer node where the tenant resides. The system tenant can view the unit information on all OBServer nodes in the cluster. |
| V$OB_KVCACHE | This view displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | This view displays the configuration information on the OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| V$OB_UNITS | This view displays the unit information on the OBServer node. |
| GV$DML_STATS | This view displays the DML information in the current user table. |
| V$DML_STATS | This view displays the DML information in the current user table. |
| 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. |
SQLSTAT-related statistics
| View name | Description |
|---|---|
| GV$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row (i.e., each unique combination of SQL_ID and Plan_Hash corresponds to one row). |
| V$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (i.e., each unique combination of SQL_ID and Plan_Hash corresponds to one row). |
Time Model-related statistics
| View name | Description |
|---|---|
| GV$OB_SESS_TIME_MODEL | This view displays the Time Model statistics at the session level in the cluster. |
| V$OB_SESS_TIME_MODEL | This view displays the Time Model statistics at the session level on the current node. |
| GV$OB_SYS_TIME_MODEL | This view displays the Time Model statistics at the tenant level in the cluster. |
| V$OB_SYS_TIME_MODEL | This view displays the Time Model statistics at the tenant level on the current node. |
Dump-related statistics
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | This view displays the statistics of completed compactions in the OceanBase cluster. |
| V$OB_MERGE_INFO | This view displays the statistics of completed compactions in the OceanBase cluster. |
Thread-related statistics
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, this view displays the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, this view displays the execution information of each thread. |
Statistics related to workarea
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | This view displays the workarea information of the active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of all workareas executed in the past, such as the number of times in-memory processing is performed in the range of 1 MB to 2 MB and the number of one-pass operations. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory. |
| V$SQL_WORKAREA | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | This view displays the workarea information of the active operators. |
| V$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of all workareas executed in the past, such as the number of times in-memory processing is performed in the range of 1 MB to 2 MB and the number of one-pass operations. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some overall information about the SQL workarea, including the maximum available memory, current used memory, and current held memory. |
Statistics related to 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. |
Statistics related to transactions
| View name | 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 an Oracle tenant
Overview
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Views and tables
| View | Description |
|---|---|
| ALL_ALL_TABLES | This view displays the object and relational tables accessible to the user. |
| ALL_COL_COMMENTS | This view displays the column comments of the views and tables accessible to the user. |
| ALL_TABLES | This view displays all tables accessible to the 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 of the tables and views accessible to the current user. |
| DBA_COL_COMMENTS | This view displays the column comments of all views and tables in the database. |
| DBA_TAB_COMMENTS | This view displays the comments of all tables and views in the database. |
| USER_COL_COMMENTS | This view displays the column comments of the views and tables owned by the current user. |
| USER_TAB_COMMENTS | This view displays the comments of the tables and views owned by the current user. |
| DBA_OB_TABLEGROUP_TABLES | This view displays the association between a tablegroup and a table. Tables not in a tablegroup are not displayed. |
| DBA_TABLES | This view displays all tables in the database. |
| DBA_ALL_TABLES | This view displays the object and relational tables in the database. The fields of this view are the same as those of ALL_ALL_TABLES. |
| DBA_TABLESPACES | This view displays all tablespaces in the database. |
| DBA_TAB_COLS | This view displays all columns of 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 and relational tables accessible to the current user. The fields of this view, except for the OWNER field, are the same as those of ALL_ALL_TABLES. |
| USER_TABLES | This view displays all tables owned by the current user. |
| USER_TABLESPACES | This view displays the tablespaces accessible to the current user. The columns of this view are the same as those of DBA_TABLESPACES, except that the PLUGGED_IN field is removed. |
| 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 all views accessible to the current user. |
| DBA_VIEWS | This view displays all views in the database. The columns are the same as those in the ALL_VIEWS view. |
| USER_VIEWS | This view displays views owned by the current user. |
| DICTIONARY | Description |
| DICT | Description |
| DBA_OB_TABLE_LOCATIONS | This view displays the locations of tables and partitions, including system tables, user tables, index tables, and so on. |
Outline
| View name | Description |
|---|---|
| DBA_OB_OUTLINES | This view displays the outline information of the execution plans of the current tenant. |
| DBA_OB_CONCURRENT_LIMIT_SQL | This view displays the outline information of the throttling rules of the current tenant. |
| DBA_OB_OUTLINE_CONCURRENT_HISTORY | This view displays the outline information of the execution plans and throttling rules of the current tenant. |
SPM
| View name | Description |
|---|---|
| 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 of SPM. |
Basic database information
| View name | Description |
|---|---|
| DBA_CONTEXT | This view displays the information of all context namespaces in the database. |
| DBA_OB_DATABASES | This view displays the database metadata of the current tenant. |
| DBA_OB_MAJOR_COMPACTION | This view displays the global information of the current tenant. |
| DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the information of the major compactions in each zone of the current tenant. |
| ALL_OBJECTS | This view displays all database objects accessible to the current user. |
| DBA_OBJECTS | This view displays all database objects. |
| USER_OBJECTS | This view displays all database objects owned by the current user. |
| ALL_DEPENDENCIES | This view displays the dependencies between all database objects. |
| DBA_DEPENDENCIES | This view displays all dependencies between database objects. |
| USER_DEPENDENCIES | This view displays the dependencies between objects in the current user schema. |
| DBA_OB_FREEZE_INFO | This view displays the version information generated by major freeze. |
Functions and procedures
| View name | Description |
|---|---|
| ALL_ARGUMENTS | This view displays the parameters of all functions and procedures accessible to the current user. |
| ALL_PROCEDURES | This view displays all functions and procedures accessible to the current user, along with their related attributes. |
| ALL_SOURCE | This view displays the text source of all stored objects accessible to the current user. |
| DBA_ARGUMENTS | This view displays the parameters of all functions and procedures available in the database. Its 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. Its columns are the same as those in ALL_PROCEDURES. |
| DBA_SOURCE | This view displays the text source of all stored objects in the database. Its columns are the same as those in ALL_SOURCE. |
| USER_ARGUMENTS | This view displays the parameters of all functions and procedures owned by the current user. Its columns are the same as those in ALL_ARGUMENTS, excluding the OWNER column. |
| USER_PROCEDURES | This view displays all functions and procedures owned by the current user, along with their related attributes. Its columns are the same as those in ALL_PROCEDURES, excluding the OWNER column. |
| USER_SOURCE | This view displays the text source of all stored objects owned by the current user. Its columns are the same as those in ALL_SOURCE, excluding the OWNER column. |
| DBA_JOBS | This view displays an overview of all submitted tasks. |
| USER_JOBS | This view displays an overview of all submitted tasks. |
| DBA_JOBS_RUNNING | This view displays all running tasks. |
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 jobs of the current tenant. |
| DBA_OB_BACKUP_TASK_HISTORY | This view displays the history of task-level backup jobs of the current tenant. |
| DBA_OB_BACKUP_SET_FILES | This view displays the status of files in 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 path 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 historical 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 backup deletion jobs at the tenant level. |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of backup deletion jobs executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASKS | This view displays the information about the backup_set/backup_piece deletion tasks being executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of 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, including historical and current ones. |
| DBA_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of pieces in a backup set. |
| DBA_OB_BACKUP_PARAMETER | This view displays the backup parameters. |
| DBA_OB_RECOVER_TABLE_JOBS | This view displays information about table-level restore tasks. |
| DBA_OB_IMPORT_TABLE_JOBS | This view displays information about import tasks. |
| DBA_OB_IMPORT_TABLE_TASKS | This view displays records of table-level import tasks. |
| DBA_OB_RECOVER_TABLE_JOB_HISTORY | This view displays the results of table-level restore tasks. |
| DBA_OB_IMPORT_TABLE_JOB_HISTORY | This view displays the results of import tasks. |
| DBA_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the history of cross-tenant table-level import tasks. |
Statistics and histograms
| View name | Description |
|---|---|
| ALL_PART_COL_STATISTICS | This view displays column statistics and histogram information for partitions of all partitioned tables accessible to the current user. |
| ALL_PART_HISTOGRAMS | This view displays histogram information for all partitions. |
| ALL_SUBPART_COL_STATISTICS | This view displays column statistics and histogram information for subpartitions of all partitioned tables accessible to the current user. |
| ALL_SUBPART_HISTOGRAMS | This view displays histogram information for all subpartitions. |
| ALL_TAB_COL_STATISTICS | This view displays column statistics and histogram information for all tables accessible to the current user. |
| ALL_TAB_HISTOGRAMS | This view displays histogram information for all tables. |
| ALL_TAB_STATISTICS | This view displays optimizer statistics for all tables accessible to the current user. |
| DBA_PART_COL_STATISTICS | This view displays column statistics and histogram information for partitions of all partitioned tables in the database. |
| DBA_PART_HISTOGRAMS | This view displays histogram information for all partitions. |
| DBA_SUBPART_COL_STATISTICS | This view displays column statistics and histogram information for subpartitions of all partitioned tables in the database. |
| DBA_SUBPART_HISTOGRAMS | This view displays histogram information for all subpartitions. |
| DBA_TAB_COL_STATISTICS | This view displays column statistics and histogram information for all tables in the database. |
| DBA_TAB_HISTOGRAMS | This view displays histogram information for all tables. |
| DBA_TAB_STATISTICS | This view displays optimizer statistics for all tables. |
| USER_PART_COL_STATISTICS | This view displays column statistics and histogram information for partitions of all partitioned tables accessible to the current user. |
| USER_PART_HISTOGRAMS | This view displays histogram information for all partitions. |
| USER_SUBPART_COL_STATISTICS | This view displays column statistics and histogram information for subpartitions of all partitioned tables accessible to the current user. |
| USER_SUBPART_HISTOGRAMS | This view displays histogram information for all subpartitions. |
| USER_TAB_COL_STATISTICS | This view displays column statistics and histogram information for all tables accessible to the current user. |
| USER_TAB_HISTOGRAMS | This view displays histogram information for all tables. |
| USER_TAB_STATISTICS | This view displays the optimizer statistics for all tables of the current user. |
| ALL_TAB_STATS_HISTORY | This view displays the table statistics modification history for all tables accessible to the current user. |
| DBA_TAB_STATS_HISTORY | This view displays the table statistics modification history for all tables in the database. |
| USER_TAB_STATS_HISTORY | This view displays the table statistics modification history for all tables owned by the current user. |
| ALL_IND_STATISTICS | This view displays the optimizer statistics for indexes on tables accessible to the current user. |
| DBA_IND_STATISTICS | This view displays the optimizer statistics for all indexes in the database. |
| USER_IND_STATISTICS | This view displays the optimizer statistics for indexes on tables owned by the current user. |
| ALL_TAB_MODIFICATIONS | This view displays the modification information for tables accessible to the current user since the last statistics collection. |
| DBA_TAB_MODIFICATIONS | This view displays the modification information for all tables in the database since the last statistics collection. |
| USER_TAB_MODIFICATIONS | This view displays the modification information for tables owned by the current user since the last statistics collection. |
Users and privileges
| View name | Description |
|---|---|
| ALL_USERS | This view displays all database users visible to the current user. |
| DBA_USERS | This view displays all users in the database. |
| USER_USERS | This view displays information about the current user. |
| ALL_COL_PRIVS | This view displays column object privileges granted to the current user as the owner, grantor, or grantee. Column object privileges granted to enabled roles or PUBLIC are also displayed. |
| ALL_TAB_PRIVS | *This view displays object privileges granted to the current user as the owner, grantor, or grantee. Object privileges granted to activated roles or the PUBLIC role are also displayed. * |
| 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 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. |
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. |
Audit
| View name | Description |
|---|---|
| ALL_DEF_AUDIT_OPTS | This view displays audit conditions for default auditing of any object. |
| AUDIT_ACTIONS | This view displays the Action ID and corresponding name in audit records. |
| DBA_AUDIT_EXISTS | This view displays audit trail entries generated by the AUDIT EXISTS and AUDIT NOT EXISTS statements. |
| DBA_AUDIT_OBJECT | This view displays audit trail records for all objects in the database. |
| DBA_AUDIT_SESSION | This view displays audit trail records for CONNECT and DISCONNECT events. |
| DBA_AUDIT_STATEMENT | This view displays audit trail records for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements in the database. |
| DBA_AUDIT_TRAIL | This view displays all audit trail entries. |
| DBA_OBJ_AUDIT_OPTS | This view displays detailed object-level audit configurations. |
| DBA_STMT_AUDIT_OPTS | This view displays detailed statement-level audit configurations. |
| STMT_AUDIT_OPTION_MAP | This view displays the type, name, and priority of statement-level audit options. |
| USER_AUDIT_OBJECT | This view displays audit trail records for objects accessible to the current user. |
| USER_AUDIT_SESSION | This view displays audit trail records for the current user's connections and disconnections. |
| USER_AUDIT_STATEMENT | This view displays audit trail entries for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements issued by the current user. |
| USER_AUDIT_TRAIL | This view displays standard audit trail entries related to the current user. |
Indexes
| View Name | Description |
|---|---|
| ALL_INDEXES | This view displays the index column information of all tables accessible to the user. |
| ALL_IND_COLUMNS | This view displays the index column information of all tables accessible to the user. |
| ALL_IND_EXPRESSIONS | This view displays the information of function-based indexes accessible to the user in the database. |
| ALL_IND_PARTITIONS | This view displays the information of index partitions accessible to the user in the database. |
| ALL_IND_SUBPARTITIONS | This view displays the information of all index subpartitions accessible to the user in the database. |
| ALL_PART_INDEXES | This view displays the partition information of partition indexes accessible to the current user. |
| DBA_INDEXES | This view displays the index information of all tables in the database. |
| DBA_IND_COLUMNS | This view displays the index column information of all tables in the database. |
| DBA_IND_EXPRESSIONS | This view displays the information of all function-based indexes in the database. |
| DBA_IND_PARTITIONS | This view displays the information of all index partitions in the database. |
| DBA_IND_SUBPARTITIONS | This view displays the information of all index subpartitions in the database. |
| USER_INDEXES | This view displays the index information of all tables owned by the user. |
| USER_IND_COLUMNS | This view displays the index column information of all tables owned by the user. |
| USER_IND_EXPRESSIONS | This view displays the information of function-based indexes owned by the user in the database. |
| USER_IND_PARTITIONS | This view displays the information of index partitions owned by the current user in the database. This view does not contain the INDEX_OWNER column, which is present in ALL_IND_PARTITIONS and DBA_IND_PARTITIONS. |
| USER_IND_SUBPARTITIONS | This view displays the information of all index subpartitions owned by the user in the database. This view does not contain the INDEX_OWNER column, which is present in DBA_IND_SUBPARTITIONS and ALL_IND_SUBPARTITIONS. |
| USER_PART_INDEXES | This view displays the partition information of partition indexes owned by the current user. |
Partition
| View | Description |
|---|---|
| ALL_PART_KEY_COLUMNS | This view displays the columns of the partition key in all partitioned objects accessible to the current user. |
| ALL_PART_TABLES | This view displays partition information of all partitioned tables accessible to the current user. |
| ALL_SUBPARTITION_TEMPLATES | Description |
| ALL_SUBPART_KEY_COLUMNS | This view lists the subpartition key columns of all user-accessible subpartitioned objects. |
| ALL_TAB_PARTITIONS | This view displays the partitions of all partitioned tables. The view also provides storage and statistics parameters of partitions. |
| ALL_TAB_SUBPARTITIONS | This view displays partition level information, storage parameters, and statistics generated by the DBMS_STATS package for partitions accessible by the current user. |
| DBA_PART_INDEXES | This view displays information about partitions of all indexes. |
| DBA_PART_KEY_COLUMNS | This view displays the columns in the partitioning key for all partitioned objects in the database. |
| DBA_PART_TABLES | This view displays the partition information of the partitioned tables that the current user has access to. |
| DBA_SUBPARTITION_TEMPLATES | Description |
| DBA_SUBPART_KEY_COLUMNS | This view displays the columns of the subpartition key for all partitioned objects in the database. |
| DBA_TAB_PARTITIONS | This view displays partitioning information, partition storage parameters, and partition statistics of all tables and clusters that are accessible to the current user. |
| DBA_TAB_SUBPARTITIONS | This view displays subpartition names, table names, partition names, storage attributes, and statistics generated by the DBMS_STATS package. |
| USER_PART_KEY_COLUMNS | This view displays the columns in partitioning keys of all partitioned objects owned by the current user. |
| USER_PART_TABLES | This view displays the partition information of the current user's partitioned tables. |
| USER_SUBPARTITION_TEMPLATES | Description |
| USER_SUBPART_KEY_COLUMNS | This view displays all columns included in the subpartition key for all partitioned objects owned by the current user. |
| USER_TAB_SUBPARTITIONS | This view displays subpartition names, table names, partition names, and storage attributes for each subpartition of the tables owned by the current user. |
| USER_TAB_PARTITIONS | This view displays the hierarchical partitioning information, storage parameters, and statistics for partitions of the current user. |
Session related
| View | Description |
|---|---|
| DBA_OB_DEADLOCK_EVENT_HISTORY | This view displays the history of deadlock events. In a non-root tenant, the view shows the history of events within that tenant. |
Sequence
| View | Description |
|---|---|
| ALL_SEQUENCES | This view displays all SEQUENCEs accessible to the current user. |
| DBA_SEQUENCES | This view displays all SEQUENCE in the database. |
| USER_SEQUENCES | This view displays all sequences of the current user. |
| TENANT_VIRTUAL_GLOBAL_VARIABLE | This view displays information about global variables. |
| TENANT_VIRTUAL_SESSION_VARIABLE | This view displays session variable information. |
Synonyms
| View | Description |
|---|---|
| ALL_SYNONYMS | This view displays all synonyms accessible by the current user. |
| DBA_SYNONYMS | This view displays all synonyms in the database. |
| USER_SYNONYMS | This view displays synonyms owned by the current user. |
Triggers
| View | Description |
|---|---|
| ALL_TRIGGERS | Description |
| DBA_TRIGGERS | This view displays all triggers in the database. |
| USER_TRIGGERS | This view displays all triggers owned by the current user. |
Trash
| View | Description |
|---|---|
| DBA_RECYCLEBIN | This view displays information about the recyclebins in the database. |
| USER_RECYCLEBIN | This view displays information of the recycle bin owned by the current user. Its columns are the same as those in DBA_RECYCLEBIN, but without the OWNER column. |
Resource group
| View | Description |
|---|---|
| DBA_RSRC_GROUP_MAPPINGS | This view displays the mappings between users and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | This view displays information about all resource consumer 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 details of each resource plan directive for a database. |
NLS
| View | Description |
|---|---|
| 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. |
User-defined types
| View | Description |
|---|---|
| ALL_COLL_TYPES | Type |
| ALL_TYPES | Type |
| ALL_TYPE_ATTRS | Type |
| DBA_COLL_TYPES | Type |
| DBA_TYPES | Type |
| DBA_TYPE_ATTRS | Type |
| USER_COLL_TYPES | Type |
| USER_TYPES | Type |
| USER_TYPE_ATTRS | Type |
Storage objects
| View name | Description |
|---|---|
| ALL_ERRORS | This view displays the errors of the storage objects that the current user can access. |
| DBA_ERRORS | This view displays the errors of the storage objects in the database. |
| USER_ERRORS | This view displays the errors of the storage objects that the current 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. |
PROFILE
| View name | Description |
|---|---|
| ALL_PROFILES | This view displays the profiles and their limits. |
| DBA_PROFILES | This view displays the profiles and their limits. |
| USER_PROFILES | This view displays the profiles and their limits. |
Replicas and logs
| View name | Description |
|---|---|
| DBA_OB_LS_LOCATIONS | This view displays the distribution information of the log stream (LS) replicas in the current tenant. |
| DBA_OB_TABLEGROUPS | This view displays the metadata of the table groups, mainly the partition information of the table groups. |
| DBA_OB_TABLEGROUP_PARTITIONS | This view displays the primary partition information of the partitioned table groups. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of the partitioned table groups. |
| DBA_OB_TABLET_REPLICAS | This view displays the information of all tablets in the current tenant. Each tablet replica is uniquely determined by the joint key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| DBA_OB_TABLET_TO_LS | This view displays the list of all tablets in the current tenant and the information of the log streams to which the tablets belong. |
| DBA_OB_LS | This view displays the status and recovery progress of the log streams. |
WR related
| 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 ASH data of the current tenant. |
| DBA_WR_STATNAME | This view displays the names of the system statistics of the current tenant. |
| DBA_WR_SYSSTAT | This view displays the details of the system statistics of the current tenant. |
| DBA_WR_CONTROL | This view displays the WR-related configuration information. |
| DBA_WR_SYSTEM_EVENT | This view displays the tenant-level wait event information of the current tenant. |
| DBA_WR_EVENT_NAME | This view displays the tenant-level wait event names of the current tenant. |
| DBA_WR_SQLTEXT | This view displays the SQL texts collected by WR of the current tenant. |
SQLSTAT related
| View name | Description |
|---|---|
| DBA_WR_SQLSTAT | This view displays the basic performance statistics of the SQL statements executed by the current tenant. |
SQLSTAT related
| View name | Description |
|---|---|
| DBA_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics of the current tenant. |
Load balancing related
| View name | Description |
|---|---|
| DBA_OB_TRANSFER_PARTITION_TASKS | This view displays the Transfer Partition tasks being processed by the current tenant. |
| DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of the Transfer Partition tasks executed by the current tenant. |
Scheduler
| View name | Description |
|---|---|
| DBA_SCHEDULER_JOBS | This view displays the scheduler jobs accessible to the current user. |
| DBA_SCHEDULER_PROGRAM | This view displays all the scheduler information in the database. |
| DBA_SCHEDULER_JOB_RUN_DETAILS | This view displays all the scheduler jobs in the tenant. |
DBLINK related
| View name | Description |
|---|---|
| ALL_DB_LINKS | This view displays all the DBLINKs accessible to the current user. |
| DBA_DB_LINKS | This view displays all the DBLINKs created in the current tenant. |
| USER_DB_LINKS | This view displays all the DBLINKs created by the current user. |
Not supported views
| View | Description |
|---|---|
| ALL_METHOD_PARAMS | Type |
| ALL_SCHEDULER_JOB_ARGS | This view displays the parameters of scheduler jobs that can be queried by users. |
| ALL_SCHEDULER_PROGRAM_ARGS | This view displays user-specified parameter information of all scheduler programs. |
| ALL_TYPE_METHODS | Type |
| DBA_METHOD_PARAMS | Type |
| DBA_SCHEDULER_JOB_ARGS | This view displays the information about job arguments of database scheduler jobs. |
| USER_SCHEDULER_JOB_ARGS | This view displays parameters of the current user's jobs. |
| DBA_SCHEDULER_PROGRAM_ARGS | This view displays the information about the parameters of a scheduled program. |
| USER_SCHEDULER_PROGRAM_ARGS | This view displays the scheduler program arguments of the current user. |
| DBA_TYPE_METHODS | Type |
| USER_TYPE_METHODS | Type |
Overview of performance views
ASH related
| View name | Description |
|---|---|
| GV$OB_ACTIVE_SESSION_HISTORY | Displays the active session history. |
Statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | Displays the configuration information on all OBServer nodes where the tenant is located. |
| GV$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| V$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| GV$OB_UNITS | Displays the unit information on the OBServer node where the tenant is located. The system tenant can view the unit information on all OBServer nodes in the cluster. |
| GV$SYSSTAT | Displays the system-level statistical events on all servers. |
| GV$DML_STATS | Displays the DML information in the current user table. |
| V$DML_STATS | Displays the DML information in the current user table. |
| V$GLOBALCONTEXT | Displays the CLIENT_IDENTIFIER value of the global context attributes accessible to the current session. |
| V$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | Displays the configuration information on the current OBServer node. |
| V$SYSSTAT | Displays the system-level statistical events on the current server. |
| V$OB_UNITS | Displays the unit information on the current OBServer node. |
| V$VERSION | Displays the names and versions of all components of the database product. |
| V$STATNAME | Displays the names of statistical items. |
Instance related
| View name | Description |
|---|---|
| GV$INSTANCE | Displays the status of the current database instance. |
| V$INSTANCE | Displays the status of the current database instance. |
Memory-related 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 for each 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 for each 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. |
Cache-related
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache of all servers. |
| GV$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache of all servers for the current tenant. |
| GV$OB_PLAN_CACHE_STAT | This view records the overall 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 overall status of each plan cache in all servers for the current tenant. |
| V$RSRC_PLAN | This view displays the resource management plan of the current active tenant. |
| GV$OB_PL_CACHE_OBJECT | This view displays the basic information of PL-related cached objects for all tenants. |
| V$OB_PL_CACHE_OBJECT | This view displays the basic information of PL-related cached objects for all tenants. |
Log-related
| 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. |
Monitoring information
| View name | Description |
|---|---|
| GV$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on all OBServer nodes. |
| GV$OB_PS_ITEM_INFO | This view provides monitoring capabilities for Prepared Statements, including basic information about all prepared 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. |
| 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. |
| V$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on OBServer nodes. |
| 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. |
| V$SQL_MONITOR_STATNAME | This view displays the meaning of the numbers in the OTHERSTAT_X_ID column of GV$SQL_PLAN_MONITOR. |
Session-related
| View name | Description |
|---|---|
| GV$OB_PROCESSLIST | This view displays session information on all OBServer nodes of the tenant. |
| GV$SESSION_WAIT | This view displays information about the current or previous wait events of all sessions on all servers, including the wait event name and wait time. |
| GV$SESSION_WAIT_HISTORY | This view displays information about the most recent 10 wait events of all sessions on all servers. |
| GV$SESSTAT | This view displays session-level statistics on all servers. |
| GV$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$NLS_PARAMETERS | This view displays NLS parameters at the session level. |
| V$OB_PROCESSLIST | This view displays session information on the current OBServer node. |
| V$SESSION_WAIT | This view displays information about the current or previous wait events of all sessions on the current server, including the wait event name and wait time. |
| V$SESSION_WAIT_HISTORY | This view displays information about the most recent 10 wait events of all sessions on the current server. |
| V$SESSTAT | This view displays session-level statistics. |
| V$EVENT_NAME | This view displays event definitions under the tenant. |
Cgroup-related
| View name | Description |
|---|---|
| GV$OB_CGROUP_CONFIG | This view queries the cgroup configurations of the OBServer node. |
| V$OB_CGROUP_CONFIG | This view queries the cgroup configurations of the OBServer node. |
SQL-related statistics
| View | Description |
|---|---|
| GV$OB_SQL_AUDIT | This view displays the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | This view displays the source and execution status of each SQL request on the current server. |
| 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 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. |
| GV$OB_FLT_TRACE_CONFIG | This view displays the diagnostic information of full-link tracing. |
Threads
| View | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, this view displays the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, this view displays the execution information of each thread. |
Workarea
| View | Description |
|---|---|
| GV$SQL_WORKAREA | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | This view displays the workarea information of active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some information about the SQL workarea, including the maximum available memory, current used memory, and current hold memory. |
| V$SQL_WORKAREA | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | This view displays the workarea information of active operators. |
| V$SQL_WORKAREA_HISTOGRAM | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
Transaction-related views
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | This view displays the OBServer-level major compaction progress of the 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$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participants on all OBServer nodes. |
| GV$SYSTEM_EVENT | This view displays the system-level wait events on all servers, including the number of occurrences, wait time, and timeout count for each type of wait event. |
| GV$GLOBAL_TRANSACTION | This view displays the information of active global transactions. |
| V$OB_COMPACTION_PROGRESS | This view displays the server-level major compaction progress of the 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. |
| V$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participants on all OBServer nodes. |
| V$SYSTEM_EVENT | This view displays the system-level wait events on the current server, including the number of occurrences, wait time, and timeout count for each type of wait event. |
| V$GLOBAL_TRANSACTION | This view displays the information of active global transactions. |
| GV$OB_GLOBAL_TRANSACTION | This view displays the information of all XA transactions in the cluster. |
| V$OB_GLOBAL_TRANSACTION | This view displays the information of all XA transactions whose original scheduler is the current node. |
Time zone
| View name | Description |
|---|---|
| V$TIMEZONE_NAMES | This view displays valid time zone names. |
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. |
DBLINK
| View name | Description |
|---|---|
| GV$DBLINK | This view displays all database links (IN_TRANSACTION=YES) opened after the query session that issued 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 the query session that issued this view. These database links must be committed or rolled back before they are closed. |
SQLSTAT
| View name | Description |
|---|---|
| GV$OB_SQLSTAT | This view displays basic performance statistics for SQL statements in the cluster. Each SQL statement is represented as a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
| V$OB_SQLSTAT | This view displays basic performance statistics for SQL statements on the current node. Each SQL statement is represented as a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
Time Model
| View name | Description |
|---|---|
| GV$OB_SESS_TIME_MODEL | This view displays session-level Time Model statistics in the cluster. |
| V$OB_SESS_TIME_MODEL | This view displays session-level Time Model statistics on the current node. |
| GV$OB_SYS_TIME_MODEL | This view displays tenant-level Time Model statistics in the cluster. |
| V$OB_SYS_TIME_MODEL | This view displays tenant-level Time Model statistics on the current node. |