Overview of system views|V4.2.0|OceanBase Database| docs|Distributed Database

Overview of views in the SYS tenant

Dictionary views overview

View name	Description
oceanbase.CDB_IND_COLUMNS	Displays the column information of index tables of all tenants.
oceanbase.CDB_INDEXES	Displays the index information of all tenants.
oceanbase.CDB_TABLES	Displays the table information of all tenants.
oceanbase.CDB_OB_TABLEGROUP_TABLES	Displays the associations between table groups and tables of all tenants in the sys tenant. Tables not in a table group are not displayed.
oceanbase.CDB_TAB_COLS	Displays the column information of all tables and views of all tenants.
oceanbase.CDB_TAB_COLS_V$	Displays the column information of all tables and views of all tenants.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the associations between table groups and tables. Tables not in a table group are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key of all partitioned objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key of all subpartitioned objects in the database.
oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO	Displays the information about column checksum inconsistencies between index tables (including global indexes and local indexes) and primary tables.
oceanbase.CDB_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.

Outline

View name	Description
oceanbase.DBA_OB_OUTLINES	Displays the outline information of execution plans for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the outline information of concurrency limit rules for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the history of execution plans and concurrency limit rules for the current tenant.

Basic information about the database

View name	Description
oceanbase.CDB_OB_DATABASES	Displays the metadata of all tenants in the sys tenant.
oceanbase.CDB_OB_MAJOR_COMPACTION	Displays the global major compaction information of all tenants in the sys tenant.
oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of all zones of all tenants in the sys tenant.
oceanbase.DBA_OB_DATABASES	Displays the metadata of databases in the current tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information in the current tenant.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the event history of the Root Service.
oceanbase.DBA_OB_SERVER_JOBS	Displays the tasks on all OBServer nodes.
oceanbase.DBA_OB_SERVERS	Displays information about all OBServer nodes.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of all zones in the current tenant.
oceanbase.DBA_OB_ZONES	Displays information about all zones.
oceanbase.CDB_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).

Partitioning

View name	Description
oceanbase.CDB_IND_PARTITIONS	Displays the partition information of index tables of all tenants.
oceanbase.CDB_PART_INDEXES	Displays the partition information of index tables of all tenants.
oceanbase.CDB_PART_TABLES	Displays the partition information of partitioned tables of all tenants.
oceanbase.CDB_SUBPARTITION_TEMPLATES	Displays the template-based subpartition information of partitioned tables of all tenants.
oceanbase.CDB_TAB_PARTITIONS	Displays the partition information of partitioned tables of all tenants.
oceanbase.CDB_TAB_SUBPARTITIONS	Displays the subpartition information of partitioned tables of all tenants.
oceanbase.DBA_IND_PARTITIONS	Displays the partition and subpartition information of indexes.
oceanbase.DBA_PART_INDEXES	Displays the partition information of all indexes.
oceanbase.DBA_PART_TABLES	Displays the partition information of user tables.
oceanbase.DBA_TAB_PARTITIONS	Displays the partition, subpartition, storage parameters, and statistics of accessible multi-level partitioned tables of the current user.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the subpartition name, the table name, the partition name to which the subpartition belongs, the storage attributes of the subpartition, and the statistics generated by using the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays descriptions of all subpartition templates.

View name	Description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	Displays the history records of deadlocks. This view displays the history records of all tenants in the root tenant.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history records of deadlocks. This view displays the history records of the current tenant in a non-root tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	Displays the event history information of OBServer nodes.

View name	Description
oceanbase.CDB_OB_RESTORE_PROGRESS	Displays the progress of ongoing physical restore tasks.
oceanbase.CDB_OB_RESTORE_HISTORY	Displays the status of completed physical restore tasks.
oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.
oceanbase.CDB_OB_BACKUP_SET_FILES	Displays the status of files in backup sets.
oceanbase.CDB_OB_BACKUP_JOBS	Displays the backup jobs of all tenants in the cluster. A backup job record is generated after a backup job is initiated.
oceanbase.CDB_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs of all tenants in the cluster.
oceanbase.CDB_OB_BACKUP_TASKS	Displays the backup tasks of all tenants in the cluster. A backup task record is generated for each backup set. A backup task record corresponds to a backup job record on a one-to-one basis.
oceanbase.CDB_OB_BACKUP_TASK_HISTORY	Displays the history of backup tasks of all tenants in the cluster.
oceanbase.DBA_OB_BACKUP_JOBS	Displays the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the history of backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the history of backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the status of files in backup sets.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays the ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays the completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
oceanbase.CDB_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
oceanbase.CDB_OB_BACKUP_PARAMETER	Displays the backup parameters.
oceanbase.CDB_OB_BACKUP_DELETE_JOBS	Displays the progress of tenant-level backup deletion jobs.
oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of completed backup deletion jobs in the current tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS	Displays the information about backup set or piece deletion tasks that are being executed in the current tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of completed backup set or piece deletion tasks in the current tenant.
oceanbase.CDB_OB_BACKUP_DELETE_POLICY	Displays the deletion policies set for expired data deletion and automatic data deletion in the current tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore in the current tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations used for backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations used for backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the deletion policies set for expired data deletion and automatic data deletion in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the progress of tenant-level backup deletion jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of completed backup deletion jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays the information about backup set or piece deletion tasks that are being executed in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of completed backup set or piece deletion tasks in the current tenant.
oceanbase.DBA_OB_ARCHIVELOG	Displays the status of log backup for each archive path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all log backups in history and currently.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.
oceanbase.CDB_OB_ARCHIVELOG	Displays the status of log archiving for each archive path.
oceanbase.CDB_OB_ARCHIVELOG_SUMMARY	Displays the status of all log archivings in history and currently.

Statistics and histograms

View name	Description
oceanbase.DBA_TAB_STATISTICS	Displays optimizer statistics for all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays column statistics and histograms for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays column statistics and histograms for all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays column statistics and histograms for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays histograms for all columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays histogram endpoint data for all partitions of all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays histogram endpoint data for all subpartitions of all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	Displays table statistics history for all tables in the database.
oceanbase.DBA_IND_STATISTICS	Displays optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the modification information of all tables in the database since the last time statistics were collected for the tables.
oceanbase.CDB_TAB_COL_STATISTICS	Displays column-level statistics in the sys tenant.

View name	Description
oceanbase.DBA_OBJECTS	Displays all database objects in the database. The view definition is the same as that of ALL_OBJECTS.
oceanbase.CDB_OBJECTS	Displays the objects of all tenants in the sys tenant.
oceanbase.DBA_OB_TENANTS	Displays basic information about all tenants, including the sys tenant, user tenants, and meta tenants. You can filter the tenants by `TENANT_TYPE`.
oceanbase.DBA_OB_TENANT_JOBS	Displays information about tenant-level scheduled jobs.
oceanbase.CDB_OB_SYS_VARIABLES	Displays the system variables of all tenants in the sys tenant.

View name	Description
oceanbase.DBA_OB_RESOURCE_POOLS	Displays information about all resource pools of tenants.
oceanbase.DBA_OB_UNIT_JOBS	Displays information about all UNIT-related tasks.
oceanbase.DBA_OB_UNITS	Displays information about all units of tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	Displays the specifications of all units of tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.

