Views in the sys tenant
Dictionary views
Views related to tables and columns
| View name | Description |
|---|---|
| oceanbase.CDB_IND_COLUMNS | Displays the column information of the index tables of all tenants. |
| oceanbase.CDB_INDEXES | Displays the indexes of all tenants. |
| oceanbase.CDB_TABLES | Displays information about tables in all tenants. |
| oceanbase.CDB_OB_TABLEGROUP_TABLES | Displays the associations between table groups and tables of all tenants in the sys tenant. Tables that do not belong to a table group are not displayed. |
| oceanbase.CDB_TAB_COLS | Displays the column information of the table and view objects in all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | Displays the column information of the table and view objects in all tenants. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays associations between table groups and tables. Tables that do not belong to a table group are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects in the database. |
| oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO | Displays information about column checksum inconsistencies between the index table (including global and local indexes) and the primary table. |
| 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. |
Views related to outlines
| View name | Description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | Displays information about the execution plan outlines in the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | Displays the relevant information about the throttling rule outlines in the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history of execution plans and throttling rule outlines in the current tenant. |
Views related to general database information
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DATABASES | Displays the database 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 compaction information of each zone in all tenants under the sys tenant. |
| oceanbase.DBA_OB_DATABASES | Displays the database metadata of a tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the global information about major compactions in the current tenant. |
| oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY | Displays the RootService event history. |
| oceanbase.DBA_OB_SERVER_JOBS | Displays all jobs related to OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | Displays information about all OBServer nodes. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays information about the major compactions of zones. |
| oceanbase.DBA_OB_ZONES | Displays information about all zones. |
| oceanbase.CDB_OB_FREEZE_INFO | Displays the version information generated by major compactions. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major compactions. |
Views related to partitions
| View name | Description |
|---|---|
| oceanbase.CDB_IND_PARTITIONS | Displays the partitioning information of the indexed tables of all tenants. |
| oceanbase.CDB_PART_INDEXES | Displays the partitioning information of the index tables of all tenants. |
| oceanbase.CDB_PART_TABLES | Displays the partitioning information of the partitioned tables of all tenants. |
| oceanbase.CDB_SUBPARTITION_TEMPLATES | Displays the subpartitioning information of the template partitioned tables of all tenants. |
| oceanbase.CDB_TAB_PARTITIONS | Displays the partitioning information of the partitioned tables of all tenants. |
| oceanbase.CDB_TAB_SUBPARTITIONS | Displays the subpartitioning information of the partitioned tables of all tenants. |
| oceanbase.DBA_IND_PARTITIONS | Displays information about the partition and subpartitions of an index. |
| oceanbase.DBA_PART_INDEXES | Displays information about partitions of all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | Displays information about a partitioned table. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | Displays, for each subpartition, the subpartition name, the names of the table and partition to which it belongs, its storage attributes, and statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays information about all subpartition templates. |
Views related to load balancing
| View name | Description |
|---|---|
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS | Displays the ongoing partition transfer tasks in all tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the historical partition transfer tasks executed in all tenants. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the ongoing partition transfer tasks in the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the historical partition transfer tasks in the current tenant. |
Views related to sessions
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. After you log on as the root user to the sys tenant, you can view the deadlock event history of all tenants. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. You can query this view from a user tenant for the history of deadlock events of the current tenant. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | Displays the event history on an OBServer node. |
Views related to backup and restore
| View name | Description |
|---|---|
| oceanbase.CDB_OB_RESTORE_PROGRESS | Displays the current execution progress of physical restore jobs. |
| oceanbase.CDB_OB_RESTORE_HISTORY | Displays the states of physical restore jobs upon completion. |
| oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| oceanbase.CDB_OB_BACKUP_JOBS | Displays the backup jobs of all tenants in the cluster. Each time a user initiates a backup job, a job record is generated. |
| 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 in all tenants in the cluster. A task record is generated for each backup set. The task records and job records are in one-to-one mapping. |
| oceanbase.CDB_OB_BACKUP_TASK_HISTORY | Displays the history of backup tasks in all tenants in the cluster. |
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the history of backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the history of backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | Displays the history of backup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | Displays ongoing restore jobs. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays the restore jobs that have been completed. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| oceanbase.CDB_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| oceanbase.CDB_OB_BACKUP_PARAMETER | Displays the backup parameters. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOBS | Displays the execution progress of backup cleanup jobs in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of backup cleanup jobs that have been executed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | Displays information about the backup set/piece cleanup tasks that are being executed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of the backup_set/backup_piece cleanup tasks that have been completed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies for retention period-based cleanup and automatic cleanup jobs in the current tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | Displays information about backup destinations of backup and restore in the current tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations of backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays information about backup destinations of backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations of backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies for retention period-based cleanup and automatic cleanup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of backup cleanup jobs in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of backup cleanup jobs that have been executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays information about the backup set/piece cleanup tasks that are being executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of the backup_set/backup_piece cleanup tasks that have been completed in the tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | Displays the log backup status for each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log backups. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| oceanbase.CDB_OB_ARCHIVELOG | Displays the log archiving status for each path. |
| oceanbase.CDB_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log archiving tasks. |
| 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 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 import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the history of table-level import tasks. |
Views related to statistics and histograms
| View name | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays the optimizer statistics of all tables of the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms on all tables of the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays the column statistics and histograms of all partitioned tables of the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms of all subpartitioned tables of the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays the column histograms of all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays the histograms of all partitioned tables of the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays the histograms of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the history of the table statistics of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays the optimizer statistics of all indexes of the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the modification history of all tables of the database since the table statistics were collected the last time. |
| oceanbase.CDB_TAB_COL_STATISTICS | Displays column statistics for the sys tenant. |
Views related to tenants
| View name | Description |
|---|---|
| oceanbase.DBA_OBJECTS | Displays all database objects in the database. The definition of this view is the same as that of the ALL_OBJECTS view. |
| oceanbase.CDB_OBJECTS | Displays information about objects in all tenants under the sys tenant. |
| oceanbase.DBA_OB_TENANTS | Displays the basic information about all tenants, including information about the sys tenant, user tenants, and meta tenants. You can determine the tenant type based on the TENANT_TYPE column. |
| oceanbase.DBA_OB_TENANT_JOBS | Displays the tenant-level job information. |
| oceanbase.CDB_OB_SYS_VARIABLES | Displays the system variable information about all tenants in the sys tenant. |
Views related to resources
| View name | Description |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | Displays information about the resource pools of all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | Displays all unit-related jobs. |
| oceanbase.DBA_OB_UNITS | Displays information about the units of all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | Displays information about the unit configs of all 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 the log stream (LS) replicas of all tenants. |
| oceanbase.CDB_OB_TABLEGROUPS | Displays the metadata of table groups of all tenants in the sys tenant, especially the partition information of the table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | Displays the partitioning information of the partitioned table groups of all tenants in the sys tenant. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartitioning information of the partitioned table groups of all tenants in the sys tenant. |
| oceanbase.CDB_OB_TABLET_TO_LS | Displays the list of tablets of all tenants in the sys tenant and the log streams to which these tablets belong. |
| oceanbase.CDB_OB_TABLET_REPLICAS | Displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key string of <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.CDB_PART_KEY_COLUMNS | Displays the partitioning information of partitioned objects (tables and indexes) of all tenants. |
| oceanbase.CDB_SUBPART_KEY_COLUMNS | Displays the subpartitioning information of partitioned objects (tables and indexes) of all tenants. |
| 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 partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays information about the subpartitions of a partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the metadata of a table group, mainly the partition information of the table group. |
| oceanbase.DBA_OB_TABLET_REPLICAS | Displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key string of <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays the list of tablets in the current tenant and information about the log streams to which these tablets belong. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution of the log stream (LS) replicas in 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. |
Views related to WR
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | Displays the snapshots of the current tenant. |
| oceanbase.CDB_WR_SNAPSHOT | Displays snapshots of all tenants. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | Displays the persisted Active Session History (ASH) data of the current tenant. |
| oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY | Displays persisted ASH data of all tenants. |
| oceanbase.DBA_WR_STATNAME | Displays names of system statistical items of the current tenant. |
| oceanbase.CDB_WR_STATNAME | Displays the system statistical items of all tenants. |
| oceanbase.DBA_WR_SYSSTAT | Displays details about system statistical items of the current tenant. |
| oceanbase.CDB_WR_SYSSTAT | Displays details about system statistical items of all tenants. |
| oceanbase.DBA_WR_CONTROL | Displays Workload Repository (WR) configurations. |
| oceanbase.CDB_WR_CONTROL | Displays WR configurations. |
| oceanbase.CDB_WR_SYSTEM_EVENT | Displays the persisted tenant-level wait events of all tenants. |
| oceanbase.DBA_WR_SYSTEM_EVENT | Displays the persisted tenant-level wait events of the current tenant. |
| oceanbase.CDB_WR_EVENT_NAME | Displays the persisted tenant-level wait events of all tenants. |
| oceanbase.DBA_WR_EVENT_NAME | Displays the persisted tenant-level wait events of the current tenant. |
| oceanbase.CDB_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed in all tenants. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
| oceanbase.DBA_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed in the current tenant. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
| oceanbase.CDB_WR_SYS_TIME_MODEL | Displays the WR data for the time model statistical items of all tenants. |
| oceanbase.DBA_WR_SYS_TIME_MODEL | Displays the WR data for the time model statistical items of the current tenant. |
| oceanbase.CDB_WR_SQLTEXT | Displays the SQL statements of all tenants collected by WR. |
| oceanbase.DBA_WR_SQLTEXT | Displays the SQL statements of the current tenant collected by WR. |
Views related to OBKV
| View name | Description |
|---|---|
| oceanbase.CDB_OB_KV_TTL_TASKS | Displays the ongoing time-to-live (TTL) tasks in all tenants. You can query this view only from the sys tenant. |
| oceanbase.CDB_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks in all tenants. You can query this view only from the sys tenant. |
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the ongoing TTL tasks in the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks in the current tenant. |
Performance views
Views related to event statistics
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the progress of OBServer node-level compactions in the current tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| GV$OB_PROCESSLIST | Displays the session information about all OBServer nodes of a tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of a tablet-level compaction. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays information about the transaction participants on all OBServer nodes. |
| GV$SESSION_EVENT | Displays the session-level wait events of all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | Displays information about the current or previous wait events of all sessions on all OBServer nodes, including the event names and the amount of time spent on waiting. |
| GV$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on all OBServer nodes. |
| GV$SYSTEM_EVENT | Displays all tenant-level wait events in the cluster. |
| GV$SESSTAT | Displays the session-level statistical events on all OBServer nodes. |
| GV$SYSSTAT | Displays information about tenant-level statistical events on all OBServer nodes. |
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$OB_COMPACTION_PROGRESS | Displays the server-level compaction progress of tenants. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| V$OB_PROCESSLIST | Displays the session information about the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of a tablet-level compaction. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays information about the transaction participants on all OBServer nodes. |
| V$STATNAME | Displays definitions related to all the statistical events. |
| V$EVENT_NAME | Displays the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | Displays details about the current wait events in each session. Each wait event has three parameters. |
| V$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of each session. |
| V$SESSTAT | Displays an overview of session-level statistical events. |
| V$SYSSTAT | Displays information about tenant-level statistical events on the current OBServer node. |
| V$SYSTEM_EVENT | Displays the tenant-level wait events. |
| GV$SESSION_LONGOPS | Displays the progress of index creation in the cluster. |
| V$SESSION_LONGOPS | Displays the progress of index creation on the current OBServer node. |
Views related to monitoring statistics
| View name | Description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information about the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information about the DTL intermediate result manager. |
Views related to I/O statistics
| View name | Description |
|---|---|
| GV$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| V$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| GV$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
| V$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
Views related to cache statistics
| View name | Description |
|---|---|
| GV$OB_MEMORY | Displays the tenant-level memory statistics. |
| V$OB_MEMORY | Displays the tenant-level memory statistics. |
| GV$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE | Displays session-level MemStore statistics. |
| GV$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all OBServer nodes. |
| GV$OB_SSTABLES | Displays the SSTables of tenants. |
| V$OB_SSTABLES | Displays the SSTables 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. |
Views related to SQL statistics
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | Displays the outlines of the current tenant. It is used for outline migration. |
| V$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServer nodes. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all OBServer nodes. |
| V$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current OBServer node. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all OBServer nodes. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current OBServer node. |
| GV$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| V$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | Displays the monitoring information about prepared statements, including the basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Displays the monitoring information about prepared statements, including the 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 statistics about each SQL request on all OBServer nodes, such as the source and execution status. |
| V$OB_SQL_AUDIT | Displays the statistics about each SQL request on the current OBServer node, such as the source and execution status. |
| GV$SQL_PLAN_MONITOR | Displays plan-level statistics about slow queries on all OBServer nodes. Each slow query has one row in this view. It also records the trace information about the plan. |
| V$SQL_PLAN_MONITOR | Displays the operation-level statistics of slow queries. Each operation has one row in this view. |
| V$SQL_MONITOR_STATNAME | Displays the numbers in the OTHERSTAT_X_ID column of the GV$SQL_PLAN_MONITOR view. |
| GV$OB_FLT_TRACE_CONFIG | Displays information about end-to-end diagnostics. |
| GV$OB_SQLSTAT | Displays the basic performance statistics of SQL statements in the cluster. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
| V$OB_SQLSTAT | Displays the basic performance statistics of SQL statements on the current OBServer node. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
Views related to log statistics
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | Displays the Palf status information. |
| V$OB_LOG_STAT | Displays the Palf status information. |
Views related to network statistics
| View name | Description |
|---|---|
| GV$OB_RPC_OUTGOING | Displays the RPC sending statistics of all OBServer nodes. |
| GV$OB_RPC_INCOMING | Displays the RPC receiving statistics of all OBServer nodes. |
| V$OB_RPC_OUTGOING | Displays the data sending status of all RPC packet codes under each tenant on the OBServer node. |
| V$OB_RPC_INCOMING | Displays the data receiving status of all RPC packet codes under each tenant on the OBServer node. |
Views related to database statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameters on all OBServer nodes of a tenant. |
| GV$OB_SERVER_SCHEMA_INFO | Displays information about schemas on all OBServer nodes. |
| GV$OB_SERVERS | Displays the information about all OBServer nodes. |
| GV$OB_UNITS | Displays the information about the units on the OBServer node where the current tenant is located. You can view the units of all OBServer nodes in the current cluster from the sys tenant. |
| V$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameters on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays information about schemas on all OBServer nodes. |
| V$OB_SERVERS | Displays the information about the current OBServer node. |
| V$OB_UNITS | Displays the information about the units on the current OBServer node. |
| GV$DML_STATS | Displays the information about the DML operations performed in the current user table. |
| V$DML_STATS | Displays the information about the DML operations performed in the current user table. |
Views related to time model statistics
| View name | Description |
|---|---|
| GV$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the cluster. |
| V$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the current OBServer node. |
| GV$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the cluster. |
| V$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the current OBServer node. |
Views related to minor compactions
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | Displays the statistics about compactions that are completed in the cluster. |
| V$OB_MERGE_INFO | Displays the statistics about compactions that are completed in the cluster. |
Views related to threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
| V$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
| GV$OB_TENANT_RUNTIME_INFO | Displays information about quotas of queues and threads in tenant threads. |
| V$OB_TENANT_RUNTIME_INFO | Displays information about quotas of queues and threads in tenant threads. |
Views related to workareas
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workarea information about active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions consumed 1 MB to 2 MB of memory and the number of executions in one-pass mode. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| V$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workarea information about active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one pass mode. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, including the maximum available memory, current memory usage, and currently held memory. |
Views related to encrypted tables
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with encryption enabled. |
Views related to transactions
| View name | Description |
|---|---|
| GV$LATCH | Displays information about the latches on each OBServer node in the cluster. |
| V$LATCH | Displays information about the latches on each OBServer node in the cluster. |
Views related to ASH statistics
| View name | Description |
|---|---|
| GV$OB_ACTIVE_SESSION_HISTORY | Displays the historical records of active sessions. |
| V$OB_ACTIVE_SESSION_HISTORY | Displays the historical records of active sessions on the current OBServer node. |
Views in a MySQL tenant
Dictionary views
Views related to the HELP command
| View name | Description |
|---|---|
| mysql.help_topic | Generates the HELP command in coordination with the following three tables: mysql.help_category, mysql.help_relation, and mysql.help_keyword tables. |
| mysql.help_category | Generates the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_keyword. |
| mysql.help_category | Generates the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_keyword. |
| mysql.help_keyword | Generates the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_category. |
| mysql.help_relation | Generates the HELP command in combination with the following three tables: mysql.help_category, mysql.help_topic, and mysql.help_keyword tables. |
Views related to SPM
| View name | Description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | Displays the SQL plan baseline in SQL Plan Management (SPM). |
| oceanbase.DBA_SQL_MANAGEMENT_CONFIG | Displays the configuration parameters in SQL Plan Management (SPM). |
Views related to privileges
| View name | Description |
|---|---|
| mysql.db | Displays information about system-level privileges. |
| mysql.user | Displays information about user-level privileges. |
| information_schema.COLUMN_PRIVILEGES | Displays the column privilege information. |
| information_schema.SCHEMA_PRIVILEGES | Displays information about database privileges. |
| information_schema.TABLE_PRIVILEGES | Displays information about table privileges. |
| information_schema.USER_PRIVILEGES | Displays information about user privileges. |
Views related to OBKV
| View name | Description |
|---|---|
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the ongoing TTL tasks in the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks in the current tenant. |
Views related to schedulers
| View name | Description| |--|---------------------| | oceanbase.DBA_SCHEDULER_JOBS| Displays all scheduler jobs in the database. |
Views related to storage
| View name | Description |
|---|---|
| mysql.proc | Displays information about stored procedures. |
| information_schema.ENGINES | Displays information about storage engines. |
| information_schema.PARAMETERS | Displays information about parameters and returns values for stored procedures. |
| information_schema.ROUTINES | Displays information about routines. |
Views related to time zones
| View name | Description |
|---|---|
| mysql.time_zone | Displays information about time zones. It is a system view. |
| mysql.time_zone_name | Displays time zone information. It is a system view. |
| mysql.time_zone_transition | Displays time zone conversion information. It is a system view. |
| mysql.time_zone_transition_type | Displays information about time zone conversion types. It is a system view. |
Views related to character sets
| View name | Description |
|---|---|
| information_schema.CHARACTER_SETS | Displays information about character sets in OceanBase Database. |
| information_schema.COLLATIONS | Displays information about collations for each character set. |
| information_schema.COLLATION_CHARACTER_SET_APPLICABILITY | Displays the correspondence between character sets and collations. |
Views related to tables and columns
| View name | Description |
|---|---|
| information_schema.COLUMNS | Displays information about columns in tables. |
| information_schema.STATISTICS | Displays information about table indexes. |
| information_schema.TABLES | Displays information about tables. |
| information_schema.VIEWS | Displays information about views. |
| information_schema.VIEW_TABLE_USAGE | Displays the information of the table and view used in the view definition. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays associations between table groups and tables. Tables that do not belong to a table group are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects in the database. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the locations of tables or partitions, including system tables, user tables, and index tables. |
Views related to outlines
|View name | Description | |-|------------------| | oceanbase.DBA_OB_OUTLINES | Displays information about the execution plan outlines in the current tenant. | | oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | Displays the relevant information about the throttling rule outlines in the current tenant. | | oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history of execution plans and throttling rule outlines in the current tenant. |
Views related to general database information
| View name | Description |
|---|---|
| information_schema.GLOBAL_STATUS | Displays the global status information about OceanBase Database. |
| information_schema.GLOBAL_VARIABLES | Displays information about global variables. |
| information_schema.SCHEMATA | Displays database metadata. |
| oceanbase.DBA_OB_DATABASES | Displays the database metadata of a tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the global information about major compactions in the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays information about the major compactions of zones. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major compactions. |
Views related to partitions
| View name | Description |
|---|---|
| information_schema.PARTITIONS | Displays information about table partitions. |
| oceanbase.DBA_IND_PARTITIONS | Displays information about the partition and subpartitions of an index. |
| oceanbase.DBA_PART_INDEXES | Displays information about partitions of all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | Displays information about a partitioned table. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | Displays, for each subpartition, the subpartition name, the names of the table and partition to which it belongs, its storage attributes, and statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays information about all subpartition templates. |
Views related to load balancing
| View name | Description |
|---|---|
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the ongoing partition transfer tasks in the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the historical partition transfer tasks executed in the current tenant. |
Views related to threads
| View name | Description |
|---|---|
| information_schema.PROCESSLIST | Displays information about threads that are being executed. |
Views related to constraints
| View name | Description |
|---|---|
| information_schema.CHECK_CONSTRAINTS | Displays constraints on tables and columns when the CREATE TABLE operation is performed. |
| information_schema.KEY_COLUMN_USAGE | Displays information about key columns that have constraints. |
| information_schema.REFERENTIAL_CONSTRAINTS | Displays metadata of foreign key constraints. |
| information_schema.TABLE_CONSTRAINTS | Displays information about table constraints. |
Views related to sessions
| View name | Description |
|---|---|
| information_schema.SESSION_STATUS | Displays the session status, such as the number of active connections and the database active duration (uptime). |
| information_schema.SESSION_VARIABLES | Displays information about session variables. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. You can query this view from a user tenant for the history of deadlock events of the current tenant. |
Views related to user logon
| View name | Description |
|---|---|
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | Displays the number of failed logon attempts of different users. |
Views related to backup and restore
| View name | Description |
|---|---|
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the history of backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the history of backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | Displays the history of backup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | Displays ongoing restore tasks. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays the restore jobs that have been completed. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays information about backup destinations of backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations of backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies for retention period-based cleanup and automatic cleanup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of backup cleanup jobs in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of backup cleanup jobs that have been executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays information about the backup set/piece cleanup tasks that are being executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of the backup_set/backup_piece cleanup tasks that have been completed in the tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | Displays the log backup status for each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log backups. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| 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 of table-level import tasks. |
Views related to statistics and histograms
| View name | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays the optimizer statistics of all tables of the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms on all tables of the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays the column statistics and histograms of all partitioned tables of the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms of all subpartitioned tables of the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays the column histograms of all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays the histograms of all partitioned tables of the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays the histograms of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the history of the table statistics of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays the optimizer statistics of all indexes of the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the modification history of all tables of the database since the table statistics were collected the last time. |
| information_schema.QUERY_RESPONSE_TIME | Displays the data types of RESPONSE TIME histograms for Prometheus to monitor. |
Views related to tenants
| View name | Description |
|---|---|
| oceanbase.DBA_OBJECTS | Displays all database objects in the database. The definition of this view is the same as that of the ALL_OBJECTS view. |
| oceanbase.DBA_OB_TENANTS | Displays the basic information about all tenants, including information about the sys tenant, user tenants, and meta tenants. You can determine the tenant type based on the TENANT_TYPE column. |
Views related to resources
| 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 partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays information about the subpartitions of a partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the metadata of a table group, mainly the partition information of the table group. |
| oceanbase.DBA_OB_TABLET_REPLICAS | Displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key string of <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays the list of tablets in the current tenant and information about the log streams to which these tablets belong. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution of the log stream (LS) replicas in the current tenant. |
Views related to WR
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | Displays the snapshots of the current tenant. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | Displays the persisted Active Session History (ASH) data of the current tenant. |
| oceanbase.DBA_WR_STATNAME | Displays names of system statistical items of the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | Displays details about system statistical items of the current tenant. |
| oceanbase.DBA_WR_CONTROL | Displays WR configurations. |
| oceanbase.DBA_WR_SYSTEM_EVENT | Displays the persisted tenant-level wait events of the current tenant. |
| oceanbase.DBA_WR_EVENT_NAME | Displays the persisted tenant-level wait events of the current tenant. |
| oceanbase.DBA_WR_SQLTEXT | Displays the SQL statements of the current tenant collected by WR. |
Views related to SQL statistics
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed in the current tenant. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
Views related to time models
| View name | Description |
|---|---|
| oceanbase.DBA_WR_SYS_TIME_MODEL | Displays the WR data for the time model statistical items of the current tenant. |
Performance views
Views related to ASH statistics
| View name | Description |
|---|---|
| GV$OB_ACTIVE_SESSION_HISTORY | Displays the historical records of active sessions. |
| V$OB_ACTIVE_SESSION_HISTORY | Displays the historical records of active sessions on the current OBServer node. |
Views related to event statistics
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the progress of OBServer node-level compactions in the current tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| GV$OB_PROCESSLIST | Displays the session information about all OBServer nodes of a tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of a tablet-level compaction. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays information about the transaction participants on all OBServer nodes. |
| GV$SESSION_EVENT | Displays the session-level wait events of all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | Displays information about the current or previous wait events of all sessions on all OBServer nodes, including the event names and the amount of time spent on waiting. |
| GV$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on all OBServer nodes. |
| GV$SYSTEM_EVENT | Displays all tenant-level wait events in the cluster. |
| GV$SESSTAT | Displays the session-level statistical events on all OBServer nodes. |
| GV$SYSSTAT | Displays information about tenant-level statistical events on all OBServer nodes. |
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$OB_COMPACTION_PROGRESS | Displays the server-level compaction progress of tenants. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| V$OB_PROCESSLIST | Displays the session information about the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of a tablet-level compaction. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays information about the transaction participants on all OBServer nodes. |
| V$STATNAME | Displays definitions related to all the statistical events. |
| V$EVENT_NAME | Displays the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | Displays details about the current wait events in each session. Each wait event has three parameters. |
| V$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of each session. |
| V$SESSTAT | Displays an overview of session-level statistical events. |
| V$SYSSTAT | Displays information about tenant-level statistical events on the current OBServer node. |
| V$SYSTEM_EVENT | Displays the tenant-level wait events. |
| GV$SESSION_LONGOPS | Displays the progress of index creation in the cluster. |
| V$SESSION_LONGOPS | Displays the progress of index creation on the current OBServer node. |
Views related to monitoring statistics
| View name | Description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information about the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information about the DTL intermediate result manager. |
Views related to I/O statistics
| View name | Description |
|---|---|
| GV$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| V$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| GV$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
| V$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
Views related to cache statistics
| View name | Description |
|---|---|
| GV$OB_MEMORY | Displays the tenant-level memory statistics. |
| V$OB_MEMORY | Displays the tenant-level memory statistics. |
| GV$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE | Displays session-level MemStore statistics. |
| GV$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all OBServer nodes. |
| GV$OB_SSTABLES | Displays the SSTables of tenants. |
| V$OB_SSTABLES | Displays the SSTables 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. |
Views related to SQL statistics
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | Displays the outlines of the current tenant. It is used for outline migration. |
| V$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServer nodes. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all OBServer nodes. |
| V$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current OBServer node. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all OBServer nodes. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current OBServer node. |
| GV$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| V$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | Displays the monitoring information about prepared statements, including the basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Displays the monitoring information about prepared statements, including the 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 statistics about each SQL request on all OBServer nodes, such as the source and execution status. |
| V$OB_SQL_AUDIT | Displays the statistics about each SQL request on the current OBServer node, such as the source and execution status. |
| GV$SQL_PLAN_MONITOR | Displays plan-level statistics about slow queries on all OBServer nodes. Each slow query has one row in this view. It also records the trace information about the plan. |
| V$SQL_PLAN_MONITOR | Displays the operation-level statistics of slow queries. Each operation has one row in this view. |
| V$SQL_MONITOR_STATNAME | Displays the numbers in the OTHERSTAT_X_ID column of the GV$SQL_PLAN_MONITOR view. |
| GV$OB_FLT_TRACE_CONFIG | Displays information about end-to-end diagnostics. |
Views related to log statistics
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | Displays the Palf status information. |
| V$OB_LOG_STAT | Displays the Palf status information. |
Views related to network statistics
| View name | Description |
|---|---|
| GV$OB_RPC_OUTGOING | Displays the RPC sending statistics of all OBServer nodes. |
| GV$OB_RPC_INCOMING | Displays the RPC receiving statistics of all OBServer nodes. |
| V$OB_RPC_OUTGOING | Displays the data sending status of all RPC packet codes under each tenant on the OBServer node. |
| V$OB_RPC_INCOMING | Displays the data receiving status of all RPC packet codes under each tenant on the OBServer node. |
Views related to database statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | Displays information about the KV cache on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameters on all OBServer nodes of a tenant. |
| GV$OB_SERVER_SCHEMA_INFO | Displays information about schemas on all OBServer nodes. |
| GV$OB_SERVERS | Displays information about all OBServer nodes. |
| GV$OB_UNITS | Displays information about the units on the OBServer node where the current tenant is located. You can view the units of all OBServer nodes in the current cluster from the sys tenant. |
| V$OB_KVCACHE | Displays information about the KV cache on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameters on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays information about schemas on all OBServer nodes. |
| V$OB_SERVERS | Displays information about the current OBServer node. |
| V$OB_UNITS | Displays information about the units on the current OBServer node. |
| GV$DML_STATS | Displays information about the DML operations performed in the current user table. |
| V$DML_STATS | Displays information about the DML operations performed in the current user table. |
Views related to SQL statistics
| View name | Description |
|---|---|
| GV$OB_SQLSTAT | Displays the basic performance statistics of SQL statements in the cluster. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
| V$OB_SQLSTAT | Displays the basic performance statistics of SQL statements on the current OBServer node. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
Views related to time model statistics
| View name | Description |
|---|---|
| GV$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the cluster. |
| V$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the current OBServer node. |
| GV$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the cluster. |
| V$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the current OBServer node. |
Views related to minor compactions
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | Displays the statistics about compactions that are completed in the cluster. |
| V$OB_MERGE_INFO | Displays the statistics about compactions that are completed in the cluster. |
Views related to threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
| V$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
Views related to workareas
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workarea information about active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions consumed 1 MB to 2 MB of memory and the number of executions in one-pass mode. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| V$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workarea information about active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one pass mode. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, including the maximum available memory, current memory usage, and currently held memory. |
Views related to encrypted tables
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with encryption enabled. |
Views related to transactions
| View name | Description |
|---|---|
| GV$LATCH | Displays information about the latches on each OBServer node in the cluster. |
| V$LATCH | Displays information about the latches on each OBServer node in the cluster. |
Views in an Oracle tenant
Dictionary views
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Views related to tables and views
| View name | Description |
|---|---|
| ALL_ALL_TABLES | Displays the object tables and relational tables accessible to the current user. |
| ALL_COL_COMMENTS | Displays all column comments in the views and tables accessible to the current user. |
| ALL_TABLES | Displays all tables accessible to the current user. |
| ALL_TAB_COLS | Displays all columns in the tables, views, and clusters accessible to the current user. |
| ALL_TAB_COLUMNS | Displays all columns in the tables, views, and clusters accessible to the current user. |
| ALL_TAB_COMMENTS | Displays the comments in the tables and views accessible to the current user. |
| DBA_COL_COMMENTS | Displays all column comments in all views and tables in the database. |
| DBA_TAB_COMMENTS | Displays the comments in all tables and views in the database. |
| USER_COL_COMMENTS | Displays all column comments in the views and tables owned by the current user. |
| USER_TAB_COMMENTS | Displays the comments in the tables and views owned by the current user. |
| DBA_OB_TABLEGROUP_TABLES | Displays the association relationships between table groups and tables. Tables that do not belong to a table group are not displayed. |
| DBA_TABLES | Displays all tables in the database. |
| DBA_ALL_TABLES | Displays all object tables and relational tables in the database. Its columns are the same as those of 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 object tables and relational tables accessible to the current user. Its columns are the same as those of the ALL_ALL_TABLES view except that it does not have the OWNER column. |
| USER_TABLES | Displays all tables owned by the current user. |
| USER_TABLESPACES | Displays the tablespaces accessible to the current user. Its columns are the same as those of the DBA_TABLESPACES view, except that it does not have the PLUGGED_IN column. |
| USER_TAB_COLS | Displays all columns of the tables, views, and clusters owned by the current user. |
| USER_TAB_COLUMNS | Displays all columns of the tables, views, and clusters owned by the current user. |
| ALL_VIEWS | Displays all views accessible to the current user. |
| DBA_VIEWS | Displays all views in the database. Its columns are the same as those of ALL_VIEWS. |
| USER_VIEWS | Displays the views owned by the current user. |
| DICTIONARY | Displays the data dictionary tables and views. |
| DICT | Displays the data dictionary tables and views. |
| DBA_OB_TABLE_LOCATIONS | Displays the locations of tables and partitions, including system tables, user tables, and index tables. |
Views related to outlines
|View name | Description | |-|------------------| | DBA_OB_OUTLINES | Displays information about the execution plan outlines in the current tenant. | | DBA_OB_CONCURRENT_LIMIT_SQL | Displays the relevant information about the throttling rule outlines in the current tenant. | | DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history of execution plans and throttling rule outlines in the current tenant. |
Views related to SPM
| View name | Description |
|---|---|
| DBA_SQL_PLAN_BASELINES | Displays the SQL plan baseline in SQL Plan Management (SPM). |
| DBA_SQL_MANAGEMENT_CONFIG | Displays the configuration parameters in SPM. |
Views related to general database information
| View name | Description |
|---|---|
| DBA_CONTEXT | Displays information about all context namespaces in the database. |
| DBA_OB_DATABASES | Displays the database metadata of a tenant. |
| DBA_OB_MAJOR_COMPACTION | Displays the global information about major compactions in the current tenant. |
| DBA_OB_ZONE_MAJOR_COMPACTION | Displays information about the major compactions of zones. |
| ALL_OBJECTS | Displays all database objects accessible to the current user. |
| DBA_OBJECTS | Displays all database objects in the database. |
| USER_OBJECTS | Displays all database objects owned by the current user. |
| ALL_DEPENDENCIES | Displays the dependencies among all the objects accessible to the current user. |
| DBA_DEPENDENCIES | Displays the dependencies among all objects in the database. |
| USER_DEPENDENCIES | Displays the dependencies among objects in the schema of the current user. |
| DBA_OB_FREEZE_INFO | Displays the version information generated by major compactions. |
Views related to functions and procedures
| View name | Description |
|---|---|
| ALL_ARGUMENTS | Displays the arguments of the functions and procedures accessible to the current user. |
| ALL_PROCEDURES | Displays all functions and procedures accessible to the current user as well as their properties. |
| ALL_SOURCE | Displays the text sources of the stored objects accessible to the current user. |
| DBA_ARGUMENTS | Displays the arguments of the available functions and procedures in the database. Its columns are the same as those of ALL_ARGUMENTS. |
| DBA_PROCEDURES | Displays all available functions and procedures in the database as well as their properties. Its columns are the same as those of ALL_PROCEDURES. |
| DBA_SOURCE | Displays the text sources of all stored objects in the database. Its columns are the same as those of ALL_SOURCE. |
| USER_ARGUMENTS | Displays the arguments of the functions and procedures owned by the current user. Its columns are the same as those of the ALL_ARGUMENTS view, except that it does not have the OWNER column. |
| USER_PROCEDURES | Displays all functions and procedures owned by the current user, as well as their associated properties. Its columns are the same as those of the ALL_PROCEDURES view, except that it does not have the OWNER column. |
| USER_SOURCE | Displays the text sources of the stored objects owned by the current user. Its columns are the same as those of the ALL_SOURCE view, except that it does not have the OWNER column. |
| DBA_JOBS | Displays an overview of committed jobs. |
| USER_JOBS | Displays an overview of committed jobs. |
| DBA_JOBS_RUNNING | Displays the running jobs. |
Views related to backup and restore
| View name | Description |
|---|---|
| DBA_OB_BACKUP_JOBS | Displays the backup jobs in the current tenant. |
| DBA_OB_BACKUP_JOB_HISTORY | Displays the history of backup jobs in the current tenant. |
| DBA_OB_BACKUP_TASKS | Displays the backup tasks in the current tenant. |
| DBA_OB_BACKUP_TASK_HISTORY | Displays the history of backup tasks in the current tenant. |
| DBA_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| DBA_OB_RESTORE_PROGRESS | Displays ongoing restore tasks. |
| DBA_OB_RESTORE_HISTORY | Displays the restore jobs that have been completed. |
| DBA_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| DBA_OB_BACKUP_STORAGE_INFO | Displays information about backup destinations of backup and restore in the current tenant. |
| DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations of backup and restore in the current tenant. |
| DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies for retention period-based cleanup and automatic cleanup tasks in the current tenant. |
| DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of backup cleanup jobs in the tenant. |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of backup cleanup jobs that have been executed in the tenant. |
| DBA_OB_BACKUP_DELETE_TASKS | Displays information about the backup set/piece cleanup tasks that are being executed in the tenant. |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of the backup_set/backup_piece cleanup tasks that have been completed in the tenant. |
| DBA_OB_ARCHIVELOG | Displays the log backup status for each path. |
| DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log backups. |
| DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| 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 of table-level import tasks. |
Views related to statistics and histograms
| View name | Description |
|---|---|
| ALL_PART_COL_STATISTICS | Displays the column statistics and histograms on partitions in the partitioned tables accessible to the current user. |
| ALL_PART_HISTOGRAMS | Displays the histograms on all partitions. |
| ALL_SUBPART_COL_STATISTICS | Displays the column statistics and histograms on subpartitions in the partitioned tables accessible to the current user. |
| ALL_SUBPART_HISTOGRAMS | Displays the histograms on all subpartitions. |
| ALL_TAB_COL_STATISTICS | Displays the column statistics and histograms on tables accessible to the current user. |
| ALL_TAB_HISTOGRAMS | Displays all table-level histograms. |
| ALL_TAB_STATISTICS | Displays the optimizer statistics of tables accessible to the current user. |
| DBA_PART_COL_STATISTICS | Displays the column statistics and histograms on partitions in the partitioned tables of the database. |
| DBA_PART_HISTOGRAMS | Displays the histograms on partitions of the current database. |
| DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms on subpartitions in the partitioned tables of the database. |
| DBA_SUBPART_HISTOGRAMS | Displays the histograms on the subpartitions of the current database. |
| DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms on all tables of the database. |
| DBA_TAB_HISTOGRAMS | Displays the table-level histograms on the current database. |
| DBA_TAB_STATISTICS | Displays the optimizer statistics of all tables of the database. |
| USER_PART_COL_STATISTICS | Displays the column statistics and histograms on the partitions in the partitioned tables of the current user. |
| USER_PART_HISTOGRAMS | Displays the histograms on the partitions of the current user. |
| USER_SUBPART_COL_STATISTICS | Displays the column statistics and histograms on the subpartitions in the partitioned tables of the current user. |
| USER_SUBPART_HISTOGRAMS | Displays the histograms on the subpartitions of the current user. |
| USER_TAB_COL_STATISTICS | Displays the column statistics and histograms on the tables of the current user. |
| USER_TAB_HISTOGRAMS | Displays the table-level histograms on the current user. |
| USER_TAB_STATISTICS | Displays the optimizer statistics of all tables of the current user. |
| ALL_TAB_STATS_HISTORY | Displays the change history of the table statistics of all tables accessible to the current user. |
| DBA_TAB_STATS_HISTORY | Displays the change history of the table statistics of all tables in the database. |
| USER_TAB_STATS_HISTORY | Displays the change history of the table statistics of all tables owned by the current user. |
| ALL_IND_STATISTICS | Displays the optimizer statistics on the indexes of tables accessible to the current user. |
| DBA_IND_STATISTICS | Displays the optimizer statistics of all indexes of the database. |
| USER_IND_STATISTICS | Displays the optimizer statistics on the indexes of tables owned by the current user. |
| ALL_TAB_MODIFICATIONS | Displays the modification history of tables accessible to the current user since the table statistics were collected the last time. |
| DBA_TAB_MODIFICATIONS | Displays the modification history of all tables of the database since the table statistics were collected the last time. |
| USER_TAB_MODIFICATIONS | Displays the modification history of tables owned by the current user since the table statistics were collected the last time. |
Views related to users and privileges
| View name | Description |
|---|---|
| ALL_USERS | Displays all database users visible to the current user. |
| DBA_USERS | Displays all database users in the database. |
| USER_USERS | Displays information about the current user. |
| ALL_COL_PRIVS | Displays the granted column object privileges for which the current user is the object owner, grantor, or grantee. displays the column object grants for which an enabled role or PUBLIC is the grantee. |
| ALL_TAB_PRIVS | **Displays the object grants for which the current user is the object owner, grantor, or grantee; Object grants for which an enabled role or PUBLIC is the grantee |
| DBA_COL_PRIVS | Displays all column object grants in the database. |
| DBA_SYS_PRIVS | Displays the system privileges granted to users and roles. |
| DBA_TAB_PRIVS | Displays all object grants in the database. |
| USER_TAB_PRIVS | Displays the object grants for which the current user is the object owner, grantor, or grantee. |
| USER_COL_PRIVS | Displays the column object grants for which the current user is the object owner, grantor, or grantee. |
| 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 granted to roles. Information is provided only about roles to which the user has access. |
| ROLE_SYS_PRIVS | Displays the system privileges granted to roles. |
| ROLE_ROLE_PRIVS | Displays the roles granted to other roles. Information is provided only about roles to which the user has access. |
| DBA_ROLE_PRIVS | Displays the roles granted to all users and roles in the database. |
| DBA_ROLES | Displays all roles that exist in the database. |
| ALL_DIRECTORIES | Displays all directories accessible to the current user. |
| DBA_DIRECTORIES | Displays all directories accessible to the current user. |
Views related to constraints
| View name | Description |
|---|---|
| ALL_CONSTRAINTS | Displays the constraints on all tables accessible to the current user. |
| ALL_CONS_COLUMNS | Displays the columns that are specified in the constraints on all tables accessible to the current user. |
| DBA_CONSTRAINTS | Displays the constraints on all tables in the database. |
| DBA_CONS_COLUMNS | Displays the columns that are specified in the constraints on all tables in the database. |
| USER_CONSTRAINTS | Displays the constraints on all tables owned by the current user. |
| USER_CONS_COLUMNS | Displays the columns that are specified in the constraints on all tables owned by the current user. |
Views related to audit
| View name |Description | |----------------------------------------------------------------------|--| | ALL_DEF_AUDIT_OPTS | Displays the default object-auditing options for any object. | | AUDIT_ACTIONS| Displays the action IDs and names in audit records. | | DBA_AUDIT_EXISTS | Displays audit trail entries produced by AUDIT EXISTS and AUDIT NOT EXISTS. | | DBA_AUDIT_OBJECT | Displays the audit trail records for all objects in the database. | | DBA_AUDIT_SESSION| Displays all audit trail records concerning CONNECT and DISCONNECT. | | DBA_AUDIT_STATEMENT | Displays audit trail records for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements in the database. | | DBA_AUDIT_TRAIL | Displays all audit trail entries. | | DBA_OBJ_AUDIT_OPTS | Displays detailed auditing configurations at the object level. | | DBA_STMT_AUDIT_OPTS | Displays detailed auditing configuration at the statement level. | | STMT_AUDIT_OPTION_MAP | Displays statement-level auditing types and their corresponding names and priorities. | | USER_AUDIT_OBJECT| Displays audit trail records for objects accessible to the current user. | | USER_AUDIT_SESSION | Displays audit trail records for connections and disconnections in the current user. | | USER_AUDIT_STATEMENT | Displays audit trail entries for the GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements issued by the current user. | | USER_AUDIT_TRAIL | Displays standard audit trail entries concerning the current user. |
Views related to indexes
| View name | Description |
|---|---|
| ALL_INDEXES | Displays the indexes on all tables accessible to the current user. |
| ALL_IND_COLUMNS | Displays the indexes on all tables accessible to the current user. |
| ALL_IND_EXPRESSIONS | Displays information about function-based indexes accessible to the current user in the database. |
| ALL_IND_PARTITIONS | Displays information about index partitions accessible to the current user in the database. |
| ALL_IND_SUBPARTITIONS | Displays information about all index subpartitions accessible to the current user in the database. |
| ALL_PART_INDEXES | Displays the partitioning information of all partitioned indexes accessible to the current user. |
| DBA_INDEXES | Displays the indexes on all tables in the database. |
| DBA_IND_COLUMNS | Displays the columns of indexes on all tables in the database. |
| DBA_IND_EXPRESSIONS | Displays information about all function-based indexes in the database. |
| DBA_IND_PARTITIONS | Displays information about all index partitions in the database. |
| DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| USER_INDEXES | Displays the indexes on all tables owned by the current user. |
| USER_IND_COLUMNS | Displays the columns of indexes on all tables owned by the current user. |
| USER_IND_EXPRESSIONS | Displays information about function-based indexes owned by the current user in the database. |
| USER_IND_PARTITIONS | Displays information about the index partitions owned by the current user in the database. This view does not have the INDEX_OWNER column compared with the ALL_IND_PARTITIONS and DBA_IND_PARTITIONS views. |
| USER_IND_SUBPARTITIONS | Displays information about all index subpartitions owned by the current user in the database. This view does not have the INDEX_OWNER column compared with the DBA_IND_SUBPARTITIONS and ALL_IND_SUBPARTITIONS views. |
| USER_PART_INDEXES | Displays the partitioning information of partitioned indexes owned by the current user. |
Views related to partitions
| View name | Description |
|---|---|
| ALL_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects accessible to the current user. |
| ALL_PART_TABLES | Displays the partitioning information of all partitioned tables accessible to the current user. |
| ALL_SUBPARTITION_TEMPLATES | Displays information about all subpartition templates. |
| ALL_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects accessible to the current user. |
| ALL_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics of all partitioned tables. |
| ALL_TAB_SUBPARTITIONS | Displays the partition-level partitioning information, partition storage parameters, and partition statistics generated by the DBMS_STATS package for the partitions accessible to the current user. |
| DBA_PART_INDEXES | Displays information about partitions of all partitioned indexes. |
| DBA_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects in the database. |
| DBA_PART_TABLES | Displays the partitioning information of all partitioned tables accessible to the current user. |
| DBA_SUBPARTITION_TEMPLATES | Displays information about all subpartition templates. |
| DBA_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects in the database. |
| DBA_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics accessible to the current user. |
| DBA_TAB_SUBPARTITIONS | Displays, for each subpartition, the subpartition name, the names of the table and partition to which it belongs, its storage attributes, and statistics generated by the DBMS_STATS package. |
| USER_PART_KEY_COLUMNS | Displays the partitioning key columns in all partitioned objects owned by the current user. |
| USER_PART_TABLES | Displays the partitioning information of all partitioned tables owned by the current user. |
| USER_SUBPARTITION_TEMPLATES | Displays information about all subpartition templates. |
| USER_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects owned by the current user. |
| USER_TAB_SUBPARTITIONS | Displays, for each table subpartition owned by the current user, the subpartition name, the names of the table and partition to which it belongs, and its storage attributes. |
| USER_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics of the current user. |
Views related to sessions
| View name | Description |
|---|---|
| DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. You can query this view from a user tenant for the history of deadlock events of the current tenant. |
Views related to sequences
| View name | Description |
|---|---|
| ALL_SEQUENCES | Displays all sequences accessible to the current user. |
| DBA_SEQUENCES | Displays all sequences in the database. |
| USER_SEQUENCES | Displays all sequences owned by the current user. |
| TENANT_VIRTUAL_GLOBAL_VARIABLE | Displays information about global variables. |
| TENANT_VIRTUAL_SESSION_VARIABLE | Displays information about session variables. |
Views related to synonyms
| View name | Description |
|---|---|
| ALL_SYNONYMS | Displays all synonyms accessible to the current user. |
| DBA_SYNONYMS | Displays all synonyms in the database. |
| USER_SYNONYMS | Displays all synonyms owned by the current user. |
Views related to triggers
| View name | Description |
|---|---|
| ALL_TRIGGERS | Displays the triggers on tables owned by the current user. If the user has the CREATE ANY TRIGGER privilege, this view displays all the triggers in the database. |
| DBA_TRIGGERS | Displays all triggers in the database. |
| USER_TRIGGERS | Displays the triggers owned by the current user. |
Views related to recycle bins
| View name | Description |
|---|---|
| DBA_RECYCLEBIN | Displays information about all recycle bins in the database. |
| USER_RECYCLEBIN | Displays information about recycle bins owned by the current user. Its columns are the same as those of the DBA_RECYCLEBIN view, except that it does not have the OWNER column. |
Views related to resource groups
| View name | Description |
|---|---|
| DBA_RSRC_GROUP_MAPPINGS | Displays the binding relationships between the user and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | Displays information about all resource groups in the database. |
| DBA_RSRC_PLANS | Displays all resource management plans defined in the system. |
| DBA_RSRC_PLAN_DIRECTIVES | Displays the details of each group of resource plan directives in the database. |
Views related to NLS parameters
| View name | Description |
|---|---|
| NLS_DATABASE_PARAMETERS | Displays the National Language Support (NLS) parameters at the OceanBase Database tenant level. |
| NLS_INSTANCE_PARAMETERS | Displays the NLS parameters at the instance level. |
| NLS_SESSION_PARAMETERS | Displays the NLS parameters at the session level. |
Views related to user-defined types
| View name | Description |
|---|---|
| ALL_COLL_TYPES | Displays user-defined collection types available in the database. Its columns are the same as those of the DBA_COLL_TYPES view. |
| ALL_TYPES | Displays the user-defined types available in the database. |
| ALL_TYPE_ATTRS | Displays the attributes of user-defined types available in the database. |
| DBA_COLL_TYPES | Displays user-defined collection types available in the database. Its columns are the same as those of the ALL_COLL_TYPES view. |
| DBA_TYPES | Displays the user-defined types available in the database. |
| DBA_TYPE_ATTRS | Displays the attributes of user-defined types available in the database. |
| USER_COLL_TYPES | Displays the user-defined collection types accessible to the current user. |
| USER_TYPES | Displays the user-defined types accessible to the current user. |
| USER_TYPE_ATTRS | Displays the attributes of user-defined types accessible to the current user. |
Views related to stored objects
| View name | Description |
|---|---|
| ALL_ERRORS | Displays the current errors of all stored objects accessible to the current user. |
| DBA_ERRORS | Displays the current errors of all stored objects in the database. |
| USER_ERRORS | Displays the current errors of all stored objects accessible to the current user. |
| DBA_SEGMENTS | Displays the storage allocated for all segments in the database. |
| USER_SEGMENTS | Displays the storage allocated for the segments of the objects that are owned by the current user. |
Views related to profiles
| View name | Description |
|---|---|
| ALL_PROFILES | Displays all profiles accessible to the current user and their limitations. |
| DBA_PROFILES | Displays all profiles accessible to the current user and their limitations. |
| USER_PROFILES | Displays all profiles accessible to the current user and their limitations. |
Views related to replicas and logs
| View name | Description |
|---|---|
| DBA_OB_LS_LOCATIONS | Displays the distribution of the log stream (LS) replicas in the current tenant. |
| DBA_OB_TABLEGROUPS | Displays the metadata of a table group, mainly the partition information of the table group. |
| DBA_OB_TABLEGROUP_PARTITIONS | Displays information about the partitions of a partitioned table group. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays information about the subpartitions of a partitioned table group. |
| DBA_OB_TABLET_REPLICAS | Displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key string of <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| DBA_OB_TABLET_TO_LS | Displays the list of tablets in the current tenant and information about the log streams to which these tablets belong. |
| DBA_OB_LS | Displays the status and restore progress of log streams. |
Views related to WR
| View name | Description |
|---|---|
| DBA_WR_SNAPSHOT | Displays the snapshots of the current tenant. |
| DBA_WR_ACTIVE_SESSION_HISTORY | Displays the persisted Active Session History (ASH) data of the current tenant. |
| DBA_WR_STATNAME | Displays names of system statistical items of the current tenant. |
| DBA_WR_SYSSTAT | Displays details about system statistical items of all tenants. |
| DBA_WR_CONTROL | Displays WR configurations. |
| DBA_WR_SYSTEM_EVENT | Displays the persisted tenant-level wait events of the current tenant. |
| DBA_WR_EVENT_NAME | Displays the persisted tenant-level wait events of the current tenant. |
| DBA_WR_SQLTEXT | Displays the SQL statements of the current tenant collected by WR. |
Views related to SQL statistics
| View name | Description |
|---|---|
| DBA_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed in the current tenant. |
Views related to SQL statistics
| View name | Description |
|---|---|
| DBA_WR_SYS_TIME_MODEL | Displays the WR data for the time model statistical items of the current tenant. |
Views related to load balancing
| View name | Description |
|---|---|
| DBA_OB_TRANSFER_PARTITION_TASKS | Displays the ongoing partition transfer tasks in the current tenant. |
| DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the historical partition transfer tasks executed in the current tenant. |
Views related to schedulers
| View name | Description| |--|---------------------| | DBA_SCHEDULER_JOBS| Displays the scheduler jobs accessible to the current user. | | DBA_SCHEDULER_PROGRAM | Displays all scheduler programs in the database. | | DBA_SCHEDULER_JOB_RUN_DETAILS | Displays all scheduler jobs in the tenant. |
Views related to DBLinks
| View name | Description| |--|---------------------| | ALL_DB_LINKS | Displays all DBLinks accessible to the current user. | | DBA_DB_LINKS | Displays all DBLinks created in the current tenant. | | USER_DB_LINKS | Displays the DBLinks created by the current user. |
Unsupported views
| View name | Description| |--|------------------------------------------------------------| | ALL_METHOD_PARAMS | Displays the method parameters of the object types accessible to the current user. | | ALL_SCHEDULER_JOB_ARGS| Displays the arguments of all scheduler jobs accessible to the current user. | | ALL_SCHEDULER_PROGRAM_ARGS | Displays the arguments of all scheduler programs accessible to the current user. | | ALL_TYPE_METHODS | Displays the methods of the object types accessible to the current user. | | DBA_METHOD_PARAMS | Displays the method parameters of the object types in the database. | | DBA_SCHEDULER_JOB_ARGS| Displays the arguments of all scheduler jobs in the database. | | USER_SCHEDULER_JOB_ARGS| Displays the arguments of scheduler jobs owned by the current user. | | DBA_SCHEDULER_PROGRAM_ARGS | Displays the arguments of all scheduler programs in the database. | | USER_SCHEDULER_PROGRAM_ARGS | Displays the arguments of scheduler programs owned by the current user. | | DBA_TYPE_METHODS | Displays the methods of all object types in the database. | | USER_TYPE_METHODS | Displays the methods of the object types accessible to the current user. Its columns are the same as those of the ALL_TYPE_METHODS view, except that it does not have the OWNER column. |
Performance views
Views related to ASH
| View name | Description |
|---|---|
| GV$OB_ACTIVE_SESSION_HISTORY | Displays the historical records of active sessions. |
Views related to statistics
| View name | Description| |--|------------------------------------------------------------| | GV$OB_KVCACHE| Displays information about the KVCache on each OBServer node. | | GV$OB_PARAMETERS | Displays the parameters on all OBServer nodes of the current tenant. | | GV$OB_SERVER_SCHEMA_INFO | Displays information about schemas on all OBServer nodes. | | V$OB_SERVER_SCHEMA_INFO | Displays information about schemas on all OBServer nodes. | | GV$OB_UNITS | Displays the information about the units on the OBServer nodes where the current tenant is located. You can view the units of all OBServer nodes in the current cluster from the sys tenant. | | GV$SYSSTAT | Displays the system-level statistical events on all OBServer nodes. | | GV$DML_STATS | Displays the information about the DML operations performed in the current user table. | | V$DML_STATS | Displays the information about the DML operations performed in the current user table. | | V$GLOBALCONTEXT | Displays the CLIENT_IDENTIFIER values of the global context attributes accessible to the current session. | | V$OB_KVCACHE | Displays information about the KVCache on each OBServer node. | | V$OB_PARAMETERS | Displays the parameters on the current OBServer node. | | V$SYSSTAT| Displays the system-level statistical events on the current OBServer node. | | V$OB_UNITS | Displays the information about the units on the current OBServer node. | | V$VERSION| Displays the names and versions of all components of the database. | | V$STATNAME| Displays the statistical items. |
Views related to instances
| View name | Description |
|---|---|
| GV$INSTANCE | Displays the status of the current database instance. |
| V$INSTANCE | Displays the status of the current database instance. |
Views related to memory
| View name | Description |
|---|---|
| GV$OB_MEMORY | Displays the memory usage of each tenant on all OBServer nodes. |
| GV$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on all OBServer nodes. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| GV$OB_SSTABLES | Displays the SSTables of tenants. |
| GV$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMORY | Displays the tenant-level memory statistics. |
| V$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on the current OBServer node. |
| V$OB_SSTABLES | Displays the SSTables 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. |
Views related to cache
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all OBServer nodes. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all OBServer nodes. |
| GV$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServer nodes. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current OBServer node. |
| V$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current OBServer node. |
| V$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServer nodes. |
| V$RSRC_PLAN | Displays the active resource management plans of the tenant. |
Views related to logs
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | Displays the Palf status information. |
| V$OB_LOG_STAT | Displays the Palf status information. |
Views related to 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 | Displays monitoring information about prepared statements, including the basic information about all prepared statements in the PS cache. |
| GV$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information about the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information about the DTL intermediate result manager. |
| V$OB_PX_TARGET_MONITOR | Displays the usage of PX threads on the OBServer node. |
| V$OB_PS_ITEM_INFO | Displays monitoring information about prepared statements, including the basic information about all prepared statements in the PS cache. |
| V$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| V$SQL_MONITOR_STATNAME | Displays the numbers in the OTHERSTAT_X_ID column of the GV$SQL_PLAN_MONITOR view. |
Views related to sessions
| View name | Description |
|---|---|
| GV$OB_PROCESSLIST | Displays the session information about all OBServer nodes of a tenant. |
| GV$SESSION_WAIT | Displays information about the current or last wait events of all sessions on all OBServer nodes, such as the event name and the amount of time spent on waiting. |
| GV$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on all OBServer nodes. |
| GV$SESSTAT | Displays the session-level statistics about all OBServer nodes. |
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$NLS_PARAMETERS | Displays session-level National Language Support (NLS) parameters. |
| V$OB_PROCESSLIST | Displays the session information about the current OBServer node. |
| V$SESSION_WAIT | Displays information about the current or last wait events of all sessions on the current OBServer node, such as the event name and the amount of time spent on waiting. |
| V$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on the current OBServer node. |
| V$SESSTAT | Displays the session-level statistics about the current OBServer node. |
| V$EVENT_NAME | Displays the wait events in the tenant. |
Views related to SQL statistics
| View name | Description |
|---|---|
| GV$OB_SQL_AUDIT | Displays the statistics of each SQL request on all OBServer nodes, such as the source and execution status. |
| V$OB_SQL_AUDIT | Displays the statistics about each SQL request on the current OBServer node, such as the source and execution status. |
| GV$SQL_PLAN_MONITOR | Displays plan-level statistics about slow queries on all OBServer nodes. Each slow query has one row in this view. It also records the trace information about the plan. |
| V$SQL_PLAN_MONITOR | Displays plan-level statistics about slow queries on all OBServer nodes. Each slow query has one row in this view. It also records the trace information about the plan. |
| GV$OB_FLT_TRACE_CONFIG | Displays information about end-to-end diagnostics. |
Views related to threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
| V$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
Views related to workareas
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workarea information about active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| V$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workarea information about active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas. |
Views related to transactions
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the progress of OBServer node-level compactions in the current tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of a tablet-level compaction. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays the information about the transaction participants on all OBServer nodes. |
| GV$SYSTEM_EVENT | Displays system wait events of tenants on all OBServer nodes, including the number of occurrences, wait time, and number of timeouts of each type of wait event. |
| GV$GLOBAL_TRANSACTION | Displays information about currently active global transactions. |
| V$OB_COMPACTION_PROGRESS | Displays the server-level compaction progress of tenants. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of a tablet-level compaction. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays information about the transaction participants on all OBServer nodes. |
| V$SYSTEM_EVENT | Displays system wait events of tenants on the current OBServer node, including the number of occurrences, wait time, and number of timeouts of each type of wait event. |
| V$GLOBAL_TRANSACTION | Displays information about currently 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 whose original scheduler is the current OBServer node. |
Views related to time zones
| View name | Description |
|---|---|
| V$TIMEZONE_NAMES | Displays the valid time zone names. |
Views related to encrypted tables
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables that have enabled encryption. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces that have enabled encryption. |
Views related to DBLinks
| View name | Description |
|---|---|
| GV$DBLINK | Displays all DBLinks (the links with IN_TRANSACTION set to YES) opened by the session that issues the query on this view. These DBLinks must be committed or rolled back before they are closed. |
| V$DBLINK | Displays all DBLinks (the links with IN_TRANSACTION set to YES) opened by the session that issues the query on this view. These DBLinks must be committed or rolled back before they are closed. |
Views related to SQL statistics
| View name | Description |
|---|---|
| GV$OB_SQLSTAT | Displays the basic performance statistics of SQL statements in the cluster. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
| V$OB_SQLSTAT | Displays the basic performance statistics of SQL statements on the current OBServer node. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
Views related to time models
| View name | Description |
|---|---|
| GV$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the cluster. |
| V$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the current OBServer node. |
| GV$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the cluster. |
| V$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the current OBServer node. |