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 | Provides 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 the 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 | Provides 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 | Provides 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 | Provides information about all OBServer nodes. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Provides information about the major compactions of zones. |
| oceanbase.DBA_OB_ZONES | Provides 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 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 | Provides information about the partition and subpartitions of an index. |
| oceanbase.DBA_PART_INDEXES | Provides information about partitions of all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | Provides 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 | Provides information about all subpartition templates. |
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. In a user tenant, this view displays the history in 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 tasks. |
| oceanbase.CDB_OB_RESTORE_HISTORY | Displays the states of physical restore tasks 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 jobs of 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 jobs of 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 jobs 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 tasks 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 JOB-level backup cleanup jobs that have been executed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | Provides information about the backup_set/backup_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 policy configured for cleanup upon expiration and automatic cleanup in the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | Provides 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 | Provides 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 policy configured for cleanup upon expiration and automatic cleanup in the 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 JOB-level backup cleanup jobs that have been executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Provides information about the backup_set/backup_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. |
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 | Provides 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 | Provides information about the resource pools of all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | Displays all unit-related jobs. |
| oceanbase.DBA_OB_UNITS | Provides information about the units of all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | Provides 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 | Provides 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 | Provides 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 | Provides information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Provides information about the partitions of a partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Provides 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 | Provides 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 | Provides 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. |
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 diagnostics. |
| 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 | Provides 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 | Provides information about the current or previous wait events of all sessions on all servers, 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 servers. |
| 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 | Provides 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 a tenant. |
| 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 diagnostics. |
| 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 | Provides 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 | Provides information about tenant-level statistical events on the current server. |
| 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 servers. |
| V$OB_MEMSTORE | Displays session-level MemStore statistics. |
| GV$OB_MEMSTORE_INFO | Displays details about MemTables in all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE_INFO | Displays details about MemTables in 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 servers. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all servers. |
| V$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current server. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current server. |
| 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 servers, such as the source and execution status. |
| V$OB_SQL_AUDIT | Displays the statistics about each SQL request on the current server, 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. |
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 | Provides 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 | Provides information about schemas on all servers. |
| GV$OB_SERVERS | Provides information about all OBServer nodes. |
| GV$OB_UNITS | Provides 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 | Provides 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 | Provides information about schemas on all servers. |
| V$OB_SERVERS | Provides information about the current OBServer node. |
| V$OB_UNITS | Provides information about the units on the current OBServer node. |
| GV$DML_STATS | Provides information about the DML operations performed in the current user table. |
| V$DML_STATS | Provides information about the DML operations performed in the current user table. |
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 | Provides information about the latches on each OBServer node in the cluster. |
| V$LATCH | Provides information about the latches on each OBServer node in the cluster. |
Views in a MySQL tenant
Dictionary views
Views related to the HELP command
| View name | Description |
|---|---|
| mysql.help_topic | mysql.help_topic is used to generate the HELP command in coordination with the following three tables: mysql.help_category, mysql.help_relation, and mysql.help_keyword. |
| mysql.help_category | mysql.help_category is used to generate the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_keyword. |
| mysql.help_category | mysql.help_category is used to generate the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_keyword. |
| mysql.help_keyword | mysql.help_keyword is used to generate the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_category. |
| mysql.help_relation | mysql.help_relation is used to generate the HELP command in combination with the following three tables: mysql.help_category, mysql.help_topic, and mysql.help_keyword. |
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 | Provides information about system-level privileges. |
| mysql.user | Provides information about user-level privileges. |
| information_schema.COLUMN_PRIVILEGES | Provides information about column privileges. |
| information_schema.SCHEMA_PRIVILEGES | Provides information about database privileges. |
| information_schema.TABLE_PRIVILEGES | Provides information about table privileges. |
| information_schema.USER_PRIVILEGES | Provides information about user privileges. |
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 | Provides information about stored procedures. |
| information_schema.ENGINES | Provides information about storage engines. |
| information_schema.PARAMETERS | Provides information about parameters and returns values for stored procedures. |
| information_schema.ROUTINES | Provides information about routines. |
Views related to time zones
| View name | Description |
|---|---|
| mysql.time_zone | Provides 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 | Provides information about time zone conversion types. It is a system view. |
Views related to character sets
| View name | Description |
|---|---|
| information_schema.CHARACTER_SETS | Provides information about character sets available in OceanBase Database. |
| information_schema.COLLATIONS | Provides information about collations for each character set. |
| information_schema.COLLATION_CHARACTER_SET_APPLICABILITY | Indicates what character set is applicable for what collation. |
Views related to tables and columns
| View name | Description |
|---|---|
| information_schema.COLUMNS | Provides information about columns in tables. |
| information_schema.STATISTICS | Provides information about table indexes. |
| information_schema.TABLES | Provides information about tables. |
| information_schema.VIEWS | Provides 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 the 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 | Provides 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 | Provides 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_ROOTSERVICE_EVENT_HISTORY | Displays the RootService event history. |
| oceanbase.DBA_OB_SERVER_JOBS | Displays all jobs related to OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | Provides information about all OBServer nodes. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Provides information about the major compactions of zones. |
| oceanbase.DBA_OB_ZONES | Provides information about all zones. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major compactions. |
Views related to partitions
| View name | Description |
|---|---|
| information_schema.PARTITIONS | Provides information about table partitions. |
| oceanbase.DBA_IND_PARTITIONS | Provides information about the partition and subpartitions of an index. |
| oceanbase.DBA_PART_INDEXES | Provides information about partitions of all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | Provides 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 | Provides information about all subpartition templates. |
Views related to threads
| View name | Description |
|---|---|
| information_schema.PROCESSLIST | Provides information about threads that are being executed. |
Views related to constraints
| View name | Description |
|---|---|
| information_schema.CHECK_CONSTRAINTS | Provides information about constraints on tables and columns when the CREATE TABLE operation is performed. |
| information_schema.KEY_COLUMN_USAGE | Provides information about key columns that have constraints. |
| information_schema.REFERENTIAL_CONSTRAINTS | Displays metadata of foreign key constraints. |
| information_schema.TABLE_CONSTRAINTS | Provides 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 | Provides information about session variables. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. In a user tenant, this view displays the history in the current tenant. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | Displays the event history on an OBServer node. |
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 jobs 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 tasks that have been completed. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Provides 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 policy configured for cleanup upon expiration and automatic cleanup in the 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 JOB-level backup cleanup jobs that have been executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Provides information about the backup_set/backup_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. |
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. |
| oceanbase.DBA_OB_TENANT_JOBS | Displays the tenant-level job information. |
Views related to resources
| View name | Description |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | Provides information about the resource pools of all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | Displays all unit-related jobs. |
| oceanbase.DBA_OB_UNITS | Provides information about the units of all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | Provides 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.DBA_IND_SUBPARTITIONS | Provides information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Provides information about the partitions of a partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Provides 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 | Provides 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. |
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 diagnostics. |
| 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 | Provides 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 | Provides information about the current or previous wait events of all sessions on all servers, 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 servers. |
| 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 | Provides 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 a tenant. |
| 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 diagnostics. |
| 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 | Provides 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 | Provides information about tenant-level statistical events on the current server. |
| 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 servers. |
| V$OB_MEMSTORE | Displays session-level MemStore statistics. |
| GV$OB_MEMSTORE_INFO | Displays details about MemTables in all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE_INFO | Displays details about MemTables in 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 servers. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all servers. |
| V$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current server. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current server. |
| 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 servers, such as the source and execution status. |
| V$OB_SQL_AUDIT | Displays the statistics about each SQL request on the current server, 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. |
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 | Provides 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 | Provides information about schemas on all servers. |
| GV$OB_SERVERS | Provides information about all OBServer nodes. |
| GV$OB_UNITS | Provides 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 | Provides 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 | Provides information about schemas on all servers. |
| V$OB_SERVERS | Provides information about the current OBServer node. |
| V$OB_UNITS | Provides information about the units on the current OBServer node. |
| GV$DML_STATS | Provides information about the DML operations performed in the current user table. |
| V$DML_STATS | Provides information about the DML operations performed in the current user table. |
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 | Provides information about the latches on each OBServer node in the cluster. |
| V$LATCH | Provides 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 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 comments on all columns of the tables and views accessible to the current user. |
| ALL_TABLES | Displays all tables accessible to the current user. |
| ALL_TAB_COLS | Displays all columns of the tables, views, and clusters accessible to the current user. |
| ALL_TAB_COLUMNS | Displays all columns of the tables, views, and clusters accessible to the current user. |
| ALL_TAB_COMMENTS | Displays comments on tables and views accessible to the current user. |
| DBA_COL_COMMENTS | Displays the comments on all columns of all tables and views in the database. |
| DBA_TAB_COMMENTS | Displays the comments on all tables and views in the database. |
| USER_COL_COMMENTS | Displays the comments on all columns of the tables and views owned by the current user. |
| USER_TAB_COMMENTS | Displays the comments on tables and views owned by the current user. |
| DBA_OB_TABLEGROUP_TABLES | Displays the associations 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 the 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 or partitions, including system tables, user tables, and index tables. |
Views related to outlines
| View name | Description |
|---|---|
| DBA_OB_OUTLINES | Provides 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 SQL Plan Management (SPM). |
Views related to general database information
| View name | Description |
|---|---|
| DBA_CONTEXT | Provides 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 | Provides 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 job-level 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 jobs in the current tenant. |
| DBA_OB_BACKUP_TASK_HISTORY | Displays the history of backup jobs 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 tasks that have been completed. |
| DBA_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| DBA_OB_BACKUP_STORAGE_INFO | Provides 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 policy configured for cleanup upon expiration and automatic cleanup in the 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 JOB-level backup cleanup jobs that have been executed in the tenant. |
| DBA_OB_BACKUP_DELETE_TASKS | Provides information about the backup_set/backup_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. |
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. |
| ALL_COL_PRIVS | Displays the column object grants 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. Displays the column 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 conditions 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, 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 of 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 | Provides information about function-based indexes accessible to the current user in the database. |
| ALL_IND_PARTITIONS | Provides information about index partitions accessible to the current user in the database. |
| ALL_IND_SUBPARTITIONS | Provides 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 | Provides information about all function-based indexes in the database. |
| DBA_IND_PARTITIONS | Provides information about all index partitions in the database. |
| DBA_IND_SUBPARTITIONS | Provides 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 | Provides information about function-based indexes owned by the current user in the database. |
| USER_IND_PARTITIONS | Provides 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 | Provides 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 | Provides 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 | Provides 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 | Provides 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 | Provides 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. In a user tenant, this view displays the history in 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 | Provides information about global variables. |
| TENANT_VIRTUAL_SESSION_VARIABLE | Provides 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 bin variables
| View name | Description |
|---|---|
| DBA_RECYCLEBIN | Provides information about all recycle bins in the database. |
| USER_RECYCLEBIN | Provides 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 | Provides 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 | Provides information about the partitions of a partitioned table group. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | Provides information about the subpartitions of a partitioned table group. |
| DBA_OB_TABLET_REPLICAS | Provides 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 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. |
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 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 statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | Provides 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 | Provides information about schemas on all servers. |
| V$OB_SERVER_SCHEMA_INFO | Provides information about schemas on all servers. |
| GV$OB_UNITS | Provides 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. |
| GV$SYSSTAT | Displays the system-level statistical events on all OBServer nodes. |
| GV$DML_STATS | Provides information about the DML operations performed in the current user table. |
| V$DML_STATS | Provides information about the DML operations performed in the current user table. |
| V$GLOBALCONTEXT | Displays the CLIENT_IDENTIFIER values of the global context attribute that can be accessed by the current session. |
| V$OB_KVCACHE | Provides information about the KV cache 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 | Provides information about the units on the current OBServer node. |
| V$VERSION | Displays the names and versions of all components of the database. |
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 servers. |
| 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 in all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE_INFO | Displays details about MemTables in 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 server. |
| 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 plan cache variables
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all servers. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all servers. |
| GV$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current server. |
| V$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current server. |
| V$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all servers. |
| 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 | Provides 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 servers. |
| 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 | Provides 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 servers, such as the source and execution status. |
| V$OB_SQL_AUDIT | Displays the statistics about each SQL request on the current server, 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. |
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 diagnostics. |
| 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 | Provides information about the transaction participants on all OBServer nodes. |
| GV$SYSTEM_EVENT | Displays system wait events of tenants on all servers, including the number of occurrences, wait time, and number of timeouts of each type of wait event. |
| GV$GLOBAL_TRANSACTION | Provides information about currently active global transactions. |
| V$OB_COMPACTION_PROGRESS | Displays the server-level compaction progress of a tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostics. |
| 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 | Provides 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 | Provides information about currently active global transactions. |
| GV$OB_GLOBAL_TRANSACTION | Provides information about all XA transactions in the cluster. |
| V$OB_GLOBAL_TRANSACTION | Provides 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. |