View name	Description
oceanbase.CDB_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.CDB_OB_LS_LOCATIONS	Displays the distribution of log stream (LS) replicas for all tenants.
oceanbase.CDB_OB_TABLEGROUPS	Displays the metadata of all table groups in the sys tenant, including the partition information of the table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	Displays the primary partitions of all partitioned table groups in the sys tenant.
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartitions of all partitioned table groups in the sys tenant.
oceanbase.CDB_OB_TABLET_TO_LS	Displays the tables and the LS to which each tablet belongs in the sys tenant.
oceanbase.CDB_OB_TABLET_REPLICAS	Displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: `<TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.CDB_PART_KEY_COLUMNS	Displays the primary partitioning keys of partitioned objects (partitioned tables and partitioned indexes) in all tenants.
oceanbase.CDB_SUBPART_KEY_COLUMNS	Displays the subpartitioning keys of partitioned objects (partitioned tables and partitioned indexes) in all tenants.
oceanbase.DBA_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the primary partitions of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartitions of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUPS	Displays the metadata of table groups, including the partition information of the table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	Displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	Displays the tables and the LS to which each tablet belongs in the current tenant.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the distribution of log stream (LS) replicas for the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO	Displays information about data inconsistencies between tablet replicas.
oceanbase.CDB_OB_LS	Displays the status and restore progress of log streams.
oceanbase.DBA_OB_LS	Displays the status and restore progress of log streams.

Overview of the performance view

View name	Description
GV$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of each OBServer node in the tenant.
GV$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
GV$OB_PROCESSLIST	Displays the session information of all OBServer nodes in the tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the history information of tablet-level major compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level major compactions.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participant information of all OBServer nodes.
GV$SESSION_EVENT	Displays the wait events of sessions on all OBServer nodes in the cluster.
GV$SESSION_WAIT	Displays the name and duration of the current or last wait event of all sessions on all servers.
GV$SESSION_WAIT_HISTORY	Displays the names and durations of the last 10 wait events of all sessions on all servers.
GV$SYSTEM_EVENT	Displays the tenant-level wait events of all tenants in the cluster.
GV$SESSTAT	Displays the statistical events of sessions on all OBServer nodes.
GV$SYSSTAT	Displays the tenant-level statistical events on all servers.
GV$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of each OBServer node in the tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
V$OB_TABLET_COMPACTION_HISTORY	Displays the history information of tablet-level major compactions.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level major compactions.
V$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participant information of all OBServer nodes.
V$STATNAME	Displays the definitions of all statistical events.
V$EVENT_NAME	Displays the definitions of all statistical events on the current OBServer node.
V$SESSION_WAIT	Displays the details of the current wait event of each session. According to the convention, each wait event has three parameters, and the values of these parameters are recorded.
V$SESSION_WAIT_HISTORY	Displays the details of the current wait event of each session and the last 10 wait events of each session.
V$SESSTAT	Displays the statistical events of sessions.
V$SYSSTAT	Displays the tenant-level statistical events on the current server.
V$SYSTEM_EVENT	Displays the tenant-level wait events.
GV$SESSION_LONGOPS	Displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	Displays the execution status and progress of DDL operations on the current OBServer node.

View name	Description
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.

View name	Description
GV$OB_IO_CALIBRATION_STATUS	Displays the execution status of I/O calibration tasks.
V$OB_IO_CALIBRATION_STATUS	Displays the execution status of I/O calibration tasks.
GV$OB_IO_BENCHMARK	Displays the calibration data of disks used by the I/O module.
V$OB_IO_BENCHMARK	Displays the calibration data of disks used by the I/O module.

View name	Description
GV$OB_MEMORY	Displays memory statistics at the tenant level.
V$OB_MEMORY	Displays memory statistics at the tenant level.
GV$OB_MEMSTORE	Displays the memory usage of MemTables on all servers and tenants.
V$OB_MEMSTORE	Displays the statistics of MemStores at the tenant level.
GV$OB_MEMSTORE_INFO	Displays detailed information about MemTables in all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays detailed information about MemTables in all partitions of all tenants on all servers.
GV$OB_SSTABLES	Displays the information about SSTables of a tenant.
V$OB_SSTABLES	Displays the information about SSTables of a tenant.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in a cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

View name	Description
GV$OB_PLAN_CACHE_STAT	Displays the overall status of each plan cache on all OBServer nodes of the current tenant.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers of the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan caches on all servers of the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in all plan caches on all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache.
GV$OB_PS_ITEM_INFO	Provides monitoring functionality for prepared statements. It contains basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Provides monitoring functionality for prepared statements. It contains basic information about all prepared statements in the PS cache.
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on OBServer nodes.
GV$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	Displays the statistics of slow queries on all OBServer nodes from the plan level. Each slow query has a statistics record, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	Displays the statistics of operations in slow queries on the current server. Each operation has a statistics record.
V$SQL_MONITOR_STATNAME	Describes the meanings of numbers in the `OTHERSTAT_X_ID` field of the `GV$SQL_PLAN_MONITOR` view.

View name	Description
GV$OB_LOG_STAT	Displays the status of the PALF.
V$OB_LOG_STAT	Displays the status of the PALF.

View name	Description
GV$OB_RPC_OUTGOING	Displays the statistics of outgoing RPCs on all OBServer nodes.
GV$OB_RPC_INCOMING	Displays the statistics of RPC requests received by all OBServer nodes.
V$OB_RPC_OUTGOING	Statistics of outgoing RPC data on different tenants of different RPC packet codes on OBServer nodes.
V$OB_RPC_INCOMING	Statistics of incoming RPC data on different tenants of different RPC packet codes on OBServer nodes.

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes in the tenant.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_SERVERS	Displays information about all OBServer nodes.
GV$OB_UNITS	Displays the unit information on the OBServer node where the tenant resides. You will see the unit information on all OBServer nodes in the cluster if you are using the sys tenant.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the parameter information on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_SERVERS	Displays information about the current OBServer node.
V$OB_UNITS	Displays the unit information on the current OBServer node.
GV$DML_STATS	Displays the DML information in the current user table.
V$DML_STATS	Displays the DML information in the current user table.

View name	Description
GV$OB_MERGE_INFO	Displays statistics about minor compactions completed in the OceanBase cluster.
V$OB_MERGE_INFO	Displays statistics about minor compactions completed in the OceanBase cluster.

View name	Description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, displays the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, displays the execution information of each thread.

View name	Description
GV$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
GV$SQL_WORKAREA_HISTOGRAM	Statistics of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of one-pass operations.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Queries overall statistics of SQL workareas, such as the maximum available memory, the current memory usage, and the memory held.
V$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
V$SQL_WORKAREA_HISTOGRAM	Statistics of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of one-pass operations.
V$OB_SQL_WORKAREA_MEMORY_INFO	Queries overall statistics of SQL workareas, including the maximum available memory, the current memory usage, and the memory held.

Statistics on encrypted tables

View name	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables with the encryption feature enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces with the encryption feature enabled.

Statistics on transactions

View name	Description
GV$LATCH	The latch information of all OBServer nodes in the cluster.
V$LATCH	The latch information of all OBServer nodes in the cluster.

Overview of views in a MySQL tenant

Dictionary views overview

Help command

View name	Description
mysql.help_topic	Works with the other three tables `mysql.help_category`, `mysql.help_relation`, and `mysql.help_keyword` to generate the Help command.
mysql.help_category	Works with the other three tables `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_keyword` to generate the Help command.
mysql.help_keyword	Works with the other three tables `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_category` to generate the Help command.
mysql.help_relation	Works with the other three tables `mysql.help_category`, `mysql.help_topic`, and `mysql.help_keyword` to generate the Help command.

View name	Description
oceanbase.DBA_SQL_PLAN_BASELINES	Displays the plan baselines of SQL statements in SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

View name	Description
mysql.db	Displays database-level privileges (VIRTUAL_TABLE).
mysql.user	Records user-level privileges (VIRTUAL_TABLE).
information_schema.COLUMN_PRIVILEGES	Displays column privileges.
information_schema.SCHEMA_PRIVILEGES	Describes database privileges.
information_schema.TABLE_PRIVILEGES	Records table privileges.
information_schema.USER_PRIVILEGES	Records user privileges.

Scheduler

View name	Description
oceanbase.DBA_SCHEDULER_JOBS	Displays information about all scheduled jobs in the database.

View name	Description
mysql.proc	Displays information about stored procedures.
information_schema.ENGINES	Records information about storage engines.
information_schema.PARAMETERS	Provides information about parameters and return values of stored procedures.
information_schema.ROUTINES	Provides information about stored procedures.

View name	Description
mysql.time_zone	Displays time zone-related information (SYSTEM_VIEW).
mysql.time_zone_name	Records the names of time zones (SYSTEM_VIEW).
mysql.time_zone_transition	The `mysql.time_zone_transition` view records the time zone transition information.
mysql.time_zone_transition_type	Provides information about the types of time zone transitions (SYSTEM_VIEW).

Character sets

View name	Description
information_schema.CHARACTER_SETS	Records the character sets supported by OceanBase Database.
information_schema.COLLATIONS	Records the collation methods for each character set.
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY	Records the correspondences between character sets and collations.

Tables and columns

View name	Description
information_schema.COLUMNS	Records information about columns.
information_schema.STATISTICS	Records information about indexes of tables.
information_schema.TABLES	Records information about tables.
information_schema.VIEWS	Records information about views.
information_schema.VIEW_TABLE_USAGE	Displays information about tables and views used in view definitions.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the relationship between table groups and tables. Tables not belonging to any table group are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key in all partitioned objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key in all subpartitioned objects in the database.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.

Outline

View name	Description
oceanbase.DBA_OB_OUTLINES	Displays the outline information of execution plans for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the outline information of concurrency limit rules for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the history information of execution plans and concurrency limit rules outlines for the current tenant.

Basic information about the database

View name	Description
information_schema.GLOBAL_STATUS	Records the global status information of OceanBase Database.
information_schema.GLOBAL_VARIABLES	Records the global variables.
information_schema.SCHEMATA	Records the metadata of the database.
oceanbase.DBA_OB_DATABASES	Displays the metadata of the tenant's databases.
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information of the tenant.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the event history of the Root Service.
oceanbase.DBA_OB_SERVER_JOBS	Displays the related tasks of all OBServer nodes.
oceanbase.DBA_OB_SERVERS	Displays the information of all OBServer nodes.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of each zone of the tenant.
oceanbase.DBA_OB_ZONES	Displays the information of all zones.
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).

View name	Description
information_schema.PARTITIONS	Records information about partitions.
oceanbase.DBA_IND_PARTITIONS	Displays information about the partitions and subpartitions of indexes.
oceanbase.DBA_PART_INDEXES	Displays information about all partitions of indexes.
oceanbase.DBA_PART_TABLES	Displays partition information of user tables.
oceanbase.DBA_TAB_PARTITIONS	Displays the multi-partition information, storage parameters, and statistics of partitions that the current user has access to.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the names of subpartitions, the names of tables to which the subpartitions belong, and the names of the partitions to which the subpartitions belong. It also displays the storage attributes of subpartitions and the statistics generated by the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays descriptions of all subpartition templates.

Threads

View name	Description
information_schema.PROCESSLIST	Provides information about running threads.

Constraints

View name	Description
information_schema.CHECK_CONSTRAINTS	Displays the constraints on tables and columns when you execute the `CREATE TABLE` statement.
information_schema.KEY_COLUMN_USAGE	Records the key constraints on columns.
information_schema.REFERENTIAL_CONSTRAINTS	Displays the metadata of foreign key constraints.
information_schema.TABLE_CONSTRAINTS	Describes table constraints.

View name	Description
information_schema.SESSION_STATUS	Records the status information of sessions, such as the number of current active connections and the uptime of the database.
information_schema.SESSION_VARIABLES	Records the variables of sessions.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history records of deadlocks. This view displays the history records of the current tenant in a non-root tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	Displays the event history information of OBServer nodes.

View name	Description
information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS	Displays the number of failed login attempts for each user.

View name	Description
oceanbase.DBA_OB_BACKUP_JOBS	Displays the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the history records of the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the history records of the backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the status of backup sets.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays the ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays the completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the historical information about backup destinations used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies, such as automatic and expiration cleanup, set for the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of the tenant-level backup cleanup jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history information of the backup cleanup jobs executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays the information about backup_set or backup_piece cleanup tasks being executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the historical information about backup_set or backup_piece cleanup tasks completed in the tenant.
oceanbase.DBA_OB_ARCHIVELOG	Displays the status of log backup for each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all log backups in history and currently.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.

Statistics and histograms

View name	Description
oceanbase.DBA_TAB_STATISTICS	Displays optimizer statistics for all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays column statistics and histograms for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays column statistics and histograms for all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays column statistics and histograms for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays histograms for all columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays the endpoint data of histograms for all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays the endpoint data of histograms for all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	Displays the statistics history for all tables in the database.
oceanbase.DBA_IND_STATISTICS	Displays optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the modification information of all tables in the database since the last time statistics were collected for these tables.
information_schema.QUERY_RESPONSE_TIME	Displays data types (Histogram) such as the response time histogram for Prometheus monitoring.

View name	Description
oceanbase.DBA_OBJECTS	Displays all database objects in the database. The view definition is the same as that of ALL_OBJECTS.
oceanbase.DBA_OB_TENANTS	Displays basic information about all tenants, including system tenants, user tenants created by users, and meta tenants. You can filter the tenants by type using the `TENANT_TYPE` column.
oceanbase.DBA_OB_TENANT_JOBS	Displays information about tenant-level scheduled jobs.

View name	Description
oceanbase.DBA_OB_RESOURCE_POOLS	Displays information about all resource pools of all tenants.
oceanbase.DBA_OB_UNIT_JOBS	Displays information about all UNIT-related tasks.
oceanbase.DBA_OB_UNITS	Displays information about all units of all tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	Displays the specifications of all units of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.

View name	Description
oceanbase.DBA_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the primary partitions of table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartitions of table groups.
oceanbase.DBA_OB_TABLEGROUPS	Displays the metadata of table groups, including the partition information of table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	Displays information about all tablet replicas in the tenant. Each tablet replica is uniquely identified by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	Displays the tablets and the log streams to which they belong in the tenant.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the distribution of log stream (LS) replicas in the tenant.

Overview of the performance view

View name	Description
GV$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of each tenant on OBServer nodes.
GV$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
GV$OB_PROCESSLIST	Displays the session information on all OBServer nodes of a tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level major compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level major compactions.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
GV$SESSION_EVENT	Displays the wait events of all sessions on OBServer nodes in the cluster.
GV$SESSION_WAIT	Displays information about the current or last wait event of each session on all servers, including the name and duration of the wait event.
GV$SESSION_WAIT_HISTORY	Displays information about the last 10 wait events of each session on all servers.
GV$SYSTEM_EVENT	Displays the tenant-level wait events of all tenants in the cluster.
GV$SESSTAT	Displays the statistics of wait events at the session level on all OBServer nodes.
GV$SYSSTAT	Displays the statistics of wait events at the tenant level on all servers.
GV$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of each tenant on OBServer nodes.
V$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
V$OB_PROCESSLIST	Displays the session information on the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
V$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level major compactions.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level major compactions.
V$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
V$STATNAME	Displays definitions of all statistics events.
V$EVENT_NAME	Displays definitions of all statistics events on the current OBServer node.
V$SESSION_WAIT	Displays details of the current wait event for each session. According to the convention, each wait event has three parameters, and the values of these parameters are recorded.
V$SESSION_WAIT_HISTORY	Displays details of the current wait event for each session and the last 10 wait events.
V$SESSTAT	Displays the statistics of wait events at the session level.
V$SYSSTAT	Displays the statistics of wait events at the tenant level on the current server.
V$SYSTEM_EVENT	Displays the tenant-level wait events.
GV$SESSION_LONGOPS	Displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	Displays the execution status and progress of DDL operations on the current OBServer node.

View name	Description
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.

View name	Description
GV$OB_MEMORY	Displays memory statistics at the tenant level.
V$OB_MEMORY	Displays memory statistics at the tenant level.
GV$OB_MEMSTORE	Displays the memory usage of MemTables on all servers and tenants.
V$OB_MEMSTORE	Displays the statistics of MemStores at the tenant level.
GV$OB_MEMSTORE_INFO	Displays details about MemTables of all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays details about MemTables of all partitions of all tenants on all servers.
GV$OB_SSTABLES	Displays the information about SSTables of a tenant.
V$OB_SSTABLES	Displays the information about SSTables of a tenant.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

View name	Description
GV$OB_PLAN_CACHE_STAT	Displays the outline information of the current tenant, which is mainly used for outline migration.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers of the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan caches on all servers of the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in all servers' plan caches.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache.
GV$OB_PS_ITEM_INFO	Provides monitoring functionality for prepared statements and contains basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Provides monitoring functionality for prepared statements and contains basic information about all prepared statements in the PS cache.
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on the current OBServer node.
GV$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	Displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistic record, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	Displays the operation-level statistics of slow queries. Each operation has a corresponding statistic record.
V$SQL_MONITOR_STATNAME	Describes the meaning of numbers in the `OTHERSTAT_X_ID` field of the `GV$SQL_PLAN_MONITOR` view.

View name	Description
GV$OB_LOG_STAT	Displays the status of the PALF.
V$OB_LOG_STAT	Displays the status of the PALF.

View name	Description
GV$OB_RPC_OUTGOING	Statistics on RPCs sent by all OBServer nodes.
GV$OB_RPC_INCOMING	Statistics on RPC requests received by all OBServer nodes.
V$OB_RPC_OUTGOING	Statistics on RPC data sent by all tenants on the OBServer node for different RPC packet codes.
V$OB_RPC_INCOMING	Statistics on RPC data received by different tenants on the OBServer node for different RPC packet codes.

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes within the tenant.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_UNITS	Displays the unit information on the OBServer node where the tenant resides. System tenant users can view the units of all OBServer nodes in the cluster.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the parameter information on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_UNITS	Displays the unit information on the current OBServer node.
GV$DML_STATS	Displays the DML information in the current user table.
V$DML_STATS	Displays the DML information in the current user table.

View name	Description
GV$OB_MERGE_INFO	Displays statistics on minor compactions completed in the OceanBase cluster.
V$OB_MERGE_INFO	Displays statistics on minor compactions completed in the OceanBase cluster.

View name	Description
GV$OB_PX_WORKER_STAT	Displays the execution information of each thread in parallel execution scenarios.
V$OB_PX_WORKER_STAT	Displays the execution information of each thread in parallel execution scenarios.

View name	Description
GV$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
GV$SQL_WORKAREA_HISTOGRAM	Statistics of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of one-pass operations.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Queries overall statistics of SQL workareas, such as the maximum available memory, the current memory usage, and the current held memory.
V$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
V$SQL_WORKAREA_HISTOGRAM	Statistics of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of one-pass operations.
V$OB_SQL_WORKAREA_MEMORY_INFO	Queries overall statistics of SQL workareas, including the maximum available memory, the current memory usage, and the current held memory.

Statistics on encrypted tables

View name	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables with the encryption feature enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces with the encryption feature enabled.

Statistics on transactions

View name	Description
GV$LATCH	The latch information of all OBServer nodes in the cluster.
V$LATCH	The latch information of all OBServer nodes in the cluster.

Overview of views in an Oracle tenant

Overview

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.

Tables and views

View name	Description
ALL_ALL_TABLES	Displays the object tables and relational tables that the user has access to.
ALL_COL_COMMENTS	Displays the comments on all columns of the views and tables that the user has access to.
ALL_TABLES	Displays all tables that the user has access to.
ALL_TAB_COLS	Displays all columns of the tables, views, and clusters that the user has access to.
ALL_TAB_COLUMNS	Displays all columns of the tables, views, and clusters that the user has access to.
ALL_TAB_COMMENTS	Displays the comments on the tables and views that the user has access to.
DBA_COL_COMMENTS	Displays the comments on all columns of all views and tables in the database.
DBA_TAB_COMMENTS	Displays the comments on all tables and views in the database.
USER_COL_COMMENTS	Displays the comments on all columns of the views and tables that the user owns.
USER_TAB_COMMENTS	Displays the comments on the tables and views that the user owns.
DBA_OB_TABLEGROUP_TABLES	Displays the relationships between tables and table groups. Tables not in a table group are not displayed.
DBA_TABLES	Displays all tables in the database.
DBA_ALL_TABLES	Displays the object tables and relational tables in the database. The fields are the same as those in ALL_ALL_TABLES.
DBA_TABLESPACES	Displays all tablespaces in the database.
DBA_TAB_COLS	Displays all columns of all tables, views, and clusters in the database.
DBA_TAB_COLUMNS	Displays all columns of all tables, views, and clusters in the database.
USER_ALL_TABLES	Displays the object tables and relational tables that the user has access to, except the OWNER field. The other fields are the same as those in ALL_ALL_TABLES.
USER_TABLES	Displays all tables that the user owns.
USER_TABLESPACES	Displays the tablespaces that the user can access. The columns are the same as those in `DBA_TABLESPACES`, with the `PLUGGED_IN` column removed.
USER_TAB_COLS	Displays all columns of the tables, views, and clusters that the user owns.
USER_TAB_COLUMNS	Displays all columns of the tables, views, and clusters that the user owns.
ALL_VIEWS	Displays the views that the user has access to.
DBA_VIEWS	Displays all views in the database. The columns are the same as those in `ALL_VIEWS`.
USER_VIEWS	Displays the views that the user owns.
DICTIONARY	Displays the descriptions of dictionary tables and views.
DICT	Displays the descriptions of dictionary tables and views.
DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.

Outline

View name	Description
DBA_OB_OUTLINES	Displays the outline information of execution plans in the current tenant.
DBA_OB_CONCURRENT_LIMIT_SQL	Displays the outline-related information of throttling rules in the current tenant.
DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the outline information of execution plans and throttling rules in the current tenant.

SPM

View name	Description
DBA_SQL_PLAN_BASELINES	Displays the plan baselines of SQL statements in SPM.
DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

Database information

View name	Description
DBA_CONTEXT	Displays information about all context namespaces in the database.
DBA_OB_DATABASES	Displays metadata about the databases of the tenant.
DBA_OB_MAJOR_COMPACTION	Displays global information about major compactions in the tenant.
DBA_OB_ZONE_MAJOR_COMPACTION	Displays information about major compactions in each zone of the tenant.
ALL_OBJECTS	Displays all database objects that the user has access to.
DBA_OBJECTS	Displays all database objects in the database.
USER_OBJECTS	Displays all database objects owned by the user.
ALL_DEPENDENCIES	Displays the dependencies among all objects in the database.
DBA_DEPENDENCIES	Displays all dependencies among objects in the database.
USER_DEPENDENCIES	Displays the dependencies among objects in the user's schema.
DBA_OB_FREEZE_INFO	Displays version information generated by major compactions (major_freeze).

Functions and procedures

View name	Description
ALL_ARGUMENTS	Displays the parameters of the functions and procedures that the current user can access.
ALL_PROCEDURES	Displays all the functions and procedures that the current user can access, along with their related attributes.
ALL_SOURCE	Displays the text source code of the storage objects that the current user can access.
DBA_ARGUMENTS	Displays the parameters of the functions and procedures available in the database. The columns are the same as those in the `ALL_ARGUMENTS` view.
DBA_PROCEDURES	Displays all the functions and procedures available in the database, along with their related attributes. The columns are the same as those in the `ALL_PROCEDURES` view.
DBA_SOURCE	Displays the text source code of all the storage objects in the database. The columns are the same as those in the `ALL_SOURCE` view.
USER_ARGUMENTS	Displays the parameters of the functions and procedures that the current user owns. The columns are the same as those in the `ALL_ARGUMENTS` view, excluding the `OWNER` column.
USER_PROCEDURES	Displays all the functions and procedures that the current user owns, along with their related attributes. The columns are the same as those in the `ALL_PROCEDURES` view, excluding the `OWNER` column.
USER_SOURCE	Displays the text source code of the storage objects that the current user owns. The columns are the same as those in the `ALL_SOURCE` view, excluding the `OWNER` column.
DBA_JOBS	Displays a summary of the tasks that have been committed.
USER_JOBS	Displays a summary of the tasks that have been committed.
DBA_JOBS_RUNNING	Displays the running tasks.

View name	Description
DBA_OB_BACKUP_JOBS	Displays the backup jobs of the current tenant.
DBA_OB_BACKUP_JOB_HISTORY	Displays the history records of the backup jobs of the current tenant.
DBA_OB_BACKUP_TASKS	Displays the backup tasks of the current tenant.
DBA_OB_BACKUP_TASK_HISTORY	Displays the history records of the backup tasks of the current tenant.
DBA_OB_BACKUP_SET_FILES	Displays the status of files in backup sets.
DBA_OB_RESTORE_PROGRESS	Displays the ongoing restore tasks.
DBA_OB_RESTORE_HISTORY	Displays the completed restore tasks.
DBA_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore in the current tenant.
DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the historical information about backup destinations used for backup and restore in the current tenant.
DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies set for automatic or periodic cleanup of expired data in the current tenant.
DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of the backup cleanup jobs at the tenant level.
DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history information of the backup cleanup jobs executed in the current tenant.
DBA_OB_BACKUP_DELETE_TASKS	Displays the information about backup_set or backup_piece cleanup tasks being executed in the current tenant.
DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history information of the backup_set or backup_piece cleanup tasks completed in the current tenant.
DBA_OB_ARCHIVELOG	Displays the backup status of logs on each path.
DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all log backups in history and currently.
DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.
DBA_OB_BACKUP_PARAMETER	Displays the backup parameters.

Statistics and histograms

View name	Description
ALL_PART_COL_STATISTICS	Displays the column statistics and histogram information of the partitions of the tables that the current user has access to.
ALL_PART_HISTOGRAMS	Displays the histogram information of all partitions.
ALL_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information of the subpartitions of the tables that the current user has access to.
ALL_SUBPART_HISTOGRAMS	Displays the histogram information of all subpartitions.
ALL_TAB_COL_STATISTICS	Displays the column statistics and histogram information of the tables that the current user has access to.
ALL_TAB_HISTOGRAMS	Displays the histogram information of all tables.
ALL_TAB_STATISTICS	Displays the optimizer statistics of the tables that the current user has access to.
DBA_PART_COL_STATISTICS	Displays the column statistics and histogram information of the partitions of the tables in the database.
DBA_PART_HISTOGRAMS	Displays the histogram information of the partitions of the tables in the current database.
DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information of the subpartitions of the tables in the database.
DBA_SUBPART_HISTOGRAMS	Displays the histogram information of the subpartitions of the tables in the current database.
DBA_TAB_COL_STATISTICS	Displays the column statistics and histogram information of all tables in the database.
DBA_TAB_HISTOGRAMS	Displays the histogram information of all tables in the current database.
DBA_TAB_STATISTICS	Displays the optimizer statistics of all tables in the database.
USER_PART_COL_STATISTICS	Displays the column statistics and histogram information of the partitions of the tables that the current user owns.
USER_PART_HISTOGRAMS	Displays the histogram information of the partitions of the tables that the current user owns.
USER_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information of the subpartitions of the tables that the current user owns.
USER_SUBPART_HISTOGRAMS	Displays the histogram information of the subpartitions of the tables that the current user owns.
USER_TAB_COL_STATISTICS	Displays the column statistics and histogram information of the tables that the current user owns.
USER_TAB_HISTOGRAMS	Displays the histogram information of the tables that the current user owns.
USER_TAB_STATISTICS	Displays the optimizer statistics of the tables that the current user owns.
ALL_TAB_STATS_HISTORY	Displays the modification history of the statistics of all tables that the current user has access to.
DBA_TAB_STATS_HISTORY	Displays the modification history of the statistics of all tables in the database.
USER_TAB_STATS_HISTORY	Displays the modification history of the statistics of all tables that the current user owns.
ALL_IND_STATISTICS	Displays the optimizer statistics of the indexes of the tables that the current user has access to.
DBA_IND_STATISTICS	Displays the optimizer statistics of all indexes in the database.
USER_IND_STATISTICS	Displays the optimizer statistics of the indexes of the tables that the current user owns.
ALL_TAB_MODIFICATIONS	Displays the modification information of the tables that the current user has access to since the last time statistics were collected on these tables.
DBA_TAB_MODIFICATIONS	Displays the modification information of all tables in the database since the last time statistics were collected on these tables.
USER_TAB_MODIFICATIONS	Displays the modification information of the tables that the current user owns since the last time statistics were collected on these tables.

Users and privileges

View name	Description
ALL_USERS	Displays all database users visible to the current user.
DBA_USERS	Displays all users of the database.
ALL_COL_PRIVS	Displays the column privileges of the current user on objects that the user owns, has been granted privileges on, or has granted privileges on. Column privileges on objects that have been granted to the PUBLIC role are also displayed.
ALL_TAB_PRIVS	Displays the object privileges of the current user on objects that the user owns, has been granted privileges on, or has been granted privileges on. Object privileges on objects that have been granted to the PUBLIC role are also displayed.
DBA_COL_PRIVS	Displays all column privileges granted in the database.
DBA_SYS_PRIVS	Displays the system privileges granted to users and roles.
DBA_TAB_PRIVS	Displays all object privileges granted in the database.
USER_TAB_PRIVS	Displays the object privileges of the current user on objects that the user owns or has been granted privileges on.
USER_COL_PRIVS	Displays the column privileges of the current user on objects that the user owns, has been granted privileges on, or has granted privileges on.
USER_ROLE_PRIVS	Displays the roles granted to the current user.
USER_SYS_PRIVS	Displays the system privileges granted to the current user.
ROLE_TAB_PRIVS	Displays the table privileges of roles granted to the current user. Only information about roles accessible to the user is provided.
ROLE_SYS_PRIVS	Displays the system privileges of roles granted to the current user.
ROLE_ROLE_PRIVS	Displays the roles that grant privileges to other roles. Only information about roles accessible to the user is provided.
DBA_ROLE_PRIVS	Displays the roles granted to all users and the roles in the database.
DBA_ROLES	Displays all roles in the database.
ALL_DIRECTORIES	Displays all directories accessible to the current user.
DBA_DIRECTORIES	Displays all directories accessible to the current user.

Views

View name	Description
ALL_CONSTRAINTS	Displays the constraints of all tables accessible to the user.
ALL_CONS_COLUMNS	Displays the columns of all constraints of all tables accessible to the user.
DBA_CONSTRAINTS	Displays the constraints of all tables in the database.
DBA_CONS_COLUMNS	Displays the columns of all constraints of all tables in the database.
USER_CONSTRAINTS	Displays the constraints of all tables owned by the user.
USER_CONS_COLUMNS	Displays the columns of all constraints of all tables owned by the user.

Auditing

View name	Description
ALL_DEF_AUDIT_OPTS	Displays the default audit conditions for any object.
AUDIT_ACTIONS	Displays the action IDs and their names in audit records.
DBA_AUDIT_EXISTS	Displays the audit trail entries generated by the `AUDIT EXISTS` and `AUDIT NOT EXISTS` statements.
DBA_AUDIT_OBJECT	Displays the audit trail records of all objects in the database.
DBA_AUDIT_SESSION	Displays the audit trail records of all `CONNECT` and `DISCONNECT` statements.
DBA_AUDIT_STATEMENT	Displays the audit trail records of `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements in the database.
DBA_AUDIT_TRAIL	Displays all audit trail entries.
DBA_OBJ_AUDIT_OPTS	Displays the details of object-level audit configurations.
DBA_STMT_AUDIT_OPTS	Displays the details of statement-level audit configurations.
STMT_AUDIT_OPTION_MAP	Displays the types, names, and priorities of statement-level audit configurations.
USER_AUDIT_OBJECT	Displays the audit trail records of objects that the current user has access to.
USER_AUDIT_SESSION	Displays the audit trail records of connections and disconnections of the current user.
USER_AUDIT_STATEMENT	Displays the audit trail entries of `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements issued by the current user.
USER_AUDIT_TRAIL	Displays the standard audit trail entries related to the current user.

Indexes

View name	Description
ALL_INDEXES	Displays the index columns of all tables that the user can access.
ALL_IND_COLUMNS	Displays the index columns of all tables that the user can access.
ALL_IND_EXPRESSIONS	Displays the function-based indexes that the user can access in the database.
ALL_IND_PARTITIONS	Displays the partitions of indexes that the user can access in the database.
ALL_IND_SUBPARTITIONS	Displays the subpartitions of indexes that the user can access in the database.
ALL_PART_INDEXES	Displays the partitions of partitioned indexes that the user can access.
DBA_INDEXES	Displays the indexes of all tables in the database.
DBA_IND_COLUMNS	Displays the index columns of all tables in the database.
DBA_IND_EXPRESSIONS	Displays all function-based indexes in the database.
DBA_IND_PARTITIONS	Displays the partitions of indexes in the database.
DBA_IND_SUBPARTITIONS	Displays the subpartitions of indexes in the database.
USER_INDEXES	Displays the indexes of all tables owned by the user.
USER_IND_COLUMNS	Displays the index columns of all tables owned by the user.
USER_IND_EXPRESSIONS	Displays the function-based indexes owned by the user in the database.
USER_IND_PARTITIONS	Displays the partitions of indexes owned by the user in the database. This view does not contain the `INDEX_OWNER` column, which is included in the `ALL_IND_PARTITIONS` and `DBA_IND_PARTITIONS` views.
USER_IND_SUBPARTITIONS	Displays the subpartitions of indexes owned by the user in the database. This view does not contain the `INDEX_OWNER` column, which is included in the `DBA_IND_SUBPARTITIONS` and `ALL_IND_SUBPARTITIONS` views.
USER_PART_INDEXES	Displays the partitions of partitioned indexes that the user can access.

Partitioning

View name	Description
ALL_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key of all partitioned objects that the user has access to.
ALL_PART_TABLES	Displays the partition information of partitioned tables that the user has access to.
ALL_SUBPART_TEMPLATES	Displays descriptions of all subpartition templates.
ALL_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key of all partitioned objects that the user has access to.
ALL_TAB_PARTITIONS	Displays the multilevel partitioning information, storage parameters, and statistics of all partitioned tables.
ALL_TAB_SUBPARTITIONS	Displays the partition-level details, storage parameters, and statistics generated by the `DBMS_STATS` package for the partitions of the tables that the user has access to.
DBA_PART_INDEXES	Displays the partitions of all indexes in the database.
DBA_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key of all partitioned objects in the database.
DBA_PART_TABLES	Displays the partition information of partitioned tables that the user has access to.
DBA_SUBPART_TEMPLATES	Displays descriptions of all subpartition templates.
DBA_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key of all partitioned objects in the database.
DBA_TAB_PARTITIONS	Displays the multilevel partitioning information, storage parameters, and statistics of the tables that the user has access to.
DBA_TAB_SUBPARTITIONS	Displays the subpartition name, table name, partition name to which the subpartition belongs, storage attributes, and statistics generated by the `DBMS_STATS` package.
USER_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key of all partitioned objects that the user owns.
USER_PART_TABLES	Displays the partition information of partitioned tables that the user owns.
USER_SUBPART_TEMPLATES	Displays descriptions of all subpartition templates.
USER_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key of all partitioned objects that the user owns.
USER_TAB_SUBPARTITIONS	Displays the subpartition name, table name, partition name to which the subpartition belongs, storage attributes, and statistics generated by the `DBMS_STATS` package for each table that the user owns.
USER_TAB_PARTITIONS	Displays the multilevel partitioning information, storage parameters, and statistics of the tables that the user owns.

View name	Description
DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlocks. This view displays the deadlocks that occurred in the current tenant in a non-root tenant.

View name	Description
ALL_SEQUENCES	Displays all sequences accessible to the user.
DBA_SEQUENCES	Displays all sequences in the database.
USER_SEQUENCES	Displays all sequences owned by the current user.
TENANT_VIRTUAL_GLOBAL_VARIABLE	Displays the information of global variables.
TENANT_VIRTUAL_SESSION_VARIABLE	Displays the variables of the session.

Synonym views

View name	Description
ALL_SYNONYMS	Displays all synonyms accessible to the user.
DBA_SYNONYMS	Displays all synonyms in the database.
USER_SYNONYMS	Displays the synonyms owned by the current user.

Trigger views

View name	Description
ALL_TRIGGERS	Displays the triggers and descriptions of the tables on which the current user has privileges. If the current user has the CREATE ANY TRIGGER privilege, this view displays the descriptions of all triggers in the database.
DBA_TRIGGERS	Displays all triggers in the database.
USER_TRIGGERS	Displays the triggers owned by the current user.

Recycle bin

View name	Description
DBA_RECYCLEBIN	Displays information about all recycle bins in the database.
USER_RECYCLEBIN	Displays information about the recycle bins owned by the current user. The columns are the same as those in `DBA_RECYCLEBIN`, except that the `OWNER` column is removed.

Resource groups

View name	Description
DBA_RSRC_GROUP_MAPPINGS	Displays the mappings between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	Displays information about all resource groups in the database.
DBA_RSRC_PLANS	Displays all system-defined resource management plans.
DBA_RSRC_PLAN_DIRECTIVES	Displays the details of plan directives for each resource group in the database.

NLS

View name	Description
NLS_DATABASE_PARAMETERS	Displays the NLS parameters at the database level (tenant level in OceanBase Database).
NLS_INSTANCE_PARAMETERS	Displays the NLS parameters at the instance level (tenant level).
NLS_SESSION_PARAMETERS	Displays the NLS parameters at the session level.

User-defined types

View name	Description
ALL_COLL_TYPES	Displays the user-defined collection types available in the database. The columns are the same as those in the `DBA_COLL_TYPES` view.
ALL_TYPES	Displays the user-defined types available in the database.
ALL_TYPE_ATTRS	Displays the attribute information of the user-defined types available in the database.
DBA_COLL_TYPES	Displays the user-defined collection types available in the database. The columns are the same as those in the `ALL_COLL_TYPES` view.
DBA_TYPES	Displays the user-defined types available in the database.
DBA_TYPE_ATTRS	Displays the attribute information of the user-defined types available in the database.
USER_COLL_TYPES	Displays the user-defined collection types available to the current user.
USER_TYPES	Displays the user-defined types of the current user.
USER_TYPE_ATTRS	Displays the attribute information of the user-defined types available to the current user.

Objects

View name	Description
ALL_ERRORS	Displays errors for the storage objects that the user can access.
DBA_ERRORS	Displays errors for the storage objects in the database.
USER_ERRORS	Displays errors for the storage objects that the user can access.
DBA_SEGMENTS	Displays the storage information of all segments in the database.
USER_SEGMENTS	Displays the storage information of the segments of the objects under the user's account.

Profile

View name	Description
ALL_PROFILES	Displays all profiles and the limitations of these profiles.
DBA_PROFILES	Displays all profiles and the limitations of these profiles.
USER_PROFILES	Displays all profiles and the limitations of these profiles.

View name	Description
DBA_OB_LS_LOCATIONS	Displays the distribution of log stream (LS) replicas in the tenant.
DBA_OB_TABLEGROUPS	Displays the metadata of table groups, including the partition information of table groups.
DBA_OB_TABLEGROUP_PARTITIONS	Displays the partition information of partitions in a table group.
DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartition information of subpartitions in a table group.
DBA_OB_TABLET_REPLICAS	Displays information about all tablet replicas in the tenant. Each tablet replica is uniquely identified by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
DBA_OB_TABLET_TO_LS	Displays the list of all tablets in the tenant and the log stream to which each tablet belongs.
DBA_OB_LS	Displays the status and recovery progress of log streams.

Schedulers

View name	Description
DBA_SCHEDULER_JOBS	Displays information about the scheduler jobs that the current user has access to.
DBA_SCHEDULER_PROGRAM	Displays information about all schedulers in the database.

DBLINKs

View name	Description
ALL_DB_LINKS	Displays all DBLINKs that the current user has access to.
DBA_DB_LINKS	Displays all DBLINKs created in the current tenant.
USER_DB_LINKS	Displays the DBLINKs created by the current user.

Not supported views

View name	Description
ALL_METHOD_PARAMS	Displays the method parameters of objects that the user has access to.
ALL_SCHEDULER_JOB_ARGS	Displays the parameters of scheduled jobs that the user has access to.
ALL_SCHEDULER_PROGRAM_ARGS	Displays the parameters of schedulers that the user has access to.
ALL_TYPE_METHODS	Displays the methods of objects that the user has access to.
DBA_METHOD_PARAMS	Displays the method parameters of objects in the database.
DBA_SCHEDULER_JOB_ARGS	Displays the parameters of scheduled jobs in the database.
USER_SCHEDULER_JOB_ARGS	Displays the parameters of scheduled jobs that the current user owns.
DBA_SCHEDULER_PROGRAM_ARGS	Displays the parameters of schedulers in the database.
USER_SCHEDULER_PROGRAM_ARGS	Displays the parameters of schedulers that the current user owns.
DBA_TYPE_METHODS	Displays the methods of objects in the database.
USER_TYPE_METHODS	Displays the methods of objects that the user has access to, except that the OWNER column is not included in the result.

Overview of the performance view

Statistics

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_UNITS	Displays the unit information on the OBServer node where the tenant resides. System tenant users can view the units on all OBServer nodes in the cluster.
GV$SYSSTAT	Displays the system-level statistical event information on all servers.
GV$DML_STATS	Displays the DML information in the current user table.
V$DML_STATS	Displays the DML information in the current user table.
V$GLOBALCONTEXT	Displays the `CLIENT_IDENTIFIER` value of global context attributes accessible to the current session.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the parameter information on the OBServer node where you reside.
V$SYSSTAT	Displays the system-level statistical event information on the current server.
V$OB_UNITS	Displays the unit information on the OBServer node where you reside.
V$VERSION	Queries the names and versions of all components of the database product.

View name	Description
GV$INSTANCE	Displays the status of the current database instance.
V$INSTANCE	Displays the status of the current database instance.

View name	Description
GV$OB_MEMORY	Displays the memory usage of each tenant on all servers.
GV$OB_MEMSTORE	Displays the memory usage of MemTables of all tenants on all servers.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Provides information about the SQL Workarea, including the maximum available memory, the current memory usage, and the memory usage of held data.
GV$OB_SSTABLES	Displays the SSTable information of tenants.
GV$OB_MEMSTORE_INFO	Displays the details of MemTables on all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays the details of MemTables on all partitions of all tenants on all servers.
V$OB_MEMORY	Displays the memory statistics of tenants.
V$OB_MEMSTORE	Displays the memory usage of MemTables on all tenants on the current server.
V$OB_SSTABLES	Displays the SSTable information of tenants.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

Plan cache

View name	Description
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache of all servers.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan caches of all servers in the current tenant.
GV$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers in the current tenant.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache of the current server.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on the current server in the current tenant.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers in the current tenant.
V$RSRC_PLAN	Displays the resource management plans of the current active tenant.

View name	Description
GV$OB_LOG_STAT	Displays the status of the PALF.
V$OB_LOG_STAT	Displays the status of the PALF.

Monitoring information

View name	Description
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on all OBServer nodes.
GV$OB_PS_ITEM_INFO	Provides monitoring functionality for Prepared Statements and displays basic information about all prepared statements in the PS cache.
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on OBServer nodes.
V$OB_PS_ITEM_INFO	Provides monitoring functionality for Prepared Statements and displays basic information about all prepared statements in the PS cache.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
V$SQL_MONITOR_STATNAME	Displays the meaning of the numbers in the `OTHERSTAT_X_ID` column of the `GV$SQL_PLAN_MONITOR` view.

View name	Description
GV$OB_PROCESSLIST	Displays the session information of all OBServer nodes where the tenant resides.
GV$SESSION_WAIT	Displays information about the current or last wait event of all sessions on all servers, including the event name and duration.
GV$SESSION_WAIT_HISTORY	Displays information about the last 10 wait events of all sessions on all servers.
GV$SESSTAT	Displays some statistics at the session level on all servers.
GV$ACTIVE_SESSION_HISTORY	Displays the ASH data of active sessions.
V$ACTIVE_SESSION_HISTORY	Displays the ASH data of active sessions.
V$NLS_PARAMETERS	Queries the NLS parameters at the session level.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$SESSION_WAIT	Displays information about the current or last wait event of all sessions on the current server, including the event name and duration.
V$SESSION_WAIT_HISTORY	Displays information about the last 10 wait events of all sessions on the current server.
V$SESSTAT	Displays some statistics at the session level.
V$EVENT_NAME	Displays the definitions of various events in the tenant.

View name	Description
GV$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	Displays the plan-level statistics of slow queries on all OBServer nodes. A statistics record is generated for each slow query, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	Displays the plan-level statistics of slow queries on all OBServer nodes. A statistics record is generated for each slow query, and the trace information of the plan is recorded.

Threads

View name	Description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.

Workarea

View name	Description
GV$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
GV$SQL_WORKAREA_HISTOGRAM	Statistics of all operators whose memory is managed by SQL automatic memory management.
V$OB_SQL_WORKAREA_MEMORY_INFO	Queries some overall statistics about SQL workareas, including the maximum available memory, the current memory usage, and the current held memory.
V$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
V$SQL_WORKAREA_HISTOGRAM	Statistics of all operators whose memory is managed by SQL automatic memory management.

View name	Description
GV$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of the tenant on OBServer nodes.
GV$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the history of tablet-level major compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress of tablet-level major compactions.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
GV$SYSTEM_EVENT	Displays the wait events at the system level for the tenant on all servers, and counts the occurrences and the total waiting and timeout durations for each event type.
GV$GLOBAL_TRANSACTION	Displays information about the active global transactions.
V$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of the tenant on OBServer nodes.
V$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
V$OB_TABLET_COMPACTION_HISTORY	Displays the history of tablet-level major compactions.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress of tablet-level major compactions.
V$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
V$SYSTEM_EVENT	Displays the wait events at the system level for the tenant on the current server, and counts the occurrences and the total waiting and timeout durations for each event type.
V$GLOBAL_TRANSACTION	Displays information about the active global transactions.
GV$OB_GLOBAL_TRANSACTION	Displays information about all XA transactions in the cluster.
V$OB_GLOBAL_TRANSACTION	Displays information about all XA transactions that are initiated by the current node.

Time zones

View name	Description
V$TIMEZONE_NAMES	Displays the names of effective time zones.

Encrypted tables

View name	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables with the encryption feature enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces with the encryption feature enabled.

DBLINK

View name	Description
GV$DBLINK	Displays all database links (`IN_TRANSACTION=YES`) opened after the query session on this view is started. These database links must be committed or rolled back before they are closed.
V$DBLINK	Displays all database links (`IN_TRANSACTION=YES`) opened after the query session on this view is started. These database links must be committed or rolled back before they are closed.

Overview of views in the SYS tenant

Dictionary views overview

View name	Description
oceanbase.CDB_IND_COLUMNS	Displays the column information of index tables of all tenants.
oceanbase.CDB_INDEXES	Displays the index information of all tenants.
oceanbase.CDB_TABLES	Displays the table information of all tenants.
oceanbase.CDB_OB_TABLEGROUP_TABLES	Displays the associations between table groups and tables of all tenants in the sys tenant. Tables not in a table group are not displayed.
oceanbase.CDB_TAB_COLS	Displays the column information of all tables and views of all tenants.
oceanbase.CDB_TAB_COLS_V$	Displays the column information of all tables and views of all tenants.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the associations between table groups and tables. Tables not in a table group are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key of all partitioned objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key of all subpartitioned objects in the database.
oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO	Displays the information about column checksum inconsistencies between index tables (including global indexes and local indexes) and primary tables.
oceanbase.CDB_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.

Outline

View name	Description
oceanbase.DBA_OB_OUTLINES	Displays the outline information of execution plans for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the outline information of concurrency limit rules for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the history of execution plans and concurrency limit rules for the current tenant.

Basic information about the database

View name	Description
oceanbase.CDB_OB_DATABASES	Displays the metadata of all tenants in the sys tenant.
oceanbase.CDB_OB_MAJOR_COMPACTION	Displays the global major compaction information of all tenants in the sys tenant.
oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of all zones of all tenants in the sys tenant.
oceanbase.DBA_OB_DATABASES	Displays the metadata of databases in the current tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information in the current tenant.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the event history of the Root Service.
oceanbase.DBA_OB_SERVER_JOBS	Displays the tasks on all OBServer nodes.
oceanbase.DBA_OB_SERVERS	Displays information about all OBServer nodes.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of all zones in the current tenant.
oceanbase.DBA_OB_ZONES	Displays information about all zones.
oceanbase.CDB_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).

Partitioning

View name	Description
oceanbase.CDB_IND_PARTITIONS	Displays the partition information of index tables of all tenants.
oceanbase.CDB_PART_INDEXES	Displays the partition information of index tables of all tenants.
oceanbase.CDB_PART_TABLES	Displays the partition information of partitioned tables of all tenants.
oceanbase.CDB_SUBPARTITION_TEMPLATES	Displays the template-based subpartition information of partitioned tables of all tenants.
oceanbase.CDB_TAB_PARTITIONS	Displays the partition information of partitioned tables of all tenants.
oceanbase.CDB_TAB_SUBPARTITIONS	Displays the subpartition information of partitioned tables of all tenants.
oceanbase.DBA_IND_PARTITIONS	Displays the partition and subpartition information of indexes.
oceanbase.DBA_PART_INDEXES	Displays the partition information of all indexes.
oceanbase.DBA_PART_TABLES	Displays the partition information of user tables.
oceanbase.DBA_TAB_PARTITIONS	Displays the partition, subpartition, storage parameters, and statistics of accessible multi-level partitioned tables of the current user.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the subpartition name, the table name, the partition name to which the subpartition belongs, the storage attributes of the subpartition, and the statistics generated by using the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays descriptions of all subpartition templates.

View name	Description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	Displays the history records of deadlocks. This view displays the history records of all tenants in the root tenant.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history records of deadlocks. This view displays the history records of the current tenant in a non-root tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	Displays the event history information of OBServer nodes.

View name	Description
oceanbase.CDB_OB_RESTORE_PROGRESS	Displays the progress of ongoing physical restore tasks.
oceanbase.CDB_OB_RESTORE_HISTORY	Displays the status of completed physical restore tasks.
oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.
oceanbase.CDB_OB_BACKUP_SET_FILES	Displays the status of files in backup sets.
oceanbase.CDB_OB_BACKUP_JOBS	Displays the backup jobs of all tenants in the cluster. A backup job record is generated after a backup job is initiated.
oceanbase.CDB_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs of all tenants in the cluster.
oceanbase.CDB_OB_BACKUP_TASKS	Displays the backup tasks of all tenants in the cluster. A backup task record is generated for each backup set. A backup task record corresponds to a backup job record on a one-to-one basis.
oceanbase.CDB_OB_BACKUP_TASK_HISTORY	Displays the history of backup tasks of all tenants in the cluster.
oceanbase.DBA_OB_BACKUP_JOBS	Displays the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the history of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the history of backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the history of backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the status of files in backup sets.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays the ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays the completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
oceanbase.CDB_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
oceanbase.CDB_OB_BACKUP_PARAMETER	Displays the backup parameters.
oceanbase.CDB_OB_BACKUP_DELETE_JOBS	Displays the progress of tenant-level backup deletion jobs.
oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of completed backup deletion jobs in the current tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS	Displays the information about backup set or piece deletion tasks that are being executed in the current tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of completed backup set or piece deletion tasks in the current tenant.
oceanbase.CDB_OB_BACKUP_DELETE_POLICY	Displays the deletion policies set for expired data deletion and automatic data deletion in the current tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore in the current tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations used for backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations used for backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the deletion policies set for expired data deletion and automatic data deletion in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the progress of tenant-level backup deletion jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of completed backup deletion jobs in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays the information about backup set or piece deletion tasks that are being executed in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of completed backup set or piece deletion tasks in the current tenant.
oceanbase.DBA_OB_ARCHIVELOG	Displays the status of log backup for each archive path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all log backups in history and currently.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.
oceanbase.CDB_OB_ARCHIVELOG	Displays the status of log archiving for each archive path.
oceanbase.CDB_OB_ARCHIVELOG_SUMMARY	Displays the status of all log archivings in history and currently.

Statistics and histograms

View name	Description
oceanbase.DBA_TAB_STATISTICS	Displays optimizer statistics for all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays column statistics and histograms for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays column statistics and histograms for all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays column statistics and histograms for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays histograms for all columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays histogram endpoint data for all partitions of all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays histogram endpoint data for all subpartitions of all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	Displays table statistics history for all tables in the database.
oceanbase.DBA_IND_STATISTICS	Displays optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the modification information of all tables in the database since the last time statistics were collected for the tables.
oceanbase.CDB_TAB_COL_STATISTICS	Displays column-level statistics in the sys tenant.

View name	Description
oceanbase.DBA_OBJECTS	Displays all database objects in the database. The view definition is the same as that of ALL_OBJECTS.
oceanbase.CDB_OBJECTS	Displays the objects of all tenants in the sys tenant.
oceanbase.DBA_OB_TENANTS	Displays basic information about all tenants, including the sys tenant, user tenants, and meta tenants. You can filter the tenants by `TENANT_TYPE`.
oceanbase.DBA_OB_TENANT_JOBS	Displays information about tenant-level scheduled jobs.
oceanbase.CDB_OB_SYS_VARIABLES	Displays the system variables of all tenants in the sys tenant.

View name	Description
oceanbase.DBA_OB_RESOURCE_POOLS	Displays information about all resource pools of tenants.
oceanbase.DBA_OB_UNIT_JOBS	Displays information about all UNIT-related tasks.
oceanbase.DBA_OB_UNITS	Displays information about all units of tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	Displays the specifications of all units of tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.

View name	Description
oceanbase.CDB_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.CDB_OB_LS_LOCATIONS	Displays the distribution of log stream (LS) replicas for all tenants.
oceanbase.CDB_OB_TABLEGROUPS	Displays the metadata of all table groups in the sys tenant, including the partition information of the table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	Displays the primary partitions of all partitioned table groups in the sys tenant.
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartitions of all partitioned table groups in the sys tenant.
oceanbase.CDB_OB_TABLET_TO_LS	Displays the tables and the LS to which each tablet belongs in the sys tenant.
oceanbase.CDB_OB_TABLET_REPLICAS	Displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: `<TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.CDB_PART_KEY_COLUMNS	Displays the primary partitioning keys of partitioned objects (partitioned tables and partitioned indexes) in all tenants.
oceanbase.CDB_SUBPART_KEY_COLUMNS	Displays the subpartitioning keys of partitioned objects (partitioned tables and partitioned indexes) in all tenants.
oceanbase.DBA_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the primary partitions of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartitions of partitioned table groups.
oceanbase.DBA_OB_TABLEGROUPS	Displays the metadata of table groups, including the partition information of the table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	Displays information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	Displays the tables and the LS to which each tablet belongs in the current tenant.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the distribution of log stream (LS) replicas for the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO	Displays information about data inconsistencies between tablet replicas.
oceanbase.CDB_OB_LS	Displays the status and restore progress of log streams.
oceanbase.DBA_OB_LS	Displays the status and restore progress of log streams.

