Overview of views in the SYS tenant
Dictionary views overview
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 of all tenants in the sys tenant. Tables not in a table group are not displayed. |
| oceanbase.CDB_TAB_COLS | Displays the column information of all tables and views of all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | Displays the column information of all 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 concurrency limit rules for the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history of execution plans and concurrency limit rules for the current tenant. |
Basic information about the database
| 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 databases in the current tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the global major compaction information in the current tenant. |
| oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY | Displays the event history of the Root Service. |
| oceanbase.DBA_OB_SERVER_JOBS | Displays the tasks on all OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | Displays information about all OBServer nodes. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays the major compaction information of all zones in the current tenant. |
| oceanbase.DBA_OB_ZONES | Displays information about 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). |
Partitioning
| 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, subpartition, storage parameters, and statistics of accessible multi-level partitioned tables of the current user. |
| 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 using the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays descriptions of all subpartition templates. |
Session-related views
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | Displays the history records of deadlocks. This view displays the history records of all tenants in the root tenant. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history records of deadlocks. This view displays the history records of the current tenant in a non-root tenant. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | Displays the event history information of OBServer nodes. |
Views related to backup and restore
| View name | Description |
|---|---|
| oceanbase.CDB_OB_RESTORE_PROGRESS | Displays the 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 history of backup jobs of all tenants in the cluster. |
| oceanbase.CDB_OB_BACKUP_TASKS | Displays the backup tasks of all tenants in the cluster. A backup task record is generated for each backup set. A backup task record corresponds to a backup job record on a one-to-one basis. |
| oceanbase.CDB_OB_BACKUP_TASK_HISTORY | Displays the history of 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 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 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 progress of tenant-level backup deletion jobs. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of completed backup deletion jobs in the current tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | Displays the information about backup set or piece deletion tasks that are being executed in the current tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of completed backup set or piece deletion tasks in the current tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_POLICY | Displays the deletion policies set for expired data deletion and automatic data deletion in the current tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations used for backup and restore in the current tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations used for backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations used for backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations used for backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the deletion policies set for expired data deletion and automatic data deletion in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | Displays the progress of tenant-level backup deletion jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of completed backup deletion jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays the information about backup set or piece deletion tasks that are being executed in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of completed backup set or piece deletion tasks in the current tenant. |
| 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 in history and currently. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of pieces in backup sets. |
| oceanbase.CDB_OB_ARCHIVELOG | Displays the status of log archiving for each archive path. |
| oceanbase.CDB_OB_ARCHIVELOG_SUMMARY | Displays the status of all log archivings in history and currently. |
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 histograms for all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays column statistics and histograms for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays column statistics and histograms for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays histograms for all columns in all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays histogram endpoint data for all partitions of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays histogram endpoint data for all subpartitions of 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 the 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 database. 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 filter the tenants by TENANT_TYPE. |
| oceanbase.DBA_OB_TENANT_JOBS | Displays information about tenant-level scheduled 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 information about all resource pools of tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | Displays information about all UNIT-related tasks. |
| oceanbase.DBA_OB_UNITS | Displays information about all units of tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | Displays the specifications of all units of tenants. |
| 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 of log stream (LS) replicas for all tenants. |
| oceanbase.CDB_OB_TABLEGROUPS | Displays the metadata of all table groups in the sys tenant, including the partition information of the table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | Displays the primary partitions of all partitioned table groups in the sys tenant. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartitions of all partitioned table groups in the sys tenant. |
| oceanbase.CDB_OB_TABLET_TO_LS | Displays the tables and the LS to which each tablet belongs 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 the composite key: <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.CDB_PART_KEY_COLUMNS | Displays the primary 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, including the partition information of the table groups. |
| oceanbase.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>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays the tables and the LS to which each tablet belongs in the current tenant. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution 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. |
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 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 participant information of all OBServer nodes. |
| GV$SESSION_EVENT | Displays the wait events of sessions on all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | Displays the name and duration of the current or last wait event of all sessions on all servers. |
| GV$SESSION_WAIT_HISTORY | Displays the names and durations of the last 10 wait events of all sessions 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 on all servers. |
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| 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 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 participant information of 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 last 10 wait events of each session. |
| V$SESSTAT | Displays the statistical events of sessions. |
| V$SYSSTAT | Displays the tenant-level statistical events on the current server. |
| V$SYSTEM_EVENT | Displays the tenant-level wait events. |
| GV$SESSION_LONGOPS | Displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | Displays the execution status and progress of DDL operations on the current OBServer node. |
Monitoring-related statistics
| View name | Description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
I/O-related statistics
| View name | Description |
|---|---|
| GV$OB_IO_CALIBRATION_STATUS | Displays the execution status of I/O calibration tasks. |
| V$OB_IO_CALIBRATION_STATUS | Displays the execution status of I/O calibration tasks. |
| GV$OB_IO_BENCHMARK | Displays the calibration data of disks used by the I/O module. |
| V$OB_IO_BENCHMARK | Displays the calibration data of disks used by the I/O module. |
Cache-related statistics
| View name | Description |
|---|---|
| GV$OB_MEMORY | Displays memory statistics at the tenant level. |
| V$OB_MEMORY | Displays memory statistics at the tenant level. |
| GV$OB_MEMSTORE | Displays the memory usage of MemTables on all servers and 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 a 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 plan caches on all servers. |
| 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 rate, memory usage, and number of items in the cache. |
| V$OB_PS_STAT | Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache. |
| 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 OBServer nodes. |
| 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. Each operation has a statistics record. |
| V$SQL_MONITOR_STATNAME | Describes the meanings of numbers in the OTHERSTAT_X_ID field of the GV$SQL_PLAN_MONITOR view. |
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 | Displays the statistics of outgoing RPCs on all OBServer nodes. |
| GV$OB_RPC_INCOMING | Displays the statistics of RPC requests received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | Statistics of outgoing RPC data on different tenants of different RPC packet codes on OBServer nodes. |
| V$OB_RPC_INCOMING | Statistics of incoming RPC data on different tenants of different RPC packet codes on OBServer nodes. |
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 information about all OBServer nodes. |
| GV$OB_UNITS | Displays the unit information on the OBServer node where the tenant resides. You will see the unit information on all OBServer nodes in the cluster if you are using the sys tenant. |
| 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 information about the current OBServer node. |
| 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 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. |
Workarea-related statistics
| 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, 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 | Queries overall statistics of SQL workareas, such as the maximum available memory, the current memory usage, and the memory held. |
| 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, 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 | Queries overall statistics 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 | The latch information of all OBServer nodes in the cluster. |
| V$LATCH | The latch information of all OBServer nodes in the cluster. |
Overview of views in a MySQL tenant
Dictionary views overview
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 privileges (VIRTUAL_TABLE). |
| mysql.user | Records user-level privileges (VIRTUAL_TABLE). |
| information_schema.COLUMN_PRIVILEGES | Displays column privileges. |
| information_schema.SCHEMA_PRIVILEGES | Describes database privileges. |
| information_schema.TABLE_PRIVILEGES | Records table privileges. |
| information_schema.USER_PRIVILEGES | Records user privileges. |
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 | Provides information about 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 collation methods for each character set. |
| information_schema.COLLATION_CHARACTER_SET_APPLICABILITY | Records the correspondences between character sets and collations. |
Tables and columns
| View name | Description |
|---|---|
| information_schema.COLUMNS | Records information about columns. |
| information_schema.STATISTICS | Records information about indexes of tables. |
| information_schema.TABLES | Records information about tables. |
| information_schema.VIEWS | Records information about views. |
| information_schema.VIEW_TABLE_USAGE | Displays information about tables and views used in view definitions. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the relationship between table groups and tables. Tables not belonging to any table group are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the columns that are part of the partitioning key in all partitioned objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays the columns that are part of the subpartitioning key in 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 of concurrency limit rules for the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history information of execution plans and concurrency limit rules outlines for the current tenant. |
Basic information about the database
| View name | Description |
|---|---|
| information_schema.GLOBAL_STATUS | Records the global status information of OceanBase Database. |
| information_schema.GLOBAL_VARIABLES | Records the global variables. |
| information_schema.SCHEMATA | Records the metadata of the database. |
| oceanbase.DBA_OB_DATABASES | Displays the metadata of the tenant's databases. |
| 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 related 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 each zone of the tenant. |
| oceanbase.DBA_OB_ZONES | Displays the information of all zones. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major compactions (major_freeze). |
Partition-related views
| View name | Description |
|---|---|
| information_schema.PARTITIONS | Records information about partitions. |
| oceanbase.DBA_IND_PARTITIONS | Displays information about the partitions and subpartitions of indexes. |
| oceanbase.DBA_PART_INDEXES | Displays information about all partitions of indexes. |
| oceanbase.DBA_PART_TABLES | Displays partition information of user tables. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the multi-partition information, storage parameters, and statistics of partitions that the current user has access to. |
| oceanbase.DBA_TAB_SUBPARTITIONS | Displays the names of subpartitions, the names of tables to which the subpartitions belong, and the names of the partitions to which the subpartitions belong. It also displays the storage attributes of subpartitions and the statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays descriptions of all subpartition templates. |
Threads
| View name | Description |
|---|---|
| information_schema.PROCESSLIST | Provides information about running threads. |
Constraints
| 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 table constraints. |
Session-related views
| View name | Description |
|---|---|
| information_schema.SESSION_STATUS | Records the status information of sessions, such as the number of current 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 a non-root tenant. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | Displays the event history information of OBServer nodes. |
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 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 configurations of archive paths. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information about backup destinations used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies, such as automatic and expiration cleanup, set for the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of the tenant-level backup cleanup jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history information of the backup cleanup jobs executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays the information about backup_set or backup_piece cleanup tasks being executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the historical information about backup_set or backup_piece cleanup 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 in history and currently. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of pieces in backup sets. |
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 histograms for all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays column statistics and histograms for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays column statistics and histograms 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 the endpoint data of histograms for all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays the endpoint data of histograms for all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the 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. |
| information_schema.QUERY_RESPONSE_TIME | Displays data types (Histogram) such as the response time histogram for Prometheus monitoring. |
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 created by users, and meta tenants. You can filter the tenants by type using the TENANT_TYPE column. |
| oceanbase.DBA_OB_TENANT_JOBS | Displays information about tenant-level scheduled jobs. |
Resource-related
| View name | Description |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | Displays information about all resource pools of all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | Displays information about all UNIT-related tasks. |
| oceanbase.DBA_OB_UNITS | Displays information about all units of all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | Displays the specifications of all units of all tenants. |
| 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 the primary partitions of table groups. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartitions of table groups. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the metadata of table groups, including the partition information of table groups. |
| 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 the tablets and the log streams to which they belong in the tenant. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution of log stream (LS) replicas in the tenant. |
Overview of the performance view
Event-related statistics
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the major compaction progress information of each tenant on OBServer nodes. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays suggestions for major compactions. |
| GV$OB_PROCESSLIST | Displays the session information on all OBServer nodes of a tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the diagnostic information of major compactions. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the historical information of tablet-level major compactions. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress information of tablet-level major compactions. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays the transaction participants on all OBServer nodes. |
| GV$SESSION_EVENT | Displays the wait events of all sessions on 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 last 10 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 statistics of wait events at the session level on all OBServer nodes. |
| GV$SYSSTAT | Displays the statistics of wait events at the tenant level on all servers. |
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$OB_COMPACTION_PROGRESS | Displays the major compaction progress information of each tenant on OBServer nodes. |
| V$OB_COMPACTION_SUGGESTIONS | Displays suggestions for major compactions. |
| V$OB_PROCESSLIST | Displays the session information on 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 definitions of all statistics events. |
| V$EVENT_NAME | Displays definitions of all statistics events on the current OBServer node. |
| V$SESSION_WAIT | Displays details of the current wait event for 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 details of the current wait event for each session and the last 10 wait events. |
| V$SESSTAT | Displays the statistics of wait events at the session level. |
| V$SYSSTAT | Displays the statistics of wait events at the tenant level on the current server. |
| V$SYSTEM_EVENT | Displays the tenant-level wait events. |
| GV$SESSION_LONGOPS | Displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | Displays the execution status and progress of DDL operations on the current OBServer node. |
Monitoring-related statistics
| View name | Description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
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 tenants. |
| V$OB_MEMSTORE | Displays the statistics of MemStores at the tenant level. |
| GV$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all servers. |
| GV$OB_SSTABLES | Displays the information about SSTables of a tenant. |
| V$OB_SSTABLES | Displays the information about SSTables of a tenant. |
| GV$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the current observer process. |
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' plan caches. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan cache on the current server. |
| GV$OB_PS_STAT | Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache. |
| V$OB_PS_STAT | Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache. |
| GV$OB_PS_ITEM_INFO | Provides monitoring functionality for prepared statements and contains basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Provides monitoring functionality for prepared statements and 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 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. Each slow query has a corresponding statistic record, and the trace information of the plan is recorded. |
| V$SQL_PLAN_MONITOR | Displays the operation-level statistics of slow queries. Each operation has a corresponding statistic record. |
| V$SQL_MONITOR_STATNAME | Describes the meaning of numbers in the OTHERSTAT_X_ID field of the GV$SQL_PLAN_MONITOR view. |
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 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 sent by all tenants on the OBServer node for different RPC packet codes. |
| V$OB_RPC_INCOMING | Statistics on RPC data received by different tenants on the 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 within the tenant. |
| 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. System tenant users 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 related to minor compactions
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | Displays statistics on minor compactions completed in the OceanBase cluster. |
| V$OB_MERGE_INFO | Displays statistics on minor compactions completed in the OceanBase cluster. |
Statistics related to threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | Displays the execution information of each thread in parallel execution scenarios. |
| V$OB_PX_WORKER_STAT | Displays the execution information of each thread in parallel execution scenarios. |
Workarea-related statistics
| 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, 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 | Queries overall statistics of SQL workareas, such as 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, 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 | Queries overall statistics of SQL workareas, 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 | The latch information of all OBServer nodes in the cluster. |
| V$LATCH | The latch information of all OBServer nodes in the cluster. |
Overview of views in an Oracle tenant
Overview
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Tables and views
| View name | Description |
|---|---|
| ALL_ALL_TABLES | Displays the object tables and relational tables that the user has access to. |
| ALL_COL_COMMENTS | Displays the comments on all columns of the views and tables that the user has access to. |
| ALL_TABLES | Displays all tables that the user has access to. |
| ALL_TAB_COLS | Displays all columns of the tables, views, and clusters that the user has access to. |
| ALL_TAB_COLUMNS | Displays all columns of the tables, views, and clusters that the user has access to. |
| ALL_TAB_COMMENTS | Displays the comments on the tables and views that the user has access to. |
| DBA_COL_COMMENTS | Displays the comments on all columns of all views and tables in the database. |
| DBA_TAB_COMMENTS | Displays the comments on all tables and views in the database. |
| USER_COL_COMMENTS | Displays the comments on all columns of the views and tables that the user owns. |
| USER_TAB_COMMENTS | Displays the comments on the tables and views that the user owns. |
| 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 relational tables in the database. The fields are the same as those in ALL_ALL_TABLES. |
| DBA_TABLESPACES | Displays all tablespaces in the database. |
| DBA_TAB_COLS | Displays all columns of all tables, views, and clusters in the database. |
| DBA_TAB_COLUMNS | Displays all columns of all tables, views, and clusters in the database. |
| USER_ALL_TABLES | Displays the object tables and relational tables that the user has access to, except the OWNER field. The other fields are the same as those in ALL_ALL_TABLES. |
| USER_TABLES | Displays all tables that the user owns. |
| USER_TABLESPACES | Displays the tablespaces that the user can access. The columns are the same as those in DBA_TABLESPACES, with the PLUGGED_IN column removed. |
| USER_TAB_COLS | Displays all columns of the tables, views, and clusters that the user owns. |
| USER_TAB_COLUMNS | Displays all columns of the tables, views, and clusters that the user owns. |
| ALL_VIEWS | Displays the views that the user has access to. |
| DBA_VIEWS | Displays all views in the database. The columns are the same as those in ALL_VIEWS. |
| USER_VIEWS | Displays the views that the user owns. |
| DICTIONARY | Displays the descriptions of dictionary tables and views. |
| DICT | Displays the descriptions of dictionary tables and views. |
| DBA_OB_TABLE_LOCATIONS | Displays the locations of tables or partitions, including system tables, user tables, and index tables. |
Outline
| View name | Description |
|---|---|
| DBA_OB_OUTLINES | Displays the outline information of execution plans in the current tenant. |
| DBA_OB_CONCURRENT_LIMIT_SQL | Displays the outline-related information of throttling rules in the current tenant. |
| DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the outline information of execution plans and throttling rules in the current tenant. |
SPM
| View name | Description |
|---|---|
| DBA_SQL_PLAN_BASELINES | Displays the plan baselines of SQL statements in SPM. |
| DBA_SQL_MANAGEMENT_CONFIG | Displays the configuration parameters in SPM. |
Database information
| View name | Description |
|---|---|
| DBA_CONTEXT | Displays information about all context namespaces in the database. |
| DBA_OB_DATABASES | Displays metadata about the databases of the tenant. |
| DBA_OB_MAJOR_COMPACTION | Displays global information about major compactions in the tenant. |
| DBA_OB_ZONE_MAJOR_COMPACTION | Displays information about major compactions in each zone of the tenant. |
| ALL_OBJECTS | Displays all database objects that the user has access to. |
| DBA_OBJECTS | Displays all database objects in the database. |
| 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 related attributes. |
| ALL_SOURCE | Displays the text source code of the storage 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 related attributes. The columns are the same as those in the ALL_PROCEDURES view. |
| DBA_SOURCE | Displays the text source code of all the storage 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 that the current user owns. The columns are the same as those in the ALL_ARGUMENTS view, excluding the OWNER column. |
| USER_PROCEDURES | Displays all the functions and procedures that the current user owns, along with their related attributes. The columns are the same as those in the ALL_PROCEDURES view, excluding the OWNER column. |
| USER_SOURCE | Displays the text source code of the storage objects that the current user owns. The columns are the same as those in the ALL_SOURCE view, excluding the OWNER column. |
| 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 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 in the current tenant. |
| DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the historical information about backup destinations used for backup and restore in the current tenant. |
| DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies set for automatic or periodic cleanup of expired data in the current tenant. |
| DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of the backup cleanup jobs at the tenant level. |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history information of the backup cleanup jobs executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASKS | Displays the information about backup_set or backup_piece cleanup tasks being executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history information of the backup_set or backup_piece cleanup tasks completed in the current 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. |
Statistics and histograms
| View name | Description |
|---|---|
| ALL_PART_COL_STATISTICS | Displays the column statistics and histogram information of the partitions of the tables that the current user has access to. |
| ALL_PART_HISTOGRAMS | Displays the histogram information of all partitions. |
| ALL_SUBPART_COL_STATISTICS | Displays the column statistics and histogram information of the subpartitions of the tables that the current user has access to. |
| ALL_SUBPART_HISTOGRAMS | Displays the histogram information of all subpartitions. |
| ALL_TAB_COL_STATISTICS | Displays the column statistics and histogram information of the tables that the current user has access to. |
| ALL_TAB_HISTOGRAMS | Displays the histogram information 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 histogram information of the partitions of the tables in the database. |
| DBA_PART_HISTOGRAMS | Displays the histogram information of the partitions of the tables in the current database. |
| DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histogram information of the subpartitions of the tables in the database. |
| DBA_SUBPART_HISTOGRAMS | Displays the histogram information of the subpartitions of the tables in the current database. |
| DBA_TAB_COL_STATISTICS | Displays the column statistics and histogram information of all tables in the database. |
| DBA_TAB_HISTOGRAMS | Displays the histogram information 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 histogram information of the partitions of the tables that the current user owns. |
| USER_PART_HISTOGRAMS | Displays the histogram information of the partitions of the tables that the current user owns. |
| USER_SUBPART_COL_STATISTICS | Displays the column statistics and histogram information of the subpartitions of the tables that the current user owns. |
| USER_SUBPART_HISTOGRAMS | Displays the histogram information of the subpartitions of the tables that the current user owns. |
| USER_TAB_COL_STATISTICS | Displays the column statistics and histogram information of the tables that the current user owns. |
| USER_TAB_HISTOGRAMS | Displays the histogram information of the tables that the current user owns. |
| USER_TAB_STATISTICS | Displays the optimizer statistics of the tables that the current user owns. |
| ALL_TAB_STATS_HISTORY | Displays the modification history of the statistics of all tables that the current user has access to. |
| DBA_TAB_STATS_HISTORY | Displays the modification history of the statistics of all tables in the database. |
| USER_TAB_STATS_HISTORY | Displays the modification history of the statistics of all tables that the current user owns. |
| ALL_IND_STATISTICS | Displays the optimizer statistics of the indexes of the 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 the 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. |
| ALL_COL_PRIVS | *Displays the column privileges of the current user on objects that the user owns, has been granted privileges on, or has granted privileges on. * Column privileges on objects that have been granted to the PUBLIC role are also displayed. |
| ALL_TAB_PRIVS | *Displays the object privileges of the current user on objects that the user owns, has been granted privileges on, or has been granted privileges on. * Object privileges on objects that have been granted to the PUBLIC role are also displayed. |
| 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 on objects that the user owns or has been granted privileges on. |
| USER_COL_PRIVS | Displays the column privileges of the current user on objects that the user owns, has been granted privileges on, or has granted privileges on. |
| 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. Only information about roles accessible to the user is 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. Only information about roles accessible to the user is 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 name | 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 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 configurations. |
| USER_AUDIT_OBJECT | Displays the audit trail records of objects that the current user has access to. |
| USER_AUDIT_SESSION | Displays the audit trail records of connections and disconnections 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 that the user can access. |
| ALL_IND_COLUMNS | Displays the index columns of all tables that the user can access. |
| ALL_IND_EXPRESSIONS | Displays the function-based indexes that the user can access in the database. |
| ALL_IND_PARTITIONS | Displays the partitions of indexes that the user can access in the database. |
| ALL_IND_SUBPARTITIONS | Displays the subpartitions of indexes that the user can access in the database. |
| ALL_PART_INDEXES | Displays the partitions of partitioned indexes that the user can access. |
| 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 indexes in the database. |
| DBA_IND_SUBPARTITIONS | Displays the subpartitions of 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. This view does not contain the INDEX_OWNER column, which is included in the ALL_IND_PARTITIONS and DBA_IND_PARTITIONS views. |
| USER_IND_SUBPARTITIONS | Displays the subpartitions of indexes owned by the user in the database. This view does not contain the INDEX_OWNER column, which is included in the DBA_IND_SUBPARTITIONS and ALL_IND_SUBPARTITIONS views. |
| USER_PART_INDEXES | Displays the partitions of partitioned indexes that the user can access. |
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 details, storage parameters, and statistics generated by the DBMS_STATS package for the partitions of the tables that the user has access to. |
| DBA_PART_INDEXES | Displays the partitions of all 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 the 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. |
| 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 owns. |
| 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 owns. |
| 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 table that the user owns. |
| USER_TAB_PARTITIONS | Displays the multilevel partitioning information, storage parameters, and statistics of the tables that the user owns. |
Session-related views
| View name | Description |
|---|---|
| DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlocks. This view displays the deadlocks that occurred in the current tenant in a non-root tenant. |
Sequence-related views
| View name | Description |
|---|---|
| ALL_SEQUENCES | Displays all sequences accessible to the user. |
| DBA_SEQUENCES | Displays all sequences in the database. |
| USER_SEQUENCES | Displays all sequences owned by the current user. |
| TENANT_VIRTUAL_GLOBAL_VARIABLE | Displays the information of global variables. |
| TENANT_VIRTUAL_SESSION_VARIABLE | Displays the variables of the session. |
Synonym views
| View name | Description |
|---|---|
| ALL_SYNONYMS | Displays all synonyms accessible to the user. |
| DBA_SYNONYMS | Displays all synonyms in the database. |
| USER_SYNONYMS | Displays the synonyms owned by the current user. |
Trigger views
| 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 owned by the current user. |
Recycle bin
| View name | Description |
|---|---|
| DBA_RECYCLEBIN | Displays information about all recycle bins in the database. |
| USER_RECYCLEBIN | Displays information about the recycle bins owned by the current user. The columns are the same as those in DBA_RECYCLEBIN, 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 information about all resource groups in the database. |
| DBA_RSRC_PLANS | Displays all system-defined resource management plans. |
| DBA_RSRC_PLAN_DIRECTIVES | Displays the details of 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 attribute information 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 attribute information 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 attribute information of the user-defined types available to the current user. |
Objects
| View name | Description |
|---|---|
| ALL_ERRORS | Displays errors for the storage objects that the user can access. |
| DBA_ERRORS | Displays errors for the storage objects in the database. |
| USER_ERRORS | Displays errors for the 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 the segments of the objects under the user's account. |
Profile
| View name | Description |
|---|---|
| ALL_PROFILES | Displays all profiles and the limitations of these profiles. |
| DBA_PROFILES | Displays all profiles and the limitations of these profiles. |
| USER_PROFILES | Displays all profiles and the limitations of these profiles. |
Views related to replicas and logs
| View name | Description |
|---|---|
| DBA_OB_LS_LOCATIONS | Displays the distribution of log stream (LS) replicas in the tenant. |
| DBA_OB_TABLEGROUPS | Displays the metadata of table groups, including the partition information of table groups. |
| DBA_OB_TABLEGROUP_PARTITIONS | Displays the partition information of partitions in a table group. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartition information of subpartitions in a table group. |
| 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>. |
| DBA_OB_TABLET_TO_LS | Displays the list of all tablets in the tenant and the log stream to which each tablet belongs. |
| DBA_OB_LS | Displays the status and recovery progress of log streams. |
Schedulers
| View name | Description |
|---|---|
| DBA_SCHEDULER_JOBS | Displays information about the scheduler jobs that the current user has access to. |
| DBA_SCHEDULER_PROGRAM | Displays information about all schedulers in the database. |
DBLINKs
| View name | Description |
|---|---|
| ALL_DB_LINKS | Displays all DBLINKs that the current user has access to. |
| DBA_DB_LINKS | Displays all DBLINKs created in the current tenant. |
| USER_DB_LINKS | Displays the DBLINKs created by the current user. |
Not supported views
| View name | Description |
|---|---|
| ALL_METHOD_PARAMS | Displays the method parameters of objects that the user has access to. |
| ALL_SCHEDULER_JOB_ARGS | Displays the parameters of scheduled jobs that the user has access to. |
| ALL_SCHEDULER_PROGRAM_ARGS | Displays the parameters of schedulers that the user has access to. |
| ALL_TYPE_METHODS | Displays the methods of objects that the user has access to. |
| DBA_METHOD_PARAMS | Displays the method parameters of objects in the database. |
| DBA_SCHEDULER_JOB_ARGS | Displays the parameters of scheduled jobs in the 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 the database. |
| USER_SCHEDULER_PROGRAM_ARGS | Displays the parameters of schedulers that the current user owns. |
| DBA_TYPE_METHODS | Displays the methods of objects in the database. |
| USER_TYPE_METHODS | Displays the methods of objects that the user has access to, except that the OWNER column is not included in the result. |
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 where the tenant resides. |
| 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. System tenant users can view the units on all OBServer nodes in the cluster. |
| GV$SYSSTAT | Displays the system-level statistical event information 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 parameter information on the OBServer node where you reside. |
| V$SYSSTAT | Displays the system-level statistical event information on the current server. |
| V$OB_UNITS | Displays the unit information on the OBServer node where you reside. |
| V$VERSION | Queries 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 usage of held data. |
| GV$OB_SSTABLES | Displays the SSTable information of tenants. |
| GV$OB_MEMSTORE_INFO | Displays the details of MemTables on all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | Displays the details of MemTables on 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 on 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. |
Plan cache
| 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 the PALF. |
| V$OB_LOG_STAT | Displays the status of the PALF. |
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 meaning 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 where the tenant resides. |
| GV$SESSION_WAIT | Displays information about the current or last wait event of all sessions on all servers, including the event name and duration. |
| GV$SESSION_WAIT_HISTORY | Displays information about the last 10 wait events of all sessions on all servers. |
| GV$SESSTAT | Displays some statistics at the session level on all servers. |
| GV$ACTIVE_SESSION_HISTORY | Displays the ASH data of active sessions. |
| V$ACTIVE_SESSION_HISTORY | Displays the ASH data of active sessions. |
| V$NLS_PARAMETERS | Queries 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 event name and duration. |
| V$SESSION_WAIT_HISTORY | Displays information about the last 10 wait events of all sessions on the current server. |
| V$SESSTAT | Displays some statistics at the session level. |
| V$EVENT_NAME | Displays the definitions of various events in the tenant. |
SQL-related
| 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. |
Threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, view the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, view the execution information of each thread. |
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 operators whose memory is managed by SQL automatic memory management. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Queries some overall statistics 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 operators whose memory is managed by SQL automatic memory management. |
Transaction-related
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the major compaction progress information of the 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 of tablet-level major compactions. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of tablet-level major compactions. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays the transaction participants on all OBServer nodes. |
| GV$SYSTEM_EVENT | Displays the wait events at the system level for the tenant on all servers, and counts the occurrences and the total waiting and timeout durations 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 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 of tablet-level major compactions. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of tablet-level major compactions. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays the transaction participants on all OBServer nodes. |
| V$SYSTEM_EVENT | Displays the wait events at the system level for the tenant on the current server, and counts the occurrences and the total waiting and timeout durations 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. |
