Overview of views in the SYS tenant
Overview of dictionary views
Table and column-related
| View name | Description |
|---|---|
| oceanbase.CDB_IND_COLUMNS | Displays the column information of index tables of 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 associations between table groups and tables in the sys tenant. Tables not in a table group are not displayed. |
| oceanbase.CDB_TAB_COLS | Displays the column information of tables and views of all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | Displays the column information of tables and views of all tenants. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the associations between table groups and tables. Tables not in a 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.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO | Displays the information about column checksum inconsistencies between index tables (including global indexes and local indexes) and 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 throttling rules for the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history of execution plans and throttling 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 partition storage parameters and statistics. |
| 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 by all tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of partition transfer tasks executed by all tenants. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the partition transfer tasks being processed by the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of partition transfer tasks executed by 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. |
Backup and restore-related
| 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 backup job history 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 created. A task record corresponds to one backup_set. The task record and the job record of the same backup_set are in a one-to-one relationship. |
| 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 history of backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the history of backup tasks 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 archives, 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 partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays histogram endpoint data for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays table statistics history for all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays optimizer statistics for all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the 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 the sys tenant, 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, mainly the partition information of table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | Displays the primary partitions of all tenant table groups in the sys tenant. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartitions of all tenant table groups in the sys tenant. |
| oceanbase.CDB_OB_TABLET_TO_LS | Displays the tablets and the corresponding LSs of all tenants in the sys tenant. |
| oceanbase.CDB_OB_TABLET_REPLICAS | Displays information about all tablet replicas in the current tenant. Each 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 primary 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, mainly the partition information of table groups. |
| oceanbase.DBA_OB_TABLET_REPLICAS | Displays information about all tablet replicas in the current tenant. Each 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 tablets and the corresponding LSs of 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 restore progress of log streams. |
| oceanbase.DBA_OB_LS | Displays the status and restore progress of log streams. |
WR-related views
| View | 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 system statistics of the current tenant. |
| oceanbase.CDB_WR_STATNAME | Displays the names of system statistics of all tenants. |
| oceanbase.DBA_WR_SYSSTAT | Displays the details of system statistics of the current tenant. |
| oceanbase.CDB_WR_SYSSTAT | Displays the details of 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. |
OBKV-related views
| View name | Description |
|---|---|
| oceanbase.CDB_OB_KV_TTL_TASKS | Displays all the TTL tasks being executed in all tenants in the sys tenant. |
| oceanbase.CDB_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks of all tenants in the sys 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 in the current tenant. |
Overview of the performance view
Event-related statistics
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the major compaction progress information of each OBServer node in the tenant. |
| 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 at the session level on all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | Displays the name and duration of the current or last wait event for each session on all servers, including the server name. |
| GV$SESSION_WAIT_HISTORY | Displays the information of the last 10 wait events for each session on all servers. |
| GV$SYSTEM_EVENT | Displays the tenant-level wait events in the cluster. |
| GV$SESSTAT | The statistics of wait events at 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 | Displays the details of the current wait event for each session on all servers. According to the convention, each wait event has three parameters, and the values of the parameters are recorded. |
| V$SESSION_WAIT_HISTORY | Displays the details of the current wait event for each session on all servers. It also displays the 10 most recent wait events for each session. |
| V$SESSTAT | Displays the statistics of wait events at the session level on all OBServer nodes. |
| V$SYSSTAT | Displays the tenant-level statistics of wait events on all servers. |
| 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 detailed information about MemTables in all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | Displays detailed information about MemTables in 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. |
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 of 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 statistics of slow queries on all OBServer nodes from the plan level. Each slow query has a statistics record, and the trace information of the plan is recorded. |
| V$SQL_PLAN_MONITOR | Displays the statistics of operations in slow queries on the current server. |
| V$SQL_MONITOR_STATNAME | Describes the meaning of the 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. |
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 packet codes sent by all tenants on the OBServer node. |
| V$OB_RPC_INCOMING | Statistics on RPC data of different packet codes received by all tenants on the OBServer node. |
Database-related statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameter information on all OBServer nodes in the tenant. |
| GV$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| GV$OB_SERVERS | Displays the information about all OBServer nodes. |
| GV$OB_UNITS | Displays the unit information on the OBServer node where the current tenant resides. The sys tenant can view the units of all OBServer nodes in the cluster. |
| V$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameter information on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| V$OB_SERVERS | Displays the information about the current OBServer node. |
| V$OB_UNITS | Displays the units of the current OBServer node. |
| GV$DML_STATS | Displays the DML information in the current user table. |
| V$DML_STATS | Displays the DML information in the current user table. |
Statistics related to minor compactions
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | Displays statistics about minor compactions completed in the OceanBase cluster. |
| V$OB_MERGE_INFO | Displays statistics about minor compactions completed in the OceanBase cluster. |
Statistics related to threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, displays the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, displays the execution information of each thread. |
| 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 of 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 of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of one-pass operations. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Information about the overall SQL workarea, such as the maximum available memory, the current memory usage, and the current held memory. |
| V$SQL_WORKAREA | Statistics of 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 of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of one-pass operations. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Information about the overall SQL workarea, including the maximum available memory, the current memory usage, and the current held memory. |
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. |
Statistics on transactions
| View name | Description |
|---|---|
| GV$LATCH | Displays the latch information of all OBServer nodes in the cluster. |
| V$LATCH | Displays the latch information of all OBServer nodes in the cluster. |
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. |
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 correspondence 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 the 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 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 related to throttling rules for the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history information of execution plans and throttling rules outlines for the current tenant. |
Database basic information
| View | Description |
|---|---|
| information_schema.GLOBAL_STATUS | Records the global status information of OceanBase Database. |
| information_schema.GLOBAL_VARIABLES | Records the global variable information. |
| information_schema.SCHEMATA | Records the metadata of databases. |
| oceanbase.DBA_OB_DATABASES | Displays the metadata of databases for the current tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the global major compaction information for the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays the major compaction information for each zone of the current tenant. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major compactions (major_freeze). |
Partition-related
| View name | Description |
|---|---|
| information_schema.PARTITIONS | Records partition information. |
| oceanbase.DBA_IND_PARTITIONS | Displays the partition and subpartition information of indexes. |
| oceanbase.DBA_PART_INDEXES | Displays the partition information of all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | Displays the partition information of user tables. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the multi-level partition information, partition storage parameters, and partition statistics of tables accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | Displays the subpartition name, the name of the table to which the subpartition belongs, the name of the partition to which the subpartition belongs, its storage attributes, and the statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays the descriptions of all subpartition templates. |
Load balancing-related
| View name | Description |
|---|---|
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the transfer partition tasks being processed in the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of transfer partition tasks executed in the current tenant. |
Thread-related
| View name | Description |
|---|---|
| information_schema.PROCESSLIST | Provides information about running threads. |
Constraint-related
| View name | Description |
|---|---|
| information_schema.CHECK_CONSTRAINTS | Displays the constraints on tables and columns when you execute the CREATE TABLE statement. |
| information_schema.KEY_COLUMN_USAGE | Records the key constraints on columns. |
| information_schema.REFERENTIAL_CONSTRAINTS | Displays the metadata of foreign key constraints. |
| information_schema.TABLE_CONSTRAINTS | Describes the constraints on tables. |
Session-related
| View name | Description |
|---|---|
| information_schema.SESSION_STATUS | Records the status information of sessions, such as the number of active connections and the uptime of the database. |
| information_schema.SESSION_VARIABLES | Records the variables of sessions. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history records of deadlocks. This view displays the history records of the current tenant in non-root tenants. |
User login-related views
| View name | Description |
|---|---|
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | Displays the number of failed login attempts for each user. |
Views related to backup and restore
| View name | Description |
|---|---|
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the history records of the backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the backup tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | Displays the history records of the 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 ongoing restore tasks. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays the completed restore tasks. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays the backup destination information used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information of backup destinations used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup policies for expired data and automatic cleanup, which are set for the tenant. |
| 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 information of backup deletion jobs executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays the information about backup_set or backup_piece deletion tasks being executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history information of backup_set or backup_piece deletion tasks completed in the tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | Displays the status of log backup for each 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.DBA_OB_RECOVER_TABLE_JOBS | Displays information about table-level restore jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | Displays information about import jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | Displays records of table-level import tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of table-level restore jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the results of import jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the history records of cross-tenant table-level import tasks. |
Statistics and histograms
| View name | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays optimizer statistics of all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays column statistics and histogram information of all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays column statistics and histogram information of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays column statistics and histogram information of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays histograms of all columns in all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays histogram endpoint data (of each histogram) on all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays histogram endpoint data (of each histogram) on all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays table statistics history of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays optimizer statistics of all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays modification information of all tables in the database since the last time statistics were collected on these tables. |
| information_schema.QUERY_RESPONSE_TIME | Displays data types (Histogram) such as the response time histogram for monitoring by Prometheus. |
Tenant-related
| View name | Description |
|---|---|
| oceanbase.DBA_OBJECTS | Displays all database objects in the database. The view definition is the same as that of ALL_OBJECTS. |
| oceanbase.DBA_OB_TENANTS | Displays basic information about all tenants, including system tenants, user tenants, and meta tenants. You can identify the tenant type by using the TENANT_TYPE column. |
Resource-related
| View name | Description |
|---|---|
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | Displays all sequences in the database. |
Views related to replicas and logs
| View name | Description |
|---|---|
| oceanbase.DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays information about the partitions of a table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays information about the subpartitions of a table group. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays metadata about table groups, including their partitions. |
| oceanbase.DBA_OB_TABLET_REPLICAS | Displays information about all tablet replicas in the 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 | Displays information about all tablets in the tenant and the log streams to which they belong. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution of log stream (LS) replicas in the tenant. |
WR-related views
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | Displays the SNAPSHOT information of the current tenant. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | Displays the ASH data of the current tenant after it is persisted. |
| oceanbase.DBA_WR_STATNAME | Displays the names of system statistics of the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | Displays the details of system statistics of the current tenant. |
| oceanbase.DBA_WR_CONTROL | Displays the configuration information of WR. |
Overview of the performance view
Event-related statistics
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the major compaction progress information of a tenant on OBServer nodes. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays suggestions for major compactions. |
| GV$OB_PROCESSLIST | Displays the session information of all OBServer nodes to which the tenant belongs. |
| 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 all sessions on all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | Displays information about the current or last wait event of each session on all servers, including the name and duration of the wait event. |
| GV$SESSION_WAIT_HISTORY | Displays information about the 10 most recent wait events of each session on all servers. |
| GV$SYSTEM_EVENT | Displays the tenant-level wait events of all tenants in the cluster. |
| GV$SESSTAT | Displays the statistical events of sessions on all OBServer nodes. |
| GV$SYSSTAT | Displays the tenant-level statistical events of all tenants on all servers. |
| GV$ACTIVE_SESSION_HISTORY | Displays the ASH of all sessions. |
| V$ACTIVE_SESSION_HISTORY | Displays the ASH of all sessions. |
| V$OB_COMPACTION_PROGRESS | Displays the major compaction progress information of a tenant on OBServer nodes. |
| V$OB_COMPACTION_SUGGESTIONS | Displays suggestions for major compactions. |
| V$OB_PROCESSLIST | Displays the session information of the local 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 statistical events. |
| V$EVENT_NAME | Displays the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | Displays the details of the current wait event of each session. According to the convention, each wait event has three parameters, and the values of these parameters are recorded. |
| V$SESSION_WAIT_HISTORY | Displays the details of the current wait event of each session and the 10 most recent wait events. |
| V$SESSTAT | Displays the statistical events of sessions on all OBServer nodes. |
| V$SYSSTAT | Displays the tenant-level statistical events of all tenants on all servers. |
| V$SYSTEM_EVENT | Displays the tenant-level wait events of all tenants. |
| 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. |
Monitor-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. |
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 the details of MemTables in all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | Displays the details of MemTables in 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. |
SQL-related statistics
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | Displays the outline information of the current tenant, which is mainly used for outline migration. |
| 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 cache. |
| 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 and contains basic information of all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Provides monitoring functionality for prepared statements and contains basic information of 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 current 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 | Describes the meaning of the 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. |
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 RPCs sent on all OBServer nodes. |
| GV$OB_RPC_INCOMING | Displays the statistics on RPC requests received on all OBServer nodes. |
| V$OB_RPC_OUTGOING | Displays the statistics on RPC data sent on different tenants of an OBServer node for different RPC packet codes. |
| V$OB_RPC_INCOMING | Displays the statistics on RPC data received on different tenants of an OBServer node for different RPC packet codes. |
Database-related statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameter information on all OBServer nodes where the tenant resides. |
| GV$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| GV$OB_UNITS | Displays the unit information on the OBServer node 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 on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameter information on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| V$OB_UNITS | Displays the unit information on the current OBServer node. |
| GV$DML_STATS | Displays the DML information in the current user table. |
| V$DML_STATS | Displays the DML information in the current user table. |
Statistics on major compactions
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | Displays statistics on major compactions completed in the OceanBase cluster. |
| V$OB_MERGE_INFO | Displays statistics on major compactions completed in the OceanBase cluster. |
Statistics on threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | Displays execution information of each thread in parallel execution scenarios. |
| V$OB_PX_WORKER_STAT | Displays execution information of each thread in parallel execution scenarios. |
Workarea-related statistics
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | Statistics of 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 of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of times that a one-pass operation is performed. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Information about the memory usage of SQL workareas, such as the maximum available memory, the current memory usage, and the memory held. |
| V$SQL_WORKAREA | Statistics of 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 of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of times that a one-pass operation is performed. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Information about the memory usage of SQL workareas, including 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. |
Statistics on transactions
| View name | Description |
|---|---|
| GV$LATCH | Displays the latch information of all OBServer nodes in the cluster. |
| V$LATCH | Displays the latch information of all OBServer nodes in the cluster. |
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.
Table and view-related
| View name | Description |
|---|---|
| ALL_ALL_TABLES | Displays the user's access to objects and relational tables. |
| ALL_COL_COMMENTS | Displays the comments on all columns of the user's accessible views and tables. |
| ALL_TABLES | Displays all tables accessible to the user. |
| ALL_TAB_COLS | Displays all columns of tables, views, and clusters accessible to the user. |
| ALL_TAB_COLUMNS | Displays all columns of tables, views, and clusters accessible to the user. |
| ALL_TAB_COMMENTS | Displays the comments on tables and views accessible to the user. |
| DBA_COL_COMMENTS | Displays the comments on all columns of all views and tables in the database. |
| DBA_TAB_COMMENTS | Displays the comments on tables and views in the database. |
| USER_COL_COMMENTS | Displays the comments on all columns of the views and tables owned by the user. |
| USER_TAB_COMMENTS | Displays the comments on tables and views owned by the user. |
| DBA_OB_TABLEGROUP_TABLES | Displays the relationships between tables and table groups. Tables not in a table group are not displayed. |
| DBA_TABLES | Displays all tables in the database. |
| DBA_ALL_TABLES | Displays the object tables and relationship tables in the database. Its columns are the same as those in ALL_ALL_TABLES. |
| DBA_TABLESPACES | Displays all tablespaces in the database. |
| DBA_TAB_COLS | Displays all columns of tables, views, and clusters in the database. |
| DBA_TAB_COLUMNS | Displays all columns of tables, views, and clusters in the database. |
| USER_ALL_TABLES | Displays the user's access to object tables and relationship tables. The columns in this view are the same as those in ALL_ALL_TABLES, except for the OWNER column. |
| USER_TABLES | Displays all tables owned by the user. |
| USER_TABLESPACES | Displays the tablespaces accessible to the user. The columns in this view are the same as those in DBA_TABLESPACES, with the PLUGGED_IN column removed. |
| USER_TAB_COLS | Displays all columns of tables, views, and clusters owned by the user. |
| USER_TAB_COLUMNS | Displays all columns of tables, views, and clusters owned by the user. |
| ALL_VIEWS | Displays the views accessible to the user. |
| DBA_VIEWS | Displays all views in the database. The columns in this view are the same as those in ALL_VIEWS. |
| USER_VIEWS | Displays the views owned by the user. |
| DICTIONARY | Displays the descriptions of data dictionary tables and views. |
| DICT | Displays the descriptions of data dictionary tables and views. |
| DBA_OB_TABLE_LOCATIONS | Displays the positions where tables or partitions are located, including system tables, user tables, and index tables. |
Outline
| View name | Description |
|---|---|
| DBA_OB_OUTLINES | Displays the outline information of execution plans for the current tenant. |
| DBA_OB_CONCURRENT_LIMIT_SQL | Displays the outline information of concurrency limit rules for the current tenant. |
| DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history information of execution plans and concurrency limit rules. |
SPM
| View | Description |
|---|---|
| DBA_SQL_PLAN_BASELINES | Displays the plan baselines of SQL statements in SPM. |
| DBA_SQL_MANAGEMENT_CONFIG | Displays the configuration parameters in SPM. |
Basic information about the database
| View name | Description |
|---|---|
| DBA_CONTEXT | Displays all context namespaces in the database. |
| DBA_OB_DATABASES | Displays metadata of tenant databases. |
| DBA_OB_MAJOR_COMPACTION | Displays global major compaction information of the tenant. |
| DBA_OB_ZONE_MAJOR_COMPACTION | Displays major compaction information of each zone of the tenant. |
| ALL_OBJECTS | Displays all database objects that the user can access. |
| DBA_OBJECTS | Displays all database objects. |
| USER_OBJECTS | Displays all database objects owned by the user. |
| ALL_DEPENDENCIES | Displays the dependencies among all objects in the database. |
| DBA_DEPENDENCIES | Displays all dependencies among objects in the database. |
| USER_DEPENDENCIES | Displays the dependencies among objects in the user's schema. |
| DBA_OB_FREEZE_INFO | Displays version information generated by major compactions (major_freeze). |
Functions and procedures
| View name | Description |
|---|---|
| ALL_ARGUMENTS | Displays the parameters of the functions and procedures that the current user can access. |
| ALL_PROCEDURES | Displays all the functions and procedures that the current user can access, along with their attributes. |
| ALL_SOURCE | Displays the text sources of stored objects that the current user can access. |
| DBA_ARGUMENTS | Displays the parameters of the functions and procedures available in the database. The columns are the same as those in the ALL_ARGUMENTS view. |
| DBA_PROCEDURES | Displays all the functions and procedures available in the database, along with their attributes. The columns are the same as those in the ALL_PROCEDURES view. |
| DBA_SOURCE | Displays the text sources of all stored objects in the database. The columns are the same as those in the ALL_SOURCE view. |
| USER_ARGUMENTS | Displays the parameters of the functions and procedures owned by the current user. The columns are the same as those in the ALL_ARGUMENTS view, except that the OWNER column is removed. |
| USER_PROCEDURES | Displays all the functions and procedures owned by the current user, along with their attributes. The columns are the same as those in the ALL_PROCEDURES view, except that the OWNER column is removed. |
| USER_SOURCE | Displays the text sources of the stored objects owned by the current user. The columns are the same as those in the ALL_SOURCE view, except that the OWNER column is removed. |
| DBA_JOBS | Displays a summary of the tasks that have been committed. |
| USER_JOBS | Displays a summary of the tasks that have been committed. |
| DBA_JOBS_RUNNING | Displays the running tasks. |
Backup and restore-related
| View name | Description |
|---|---|
| DBA_OB_BACKUP_JOBS | Displays the backup jobs of the current tenant. |
| DBA_OB_BACKUP_JOB_HISTORY | Displays the history records of the backup jobs of the current tenant. |
| DBA_OB_BACKUP_TASKS | Displays the backup tasks of the current tenant. |
| DBA_OB_BACKUP_TASK_HISTORY | Displays the history records of the backup tasks of the current tenant. |
| DBA_OB_BACKUP_SET_FILES | Displays the status of the files in backup sets. |
| DBA_OB_RESTORE_PROGRESS | Displays the ongoing restore tasks. |
| DBA_OB_RESTORE_HISTORY | Displays the completed restore tasks. |
| DBA_OB_ARCHIVE_DEST | Displays the configurations of archive paths. |
| DBA_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations used for backup and restore within the tenant. |
| DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information about backup destinations used for backup and restore within the tenant. |
| DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies for expired data and automatically cleared data within the tenant. |
| DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of the tenant-level backup cleanup jobs. |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history information of the backup cleanup jobs executed within the tenant. |
| DBA_OB_BACKUP_DELETE_TASKS | Displays the information about backup_set or backup_piece cleanup tasks being executed within the tenant. |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the historical information of backup_set or backup_piece cleanup tasks completed within the tenant. |
| DBA_OB_ARCHIVELOG | Displays the backup status of logs on each path. |
| DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all log backups in history and currently. |
| DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of pieces in backup sets. |
| DBA_OB_BACKUP_PARAMETER | Displays the backup parameters. |
| DBA_OB_RECOVER_TABLE_JOBS | Displays information about table-level restore jobs. |
| DBA_OB_IMPORT_TABLE_JOBS | Displays information about import jobs. |
| DBA_OB_IMPORT_TABLE_TASKS | Displays records of table-level import tasks. |
| DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of table-level restore jobs. |
| DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the results of import jobs. |
| DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the history records of cross-tenant table-level import tasks. |
Statistics and histograms
| View name | Description |
|---|---|
| ALL_PART_COL_STATISTICS | Displays the column statistics and histograms of the partitions of tables that the current user has access to. |
| ALL_PART_HISTOGRAMS | Displays the histograms of all partitions. |
| ALL_SUBPART_COL_STATISTICS | Displays the column statistics and histograms of the subpartitions of tables that the current user has access to. |
| ALL_SUBPART_HISTOGRAMS | Displays the histograms of all subpartitions. |
| ALL_TAB_COL_STATISTICS | Displays the column statistics and histograms of the tables that the current user has access to. |
| ALL_TAB_HISTOGRAMS | Displays the histograms of all tables. |
| ALL_TAB_STATISTICS | Displays the optimizer statistics of the tables that the current user has access to. |
| DBA_PART_COL_STATISTICS | Displays the column statistics and histograms of the partitions of all partitioned tables in the database. |
| DBA_PART_HISTOGRAMS | Displays the histograms of the partitions of all partitioned tables in the current database. |
| DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms of the subpartitions of all partitioned tables in the database. |
| DBA_SUBPART_HISTOGRAMS | Displays the histograms of the subpartitions of all partitioned tables in the current database. |
| DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms of all tables in the database. |
| DBA_TAB_HISTOGRAMS | Displays the histograms of all tables in the current database. |
| DBA_TAB_STATISTICS | Displays the optimizer statistics of all tables in the database. |
| USER_PART_COL_STATISTICS | Displays the column statistics and histograms of the partitions of partitioned tables that the current user has access to. |
| USER_PART_HISTOGRAMS | Displays the histograms of the partitions of partitioned tables that the current user has access to. |
| USER_SUBPART_COL_STATISTICS | Displays the column statistics and histograms of the subpartitions of partitioned tables that the current user has access to. |
| USER_SUBPART_HISTOGRAMS | Displays the histograms of the subpartitions of partitioned tables that the current user has access to. |
| USER_TAB_COL_STATISTICS | Displays the column statistics and histograms of the tables that the current user has access to. |
| USER_TAB_HISTOGRAMS | Displays the histograms of the tables that the current user has access to. |
| USER_TAB_STATISTICS | Displays the optimizer statistics of the tables that the current user has access to. |
| ALL_TAB_STATS_HISTORY | Displays the modification history of table statistics of all tables that the current user has access to. |
| DBA_TAB_STATS_HISTORY | Displays the modification history of table statistics of all tables in the database. |
| USER_TAB_STATS_HISTORY | Displays the modification history of table statistics of all tables that the current user owns. |
| ALL_IND_STATISTICS | Displays the optimizer statistics of the indexes of tables that the current user has access to. |
| DBA_IND_STATISTICS | Displays the optimizer statistics of all indexes in the database. |
| USER_IND_STATISTICS | Displays the optimizer statistics of the indexes of tables that the current user owns. |
| ALL_TAB_MODIFICATIONS | Displays the modification information of the tables that the current user has access to since the last time statistics were collected on these tables. |
| DBA_TAB_MODIFICATIONS | Displays the modification information of all tables in the database since the last time statistics were collected on these tables. |
| USER_TAB_MODIFICATIONS | Displays the modification information of the tables that the current user owns since the last time statistics were collected on these tables. |
Users and privileges
| View name | Description |
|---|---|
| ALL_USERS | Displays all database users visible to the current user. |
| DBA_USERS | Displays all users of the database. |
| USER_USERS | Displays information about the current user. |
| ALL_COL_PRIVS | Column object privileges of the current user on objects that the user owns, that the user grants privileges on, or that have privileges granted to the user. Column object privileges of enabled roles or of the PUBLIC role on objects are also displayed. |
| ALL_TAB_PRIVS | The current user owns the objects, grants privileges on the objects, or has privileges granted on the objects. The objects' privileges are granted to the PUBLIC role or the activated roles. |
| DBA_COL_PRIVS | Displays all column privileges granted in the database. |
| DBA_SYS_PRIVS | Displays the system privileges granted to users and roles. |
| DBA_TAB_PRIVS | Displays all object privileges granted in the database. |
| USER_TAB_PRIVS | Displays the object privileges of the current user. |
| USER_COL_PRIVS | Displays the column privileges of the current user on objects that the user owns, that the user grants privileges on, or that have privileges granted to the user. Column privileges of enabled roles or of the PUBLIC role on objects are also displayed. |
| USER_ROLE_PRIVS | Displays the roles granted to the current user. |
| USER_SYS_PRIVS | Displays the system privileges granted to the current user. |
| ROLE_TAB_PRIVS | Displays the table privileges of roles granted to the current user. Information about roles that the user cannot access is not provided. |
| ROLE_SYS_PRIVS | Displays the system privileges of roles granted to the current user. |
| ROLE_ROLE_PRIVS | Displays the roles that grant privileges to other roles. Information about roles that the user cannot access is not provided. |
| DBA_ROLE_PRIVS | Displays the roles granted to all users and the roles in the database. |
| DBA_ROLES | Displays all roles in the database. |
| ALL_DIRECTORIES | Displays all directories accessible to the current user. |
| DBA_DIRECTORIES | Displays all directories accessible to the current user. |
Views
| View | Description |
|---|---|
| ALL_CONSTRAINTS | Displays the constraints of all tables accessible to the user. |
| ALL_CONS_COLUMNS | Displays the columns of all constraints of all tables accessible to the user. |
| DBA_CONSTRAINTS | Displays the constraints of all tables in the database. |
| DBA_CONS_COLUMNS | Displays the columns of all constraints of all tables in the database. |
| USER_CONSTRAINTS | Displays the constraints of all tables owned by the user. |
| USER_CONS_COLUMNS | Displays the columns of all constraints of all tables owned by the user. |
Auditing
| View name | Description |
|---|---|
| ALL_DEF_AUDIT_OPTS | Displays the default audit conditions for any object. |
| AUDIT_ACTIONS | Displays the action IDs and their corresponding names in audit records. |
| DBA_AUDIT_EXISTS | Displays the audit trail entries generated by the AUDIT EXISTS and AUDIT NOT EXISTS statements. |
| DBA_AUDIT_OBJECT | Displays the audit trail records of all objects in the database. |
| DBA_AUDIT_SESSION | Displays the audit trail records of all CONNECT and DISCONNECT statements. |
| DBA_AUDIT_STATEMENT | Displays the audit trail records of GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements in the database. |
| DBA_AUDIT_TRAIL | Displays all audit trail entries. |
| DBA_OBJ_AUDIT_OPTS | Displays the details of object-level audit configurations. |
| DBA_STMT_AUDIT_OPTS | Displays the details of statement-level audit configurations. |
| STMT_AUDIT_OPTION_MAP | Displays the types, names, and priorities of statement-level audit options. |
| USER_AUDIT_OBJECT | Displays the audit trail records of objects that the current user can access. |
| USER_AUDIT_SESSION | Displays the audit trail records of connection and disconnection statements of the current user. |
| USER_AUDIT_STATEMENT | Displays the audit trail entries of GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements issued by the current user. |
| USER_AUDIT_TRAIL | Displays the standard audit trail entries related to the current user. |
Indexes
| View name | Description |
|---|---|
| ALL_INDEXES | Displays the index columns of all tables accessible to the user. |
| ALL_IND_COLUMNS | Displays the index columns of all tables accessible to the user. |
| ALL_IND_EXPRESSIONS | Displays the function-based indexes accessible to the user in the database. |
| ALL_IND_PARTITIONS | Displays the partitions of indexes accessible to the user in the database. |
| ALL_IND_SUBPARTITIONS | Displays the subpartitions of indexes accessible to the user in the database. |
| ALL_PART_INDEXES | Displays the partitions of partitioned indexes accessible to the user. |
| DBA_INDEXES | Displays the indexes of all tables in the database. |
| DBA_IND_COLUMNS | Displays the index columns of all tables in the database. |
| DBA_IND_EXPRESSIONS | Displays all function-based indexes in the database. |
| DBA_IND_PARTITIONS | Displays the partitions of all indexes in the database. |
| DBA_IND_SUBPARTITIONS | Displays the subpartitions of all indexes in the database. |
| USER_INDEXES | Displays the indexes of all tables owned by the user. |
| USER_IND_COLUMNS | Displays the index columns of all tables owned by the user. |
| USER_IND_EXPRESSIONS | Displays the function-based indexes owned by the user in the database. |
| USER_IND_PARTITIONS | Displays the partitions of indexes owned by the user in the database. The INDEX_OWNER column is not included in this view compared with the ALL_IND_PARTITIONS and DBA_IND_PARTITIONS views. |
| USER_IND_SUBPARTITIONS | Displays the subpartitions of indexes owned by the user in the database. The INDEX_OWNER column is not included in this view compared with the DBA_IND_SUBPARTITIONS and ALL_IND_SUBPARTITIONS views. |
| USER_PART_INDEXES | Displays the partitions of partitioned indexes accessible to the user. |
Partitioning
| View name | Description |
|---|---|
| ALL_PART_KEY_COLUMNS | Displays the columns that are part of the partitioning key of all partitioned objects that the user has access to. |
| ALL_PART_TABLES | Displays the partition information of partitioned tables that the user has access to. |
| ALL_SUBPART_TEMPLATES | Displays descriptions of all subpartition templates. |
| ALL_SUBPART_KEY_COLUMNS | Displays the columns that are part of the subpartitioning key of all partitioned objects that the user has access to. |
| ALL_TAB_PARTITIONS | Displays the multilevel partitioning information, storage parameters, and statistics of all partitioned tables. |
| ALL_TAB_SUBPARTITIONS | Displays the partition-level storage parameters and statistics generated by the DBMS_STATS package for each subpartition of the tables that the user has access to. |
| DBA_PART_INDEXES | Displays the partition information of all partitioned indexes in the database. |
| DBA_PART_KEY_COLUMNS | Displays the columns that are part of the partitioning key of all partitioned objects in the database. |
| DBA_PART_TABLES | Displays the partition information of partitioned tables that the user has access to. |
| DBA_SUBPART_TEMPLATES | Displays descriptions of all subpartition templates. |
| DBA_SUBPART_KEY_COLUMNS | Displays the columns that are part of the subpartitioning key of all partitioned objects in the database. |
| DBA_TAB_PARTITIONS | Displays the multilevel partitioning information, storage parameters, and statistics of partitioned tables that the user has access to. |
| DBA_TAB_SUBPARTITIONS | Displays the subpartition name, table name, partition name to which the subpartition belongs, storage attributes, and statistics generated by the DBMS_STATS package for each subpartition of the tables that the user has access to. |
| USER_PART_KEY_COLUMNS | Displays the columns that are part of the partitioning key of all partitioned objects that the user owns. |
| USER_PART_TABLES | Displays the partition information of partitioned tables that the user has access to. |
| USER_SUBPART_TEMPLATES | Displays descriptions of all subpartition templates. |
| USER_SUBPART_KEY_COLUMNS | Displays the columns that are part of the subpartitioning key of all partitioned objects that the user has access to. |
| USER_TAB_SUBPARTITIONS | Displays the subpartition name, table name, partition name to which the subpartition belongs, storage attributes, and statistics generated by the DBMS_STATS package for each subpartition of the tables that the user has access to. |
| USER_TAB_PARTITIONS | Displays the multilevel partitioning information, storage parameters, and statistics of partitioned tables that the user has access to. |
Sessions
| View Name | Function Description |
|---|---|
| DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlocks. This view displays the history of deadlocks in the current tenant if you query it in a non-root tenant. |
Sequences
| View Name | Function Description |
|---|---|
| ALL_SEQUENCES | Displays all sequences that the user has access to. |
| DBA_SEQUENCES | Displays all sequences in the database. |
| USER_SEQUENCES | Displays all sequences owned by the current user. |
| TENANT_VIRTUAL_GLOBAL_VARIABLE | Displays global variables. |
| TENANT_VIRTUAL_SESSION_VARIABLE | Displays session variables. |
Synonym
| View Name | Function Description |
|---|---|
| ALL_SYNONYMS | Displays all synonyms that the user has access to. |
| DBA_SYNONYMS | Displays all synonyms in the database. |
| USER_SYNONYMS | Displays all synonyms owned by the current user. |
Triggers
| View name | Description |
|---|---|
| ALL_TRIGGERS | Displays the triggers and descriptions of the tables on which the current user has privileges. If the current user has the CREATE ANY TRIGGER privilege, this view displays the descriptions of all triggers in the database. |
| DBA_TRIGGERS | Displays all triggers in the database. |
| USER_TRIGGERS | Displays the triggers of the current user. |
Recycle bin
| View name | Description |
|---|---|
| DBA_RECYCLEBIN | Displays information about the recycle bins in the database. |
| USER_RECYCLEBIN | Displays information about the recycle bin of the current user. The columns are the same as those in the DBA_RECYCLEBIN view, except that the OWNER column is removed. |
Resource groups
| View name | Description |
|---|---|
| DBA_RSRC_GROUP_MAPPINGS | Displays the mappings between users and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | Displays all resource groups in the database. |
| DBA_RSRC_PLANS | Displays all system-defined resource management plans. |
| DBA_RSRC_PLAN_DIRECTIVES | Displays the details of the resource plan directives for each resource group in the database. |
NLS
| View name | Description |
|---|---|
| NLS_DATABASE_PARAMETERS | Displays the NLS parameters at the database level (tenant level in OceanBase Database). |
| NLS_INSTANCE_PARAMETERS | Displays the NLS parameters at the instance level (tenant level). |
| NLS_SESSION_PARAMETERS | Displays the NLS parameters at the session level. |
User-defined types
| View name | Description |
|---|---|
| ALL_COLL_TYPES | Displays the user-defined collection types available in the database. The columns are the same as those in the DBA_COLL_TYPES view. |
| ALL_TYPES | Displays the user-defined types available in the database. |
| ALL_TYPE_ATTRS | Displays the attributes of the user-defined types available in the database. |
| DBA_COLL_TYPES | Displays the user-defined collection types available in the database. The columns are the same as those in the ALL_COLL_TYPES view. |
| DBA_TYPES | Displays the user-defined types available in the database. |
| DBA_TYPE_ATTRS | Displays the attributes of the user-defined types available in the database. |
| USER_COLL_TYPES | Displays the user-defined collection types available to the current user. |
| USER_TYPES | Displays the user-defined types of the current user. |
| USER_TYPE_ATTRS | Displays the attributes of the user-defined types available to the current user. |
Objects
| View name | Description |
|---|---|
| ALL_ERRORS | Displays errors on current storage objects that the user can access. |
| DBA_ERRORS | Displays errors on current storage objects in the database. |
| USER_ERRORS | Displays errors on current storage objects that the user can access. |
| DBA_SEGMENTS | Displays the storage information of all segments in the database. |
| USER_SEGMENTS | Displays the storage information of segments of objects under the user's account. |
Profiles
| View name | Description |
|---|---|
| ALL_PROFILES | Displays all profiles and their limitations. |
| DBA_PROFILES | Displays all profiles and their limitations. |
| USER_PROFILES | Displays all profiles and their limitations. |
Views related to replicas and logs
| View name | Description |
|---|---|
| DBA_OB_LS_LOCATIONS | Displays the distribution of log stream (LS) replicas in the current tenant. |
| DBA_OB_TABLEGROUPS | Displays the metadata of table groups, including their partition information. |
| DBA_OB_TABLEGROUP_PARTITIONS | Displays the partition information of partitions in table groups. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information of partitions in table groups. |
| DBA_OB_TABLET_REPLICAS | Displays 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>. |
| DBA_OB_TABLET_TO_LS | Displays the distribution of all tablets in the current tenant and the log stream to which each tablet belongs. |
| DBA_OB_LS | Displays the status and recovery progress of log streams. |
WR-related views
| View name | Description |
|---|---|
| DBA_WR_SNAPSHOT | Displays the SNAPSHOT information of the current tenant. |
| DBA_WR_ACTIVE_SESSION_HISTORY | Displays the ASH data of the current tenant after it is persisted. |
| DBA_WR_STATNAME | Displays the names of system statistics of the current tenant. |
| DBA_WR_SYSSTAT | Displays the details of system statistics of the current tenant. |
| DBA_WR_CONTROL | Displays the configuration information related to WR |
Load balancing-related views
| View name | Description |
|---|---|
| DBA_OB_TRANSFER_PARTITION_TASKS | Displays the transfer partition tasks being processed in the current tenant. |
| DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the history of transfer partition tasks executed in the current tenant. |
Scheduler
| View name | Description |
|---|---|
| DBA_SCHEDULER_JOBS | Displays the information of scheduled jobs accessible to the current user. |
| DBA_SCHEDULER_PROGRAM | Displays all scheduled programs in the database. |
| DBA_SCHEDULER_JOB_RUN_DETAILS | Displays the information of all scheduled jobs in the current tenant. |
DBLINK-related views
| View name | Description |
|---|---|
| ALL_DB_LINKS | Displays all DBLINKs that the current user has access to. |
| DBA_DB_LINKS | Displays all DBLINKs that have been created in the current tenant. |
| USER_DB_LINKS | Displays the DBLINKs that have been created by the current user. |
Unsupported views
| View | Description |
|---|---|
| ALL_METHOD_PARAMS | Displays the method parameters of objects that a user can access. |
| ALL_SCHEDULER_JOB_ARGS | Displays the parameters of scheduled jobs that a user can query. |
| ALL_SCHEDULER_PROGRAM_ARGS | Displays the parameters of schedulers that a user can query. |
| ALL_TYPE_METHODS | Displays the methods of objects that a user can access. |
| DBA_METHOD_PARAMS | Displays the method parameters of objects in a database. |
| DBA_SCHEDULER_JOB_ARGS | Displays the parameters of scheduled jobs in a database. |
| USER_SCHEDULER_JOB_ARGS | Displays the parameters of scheduled jobs that the current user owns. |
| DBA_SCHEDULER_PROGRAM_ARGS | Displays the parameters of schedulers in a database. |
| USER_SCHEDULER_PROGRAM_ARGS | Displays the parameters of schedulers that the current user owns. |
| DBA_TYPE_METHODS | Displays the methods of objects in a database. |
| USER_TYPE_METHODS | Displays the methods of objects that a user can access. The description of the columns is the same as that of ALL_TYPE_METHODS, but the OWNER column is not included. |
Overview of the performance view
Statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameter information on all OBServer nodes within the tenant. |
| 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 resides. The sys 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 global context attributes accessible to the current session. |
| V$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameters on the OBServer node where you are located. |
| V$SYSSTAT | Displays the system-level statistical events on the current server. |
| V$OB_UNITS | Displays the units on the OBServer node where you are located. |
| V$VERSION | Displays the names and versions of all components of the database product. |
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
| View name | Description |
|---|---|
| GV$OB_MEMORY | Displays the memory usage of each tenant on all servers. |
| GV$OB_MEMSTORE | Displays the memory usage of MemTables of all tenants on all servers. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Provides information about the SQL Workarea, including the maximum available memory, the current memory usage, and the memory occupied by held data. |
| GV$OB_SSTABLES | Displays the SSTable information of tenants. |
| GV$OB_MEMSTORE_INFO | Displays the details of MemTables of all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | Displays the details of MemTables of all partitions of all tenants on all servers. |
| V$OB_MEMORY | Displays the memory statistics of tenants. |
| V$OB_MEMSTORE | Displays the memory usage of MemTables of all tenants on the current server. |
| V$OB_SSTABLES | Displays the SSTable information of tenants. |
| 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. |
Cache-related
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache of all servers. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Records the status of each cached object in the plan caches of all servers in the current tenant. |
| GV$OB_PLAN_CACHE_STAT | Records the overall status of each plan cache on all servers in the current tenant. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache of the current server. |
| V$OB_PLAN_CACHE_PLAN_STAT | Records the status of each cached object in the plan cache on the current server in the current tenant. |
| V$OB_PLAN_CACHE_STAT | Records the overall status of each plan cache on all servers in the current tenant. |
| V$RSRC_PLAN | Displays the resource management plans of the current active tenant. |
Log-related
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | Displays the status of palfs. |
| V$OB_LOG_STAT | Displays the status of palfs. |
Monitoring information
| View name | Description |
|---|---|
| GV$OB_PX_TARGET_MONITOR | Displays the usage of PX threads on all OBServer nodes. |
| GV$OB_PS_ITEM_INFO | Provides monitoring functionality for prepared statements and displays basic information about all prepared statements in the PS cache. |
| GV$OB_PS_STAT | Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items. |
| 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. |
| V$OB_PX_TARGET_MONITOR | Displays the usage of PX threads on OBServer nodes. |
| V$OB_PS_ITEM_INFO | Provides monitoring functionality for prepared statements and displays basic information about all prepared statements in the PS cache. |
| V$OB_PS_STAT | Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items. |
| V$SQL_MONITOR_STATNAME | Displays the meanings of the numbers in the OTHERSTAT_X_ID column of the GV$SQL_PLAN_MONITOR view. |
Session-related views
| View name | Description |
|---|---|
| GV$OB_PROCESSLIST | Displays the session information of all OBServer nodes to which the tenant belongs. |
| GV$SESSION_WAIT | Displays information about the current or last wait event of all sessions on all servers, including the wait event name and the duration of the wait. |
| GV$SESSION_WAIT_HISTORY | Displays information about the last 10 wait events of all sessions on all servers. |
| GV$SESSTAT | Displays session-level statistics on all servers. |
| GV$ACTIVE_SESSION_HISTORY | Displays the ASH. |
| V$ACTIVE_SESSION_HISTORY | Displays the ASH. |
| V$NLS_PARAMETERS | Displays the NLS parameters at the session level. |
| V$OB_PROCESSLIST | Displays the session information of the current OBServer node. |
| V$SESSION_WAIT | Displays information about the current or last wait event of all sessions on the current server, including the wait event name and the duration of the wait. |
| V$SESSION_WAIT_HISTORY | Displays information about the last 10 wait events of all sessions on the current server. |
| V$SESSTAT | Displays session-level statistics. |
| V$EVENT_NAME | Displays the definitions of various events in the tenant. |
System variable-related views
SQL-related statistics
| View name | Description |
|---|---|
| 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 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. |
| GV$OB_FLT_TRACE_CONFIG | Displays diagnostic information for full-link tracing. |
Threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | In a parallel execution scenario, view the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In a parallel execution scenario, view the execution information of each thread. |
Workarea
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | Statistics of all operators whose memory is managed by SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | Information about the workareas of active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Statistics of all workareas. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Provides some information about SQL workareas, including the maximum available memory, the current memory usage, and the current held memory. |
| V$SQL_WORKAREA | Statistics of all operators whose memory is managed by SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | Information about the workareas of active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Statistics of all workareas. |
Transaction-related
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the major compaction progress information of the current tenant on OBServer nodes. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays suggestions for major compactions. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of major compactions. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the history 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$SYSTEM_EVENT | Displays the tenant-level system wait events on all servers, and statistics on the number of occurrences, total wait time, and number of timeouts for each event type. |
| GV$GLOBAL_TRANSACTION | Displays information about the active global transactions. |
| V$OB_COMPACTION_PROGRESS | Displays the major compaction progress information of the current tenant on OBServer nodes. |
| V$OB_COMPACTION_SUGGESTIONS | Displays suggestions for major compactions. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of major compactions. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the history 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$SYSTEM_EVENT | Displays the tenant-level system wait events on the current server, and statistics on the number of occurrences, total wait time, and number of timeouts for each event type. |
| V$GLOBAL_TRANSACTION | Displays information about the active global transactions. |
| GV$OB_GLOBAL_TRANSACTION | Displays information about all XA transactions in the cluster. |
| V$OB_GLOBAL_TRANSACTION | Displays information about all XA transactions that are initiated by the current node. |
Time zones
| View name | Description |
|---|---|
| V$TIMEZONE_NAMES | Displays the names of effective time zones. |
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. |
DBLINK
| View name | Description |
|---|---|
| GV$DBLINK | Displays all database links (IN_TRANSACTION=YES) opened after the query session on this view is started. These database links must be committed or rolled back before they are closed. |
| V$DBLINK | Displays all database links (IN_TRANSACTION=YES) opened after the query session on this view is started. These database links must be committed or rolled back before they are closed. |