Overview of the performance view

View name	Description
GV$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of each OBServer node in the tenant.
GV$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
GV$OB_PROCESSLIST	Displays the session information of all OBServer nodes in the tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the history information of tablet-level major compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level major compactions.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participant information of all OBServer nodes.
GV$SESSION_EVENT	Displays the wait events of sessions on all OBServer nodes in the cluster.
GV$SESSION_WAIT	Displays the name and duration of the current or last wait event of all sessions on all servers.
GV$SESSION_WAIT_HISTORY	Displays the names and durations of the last 10 wait events of all sessions on all servers.
GV$SYSTEM_EVENT	Displays the tenant-level wait events of all tenants in the cluster.
GV$SESSTAT	Displays the statistical events of sessions on all OBServer nodes.
GV$SYSSTAT	Displays the tenant-level statistical events on all servers.
GV$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of each OBServer node in the tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
V$OB_TABLET_COMPACTION_HISTORY	Displays the history information of tablet-level major compactions.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level major compactions.
V$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participant information of all OBServer nodes.
V$STATNAME	Displays the definitions of all statistical events.
V$EVENT_NAME	Displays the definitions of all statistical events on the current OBServer node.
V$SESSION_WAIT	Displays the details of the current wait event of each session. According to the convention, each wait event has three parameters, and the values of these parameters are recorded.
V$SESSION_WAIT_HISTORY	Displays the details of the current wait event of each session and the last 10 wait events of each session.
V$SESSTAT	Displays the statistical events of sessions.
V$SYSSTAT	Displays the tenant-level statistical events on the current server.
V$SYSTEM_EVENT	Displays the tenant-level wait events.
GV$SESSION_LONGOPS	Displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	Displays the execution status and progress of DDL operations on the current OBServer node.

View name	Description
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.

View name	Description
GV$OB_IO_CALIBRATION_STATUS	Displays the execution status of I/O calibration tasks.
V$OB_IO_CALIBRATION_STATUS	Displays the execution status of I/O calibration tasks.
GV$OB_IO_BENCHMARK	Displays the calibration data of disks used by the I/O module.
V$OB_IO_BENCHMARK	Displays the calibration data of disks used by the I/O module.

View name	Description
GV$OB_MEMORY	Displays memory statistics at the tenant level.
V$OB_MEMORY	Displays memory statistics at the tenant level.
GV$OB_MEMSTORE	Displays the memory usage of MemTables on all servers and tenants.
V$OB_MEMSTORE	Displays the statistics of MemStores at the tenant level.
GV$OB_MEMSTORE_INFO	Displays detailed information about MemTables in all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays detailed information about MemTables in all partitions of all tenants on all servers.
GV$OB_SSTABLES	Displays the information about SSTables of a tenant.
V$OB_SSTABLES	Displays the information about SSTables of a tenant.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in a cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

View name	Description
GV$OB_PLAN_CACHE_STAT	Displays the overall status of each plan cache on all OBServer nodes of the current tenant.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers of the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan caches on all servers of the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in all plan caches on all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache.
GV$OB_PS_ITEM_INFO	Provides monitoring functionality for prepared statements. It contains basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Provides monitoring functionality for prepared statements. It contains basic information about all prepared statements in the PS cache.
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on OBServer nodes.
GV$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	Displays the statistics of slow queries on all OBServer nodes from the plan level. Each slow query has a statistics record, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	Displays the statistics of operations in slow queries on the current server. Each operation has a statistics record.
V$SQL_MONITOR_STATNAME	Describes the meanings of numbers in the `OTHERSTAT_X_ID` field of the `GV$SQL_PLAN_MONITOR` view.

View name	Description
GV$OB_LOG_STAT	Displays the status of the PALF.
V$OB_LOG_STAT	Displays the status of the PALF.

View name	Description
GV$OB_RPC_OUTGOING	Displays the statistics of outgoing RPCs on all OBServer nodes.
GV$OB_RPC_INCOMING	Displays the statistics of RPC requests received by all OBServer nodes.
V$OB_RPC_OUTGOING	Statistics of outgoing RPC data on different tenants of different RPC packet codes on OBServer nodes.
V$OB_RPC_INCOMING	Statistics of incoming RPC data on different tenants of different RPC packet codes on OBServer nodes.

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes in the tenant.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_SERVERS	Displays information about all OBServer nodes.
GV$OB_UNITS	Displays the unit information on the OBServer node where the tenant resides. You will see the unit information on all OBServer nodes in the cluster if you are using the sys tenant.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the parameter information on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_SERVERS	Displays information about the current OBServer node.
V$OB_UNITS	Displays the unit information on the current OBServer node.
GV$DML_STATS	Displays the DML information in the current user table.
V$DML_STATS	Displays the DML information in the current user table.

View name	Description
GV$OB_MERGE_INFO	Displays statistics about minor compactions completed in the OceanBase cluster.
V$OB_MERGE_INFO	Displays statistics about minor compactions completed in the OceanBase cluster.

View name	Description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, displays the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, displays the execution information of each thread.

View name	Description
GV$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
GV$SQL_WORKAREA_HISTOGRAM	Statistics of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of one-pass operations.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Queries overall statistics of SQL workareas, such as the maximum available memory, the current memory usage, and the memory held.
V$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
V$SQL_WORKAREA_HISTOGRAM	Statistics of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of one-pass operations.
V$OB_SQL_WORKAREA_MEMORY_INFO	Queries overall statistics of SQL workareas, including the maximum available memory, the current memory usage, and the memory held.

Statistics on encrypted tables

View name	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables with the encryption feature enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces with the encryption feature enabled.

Statistics on transactions

View name	Description
GV$LATCH	The latch information of all OBServer nodes in the cluster.
V$LATCH	The latch information of all OBServer nodes in the cluster.

Overview of views in a MySQL tenant

Dictionary views overview

Help command

View name	Description
mysql.help_topic	Works with the other three tables `mysql.help_category`, `mysql.help_relation`, and `mysql.help_keyword` to generate the Help command.
mysql.help_category	Works with the other three tables `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_keyword` to generate the Help command.
mysql.help_keyword	Works with the other three tables `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_category` to generate the Help command.
mysql.help_relation	Works with the other three tables `mysql.help_category`, `mysql.help_topic`, and `mysql.help_keyword` to generate the Help command.

View name	Description
oceanbase.DBA_SQL_PLAN_BASELINES	Displays the plan baselines of SQL statements in SPM.
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

View name	Description
mysql.db	Displays database-level privileges (VIRTUAL_TABLE).
mysql.user	Records user-level privileges (VIRTUAL_TABLE).
information_schema.COLUMN_PRIVILEGES	Displays column privileges.
information_schema.SCHEMA_PRIVILEGES	Describes database privileges.
information_schema.TABLE_PRIVILEGES	Records table privileges.
information_schema.USER_PRIVILEGES	Records user privileges.

Scheduler

View name	Description
oceanbase.DBA_SCHEDULER_JOBS	Displays information about all scheduled jobs in the database.

View name	Description
mysql.proc	Displays information about stored procedures.
information_schema.ENGINES	Records information about storage engines.
information_schema.PARAMETERS	Provides information about parameters and return values of stored procedures.
information_schema.ROUTINES	Provides information about stored procedures.

View name	Description
mysql.time_zone	Displays time zone-related information (SYSTEM_VIEW).
mysql.time_zone_name	Records the names of time zones (SYSTEM_VIEW).
mysql.time_zone_transition	The `mysql.time_zone_transition` view records the time zone transition information.
mysql.time_zone_transition_type	Provides information about the types of time zone transitions (SYSTEM_VIEW).

Character sets

View name	Description
information_schema.CHARACTER_SETS	Records the character sets supported by OceanBase Database.
information_schema.COLLATIONS	Records the collation methods for each character set.
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY	Records the correspondences between character sets and collations.

Tables and columns

View name	Description
information_schema.COLUMNS	Records information about columns.
information_schema.STATISTICS	Records information about indexes of tables.
information_schema.TABLES	Records information about tables.
information_schema.VIEWS	Records information about views.
information_schema.VIEW_TABLE_USAGE	Displays information about tables and views used in view definitions.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the relationship between table groups and tables. Tables not belonging to any table group are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key in all partitioned objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key in all subpartitioned objects in the database.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.

Outline

View name	Description
oceanbase.DBA_OB_OUTLINES	Displays the outline information of execution plans for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the outline information of concurrency limit rules for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the history information of execution plans and concurrency limit rules outlines for the current tenant.

Basic information about the database

View name	Description
information_schema.GLOBAL_STATUS	Records the global status information of OceanBase Database.
information_schema.GLOBAL_VARIABLES	Records the global variables.
information_schema.SCHEMATA	Records the metadata of the database.
oceanbase.DBA_OB_DATABASES	Displays the metadata of the tenant's databases.
oceanbase.DBA_OB_MAJOR_COMPACTION	Displays the global major compaction information of the tenant.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	Displays the event history of the Root Service.
oceanbase.DBA_OB_SERVER_JOBS	Displays the related tasks of all OBServer nodes.
oceanbase.DBA_OB_SERVERS	Displays the information of all OBServer nodes.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	Displays the major compaction information of each zone of the tenant.
oceanbase.DBA_OB_ZONES	Displays the information of all zones.
oceanbase.DBA_OB_FREEZE_INFO	Displays the version information generated by major compactions (major_freeze).

View name	Description
information_schema.PARTITIONS	Records information about partitions.
oceanbase.DBA_IND_PARTITIONS	Displays information about the partitions and subpartitions of indexes.
oceanbase.DBA_PART_INDEXES	Displays information about all partitions of indexes.
oceanbase.DBA_PART_TABLES	Displays partition information of user tables.
oceanbase.DBA_TAB_PARTITIONS	Displays the multi-partition information, storage parameters, and statistics of partitions that the current user has access to.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the names of subpartitions, the names of tables to which the subpartitions belong, and the names of the partitions to which the subpartitions belong. It also displays the storage attributes of subpartitions and the statistics generated by the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays descriptions of all subpartition templates.

Threads

View name	Description
information_schema.PROCESSLIST	Provides information about running threads.

Constraints

View name	Description
information_schema.CHECK_CONSTRAINTS	Displays the constraints on tables and columns when you execute the `CREATE TABLE` statement.
information_schema.KEY_COLUMN_USAGE	Records the key constraints on columns.
information_schema.REFERENTIAL_CONSTRAINTS	Displays the metadata of foreign key constraints.
information_schema.TABLE_CONSTRAINTS	Describes table constraints.

View name	Description
information_schema.SESSION_STATUS	Records the status information of sessions, such as the number of current active connections and the uptime of the database.
information_schema.SESSION_VARIABLES	Records the variables of sessions.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history records of deadlocks. This view displays the history records of the current tenant in a non-root tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	Displays the event history information of OBServer nodes.

View name	Description
information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS	Displays the number of failed login attempts for each user.

View name	Description
oceanbase.DBA_OB_BACKUP_JOBS	Displays the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the history records of the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the history records of the backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the status of backup sets.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays the ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays the completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the historical information about backup destinations used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies, such as automatic and expiration cleanup, set for the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of the tenant-level backup cleanup jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history information of the backup cleanup jobs executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays the information about backup_set or backup_piece cleanup tasks being executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the historical information about backup_set or backup_piece cleanup tasks completed in the tenant.
oceanbase.DBA_OB_ARCHIVELOG	Displays the status of log backup for each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all log backups in history and currently.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.

Statistics and histograms

View name	Description
oceanbase.DBA_TAB_STATISTICS	Displays optimizer statistics for all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	Displays column statistics and histograms for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	Displays column statistics and histograms for all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	Displays column statistics and histograms for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	Displays histograms for all columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	Displays the endpoint data of histograms for all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	Displays the endpoint data of histograms for all subpartitioned tables in the database.
oceanbase.DBA_TAB_STATS_HISTORY	Displays the statistics history for all tables in the database.
oceanbase.DBA_IND_STATISTICS	Displays optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	Displays the modification information of all tables in the database since the last time statistics were collected for these tables.
information_schema.QUERY_RESPONSE_TIME	Displays data types (Histogram) such as the response time histogram for Prometheus monitoring.

View name	Description
oceanbase.DBA_OBJECTS	Displays all database objects in the database. The view definition is the same as that of ALL_OBJECTS.
oceanbase.DBA_OB_TENANTS	Displays basic information about all tenants, including system tenants, user tenants created by users, and meta tenants. You can filter the tenants by type using the `TENANT_TYPE` column.
oceanbase.DBA_OB_TENANT_JOBS	Displays information about tenant-level scheduled jobs.

View name	Description
oceanbase.DBA_OB_RESOURCE_POOLS	Displays information about all resource pools of all tenants.
oceanbase.DBA_OB_UNIT_JOBS	Displays information about all UNIT-related tasks.
oceanbase.DBA_OB_UNITS	Displays information about all units of all tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	Displays the specifications of all units of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	Displays all sequences in the database.

View name	Description
oceanbase.DBA_IND_SUBPARTITIONS	Displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	Displays the primary partitions of table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartitions of table groups.
oceanbase.DBA_OB_TABLEGROUPS	Displays the metadata of table groups, including the partition information of table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	Displays information about all tablet replicas in the tenant. Each tablet replica is uniquely identified by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	Displays the tablets and the log streams to which they belong in the tenant.
oceanbase.DBA_OB_LS_LOCATIONS	Displays the distribution of log stream (LS) replicas in the tenant.

Overview of the performance view

View name	Description
GV$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of each tenant on OBServer nodes.
GV$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
GV$OB_PROCESSLIST	Displays the session information on all OBServer nodes of a tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level major compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level major compactions.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
GV$SESSION_EVENT	Displays the wait events of all sessions on OBServer nodes in the cluster.
GV$SESSION_WAIT	Displays information about the current or last wait event of each session on all servers, including the name and duration of the wait event.
GV$SESSION_WAIT_HISTORY	Displays information about the last 10 wait events of each session on all servers.
GV$SYSTEM_EVENT	Displays the tenant-level wait events of all tenants in the cluster.
GV$SESSTAT	Displays the statistics of wait events at the session level on all OBServer nodes.
GV$SYSSTAT	Displays the statistics of wait events at the tenant level on all servers.
GV$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$ACTIVE_SESSION_HISTORY	Displays the active session history.
V$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of each tenant on OBServer nodes.
V$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
V$OB_PROCESSLIST	Displays the session information on the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
V$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level major compactions.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level major compactions.
V$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
V$STATNAME	Displays definitions of all statistics events.
V$EVENT_NAME	Displays definitions of all statistics events on the current OBServer node.
V$SESSION_WAIT	Displays details of the current wait event for each session. According to the convention, each wait event has three parameters, and the values of these parameters are recorded.
V$SESSION_WAIT_HISTORY	Displays details of the current wait event for each session and the last 10 wait events.
V$SESSTAT	Displays the statistics of wait events at the session level.
V$SYSSTAT	Displays the statistics of wait events at the tenant level on the current server.
V$SYSTEM_EVENT	Displays the tenant-level wait events.
GV$SESSION_LONGOPS	Displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	Displays the execution status and progress of DDL operations on the current OBServer node.

View name	Description
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.

View name	Description
GV$OB_MEMORY	Displays memory statistics at the tenant level.
V$OB_MEMORY	Displays memory statistics at the tenant level.
GV$OB_MEMSTORE	Displays the memory usage of MemTables on all servers and tenants.
V$OB_MEMSTORE	Displays the statistics of MemStores at the tenant level.
GV$OB_MEMSTORE_INFO	Displays details about MemTables of all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays details about MemTables of all partitions of all tenants on all servers.
GV$OB_SSTABLES	Displays the information about SSTables of a tenant.
V$OB_SSTABLES	Displays the information about SSTables of a tenant.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

View name	Description
GV$OB_PLAN_CACHE_STAT	Displays the outline information of the current tenant, which is mainly used for outline migration.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers of the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan caches on all servers of the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in all servers' plan caches.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of items in the cache.
GV$OB_PS_ITEM_INFO	Provides monitoring functionality for prepared statements and contains basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Provides monitoring functionality for prepared statements and contains basic information about all prepared statements in the PS cache.
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on the current OBServer node.
GV$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	Displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistic record, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	Displays the operation-level statistics of slow queries. Each operation has a corresponding statistic record.
V$SQL_MONITOR_STATNAME	Describes the meaning of numbers in the `OTHERSTAT_X_ID` field of the `GV$SQL_PLAN_MONITOR` view.

View name	Description
GV$OB_LOG_STAT	Displays the status of the PALF.
V$OB_LOG_STAT	Displays the status of the PALF.

View name	Description
GV$OB_RPC_OUTGOING	Statistics on RPCs sent by all OBServer nodes.
GV$OB_RPC_INCOMING	Statistics on RPC requests received by all OBServer nodes.
V$OB_RPC_OUTGOING	Statistics on RPC data sent by all tenants on the OBServer node for different RPC packet codes.
V$OB_RPC_INCOMING	Statistics on RPC data received by different tenants on the OBServer node for different RPC packet codes.

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes within the tenant.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_UNITS	Displays the unit information on the OBServer node where the tenant resides. System tenant users can view the units of all OBServer nodes in the cluster.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the parameter information on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_UNITS	Displays the unit information on the current OBServer node.
GV$DML_STATS	Displays the DML information in the current user table.
V$DML_STATS	Displays the DML information in the current user table.

View name	Description
GV$OB_MERGE_INFO	Displays statistics on minor compactions completed in the OceanBase cluster.
V$OB_MERGE_INFO	Displays statistics on minor compactions completed in the OceanBase cluster.

View name	Description
GV$OB_PX_WORKER_STAT	Displays the execution information of each thread in parallel execution scenarios.
V$OB_PX_WORKER_STAT	Displays the execution information of each thread in parallel execution scenarios.

View name	Description
GV$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
GV$SQL_WORKAREA_HISTOGRAM	Statistics of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of one-pass operations.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Queries overall statistics of SQL workareas, such as the maximum available memory, the current memory usage, and the current held memory.
V$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
V$SQL_WORKAREA_HISTOGRAM	Statistics of all workareas, such as the number of times that data in the range of 1 MB to 2 MB is fully processed in memory and the number of one-pass operations.
V$OB_SQL_WORKAREA_MEMORY_INFO	Queries overall statistics of SQL workareas, including the maximum available memory, the current memory usage, and the current held memory.

Statistics on encrypted tables

View name	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables with the encryption feature enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces with the encryption feature enabled.

Statistics on transactions

View name	Description
GV$LATCH	The latch information of all OBServer nodes in the cluster.
V$LATCH	The latch information of all OBServer nodes in the cluster.

Overview of views in an Oracle tenant

Overview

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.

Tables and views

View name	Description
ALL_ALL_TABLES	Displays the object tables and relational tables that the user has access to.
ALL_COL_COMMENTS	Displays the comments on all columns of the views and tables that the user has access to.
ALL_TABLES	Displays all tables that the user has access to.
ALL_TAB_COLS	Displays all columns of the tables, views, and clusters that the user has access to.
ALL_TAB_COLUMNS	Displays all columns of the tables, views, and clusters that the user has access to.
ALL_TAB_COMMENTS	Displays the comments on the tables and views that the user has access to.
DBA_COL_COMMENTS	Displays the comments on all columns of all views and tables in the database.
DBA_TAB_COMMENTS	Displays the comments on all tables and views in the database.
USER_COL_COMMENTS	Displays the comments on all columns of the views and tables that the user owns.
USER_TAB_COMMENTS	Displays the comments on the tables and views that the user owns.
DBA_OB_TABLEGROUP_TABLES	Displays the relationships between tables and table groups. Tables not in a table group are not displayed.
DBA_TABLES	Displays all tables in the database.
DBA_ALL_TABLES	Displays the object tables and relational tables in the database. The fields are the same as those in ALL_ALL_TABLES.
DBA_TABLESPACES	Displays all tablespaces in the database.
DBA_TAB_COLS	Displays all columns of all tables, views, and clusters in the database.
DBA_TAB_COLUMNS	Displays all columns of all tables, views, and clusters in the database.
USER_ALL_TABLES	Displays the object tables and relational tables that the user has access to, except the OWNER field. The other fields are the same as those in ALL_ALL_TABLES.
USER_TABLES	Displays all tables that the user owns.
USER_TABLESPACES	Displays the tablespaces that the user can access. The columns are the same as those in `DBA_TABLESPACES`, with the `PLUGGED_IN` column removed.
USER_TAB_COLS	Displays all columns of the tables, views, and clusters that the user owns.
USER_TAB_COLUMNS	Displays all columns of the tables, views, and clusters that the user owns.
ALL_VIEWS	Displays the views that the user has access to.
DBA_VIEWS	Displays all views in the database. The columns are the same as those in `ALL_VIEWS`.
USER_VIEWS	Displays the views that the user owns.
DICTIONARY	Displays the descriptions of dictionary tables and views.
DICT	Displays the descriptions of dictionary tables and views.
DBA_OB_TABLE_LOCATIONS	Displays the locations of tables or partitions, including system tables, user tables, and index tables.

Outline

View name	Description
DBA_OB_OUTLINES	Displays the outline information of execution plans in the current tenant.
DBA_OB_CONCURRENT_LIMIT_SQL	Displays the outline-related information of throttling rules in the current tenant.
DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the outline information of execution plans and throttling rules in the current tenant.

SPM

View name	Description
DBA_SQL_PLAN_BASELINES	Displays the plan baselines of SQL statements in SPM.
DBA_SQL_MANAGEMENT_CONFIG	Displays the configuration parameters in SPM.

Database information

View name	Description
DBA_CONTEXT	Displays information about all context namespaces in the database.
DBA_OB_DATABASES	Displays metadata about the databases of the tenant.
DBA_OB_MAJOR_COMPACTION	Displays global information about major compactions in the tenant.
DBA_OB_ZONE_MAJOR_COMPACTION	Displays information about major compactions in each zone of the tenant.
ALL_OBJECTS	Displays all database objects that the user has access to.
DBA_OBJECTS	Displays all database objects in the database.
USER_OBJECTS	Displays all database objects owned by the user.
ALL_DEPENDENCIES	Displays the dependencies among all objects in the database.
DBA_DEPENDENCIES	Displays all dependencies among objects in the database.
USER_DEPENDENCIES	Displays the dependencies among objects in the user's schema.
DBA_OB_FREEZE_INFO	Displays version information generated by major compactions (major_freeze).

Functions and procedures

View name	Description
ALL_ARGUMENTS	Displays the parameters of the functions and procedures that the current user can access.
ALL_PROCEDURES	Displays all the functions and procedures that the current user can access, along with their related attributes.
ALL_SOURCE	Displays the text source code of the storage objects that the current user can access.
DBA_ARGUMENTS	Displays the parameters of the functions and procedures available in the database. The columns are the same as those in the `ALL_ARGUMENTS` view.
DBA_PROCEDURES	Displays all the functions and procedures available in the database, along with their related attributes. The columns are the same as those in the `ALL_PROCEDURES` view.
DBA_SOURCE	Displays the text source code of all the storage objects in the database. The columns are the same as those in the `ALL_SOURCE` view.
USER_ARGUMENTS	Displays the parameters of the functions and procedures that the current user owns. The columns are the same as those in the `ALL_ARGUMENTS` view, excluding the `OWNER` column.
USER_PROCEDURES	Displays all the functions and procedures that the current user owns, along with their related attributes. The columns are the same as those in the `ALL_PROCEDURES` view, excluding the `OWNER` column.
USER_SOURCE	Displays the text source code of the storage objects that the current user owns. The columns are the same as those in the `ALL_SOURCE` view, excluding the `OWNER` column.
DBA_JOBS	Displays a summary of the tasks that have been committed.
USER_JOBS	Displays a summary of the tasks that have been committed.
DBA_JOBS_RUNNING	Displays the running tasks.

View name	Description
DBA_OB_BACKUP_JOBS	Displays the backup jobs of the current tenant.
DBA_OB_BACKUP_JOB_HISTORY	Displays the history records of the backup jobs of the current tenant.
DBA_OB_BACKUP_TASKS	Displays the backup tasks of the current tenant.
DBA_OB_BACKUP_TASK_HISTORY	Displays the history records of the backup tasks of the current tenant.
DBA_OB_BACKUP_SET_FILES	Displays the status of files in backup sets.
DBA_OB_RESTORE_PROGRESS	Displays the ongoing restore tasks.
DBA_OB_RESTORE_HISTORY	Displays the completed restore tasks.
DBA_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore in the current tenant.
DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the historical information about backup destinations used for backup and restore in the current tenant.
DBA_OB_BACKUP_DELETE_POLICY	Displays the cleanup strategies set for automatic or periodic cleanup of expired data in the current tenant.
DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of the backup cleanup jobs at the tenant level.
DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history information of the backup cleanup jobs executed in the current tenant.
DBA_OB_BACKUP_DELETE_TASKS	Displays the information about backup_set or backup_piece cleanup tasks being executed in the current tenant.
DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history information of the backup_set or backup_piece cleanup tasks completed in the current tenant.
DBA_OB_ARCHIVELOG	Displays the backup status of logs on each path.
DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all log backups in history and currently.
DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.
DBA_OB_BACKUP_PARAMETER	Displays the backup parameters.

Statistics and histograms

View name	Description
ALL_PART_COL_STATISTICS	Displays the column statistics and histogram information of the partitions of the tables that the current user has access to.
ALL_PART_HISTOGRAMS	Displays the histogram information of all partitions.
ALL_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information of the subpartitions of the tables that the current user has access to.
ALL_SUBPART_HISTOGRAMS	Displays the histogram information of all subpartitions.
ALL_TAB_COL_STATISTICS	Displays the column statistics and histogram information of the tables that the current user has access to.
ALL_TAB_HISTOGRAMS	Displays the histogram information of all tables.
ALL_TAB_STATISTICS	Displays the optimizer statistics of the tables that the current user has access to.
DBA_PART_COL_STATISTICS	Displays the column statistics and histogram information of the partitions of the tables in the database.
DBA_PART_HISTOGRAMS	Displays the histogram information of the partitions of the tables in the current database.
DBA_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information of the subpartitions of the tables in the database.
DBA_SUBPART_HISTOGRAMS	Displays the histogram information of the subpartitions of the tables in the current database.
DBA_TAB_COL_STATISTICS	Displays the column statistics and histogram information of all tables in the database.
DBA_TAB_HISTOGRAMS	Displays the histogram information of all tables in the current database.
DBA_TAB_STATISTICS	Displays the optimizer statistics of all tables in the database.
USER_PART_COL_STATISTICS	Displays the column statistics and histogram information of the partitions of the tables that the current user owns.
USER_PART_HISTOGRAMS	Displays the histogram information of the partitions of the tables that the current user owns.
USER_SUBPART_COL_STATISTICS	Displays the column statistics and histogram information of the subpartitions of the tables that the current user owns.
USER_SUBPART_HISTOGRAMS	Displays the histogram information of the subpartitions of the tables that the current user owns.
USER_TAB_COL_STATISTICS	Displays the column statistics and histogram information of the tables that the current user owns.
USER_TAB_HISTOGRAMS	Displays the histogram information of the tables that the current user owns.
USER_TAB_STATISTICS	Displays the optimizer statistics of the tables that the current user owns.
ALL_TAB_STATS_HISTORY	Displays the modification history of the statistics of all tables that the current user has access to.
DBA_TAB_STATS_HISTORY	Displays the modification history of the statistics of all tables in the database.
USER_TAB_STATS_HISTORY	Displays the modification history of the statistics of all tables that the current user owns.
ALL_IND_STATISTICS	Displays the optimizer statistics of the indexes of the tables that the current user has access to.
DBA_IND_STATISTICS	Displays the optimizer statistics of all indexes in the database.
USER_IND_STATISTICS	Displays the optimizer statistics of the indexes of the tables that the current user owns.
ALL_TAB_MODIFICATIONS	Displays the modification information of the tables that the current user has access to since the last time statistics were collected on these tables.
DBA_TAB_MODIFICATIONS	Displays the modification information of all tables in the database since the last time statistics were collected on these tables.
USER_TAB_MODIFICATIONS	Displays the modification information of the tables that the current user owns since the last time statistics were collected on these tables.

Users and privileges

View name	Description
ALL_USERS	Displays all database users visible to the current user.
DBA_USERS	Displays all users of the database.
ALL_COL_PRIVS	Displays the column privileges of the current user on objects that the user owns, has been granted privileges on, or has granted privileges on. Column privileges on objects that have been granted to the PUBLIC role are also displayed.
ALL_TAB_PRIVS	Displays the object privileges of the current user on objects that the user owns, has been granted privileges on, or has been granted privileges on. Object privileges on objects that have been granted to the PUBLIC role are also displayed.
DBA_COL_PRIVS	Displays all column privileges granted in the database.
DBA_SYS_PRIVS	Displays the system privileges granted to users and roles.
DBA_TAB_PRIVS	Displays all object privileges granted in the database.
USER_TAB_PRIVS	Displays the object privileges of the current user on objects that the user owns or has been granted privileges on.
USER_COL_PRIVS	Displays the column privileges of the current user on objects that the user owns, has been granted privileges on, or has granted privileges on.
USER_ROLE_PRIVS	Displays the roles granted to the current user.
USER_SYS_PRIVS	Displays the system privileges granted to the current user.
ROLE_TAB_PRIVS	Displays the table privileges of roles granted to the current user. Only information about roles accessible to the user is provided.
ROLE_SYS_PRIVS	Displays the system privileges of roles granted to the current user.
ROLE_ROLE_PRIVS	Displays the roles that grant privileges to other roles. Only information about roles accessible to the user is provided.
DBA_ROLE_PRIVS	Displays the roles granted to all users and the roles in the database.
DBA_ROLES	Displays all roles in the database.
ALL_DIRECTORIES	Displays all directories accessible to the current user.
DBA_DIRECTORIES	Displays all directories accessible to the current user.

Views

View name	Description
ALL_CONSTRAINTS	Displays the constraints of all tables accessible to the user.
ALL_CONS_COLUMNS	Displays the columns of all constraints of all tables accessible to the user.
DBA_CONSTRAINTS	Displays the constraints of all tables in the database.
DBA_CONS_COLUMNS	Displays the columns of all constraints of all tables in the database.
USER_CONSTRAINTS	Displays the constraints of all tables owned by the user.
USER_CONS_COLUMNS	Displays the columns of all constraints of all tables owned by the user.

Auditing

View name	Description
ALL_DEF_AUDIT_OPTS	Displays the default audit conditions for any object.
AUDIT_ACTIONS	Displays the action IDs and their names in audit records.
DBA_AUDIT_EXISTS	Displays the audit trail entries generated by the `AUDIT EXISTS` and `AUDIT NOT EXISTS` statements.
DBA_AUDIT_OBJECT	Displays the audit trail records of all objects in the database.
DBA_AUDIT_SESSION	Displays the audit trail records of all `CONNECT` and `DISCONNECT` statements.
DBA_AUDIT_STATEMENT	Displays the audit trail records of `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements in the database.
DBA_AUDIT_TRAIL	Displays all audit trail entries.
DBA_OBJ_AUDIT_OPTS	Displays the details of object-level audit configurations.
DBA_STMT_AUDIT_OPTS	Displays the details of statement-level audit configurations.
STMT_AUDIT_OPTION_MAP	Displays the types, names, and priorities of statement-level audit configurations.
USER_AUDIT_OBJECT	Displays the audit trail records of objects that the current user has access to.
USER_AUDIT_SESSION	Displays the audit trail records of connections and disconnections of the current user.
USER_AUDIT_STATEMENT	Displays the audit trail entries of `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements issued by the current user.
USER_AUDIT_TRAIL	Displays the standard audit trail entries related to the current user.

Indexes

View name	Description
ALL_INDEXES	Displays the index columns of all tables that the user can access.
ALL_IND_COLUMNS	Displays the index columns of all tables that the user can access.
ALL_IND_EXPRESSIONS	Displays the function-based indexes that the user can access in the database.
ALL_IND_PARTITIONS	Displays the partitions of indexes that the user can access in the database.
ALL_IND_SUBPARTITIONS	Displays the subpartitions of indexes that the user can access in the database.
ALL_PART_INDEXES	Displays the partitions of partitioned indexes that the user can access.
DBA_INDEXES	Displays the indexes of all tables in the database.
DBA_IND_COLUMNS	Displays the index columns of all tables in the database.
DBA_IND_EXPRESSIONS	Displays all function-based indexes in the database.
DBA_IND_PARTITIONS	Displays the partitions of indexes in the database.
DBA_IND_SUBPARTITIONS	Displays the subpartitions of indexes in the database.
USER_INDEXES	Displays the indexes of all tables owned by the user.
USER_IND_COLUMNS	Displays the index columns of all tables owned by the user.
USER_IND_EXPRESSIONS	Displays the function-based indexes owned by the user in the database.
USER_IND_PARTITIONS	Displays the partitions of indexes owned by the user in the database. This view does not contain the `INDEX_OWNER` column, which is included in the `ALL_IND_PARTITIONS` and `DBA_IND_PARTITIONS` views.
USER_IND_SUBPARTITIONS	Displays the subpartitions of indexes owned by the user in the database. This view does not contain the `INDEX_OWNER` column, which is included in the `DBA_IND_SUBPARTITIONS` and `ALL_IND_SUBPARTITIONS` views.
USER_PART_INDEXES	Displays the partitions of partitioned indexes that the user can access.

Partitioning

View name	Description
ALL_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key of all partitioned objects that the user has access to.
ALL_PART_TABLES	Displays the partition information of partitioned tables that the user has access to.
ALL_SUBPART_TEMPLATES	Displays descriptions of all subpartition templates.
ALL_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key of all partitioned objects that the user has access to.
ALL_TAB_PARTITIONS	Displays the multilevel partitioning information, storage parameters, and statistics of all partitioned tables.
ALL_TAB_SUBPARTITIONS	Displays the partition-level details, storage parameters, and statistics generated by the `DBMS_STATS` package for the partitions of the tables that the user has access to.
DBA_PART_INDEXES	Displays the partitions of all indexes in the database.
DBA_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key of all partitioned objects in the database.
DBA_PART_TABLES	Displays the partition information of partitioned tables that the user has access to.
DBA_SUBPART_TEMPLATES	Displays descriptions of all subpartition templates.
DBA_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key of all partitioned objects in the database.
DBA_TAB_PARTITIONS	Displays the multilevel partitioning information, storage parameters, and statistics of the tables that the user has access to.
DBA_TAB_SUBPARTITIONS	Displays the subpartition name, table name, partition name to which the subpartition belongs, storage attributes, and statistics generated by the `DBMS_STATS` package.
USER_PART_KEY_COLUMNS	Displays the columns that are part of the partitioning key of all partitioned objects that the user owns.
USER_PART_TABLES	Displays the partition information of partitioned tables that the user owns.
USER_SUBPART_TEMPLATES	Displays descriptions of all subpartition templates.
USER_SUBPART_KEY_COLUMNS	Displays the columns that are part of the subpartitioning key of all partitioned objects that the user owns.
USER_TAB_SUBPARTITIONS	Displays the subpartition name, table name, partition name to which the subpartition belongs, storage attributes, and statistics generated by the `DBMS_STATS` package for each table that the user owns.
USER_TAB_PARTITIONS	Displays the multilevel partitioning information, storage parameters, and statistics of the tables that the user owns.

View name	Description
DBA_OB_DEADLOCK_EVENT_HISTORY	Displays the history of deadlocks. This view displays the deadlocks that occurred in the current tenant in a non-root tenant.

View name	Description
ALL_SEQUENCES	Displays all sequences accessible to the user.
DBA_SEQUENCES	Displays all sequences in the database.
USER_SEQUENCES	Displays all sequences owned by the current user.
TENANT_VIRTUAL_GLOBAL_VARIABLE	Displays the information of global variables.
TENANT_VIRTUAL_SESSION_VARIABLE	Displays the variables of the session.

Synonym views

View name	Description
ALL_SYNONYMS	Displays all synonyms accessible to the user.
DBA_SYNONYMS	Displays all synonyms in the database.
USER_SYNONYMS	Displays the synonyms owned by the current user.

Trigger views

View name	Description
ALL_TRIGGERS	Displays the triggers and descriptions of the tables on which the current user has privileges. If the current user has the CREATE ANY TRIGGER privilege, this view displays the descriptions of all triggers in the database.
DBA_TRIGGERS	Displays all triggers in the database.
USER_TRIGGERS	Displays the triggers owned by the current user.

Recycle bin

View name	Description
DBA_RECYCLEBIN	Displays information about all recycle bins in the database.
USER_RECYCLEBIN	Displays information about the recycle bins owned by the current user. The columns are the same as those in `DBA_RECYCLEBIN`, except that the `OWNER` column is removed.

Resource groups

View name	Description
DBA_RSRC_GROUP_MAPPINGS	Displays the mappings between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	Displays information about all resource groups in the database.
DBA_RSRC_PLANS	Displays all system-defined resource management plans.
DBA_RSRC_PLAN_DIRECTIVES	Displays the details of plan directives for each resource group in the database.

NLS

View name	Description
NLS_DATABASE_PARAMETERS	Displays the NLS parameters at the database level (tenant level in OceanBase Database).
NLS_INSTANCE_PARAMETERS	Displays the NLS parameters at the instance level (tenant level).
NLS_SESSION_PARAMETERS	Displays the NLS parameters at the session level.

User-defined types

View name	Description
ALL_COLL_TYPES	Displays the user-defined collection types available in the database. The columns are the same as those in the `DBA_COLL_TYPES` view.
ALL_TYPES	Displays the user-defined types available in the database.
ALL_TYPE_ATTRS	Displays the attribute information of the user-defined types available in the database.
DBA_COLL_TYPES	Displays the user-defined collection types available in the database. The columns are the same as those in the `ALL_COLL_TYPES` view.
DBA_TYPES	Displays the user-defined types available in the database.
DBA_TYPE_ATTRS	Displays the attribute information of the user-defined types available in the database.
USER_COLL_TYPES	Displays the user-defined collection types available to the current user.
USER_TYPES	Displays the user-defined types of the current user.
USER_TYPE_ATTRS	Displays the attribute information of the user-defined types available to the current user.

Objects

View name	Description
ALL_ERRORS	Displays errors for the storage objects that the user can access.
DBA_ERRORS	Displays errors for the storage objects in the database.
USER_ERRORS	Displays errors for the storage objects that the user can access.
DBA_SEGMENTS	Displays the storage information of all segments in the database.
USER_SEGMENTS	Displays the storage information of the segments of the objects under the user's account.

Profile

View name	Description
ALL_PROFILES	Displays all profiles and the limitations of these profiles.
DBA_PROFILES	Displays all profiles and the limitations of these profiles.
USER_PROFILES	Displays all profiles and the limitations of these profiles.

View name	Description
DBA_OB_LS_LOCATIONS	Displays the distribution of log stream (LS) replicas in the tenant.
DBA_OB_TABLEGROUPS	Displays the metadata of table groups, including the partition information of table groups.
DBA_OB_TABLEGROUP_PARTITIONS	Displays the partition information of partitions in a table group.
DBA_OB_TABLEGROUP_SUBPARTITIONS	Displays the subpartition information of subpartitions in a table group.
DBA_OB_TABLET_REPLICAS	Displays information about all tablet replicas in the tenant. Each tablet replica is uniquely identified by the composite key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
DBA_OB_TABLET_TO_LS	Displays the list of all tablets in the tenant and the log stream to which each tablet belongs.
DBA_OB_LS	Displays the status and recovery progress of log streams.

Schedulers

View name	Description
DBA_SCHEDULER_JOBS	Displays information about the scheduler jobs that the current user has access to.
DBA_SCHEDULER_PROGRAM	Displays information about all schedulers in the database.

DBLINKs

View name	Description
ALL_DB_LINKS	Displays all DBLINKs that the current user has access to.
DBA_DB_LINKS	Displays all DBLINKs created in the current tenant.
USER_DB_LINKS	Displays the DBLINKs created by the current user.

Not supported views

View name	Description
ALL_METHOD_PARAMS	Displays the method parameters of objects that the user has access to.
ALL_SCHEDULER_JOB_ARGS	Displays the parameters of scheduled jobs that the user has access to.
ALL_SCHEDULER_PROGRAM_ARGS	Displays the parameters of schedulers that the user has access to.
ALL_TYPE_METHODS	Displays the methods of objects that the user has access to.
DBA_METHOD_PARAMS	Displays the method parameters of objects in the database.
DBA_SCHEDULER_JOB_ARGS	Displays the parameters of scheduled jobs in the database.
USER_SCHEDULER_JOB_ARGS	Displays the parameters of scheduled jobs that the current user owns.
DBA_SCHEDULER_PROGRAM_ARGS	Displays the parameters of schedulers in the database.
USER_SCHEDULER_PROGRAM_ARGS	Displays the parameters of schedulers that the current user owns.
DBA_TYPE_METHODS	Displays the methods of objects in the database.
USER_TYPE_METHODS	Displays the methods of objects that the user has access to, except that the OWNER column is not included in the result.

Overview of the performance view

Statistics

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information on all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information on all servers.
GV$OB_UNITS	Displays the unit information on the OBServer node where the tenant resides. System tenant users can view the units on all OBServer nodes in the cluster.
GV$SYSSTAT	Displays the system-level statistical event information on all servers.
GV$DML_STATS	Displays the DML information in the current user table.
V$DML_STATS	Displays the DML information in the current user table.
V$GLOBALCONTEXT	Displays the `CLIENT_IDENTIFIER` value of global context attributes accessible to the current session.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the parameter information on the OBServer node where you reside.
V$SYSSTAT	Displays the system-level statistical event information on the current server.
V$OB_UNITS	Displays the unit information on the OBServer node where you reside.
V$VERSION	Queries the names and versions of all components of the database product.

View name	Description
GV$INSTANCE	Displays the status of the current database instance.
V$INSTANCE	Displays the status of the current database instance.

View name	Description
GV$OB_MEMORY	Displays the memory usage of each tenant on all servers.
GV$OB_MEMSTORE	Displays the memory usage of MemTables of all tenants on all servers.
GV$OB_SQL_WORKAREA_MEMORY_INFO	Provides information about the SQL Workarea, including the maximum available memory, the current memory usage, and the memory usage of held data.
GV$OB_SSTABLES	Displays the SSTable information of tenants.
GV$OB_MEMSTORE_INFO	Displays the details of MemTables on all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	Displays the details of MemTables on all partitions of all tenants on all servers.
V$OB_MEMORY	Displays the memory statistics of tenants.
V$OB_MEMSTORE	Displays the memory usage of MemTables on all tenants on the current server.
V$OB_SSTABLES	Displays the SSTable information of tenants.
GV$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	Displays the memory usage of each tenant in the current observer process.

Plan cache

View name	Description
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache of all servers.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan caches of all servers in the current tenant.
GV$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers in the current tenant.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache of the current server.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on the current server in the current tenant.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers in the current tenant.
V$RSRC_PLAN	Displays the resource management plans of the current active tenant.

View name	Description
GV$OB_LOG_STAT	Displays the status of the PALF.
V$OB_LOG_STAT	Displays the status of the PALF.

Monitoring information

View name	Description
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on all OBServer nodes.
GV$OB_PS_ITEM_INFO	Provides monitoring functionality for Prepared Statements and displays basic information about all prepared statements in the PS cache.
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
GV$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_DTL_INTERM_RESULT_MONITOR	Displays the monitoring information of the DTL intermediate result manager.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on OBServer nodes.
V$OB_PS_ITEM_INFO	Provides monitoring functionality for Prepared Statements and displays basic information about all prepared statements in the PS cache.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
V$SQL_MONITOR_STATNAME	Displays the meaning of the numbers in the `OTHERSTAT_X_ID` column of the `GV$SQL_PLAN_MONITOR` view.

View name	Description
GV$OB_PROCESSLIST	Displays the session information of all OBServer nodes where the tenant resides.
GV$SESSION_WAIT	Displays information about the current or last wait event of all sessions on all servers, including the event name and duration.
GV$SESSION_WAIT_HISTORY	Displays information about the last 10 wait events of all sessions on all servers.
GV$SESSTAT	Displays some statistics at the session level on all servers.
GV$ACTIVE_SESSION_HISTORY	Displays the ASH data of active sessions.
V$ACTIVE_SESSION_HISTORY	Displays the ASH data of active sessions.
V$NLS_PARAMETERS	Queries the NLS parameters at the session level.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$SESSION_WAIT	Displays information about the current or last wait event of all sessions on the current server, including the event name and duration.
V$SESSION_WAIT_HISTORY	Displays information about the last 10 wait events of all sessions on the current server.
V$SESSTAT	Displays some statistics at the session level.
V$EVENT_NAME	Displays the definitions of various events in the tenant.

View name	Description
GV$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	Displays the plan-level statistics of slow queries on all OBServer nodes. A statistics record is generated for each slow query, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	Displays the plan-level statistics of slow queries on all OBServer nodes. A statistics record is generated for each slow query, and the trace information of the plan is recorded.

Threads

View name	Description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, view the execution information of each thread.

Workarea

View name	Description
GV$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
GV$SQL_WORKAREA_HISTOGRAM	Statistics of all operators whose memory is managed by SQL automatic memory management.
V$OB_SQL_WORKAREA_MEMORY_INFO	Queries some overall statistics about SQL workareas, including the maximum available memory, the current memory usage, and the current held memory.
V$SQL_WORKAREA	Statistics of all operators whose memory is managed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	Information about the workareas of active operators.
V$SQL_WORKAREA_HISTOGRAM	Statistics of all operators whose memory is managed by SQL automatic memory management.

View name	Description
GV$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of the tenant on OBServer nodes.
GV$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the history of tablet-level major compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress of tablet-level major compactions.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
GV$SYSTEM_EVENT	Displays the wait events at the system level for the tenant on all servers, and counts the occurrences and the total waiting and timeout durations for each event type.
GV$GLOBAL_TRANSACTION	Displays information about the active global transactions.
V$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of the tenant on OBServer nodes.
V$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
V$OB_TABLET_COMPACTION_HISTORY	Displays the history of tablet-level major compactions.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress of tablet-level major compactions.
V$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
V$SYSTEM_EVENT	Displays the wait events at the system level for the tenant on the current server, and counts the occurrences and the total waiting and timeout durations for each event type.
V$GLOBAL_TRANSACTION	Displays information about the active global transactions.
GV$OB_GLOBAL_TRANSACTION	Displays information about all XA transactions in the cluster.
V$OB_GLOBAL_TRANSACTION	Displays information about all XA transactions that are initiated by the current node.

Time zones

View name	Description
V$TIMEZONE_NAMES	Displays the names of effective time zones.

Encrypted tables

View name	Description
V$OB_ENCRYPTED_TABLES	Displays the encryption status of tables with the encryption feature enabled.
V$ENCRYPTED_TABLESPACES	Displays the encryption status of tablespaces with the encryption feature enabled.

DBLINK

View name	Description
GV$DBLINK	Displays all database links (`IN_TRANSACTION=YES`) opened after the query session on this view is started. These database links must be committed or rolled back before they are closed.
V$DBLINK	Displays all database links (`IN_TRANSACTION=YES`) opened after the query session on this view is started. These database links must be committed or rolled back before they are closed.

Customer Stories

Documentation

Overview of system views

Overview of views in the SYS tenant

Dictionary views overview

Table and column-related

Outline

Basic information about the database

Partitioning

Session-related views

Views related to backup and restore

Statistics and histograms

Tenant-related

Resource-related

Views related to replicas and logs

Overview of the performance view

Event-related statistics

Monitoring-related statistics

I/O-related statistics

Cache-related statistics

SQL-related statistics

Log-related statistics

Network-related statistics

Database-related statistics

Statistics related to minor compactions

Statistics related to threads

Workarea-related statistics

Statistics on encrypted tables

Statistics on transactions

Overview of views in a MySQL tenant

Dictionary views overview

Help command

SPM-related

Privilege-related

Scheduler

Storage-related

Time zone-related

Character sets

Tables and columns

Outline

Basic information about the database

Partition-related views

Threads

Constraints

Session-related views

User login-related views

Views related to backup and restore

Statistics and histograms

Tenant-related

Resource-related

Views related to replicas and logs

Overview of the performance view

Event-related statistics

Monitoring-related statistics

Cache-related statistics

SQL-related statistics

Log-related statistics

Network-related statistics

Database-related statistics

Statistics related to minor compactions

Statistics related to threads

Workarea-related statistics

Statistics on encrypted tables

Statistics on transactions

Overview of views in an Oracle tenant

Overview

Applicability

Tables and views

Outline

SPM

Database information

Functions and procedures

Backup and restore-related

Statistics and histograms

Users and privileges

Views

Auditing

Indexes

Partitioning

Session-related views