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

View name	Description
oceanbase.CDB_IND_COLUMNS	Displays the column information of all index tables in 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 tablegroup and table association of all tenants in the sys tenant. Tables not in a tablegroup are not displayed.
oceanbase.CDB_TAB_COLS	Displays the columns of all tables and views in all tenants.
oceanbase.CDB_TAB_COLS_V$	Displays the columns of all tables and views in all tenants.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the association between tablegroups and tables. Tables not in a tablegroup 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 their 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.

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 outlines for the current tenant.

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

View name	Description
oceanbase.CDB_IND_PARTITIONS	Displays the partition information of index tables of all tenants.
oceanbase.CDB_PART_INDEXES	Displays the partition information of index tables of all tenants.
oceanbase.CDB_PART_TABLES	Displays the partition information of partitioned tables of all tenants.
oceanbase.CDB_SUBPARTITION_TEMPLATES	Displays the template-based subpartition information of partitioned tables of all tenants.
oceanbase.CDB_TAB_PARTITIONS	Displays the partition information of partitioned tables of all tenants.
oceanbase.CDB_TAB_SUBPARTITIONS	Displays the subpartition information of partitioned tables of all tenants.
oceanbase.DBA_IND_PARTITIONS	Displays the partition and subpartition information of indexes.
oceanbase.DBA_PART_INDEXES	Displays the partition information of all indexes.
oceanbase.DBA_PART_TABLES	Displays the partition information of user tables.
oceanbase.DBA_TAB_PARTITIONS	Displays the partition and subpartition information that the current user has access to, along with the storage parameters and statistics of partitions and subpartitions.
oceanbase.DBA_TAB_SUBPARTITIONS	Displays the subpartition name, the table name, the partition name to which the subpartition belongs, the storage attributes of the subpartition, and the statistics generated by the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Displays the description of all subpartition templates.

View name	Description
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS	Displays the partition transfer tasks being processed in all tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the history of partition transfer tasks in all tenants.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	Displays the partition transfer tasks being processed in the current tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	Displays the history of partition transfer tasks in the current tenant.

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

View name	Description
oceanbase.CDB_OB_RESTORE_PROGRESS	Displays the execution progress of ongoing physical restore tasks.
oceanbase.CDB_OB_RESTORE_HISTORY	Displays the status of completed physical restore tasks.
oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.
oceanbase.CDB_OB_BACKUP_SET_FILES	Displays the status of files in backup sets.
oceanbase.CDB_OB_BACKUP_JOBS	Displays the backup jobs of all tenants in the cluster. A backup job record is generated after a backup job is initiated.
oceanbase.CDB_OB_BACKUP_JOB_HISTORY	Displays the job history of backup jobs of all tenants in the cluster.
oceanbase.CDB_OB_BACKUP_TASKS	Displays the task-level backup tasks of all tenants in the cluster. A task record is generated after a backup_set is backed up. A task record corresponds to a job record.
oceanbase.CDB_OB_BACKUP_TASK_HISTORY	Displays the history of task-level backup tasks of all tenants in the cluster.
oceanbase.DBA_OB_BACKUP_JOBS	Displays the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	Displays the job history of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	Displays the job history of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	Displays the history of task-level backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	Displays the status of files in backup sets.
oceanbase.DBA_OB_RESTORE_PROGRESS	Displays the restore tasks in progress.
oceanbase.DBA_OB_RESTORE_HISTORY	Displays the completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
oceanbase.CDB_OB_ARCHIVE_DEST	Displays the configurations of archive paths.
oceanbase.CDB_OB_BACKUP_PARAMETER	Displays the backup parameters.
oceanbase.CDB_OB_BACKUP_DELETE_JOBS	Displays the execution progress of tenant-level backup deletion jobs.
oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of completed backup deletion jobs.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS	Displays the information about backup_set/backup_piece deletion tasks that are being executed.
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of completed backup_set/backup_piece deletion tasks.
oceanbase.CDB_OB_BACKUP_DELETE_POLICY	Displays the deletion policies that are set for automatic or expiration-based deletion.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations used for backup and restore.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	Displays the information about backup destinations used for backup and restore.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	Displays the history of backup destinations used for backup and restore.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	Displays the deletion policies that are set for automatic or expiration-based deletion.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	Displays the execution progress of tenant-level backup deletion jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	Displays the history of completed backup deletion jobs.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	Displays the information about backup_set/backup_piece deletion tasks that are being executed.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	Displays the history of completed backup_set/backup_piece deletion tasks.
oceanbase.DBA_OB_ARCHIVELOG	Displays the status of log backup for each archive path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	Displays the status of all log backups, both historical and current.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	Displays the status of pieces in backup sets.
oceanbase.CDB_OB_ARCHIVELOG	Displays the status of log archiving for each archive path.
oceanbase.CDB_OB_ARCHIVELOG_SUMMARY	Displays the status of all log archivings, both historical and current.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS	Displays information about table-level restore jobs.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	Displays information about table-level restore jobs.
oceanbase.CDB_OB_IMPORT_TABLE_JOBS	Displays information about import jobs.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	Displays information about import jobs.
oceanbase.CDB_OB_IMPORT_TABLE_TASKS	Displays records of table-level cross-tenant import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	Displays records of table-level import tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of table-level restore jobs.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	Displays the results of table-level restore jobs.
oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY	Displays the results of import jobs.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	Displays the results of import jobs.
oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY	Displays the history of table-level cross-tenant import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	Displays the history of table-level cross-tenant import tasks.

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

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

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

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

View name	Description
oceanbase.DBA_WR_SNAPSHOT	Displays the `SNAPSHOT` information of the current tenant.
oceanbase.CDB_WR_SNAPSHOT	Displays the `SNAPSHOT` information of all tenants.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	Displays the ASH data of the current tenant after it is persisted.
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY	Displays the ASH data of all tenants after it is persisted.
oceanbase.DBA_WR_STATNAME	Displays the names of the system statistics of the current tenant.
oceanbase.CDB_WR_STATNAME	Displays the names of the system statistics of all tenants.
oceanbase.DBA_WR_SYSSTAT	Displays the details of the system statistics of the current tenant.
oceanbase.CDB_WR_SYSSTAT	Displays the details of the system statistics of all tenants.
oceanbase.DBA_WR_CONTROL	Displays the configuration information related to WR.
oceanbase.CDB_WR_CONTROL	Displays the configuration information related to WR.
oceanbase.CDB_WR_SYSTEM_EVENT	Displays the tenant-level wait events of all tenants after they are persisted.
oceanbase.DBA_WR_SYSTEM_EVENT	Displays the tenant-level wait events of the current tenant after they are persisted.
oceanbase.CDB_WR_EVENT_NAME	Displays the tenant-level wait event names of all tenants after they are persisted.
oceanbase.DBA_WR_EVENT_NAME	Displays the tenant-level wait event names of the current tenant after they are persisted.
oceanbase.CDB_WR_SQLSTAT	Displays the basic performance statistics of SQL statements executed in all tenants. Each SQL statement is represented by a row (that is, each unique value of the `SQL_ID` and `Plan_Hash` columns is assigned a row).
oceanbase.DBA_WR_SQLSTAT	Displays the basic performance statistics of SQL statements executed in the current tenant. Each SQL statement is represented by a row (that is, each unique value of the `SQL_ID` and `Plan_Hash` columns is assigned a row).
oceanbase.CDB_WR_SYS_TIME_MODEL	Displays the WR data of the time model statistics of all tenants.
oceanbase.DBA_WR_SYS_TIME_MODEL	Displays the WR data of the time model statistics of the current tenant.
oceanbase.CDB_WR_SQLTEXT	Displays the SQL texts collected by WR for all tenants.
oceanbase.DBA_WR_SQLTEXT	Displays the SQL texts collected by WR for the current tenant.

View name	Description
mysql.procs_priv	Stores the privilege information of stored procedures and functions.

View name	Description
oceanbase.DBA_OB_SYS_VARIABLES	Displays the configurations of system variables in the current tenant.

View name	Description
oceanbase.CDB_OB_KV_TTL_TASKS	Displays the TTL tasks being executed in all tenants in the system tenant.
oceanbase.CDB_OB_KV_TTL_TASK_HISTORY	Displays the historical TTL tasks of all tenants in the system tenant.
oceanbase.DBA_OB_KV_TTL_TASKS	Displays the TTL tasks being executed in the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	Displays the historical TTL tasks of the current tenant.

View name	Description
GV$OB_CGROUP_CONFIG	Allows you to quickly query the cgroup configurations of an OBServer node.
V$OB_CGROUP_CONFIG	Allows you to quickly query the cgroup configurations of an OBServer node.

View name	Description
GV$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
GV$OB_PROCESSLIST	Displays the session information of all OBServer nodes in the tenant.
GV$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
GV$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level major compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level major compactions.
GV$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
GV$SESSION_EVENT	Displays the wait events 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, including the idle session.
GV$SESSION_WAIT_HISTORY	Displays the information of the last 10 wait events of all sessions on all servers.
GV$SYSTEM_EVENT	Displays the tenant-level wait events in the cluster.
GV$SESSTAT	The statistics of wait events on the session level on all OBServer nodes.
GV$SYSSTAT	Displays the tenant-level statistics of wait events on all servers.
GV$ACTIVE_SESSION_HISTORY	Displays the ASH data.
V$ACTIVE_SESSION_HISTORY	Displays the ASH data.
V$OB_COMPACTION_PROGRESS	Displays the major compaction progress information of each OBServer node in the tenant.
V$OB_COMPACTION_SUGGESTIONS	Displays suggestions for major compactions.
V$OB_PROCESSLIST	Displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	Displays the diagnostic information of major compactions.
V$OB_TABLET_COMPACTION_HISTORY	Displays the historical information of tablet-level major compactions.
V$OB_TABLET_COMPACTION_PROGRESS	Displays the progress information of tablet-level major compactions.
V$OB_TRANSACTION_PARTICIPANTS	Displays the transaction participants on all OBServer nodes.
V$STATNAME	Displays the definitions of all statistics events.
V$EVENT_NAME	Displays the definitions of all statistics events on the current OBServer node.
V$SESSION_WAIT	Detailed information on the current wait events for each session. According to the convention, each wait event will have three parameters, and their corresponding values will be recorded.
V$SESSION_WAIT_HISTORY	Displays the details of the current wait event of each session and the 10 most recent wait events of the session.
V$SESSTAT	Displays the statistics of wait events on the session level.
V$SYSSTAT	Displays the tenant-level statistics of wait 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 all 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.
GV$OB_PL_CACHE_OBJECT	Displays basic information about cache objects related to PL of all tenants.
V$OB_PL_CACHE_OBJECT	Displays basic information about cache objects related to PL of the current tenant.

View name	Description
GV$OB_PLAN_CACHE_STAT	Displays the overall status of each plan cache on all OBServer nodes of the current tenant.
V$OB_PLAN_CACHE_STAT	Records the overall status of each plan cache on all servers of the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan caches on all servers of the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	Records the status of each cached object in the plan cache on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in all servers of the plan caches.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	Displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit ratio, memory usage, and number of cached items.
V$OB_PS_STAT	Monitors the overall status of the PS cache, including the hit ratio, memory usage, and number of cached items.
GV$OB_PS_ITEM_INFO	Provides monitoring functionality for prepared statements. It contains basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	Provides monitoring functionality for prepared statements. It contains basic information about all prepared statements in the PS cache.
GV$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	Displays the usage of PX threads on the OBServer node.
GV$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	Displays the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	Displays the plan-level statistics of slow queries on all OBServer nodes. A statistics record is generated for each slow query, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	Displays the operation-level statistics of slow queries. A statistics record is generated for each operation.
V$SQL_MONITOR_STATNAME	Explains the meaning of numbers in the `OTHERSTAT_X_ID` field of the `GV$SQL_PLAN_MONITOR` view.
GV$OB_FLT_TRACE_CONFIG	Displays diagnostic information for full-featured trace.
GV$OB_SQLSTAT	Displays basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row (namely, each unique combination of `SQL_ID` and `Plan_Hash`).
V$OB_SQLSTAT	Displays basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (namely, each unique combination of `SQL_ID` and `Plan_Hash`).

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 RPC requests sent by all OBServer nodes.
GV$OB_RPC_INCOMING	Statistics on RPC requests received by all OBServer nodes.
V$OB_RPC_OUTGOING	Statistics on RPC data of different RPC packet codes for different tenants on OBServer nodes.
V$OB_RPC_INCOMING	Statistics on RPC data of different RPC packet codes for different tenants on OBServer nodes.

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information of each OBServer node.
GV$OB_PARAMETERS	Displays the parameter information of all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO	Displays the schema information of all servers.
GV$OB_SERVERS	Displays the information of all OBServer nodes.
GV$OB_UNITS	Displays the unit information of OBServer nodes where the tenant resides. The sys tenant can view the units of all OBServer nodes in the cluster.
V$OB_KVCACHE	Displays the KVCACHE information of each OBServer node.
V$OB_PARAMETERS	Displays the parameter information of the current OBServer node.
V$OB_SERVER_SCHEMA_INFO	Displays the schema information of all servers.
V$OB_SERVERS	Displays the information of the current OBServer node.
V$OB_UNITS	Displays the units of the current OBServer node.
GV$DML_STATS	Displays the DML information in the user table.
V$DML_STATS	Displays the DML information in the user table.
GV$OB_KV_CONNECTIONS	Displays the statistics of OBKV connections held by all servers.
V$OB_KV_CONNECTIONS	Displays the statistics of OBKV connections held by the current server.

View name	Description
GV$OB_SESS_TIME_MODEL	Displays the session-level time model statistics of sessions in the cluster.
V$OB_SESS_TIME_MODEL	Displays the session-level time model statistics of sessions on the current node.
GV$OB_SYS_TIME_MODEL	Displays the tenant-level time model statistics of tenants in the cluster.
V$OB_SYS_TIME_MODEL	Displays the tenant-level time model statistics of tenants on the current node.

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

View name	Description
GV$OB_PX_WORKER_STAT	View the execution information of each thread in parallel execution scenarios.
V$OB_PX_WORKER_STAT	View the execution information of each thread in parallel execution scenarios.
GV$OB_TENANT_RUNTIME_INFO	Displays information about queue lengths and thread limits of tenant threads.
V$OB_TENANT_RUNTIME_INFO	Displays information about queue lengths and thread limits of tenant threads.

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

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.

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

View name	Description
GV$OB_ACTIVE_SESSION_HISTORY	Displays the ASH data of active sessions.
V$OB_ACTIVE_SESSION_HISTORY	Displays the ASH data of current active sessions.

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 privilege information (VIRTUAL_TABLE).
mysql.user	Records user-level privilege information (VIRTUAL_TABLE).
information_schema.COLUMN_PRIVILEGES	Displays column privilege information.
information_schema.SCHEMA_PRIVILEGES	Describes database privilege information.
information_schema.TABLE_PRIVILEGES	Records table privilege information.
information_schema.USER_PRIVILEGES	Records user privilege information.
mysql.procs_priv	Stores privilege information about stored procedures and functions.

View name	Description
oceanbase.DBA_OB_KV_TTL_TASKS	Displays the TTL tasks that are currently being executed in the tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	Displays the TTL tasks that have been executed in the tenant.

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	Records the types of time zone transitions (SYSTEM_VIEW).

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

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

View	Description
oceanbase.DBA_OB_OUTLINES	This view displays the execution plan outline information of the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the outline information of the throttling rules of the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the outline information of the execution plans and throttling rules of the current tenant.

View name	Description
oceanbase.CDB_OB_DATABASES	This view displays the metadata of all databases of all tenants in the sys tenant.
oceanbase.CDB_OB_MAJOR_COMPACTION	This view displays the global major compaction information of all tenants in the sys tenant.
oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of all zones of all tenants in the sys tenant.
oceanbase.DBA_OB_DATABASES	This view displays the metadata of all databases of the current tenant.
oceanbase.DBA_OB_MAJOR_COMPACTION	This view displays the global major compaction information of the current tenant.
oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY	This view displays the event history of the Root Service.
oceanbase.DBA_OB_SERVER_JOBS	This view displays the tasks related to all OBServer nodes.
oceanbase.DBA_OB_SERVERS	This view displays the information of all OBServer nodes.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information of all zones of the current tenant.
oceanbase.DBA_OB_ZONES	This view displays the information of all zones.
oceanbase.CDB_OB_FREEZE_INFO	This view displays the version information generated by major freeze.
oceanbase.DBA_OB_FREEZE_INFO	This view displays the version information generated by major freeze.

View	Description
oceanbase.CDB_IND_PARTITIONS	This view displays information about partitions of index tables in all tenants.
oceanbase.CDB_PART_INDEXES	This view displays the partition information of all index tables in all tenants.
oceanbase.CDB_PART_TABLES	This view displays the partition information for all tenant partitions.
oceanbase.CDB_SUBPARTITION_TEMPLATES	This view displays subpartition templates of partitioned tables of all tenants.
oceanbase.CDB_TAB_PARTITIONS	This view displays the primary partition information for all tenant partition tables.
oceanbase.CDB_TAB_SUBPARTITIONS	This view displays subpartition information for partitioned tables on all tenants.
oceanbase.DBA_IND_PARTITIONS	This view displays information about indexes partitioned by primary or secondary partitions.
oceanbase.DBA_PART_INDEXES	This view displays partition information of all partition indexes.
oceanbase.DBA_PART_TABLES	This view displays the information of table partitions.
oceanbase.DBA_TAB_PARTITIONS	This view displays the information, storage parameters, and statistics about subpartitions.
oceanbase.DBA_TAB_SUBPARTITIONS	This view displays the subpartition names, table names, partition names, storage attributes, and statistics generated by the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Description

View	Description
oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS	This view displays all the partition transfer tasks currently being processed for all tenants.
oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the execution history of the Transfer Partition tasks of all tenants.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	This view displays all Transfer Partition tasks that are being processed in the current system tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the history of Transfer Partition tasks executed in this tenant.

View name	Description
oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlock events. In the root tenant, this view displays the history of all tenants.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlock events. In a non-root tenant, this view displays the history of the current tenant.
oceanbase.DBA_OB_SERVER_EVENT_HISTORY	This view displays the event history of OBServer nodes.

View name	Description
oceanbase.CDB_OB_RESTORE_PROGRESS	This view displays the execution progress of a physical restore task.
oceanbase.CDB_OB_RESTORE_HISTORY	This view displays the status of a physical restore task when it is completed.
oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES	This view displays the status of a piece in a backup set.
oceanbase.CDB_OB_BACKUP_SET_FILES	This view displays the file status in a backup set.
oceanbase.CDB_OB_BACKUP_JOBS	This view displays the backup jobs of all tenants in the cluster. A backup job is recorded when a backup task is initiated.
oceanbase.CDB_OB_BACKUP_JOB_HISTORY	This view displays the historical records of backup jobs of all tenants in the cluster.
oceanbase.CDB_OB_BACKUP_TASKS	This view displays the task-level backup tasks of all tenants in the cluster. A task record corresponds to a backup set. The task records and job records are in a one-to-one correspondence.
oceanbase.CDB_OB_BACKUP_TASK_HISTORY	This view displays the historical records of task-level backup tasks of all tenants in the cluster.
oceanbase.DBA_OB_BACKUP_JOBS	This view displays the backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	This view displays the historical records of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	This view displays the task-level backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	This view displays the historical records of task-level backup tasks of the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	This view displays the file status in a backup set.
oceanbase.DBA_OB_RESTORE_PROGRESS	This view displays the progress of a restore task.
oceanbase.DBA_OB_RESTORE_HISTORY	This view displays the historical records of completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	This view displays the archive path configuration.
oceanbase.CDB_OB_ARCHIVE_DEST	This view displays the archive path configuration.
oceanbase.CDB_OB_BACKUP_PARAMETER	This view displays the backup parameters.
oceanbase.CDB_OB_BACKUP_DELETE_JOBS	This view displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY	This view displays the historical information of backup cleanup jobs executed in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASKS	This view displays the information of backup_set/backup_piece cleanup tasks being executed in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY	This view displays the historical information of backup_set/backup_piece cleanup tasks completed in the tenant.
oceanbase.CDB_OB_BACKUP_DELETE_POLICY	This view displays the cleanup policies set for expired/automatic cleanup in the tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO	This view displays the backup destination information used for backup and restore in the tenant.
oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY	This view displays the historical information of the backup destination used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	This view displays the backup destination information used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	This view displays the historical information of the backup destination used for backup and restore in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	This view displays the cleanup policies set for expired/automatic cleanup in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	This view displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	This view displays the historical information of backup cleanup jobs executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	This view displays the information of backup_set/backup_piece cleanup tasks being executed in the tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	This view displays the historical information of backup_set/backup_piece cleanup tasks completed in the tenant.
oceanbase.DBA_OB_ARCHIVELOG	This view displays the status of log backups on each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	This view displays the status of all log backups, including historical and current ones.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	This view displays the status of pieces in a backup set.
oceanbase.CDB_OB_ARCHIVELOG	This view displays the log archiving status on each path.
oceanbase.CDB_OB_ARCHIVELOG_SUMMARY	This view displays the log archiving status for all historical and current paths.
oceanbase.CDB_OB_RECOVER_TABLE_JOBS	This view displays information about table-level restore tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	This view displays information about table-level restore tasks.
oceanbase.CDB_OB_IMPORT_TABLE_JOBS	This view displays information about import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	This view displays information about import tasks.
oceanbase.CDB_OB_IMPORT_TABLE_TASKS	This view displays records of table-level cross-tenant import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	This view displays records of table-level import tasks.
oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY	This view displays the results of table-level restore tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	This view displays the results of table-level restore tasks.
oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY	This view displays the results of import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	This view displays the results of import tasks.
oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY	This view displays the historical records of table-level cross-tenant import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	This view displays the historical records of table-level cross-tenant import tasks.

View	Description
oceanbase.DBA_TAB_STATISTICS	This view displays optimizer statistics for all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	This view displays the column statistics and histogram information of all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	This view displays the column statistics and histogram information of all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information of all subpartitions in the database.
oceanbase.DBA_TAB_HISTOGRAMS	This view displays the histograms of all columns in all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	This view displays histogram data on all partitioned tables in the database (endpoints of each histogram).
oceanbase.DBA_SUBPART_HISTOGRAMS	This view displays histogram data for all subpartitioned tables in the database. It displays each histogram's endpoints.
oceanbase.DBA_TAB_STATS_HISTORY	This view displays the table statistic history of all tables in the database.
oceanbase.DBA_IND_STATISTICS	This view displays the optimizer statistics for all indexes in the database.
oceanbase.DBA_TAB_MODIFICATIONS	This view displays the modification information of all tables in the database since the last statistics collection in these tables.
oceanbase.CDB_TAB_COL_STATISTICS	This view displays statistics for columns in the system tenant.

View	Description
oceanbase.DBA_OBJECTS	This view displays all database objects. The view definition is the same as that of ALL_OBJECTS.
oceanbase.CDB_OBJECTS	This view displays information about all objects of all tenants in the system tenant.
oceanbase.DBA_OB_TENANTS	Type
oceanbase.DBA_OB_TENANT_JOBS	This view displays the information about tenant-level jobs.
oceanbase.CDB_OB_SYS_VARIABLES	This view displays the system variable information of all tenants in the system tenant.

View name	Description
oceanbase.DBA_OB_RESOURCE_POOLS	This view displays the resource pool information of all tenants.
oceanbase.DBA_OB_UNIT_JOBS	This view displays all unit-related tasks.
oceanbase.DBA_OB_UNITS	This view displays the unit information of all tenants.
oceanbase.DBA_OB_UNIT_CONFIGS	This view displays the unit specifications of all tenants.
oceanbase.DBA_OB_SEQUENCE_OBJECTS	This view displays all SEQUENCE objects in the database.

View name	Description
oceanbase.CDB_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.CDB_OB_LS_LOCATIONS	This view displays the distribution of log streams (LS) replicas for all tenants.
oceanbase.CDB_OB_TABLEGROUPS	This view displays the metadata of all table groups for all tenants, mainly focusing on the partition information of the table groups.
oceanbase.CDB_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of all partitioned table groups for all tenants.
oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of all partitioned table groups for all tenants.
oceanbase.CDB_OB_TABLET_TO_LS	This view displays the list of all tablets and the log stream information to which each tablet belongs for all tenants.
oceanbase.CDB_OB_TABLET_REPLICAS	This view displays the 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	This view displays the primary partition key information for all tenants' partitioned objects (partitioned tables and partitioned indexes).
oceanbase.CDB_SUBPART_KEY_COLUMNS	This view displays the secondary partition key information for all tenants' partitioned objects (partitioned tables and partitioned indexes).
oceanbase.DBA_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of all partitioned table groups.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of all partitioned table groups.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of all table groups, mainly focusing on the partition information of the table groups.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays the 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	This view displays the list of all tablets and the log stream information to which each tablet belongs for the current tenant.
oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution of log streams (LS) replicas for the current tenant.
oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO	This view displays information about data inconsistencies between tablet replicas.
oceanbase.CDB_OB_LS	This view displays the status and restore progress of log streams.
oceanbase.DBA_OB_LS	This view displays the status and restore progress of log streams.

View name	Description
oceanbase.DBA_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of the current tenant.
oceanbase.CDB_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of all tenants.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data of the current tenant after persistence.
oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data of all tenants after persistence.
oceanbase.DBA_WR_STATNAME	This view displays the names of the system statistics of the current tenant.
oceanbase.CDB_WR_STATNAME	This view displays the names of the system statistics of all tenants.
oceanbase.DBA_WR_SYSSTAT	This view displays the details of the system statistics of the current tenant.
oceanbase.CDB_WR_SYSSTAT	This view displays the details of the system statistics of all tenants.
oceanbase.DBA_WR_CONTROL	This view displays the WR-related configuration information.
oceanbase.CDB_WR_CONTROL	This view displays the WR-related configuration information.
oceanbase.CDB_WR_SYSTEM_EVENT	This view displays the persistent tenant-level waiting event information of all tenants.
oceanbase.DBA_WR_SYSTEM_EVENT	This view displays the persistent tenant-level waiting event information of the current tenant.
oceanbase.CDB_WR_EVENT_NAME	This view displays the persistent tenant-level waiting event names of all tenants.
oceanbase.DBA_WR_EVENT_NAME	This view displays the persistent tenant-level waiting event names of the current tenant.
oceanbase.CDB_WR_SQLSTAT	This view displays the basic performance statistics of the SQL statements executed by all tenants. Each SQL statement is a row (each unique combination of `SQL_ID` and `Plan_Hash` is a row).
oceanbase.DBA_WR_SQLSTAT	This view displays the basic performance statistics of the SQL statements executed by the current tenant. Each SQL statement is a row (each unique combination of `SQL_ID` and `Plan_Hash` is a row).
oceanbase.CDB_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of all tenants.
oceanbase.DBA_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of the current tenant.
oceanbase.CDB_WR_SQLTEXT	This view displays the SQL texts collected by WR for all tenants.
oceanbase.DBA_WR_SQLTEXT	This view displays the SQL texts collected by WR for the current tenant.

View name	Description
mysql.procs_priv	Stores the privilege information of stored procedures and functions.

View name	Description
oceanbase.DBA_OB_SYS_VARIABLES	Displays the configuration of system variables for the current tenant.

View name	Description
oceanbase.CDB_OB_KV_TTL_TASKS	Displays all TTL tasks being executed by all tenants under the sys tenant.
oceanbase.CDB_OB_KV_TTL_TASK_HISTORY	Displays the historical TTL tasks of all tenants under the sys tenant.
oceanbase.DBA_OB_KV_TTL_TASKS	Displays the TTL tasks being executed by the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	Displays the historical TTL tasks of the current tenant.

View name	Description
GV$OB_CGROUP_CONFIG	This view queries the cgroup configurations of an OBServer.
V$OB_CGROUP_CONFIG	This view queries the cgroup configurations of an OBServer.

View name	Description
GV$OB_COMPACTION_PROGRESS	This view displays the major compaction progress at the OBServer level for the tenant.
GV$OB_COMPACTION_SUGGESTIONS	This view displays the compaction suggestions.
GV$OB_PROCESSLIST	This view displays the session information on all OBServer nodes where the tenant is located.
GV$OB_COMPACTION_DIAGNOSE_INFO	This view displays the compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information of tablet-level major compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress information of tablet-level major compactions.
GV$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participant information on all OBServer nodes.
GV$SESSION_EVENT	This view displays the session-level waiting events on all OBServer nodes in the cluster.
GV$SESSION_WAIT	This view displays the current or previous waiting events of all sessions on all servers, including the waiting event name and waiting time.
GV$SESSION_WAIT_HISTORY	This view displays the information about the 10 most recent waiting events of all sessions on all servers.
GV$SYSTEM_EVENT	This view displays the waiting events at the tenant level in the cluster.
GV$SESSTAT	This view displays the session-level statistical events on all OBServer nodes.
GV$SYSSTAT	This view displays the tenant-level statistical events on all servers.
GV$ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$OB_COMPACTION_PROGRESS	This view displays the major compaction progress at the server level for the tenant.
V$OB_COMPACTION_SUGGESTIONS	This view displays the compaction suggestions.
V$OB_PROCESSLIST	This view displays the session information on the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	This view displays the compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	This view displays the history information of tablet-level compactions.
V$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress information of tablet-level compactions.
V$OB_TRANSACTION_PARTICIPANTS	This view displays the information of transaction participants on all OBServer nodes.
V$STATNAME	This view displays the definitions of all statistics events.
V$EVENT_NAME	This view displays the definitions of all statistics events on the current OBServer node.
V$SESSION_WAIT	This view displays the details of the current waiting events for each session. According to the convention, each waiting event has three parameters, and each parameter records the corresponding value.
V$SESSION_WAIT_HISTORY	This view displays the details of the current waiting events for each session, including the last 10 waiting events.
V$SESSTAT	This view displays the statistics events at the session level.
V$SYSSTAT	This view displays the statistics events at the tenant level on the current server.
V$SYSTEM_EVENT	This view displays the statistics events at the tenant level.
GV$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations on the current OBServer node.

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

View name	Description
GV$OB_MEMORY	This view displays the memory statistics at the tenant level.
V$OB_MEMORY	This view displays the memory statistics at the tenant level.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
V$OB_MEMSTORE	This view displays the MemStore statistics at the tenant level.
GV$OB_MEMSTORE_INFO	This view displays the detailed information of MemTables for all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays the detailed information of MemTables for all partitions of all tenants on all servers.
GV$OB_SSTABLES	This view displays the SSTable information of a tenant.
V$OB_SSTABLES	This view displays the SSTable information of a tenant.
GV$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the current observer process.
GV$OB_PL_CACHE_OBJECT	This view displays the basic information of PL-related cache objects for all tenants.
V$OB_PL_CACHE_OBJECT	This view displays the basic information of PL-related cache objects for the current tenant.

View name	Description
GV$OB_PLAN_CACHE_STAT	This view displays the status of each plan cache in the current tenant on all OBServer nodes.
V$OB_PLAN_CACHE_STAT	This view records the status of each plan cache in the current tenant on all servers.
GV$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache of the current tenant on all servers.
V$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache of the current tenant on the current server.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache of all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache of the current server.
GV$OB_PS_STAT	This view monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
V$OB_PS_STAT	This view monitors the overall status of the PS cache, including the hit rate, memory usage, and number of cached items.
GV$OB_PS_ITEM_INFO	This view provides monitoring capabilities for prepared statements and contains basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	This view provides monitoring capabilities for prepared statements and contains basic information about all prepared statements in the PS cache.
GV$OB_PX_TARGET_MONITOR	This view displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	This view displays the usage of PX threads on the OBServer node.
GV$OB_SQL_AUDIT	This view displays the statistics of each SQL request on all servers, including the source and execution status.
V$OB_SQL_AUDIT	This view displays the statistics of each SQL request on the current server, including the source and execution status.
GV$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistic, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	This view displays the operation-level statistics of slow queries. Each operation has a corresponding statistic.
V$SQL_MONITOR_STATNAME	This view displays the meaning of the numbers in the `OTHERSTAT_X_ID` column of the `GV$SQL_PLAN_MONITOR` view.
GV$OB_FLT_TRACE_CONFIG	This view displays the diagnostic information of end-to-end tracing.
GV$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row, where each row corresponds to a unique combination of `SQL_ID` and `Plan_Hash`.
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row, where each row corresponds to a unique combination of `SQL_ID` and `Plan_Hash`.

View name	Description
GV$OB_LOG_STAT	This view displays the status of a Palf.
V$OB_LOG_STAT	This view displays the status of a Palf.

View name	Description
GV$OB_RPC_OUTGOING	The outgoing RPC statistics for all OBServer nodes.
GV$OB_RPC_INCOMING	This view displays the incoming RPC statistics for all OBServer nodes.
V$OB_RPC_OUTGOING	This view displays the outgoing RPC statistics for different packet codes of different tenants on OBServer nodes.
V$OB_RPC_INCOMING	This view displays the incoming RPC statistics for different packet codes of different tenants on OBServer nodes.

View	Description
GV$OB_KVCACHE	This view displays KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	This view displays the configuration information on all OBServer nodes where the tenant is located.
GV$OB_SERVER_SCHEMA_INFO	This view displays the schema information on all servers.
GV$OB_SERVERS	This view displays the information of all OBServer nodes.
GV$OB_UNITS	This view displays the unit information of the OBServer node where the tenant is located. The system tenant can view the unit information of all OBServer nodes in the cluster.
V$OB_KVCACHE	This view displays KVCACHE information on each OBServer node.
V$OB_PARAMETERS	This view displays the configuration information on the current OBServer node.
V$OB_SERVER_SCHEMA_INFO	This view displays the schema information on all servers.
V$OB_SERVERS	This view displays the information of the current OBServer node.
V$OB_UNITS	This view displays the unit information of the current OBServer node.
GV$DML_STATS	This view displays the DML information in the current user table.
V$DML_STATS	This view displays the DML information in the current user table.
GV$OB_KV_CONNECTIONS	This view displays the statistics of the OBKV connections held by all servers.
V$OB_KV_CONNECTIONS	This view displays the statistics of the OBKV connections held by the current server.

View	Description
GV$OB_SESS_TIME_MODEL	This view displays the session-level Time Model statistics in the cluster.
V$OB_SESS_TIME_MODEL	This view displays the session-level Time Model statistics on the current node.
GV$OB_SYS_TIME_MODEL	This view displays the tenant-level Time Model statistics in the cluster.
V$OB_SYS_TIME_MODEL	This view displays the tenant-level Time Model statistics on the current node.

View name	Description
GV$OB_MERGE_INFO	This view displays the statistics related to completed compactions in the OceanBase cluster.
V$OB_MERGE_INFO	This view displays the statistics related to completed compactions in the OceanBase cluster.

View name	Description
GV$OB_PX_WORKER_STAT	In parallel execution scenarios, this view displays the execution information of each thread.
V$OB_PX_WORKER_STAT	In parallel execution scenarios, this view displays the execution information of each thread.
GV$OB_TENANT_RUNTIME_INFO	This view displays the information about queues and thread limits in the tenant threads.
V$OB_TENANT_RUNTIME_INFO	This view displays the information about queues and thread limits in the tenant threads.

View name	Description
GV$SQL_WORKAREA	This view displays the statistics of workareas for all operators executed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	This view displays the workarea information of the currently active operators.
GV$SQL_WORKAREA_HISTOGRAM	This view displays the statistics of all workareas executed, such as the number of times full in-memory processing occurred in the range of 1 M to 2 M and the number of one-pass operations.
GV$OB_SQL_WORKAREA_MEMORY_INFO	This view queries some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory.
V$SQL_WORKAREA	This view displays the statistics of workareas for all operators executed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	This view displays the workarea information of the currently active operators.
V$SQL_WORKAREA_HISTOGRAM	This view displays the statistics of all workareas executed, such as the number of times full in-memory processing occurred in the range of 1 M to 2 M and the number of one-pass operations.
V$OB_SQL_WORKAREA_MEMORY_INFO	This view queries some overall information about the SQL workarea, including the maximum available memory, current used memory, and current held memory.

View name	Description
V$OB_ENCRYPTED_TABLES	This view displays the encryption status of tables with encryption enabled.
V$ENCRYPTED_TABLESPACES	This view displays the encryption status of tablespaces with encryption enabled.

View name	Description
GV$LATCH	This view displays the Latch information of all OBServer nodes in the cluster.
V$LATCH	This view displays the Latch information of all OBServer nodes in the cluster.

View name	Description
GV$OB_ACTIVE_SESSION_HISTORY	This view displays the history of active sessions.
V$OB_ACTIVE_SESSION_HISTORY	This view displays the current history of active sessions.

View	Description
mysql.help_topic	This view, along with the views `mysql.help_category`, `mysql.help_relation`, and `mysql.help_keyword`, generates the commands for the Help system.
mysql.help_category	Generates the help commands with the `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_keyword` tables.
mysql.help_keyword	Together with the `mysql.help_relation`, `mysql.help_topic`, and `mysql.help_category` tables, it generates help commands.
mysql.help_relation	Generates help commands by cooperating with the three tables, `mysql.help_category`, `mysql.help_topic`, and `mysql.help_keyword`.

View	Description
oceanbase.DBA_SQL_PLAN_BASELINES	This view displays SQL plan baselines in SQL Plan Management (SPM).
oceanbase.DBA_SQL_MANAGEMENT_CONFIG	This view displays the configuration parameters in SPM.

View	Description
mysql.db	This view displays database-level privileges (VIRTUAL_TABLE).
mysql.user	This view records the permissions at the user level. (VIRTUAL_TABLE).
information_schema.COLUMN_PRIVILEGES	This view displays column privileges.
information_schema.SCHEMA_PRIVILEGES	Description
information_schema.TABLE_PRIVILEGES	This view records table privileges.
information_schema.USER_PRIVILEGES	This view displays the privilege information of users.
mysql.procs_priv	Stores the privileges of stored procedures and functions.

View	Description
oceanbase.DBA_OB_KV_TTL_TASKS	This view displays the TTL tasks that are being executed for the current tenant.
oceanbase.DBA_OB_KV_TTL_TASK_HISTORY	This view displays the history of TTL tasks of the current tenant.

View	Description
oceanbase.DBA_SCHEDULER_JOBS	This view displays information about all scheduler jobs in the database.

View	Description
mysql.proc	This view displays the information of stored procedures.
information_schema.ENGINES	Records information about storage engines.
information_schema.PARAMETERS	Provides information about the parameters and return values of stored procedures.
information_schema.ROUTINES	This view provides information about stored procedures.

View	Description
mysql.time_zone	This view displays time zone information (SYSTEM_VIEW).
mysql.time_zone_name	This view records the name of the timezone (SYSTEM_VIEW).
mysql.time_zone_transition	`mysql.time_zone_transition` is a system view for recording time zone transition information.
mysql.time_zone_transition_type	Type

View	Description
information_schema.CHARACTER_SETS	This view displays the character sets of OceanBase Database.
information_schema.COLLATIONS	Records the comparison method information for each character set.
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY	Describes the mapping between Character sets and Collations.

View name	Description
information_schema.COLUMNS	Records column information.
information_schema.STATISTICS	Records table index information.
information_schema.TABLES	Records table information.
information_schema.VIEWS	Records view information.
information_schema.VIEW_TABLE_USAGE	Displays information about tables and views used in the view definition.
oceanbase.DBA_OB_TABLEGROUP_TABLES	Displays the association between a tablegroup and a table. Tables not in a tablegroup are not displayed.
oceanbase.DBA_PART_KEY_COLUMNS	Displays columns included in the partitioning key of all partition objects in the database.
oceanbase.DBA_SUBPART_KEY_COLUMNS	Displays columns included in the subpartitioning key of all partition objects in the database.
oceanbase.DBA_OB_TABLE_LOCATIONS	Displays the location of a table or partition, including system tables, user tables, and index tables.

View name	Description
oceanbase.DBA_OB_OUTLINES	Displays the outline information of the execution plan for the current tenant.
oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL	Displays the outline information of the throttling rules for the current tenant.
oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY	Displays the outline information of the execution plan and throttling rules for the current tenant.

View	Description
information_schema.GLOBAL_STATUS	This view records the global status information of OceanBase Database.
information_schema.GLOBAL_VARIABLES	This view displays the global variables.
information_schema.SCHEMATA	Records metadata of databases.
oceanbase.DBA_OB_DATABASES	This view displays database metadata of tenants.
oceanbase.DBA_OB_MAJOR_COMPACTION	This view displays the global compaction information of the current tenant.
oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the major compaction information for each zone in the current tenant.
oceanbase.DBA_OB_FREEZE_INFO	This view displays the version information generated during the major freeze operation.

View	Description
information_schema.PARTITIONS	Records partition information.
oceanbase.DBA_IND_PARTITIONS	This view displays the primary and secondary partitions of indexes.
oceanbase.DBA_PART_INDEXES	This view displays the information of all partition indexes.
oceanbase.DBA_PART_TABLES	This view displays the partitioning information of user tables.
oceanbase.DBA_TAB_PARTITIONS	This view displays information about, storage parameters, and statistics of partitions that are accessible to the current user.
oceanbase.DBA_TAB_SUBPARTITIONS	This view displays the names of subpartitions, tables, and partitions, and their storage attributes, as well as statistics generated by the `DBMS_STATS` package.
oceanbase.DBA_SUBPARTITION_TEMPLATES	Description

View	Description
oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS	This view displays Transfer Partition tasks being processed in the current tenant.
oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the Transfer Partition task history.

View	Description
information_schema.PROCESSLIST	Provides information about running threads.

View	Description
information_schema.CHECK_CONSTRAINTS	This view displays information about constraints of tables and columns when the `CREATE TABLE` operation is executed.
information_schema.KEY_COLUMN_USAGE	Records the constraints on the keys in the Column.
information_schema.REFERENTIAL_CONSTRAINTS	This view displays metadata about foreign key constraints.
information_schema.TABLE_CONSTRAINTS	Description

View	Description
information_schema.SESSION_STATUS	This view displays the status of a session, such as current active connections and database uptime.
information_schema.SESSION_VARIABLES	This view records the session variable information.
oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY	This view displays the historical records of deadlock events. If you are not the tenant administrator, this view displays the historical records of the current tenant.

View	Description
information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS	This view displays failed login attempts of different users.

View name	Description
oceanbase.DBA_OB_BACKUP_JOBS	This view displays backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_JOB_HISTORY	This view displays the history of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASKS	This view displays the history of backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_TASK_HISTORY	This view displays the history of task-level backup jobs of the current tenant.
oceanbase.DBA_OB_BACKUP_SET_FILES	This view displays the status of files in a backup set.
oceanbase.DBA_OB_RESTORE_PROGRESS	This view displays the progress of ongoing restore tasks.
oceanbase.DBA_OB_RESTORE_HISTORY	This view displays the history of completed restore tasks.
oceanbase.DBA_OB_ARCHIVE_DEST	This view displays the archive destination configuration.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO	This view displays the information about the backup destination used for backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY	This view displays the history of the information about the backup destination used for backup and restore in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_POLICY	This view displays the cleanup policy set for expired or automatic cleanup in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_JOBS	This view displays the execution progress of tenant-level backup cleanup jobs.
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY	This view displays the history of backup cleanup jobs executed in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASKS	This view displays the information about the backup_set/backup_piece cleanup tasks being executed in the current tenant.
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY	This view displays the history of backup_set/backup_piece cleanup tasks completed in the current tenant.
oceanbase.DBA_OB_ARCHIVELOG	This view displays the status of log backups on each path.
oceanbase.DBA_OB_ARCHIVELOG_SUMMARY	This view displays the status of all log backups, including historical and current ones.
oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES	This view displays the status of pieces in a backup set.
oceanbase.DBA_OB_RECOVER_TABLE_JOBS	This view displays information about table-level restore tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOBS	This view displays information about import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASKS	This view displays records of table-level import tasks.
oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY	This view displays the results of table-level restore tasks.
oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY	This view displays the results of import tasks.
oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY	This view displays the history records of cross-tenant table-level import tasks.

View	Description
oceanbase.DBA_TAB_STATISTICS	This view displays the optimizer statistics of all tables in the database.
oceanbase.DBA_TAB_COL_STATISTICS	This view displays column statistics and histogram information for all tables in the database.
oceanbase.DBA_PART_COL_STATISTICS	This view displays the statistics and histogram information of columns in all partitioned tables in the database.
oceanbase.DBA_SUBPART_COL_STATISTICS	This view displays the column statistics and histogram information for all subpartitioned tables in the database.
oceanbase.DBA_TAB_HISTOGRAMS	This view displays histograms for all columns of all tables in the database.
oceanbase.DBA_PART_HISTOGRAMS	This view displays the histogram data (endpoint values) of all partitioned tables in the database.
oceanbase.DBA_SUBPART_HISTOGRAMS	This view displays the histogram data for all subpartitioned tables in the database (endpoints of each histogram).
oceanbase.DBA_TAB_STATS_HISTORY	This view displays the table statistics history of all tables in the database.
oceanbase.DBA_IND_STATISTICS	This view displays the statistics collected for all indexes.
oceanbase.DBA_TAB_MODIFICATIONS	This view displays modification information of all tables in the database since the last statistics collection for the table.
information_schema.QUERY_RESPONSE_TIME	Type

View	Description
oceanbase.DBA_OBJECTS	This view displays all database objects. The definition is the same as that of ALL_OBJECTS.
oceanbase.DBA_OB_TENANTS	Type

View	Description
oceanbase.DBA_OB_SEQUENCE_OBJECTS	This view displays all SEQUENCE objects in the database.

View name	Description
oceanbase.DBA_IND_SUBPARTITIONS	This view displays information about all index subpartitions in the database.
oceanbase.DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partitions of a table group.
oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the subpartitions of a table group.
oceanbase.DBA_OB_TABLEGROUPS	This view displays the metadata of a table group, including the partition information.
oceanbase.DBA_OB_TABLET_REPLICAS	This view displays all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
oceanbase.DBA_OB_TABLET_TO_LS	This view displays the list of tablets in the current tenant and the log stream to which each tablet belongs.
oceanbase.DBA_OB_LS_LOCATIONS	This view displays the distribution of log stream (LS) replicas in the current tenant.

View name	Description
oceanbase.DBA_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of the current tenant.
oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY	This view displays the persistent ASH data of the current tenant.
oceanbase.DBA_WR_STATNAME	This view displays the names of system statistics of the current tenant.
oceanbase.DBA_WR_SYSSTAT	This view displays the details of system statistics of the current tenant.
oceanbase.DBA_WR_CONTROL	This view displays the configuration information related to WR.
oceanbase.DBA_WR_SYSTEM_EVENT	This view displays the persistent tenant-level wait event information of the current tenant.
oceanbase.DBA_WR_EVENT_NAME	This view displays the names of persistent tenant-level wait events of the current tenant.
oceanbase.DBA_WR_SQLTEXT	This view displays the SQL text collected by WR for the current tenant.

View name	Description
oceanbase.DBA_WR_SQLSTAT	This view displays the basic performance statistics of SQL statements executed in the current tenant. Each SQL statement is displayed as a row (i.e., each unique value of `SQL_ID` + `Plan_Hash` is a row).

View name	Description
oceanbase.DBA_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of the current tenant.

View name	Description
oceanbase.DBA_OB_SYS_VARIABLES	This view displays the configuration of system variables of the current tenant.

View Name	Description
GV$OB_ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$OB_ACTIVE_SESSION_HISTORY	This view displays the active session history.

View Name	Description
GV$OB_CGROUP_CONFIG	This view displays the cgroup configuration of an OBServer node.
V$OB_CGROUP_CONFIG	This view displays the cgroup configuration of an OBServer node.

View name	Description
GV$OB_COMPACTION_PROGRESS	This view displays the OBServer-level major compaction progress of the tenant.
GV$OB_COMPACTION_SUGGESTIONS	This view displays the major compaction suggestions.
GV$OB_PROCESSLIST	This view displays the session information of all OBServer nodes where the tenant resides.
GV$OB_COMPACTION_DIAGNOSE_INFO	This view displays the major compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	This view displays the historical information about tablet-level major compactions.
GV$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress information about tablet-level major compactions.
GV$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participant information of all OBServer nodes.
GV$SESSION_EVENT	This view displays the session-level waiting events of all OBServer nodes in the cluster.
GV$SESSION_WAIT	This view displays the information about the current or previous waiting events of all sessions on all servers, including the waiting event name and waiting time.
GV$SESSION_WAIT_HISTORY	This view displays the information about the most recent 10 waiting events of all sessions on all servers.
GV$SYSTEM_EVENT	This view displays the waiting events at the tenant level in the cluster.
GV$SESSTAT	This view displays the session-level statistical events of all OBServer nodes.
GV$SYSSTAT	This view displays the tenant-level statistical events on all servers.
GV$ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$OB_COMPACTION_PROGRESS	This view displays the server-level major compaction progress of the tenant.
V$OB_COMPACTION_SUGGESTIONS	This view displays the major compaction suggestions.
V$OB_PROCESSLIST	This view displays the session information of the current OBServer node.
V$OB_COMPACTION_DIAGNOSE_INFO	This view displays the major compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	This view displays the history information of tablet-level compactions.
V$OB_TABLET_COMPACTION_PROGRESS	This view displays the progress information of tablet-level compactions.
V$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participant information on all OBServer nodes.
V$STATNAME	This view displays the definitions of all statistical events.
V$EVENT_NAME	This view displays the definitions of all statistical events on the current OBServer node.
V$SESSION_WAIT	This view displays the details of the current wait event for each session. Each wait event has three parameters, which will be recorded.
V$SESSION_WAIT_HISTORY	This view displays the details of the current wait event for each session, including the last 10 wait events.
V$SESSTAT	This view displays the statistical event overview at the session level.
V$SYSSTAT	This view displays the statistical event information at the tenant level on the current server.
V$SYSTEM_EVENT	This view displays the wait event statistics at the tenant level.
GV$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations in the cluster.
V$SESSION_LONGOPS	This view displays the execution status and progress of DDL operations on the current OBServer node.

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

View name	Description
GV$OB_MEMORY	This view displays the memory statistics at the tenant level.
V$OB_MEMORY	This view displays the memory statistics at the tenant level.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
V$OB_MEMSTORE	This view displays the MemStore statistics at the tenant level.
GV$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
GV$OB_SSTABLES	This view displays the SSTable information of a tenant.
V$OB_SSTABLES	This view displays the SSTable information of a tenant.
GV$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the current observer process.
GV$OB_PL_CACHE_OBJECT	This view displays the basic information of PL-related cache objects for all tenants.
V$OB_PL_CACHE_OBJECT	This view displays the basic information of PL-related cache objects for the current tenant.

View Name	Description
GV$OB_PLAN_CACHE_STAT	This view displays the outline information of the current tenant, primarily for outline migration.
V$OB_PLAN_CACHE_STAT	This view records the overall status of each plan cache on all servers for the current tenant.
GV$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache on all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache on the current server for the current tenant.
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache on all servers.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache on the current server.
GV$OB_PS_STAT	This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
V$OB_PS_STAT	This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items.
GV$OB_PS_ITEM_INFO	This view provides monitoring functionality for prepared statements, containing basic information about all prepared statements in the PS cache.
V$OB_PS_ITEM_INFO	This view provides monitoring functionality for prepared statements, containing basic information about all prepared statements in the PS cache.
GV$OB_PX_TARGET_MONITOR	This view displays the usage of PX threads on all OBServer nodes.
V$OB_PX_TARGET_MONITOR	This view displays the usage of PX threads on the OBServer node.
GV$OB_SQL_AUDIT	This view displays statistical information such as the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	This view displays statistical information such as the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	This view displays plan-level statistics for slow queries on all OBServer nodes. Each slow query has a corresponding statistical record, and the trace information of the plan is also recorded.
V$SQL_PLAN_MONITOR	This view displays operation-level statistics for slow queries. Each operation has a corresponding statistical record.
V$SQL_MONITOR_STATNAME	This view displays the meaning of the numeric values in the `OTHERSTAT_X_ID` column of `GV$SQL_PLAN_MONITOR`.
GV$OB_FLT_TRACE_CONFIG	This view displays diagnostic information for end-to-end tracing.

View name	Description
GV$OB_LOG_STAT	This view displays the status of Palf.
V$OB_LOG_STAT	This view displays the status of Palf.

View name	Description
GV$OB_RPC_OUTGOING	This view displays the statistics of RPC packets sent from all OBServer nodes.
GV$OB_RPC_INCOMING	This view displays the statistics of RPC packets received by all OBServer nodes.
V$OB_RPC_OUTGOING	This view displays the statistics of RPC packets sent from different tenants on different OBServer nodes.
V$OB_RPC_INCOMING	This view displays the statistics of RPC packets received by different tenants on different OBServer nodes.

View name	Description
GV$OB_KVCACHE	This view displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	This view displays the configuration information on all OBServer nodes where the tenant resides.
GV$OB_SERVER_SCHEMA_INFO	This view displays the schema information on all servers.
GV$OB_UNITS	This view displays the unit information on the OBServer node where the tenant resides. The system tenant can view the unit information on all OBServer nodes in the cluster.
V$OB_KVCACHE	This view displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	This view displays the configuration information on the OBServer node.
V$OB_SERVER_SCHEMA_INFO	This view displays the schema information on all servers.
V$OB_UNITS	This view displays the unit information on the OBServer node.
GV$DML_STATS	This view displays the DML information in the current user table.
V$DML_STATS	This view displays the DML information in the current user table.
GV$OB_KV_CONNECTIONS	This view displays the statistics of OBKV connections held by all servers.
V$OB_KV_CONNECTIONS	This view displays the statistics of OBKV connections held by the current server.

View name	Description
GV$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` corresponds to one row).
V$OB_SQLSTAT	This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented by a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` corresponds to one row).

View name	Description
GV$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level in the cluster.
V$OB_SESS_TIME_MODEL	This view displays the Time Model statistics at the session level on the current node.
GV$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level in the cluster.
V$OB_SYS_TIME_MODEL	This view displays the Time Model statistics at the tenant level on the current node.

View name	Description
GV$OB_MERGE_INFO	This view displays the statistics of completed compactions in the OceanBase cluster.
V$OB_MERGE_INFO	This view displays the statistics of completed compactions in the OceanBase cluster.

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

View name	Description
GV$SQL_WORKAREA	This view displays the workarea statistics of all operators executed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	This view displays the workarea information of the active operators.
GV$SQL_WORKAREA_HISTOGRAM	This view displays the statistics of all workareas executed in the past, such as the number of times in-memory processing is performed in the range of 1 MB to 2 MB and the number of one-pass operations.
GV$OB_SQL_WORKAREA_MEMORY_INFO	This view queries some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory.
V$SQL_WORKAREA	This view displays the workarea statistics of all operators executed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	This view displays the workarea information of the active operators.
V$SQL_WORKAREA_HISTOGRAM	This view displays the statistics of all workareas executed in the past, such as the number of times in-memory processing is performed in the range of 1 MB to 2 MB and the number of one-pass operations.
V$OB_SQL_WORKAREA_MEMORY_INFO	This view queries some overall information about the SQL workarea, including the maximum available memory, current used memory, and current held memory.

View name	Description
V$OB_ENCRYPTED_TABLES	This view displays the encryption status of tables with encryption enabled.
V$ENCRYPTED_TABLESPACES	This view displays the encryption status of tablespaces with encryption enabled.

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

View	Description
ALL_ALL_TABLES	This view displays the object and relational tables accessible to the user.
ALL_COL_COMMENTS	This view displays the column comments of the views and tables accessible to the user.
ALL_TABLES	This view displays all tables accessible to the user.
ALL_TAB_COLS	This view displays all columns of the tables, views, and clusters accessible to the current user.
ALL_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters accessible to the current user.
ALL_TAB_COMMENTS	This view displays the comments of the tables and views accessible to the current user.
DBA_COL_COMMENTS	This view displays the column comments of all views and tables in the database.
DBA_TAB_COMMENTS	This view displays the comments of all tables and views in the database.
USER_COL_COMMENTS	This view displays the column comments of the views and tables owned by the current user.
USER_TAB_COMMENTS	This view displays the comments of the tables and views owned by the current user.
DBA_OB_TABLEGROUP_TABLES	This view displays the association between a tablegroup and a table. Tables not in a tablegroup are not displayed.
DBA_TABLES	This view displays all tables in the database.
DBA_ALL_TABLES	This view displays the object and relational tables in the database. The fields of this view are the same as those of ALL_ALL_TABLES.
DBA_TABLESPACES	This view displays all tablespaces in the database.
DBA_TAB_COLS	This view displays all columns of the tables, views, and clusters in the database.
DBA_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters in the database.
USER_ALL_TABLES	This view displays the object and relational tables accessible to the current user. The fields of this view, except for the OWNER field, are the same as those of ALL_ALL_TABLES.
USER_TABLES	This view displays all tables owned by the current user.
USER_TABLESPACES	This view displays the tablespaces accessible to the current user. The columns of this view are the same as those of `DBA_TABLESPACES`, except that the `PLUGGED_IN` field is removed.
USER_TAB_COLS	This view displays all columns of the tables, views, and clusters owned by the current user.
USER_TAB_COLUMNS	This view displays all columns of the tables, views, and clusters owned by the current user.
ALL_VIEWS	This view displays all views accessible to the current user.
DBA_VIEWS	This view displays all views in the database. The columns are the same as those in the `ALL_VIEWS` view.
USER_VIEWS	This view displays views owned by the current user.
DICTIONARY	Description
DICT	Description
DBA_OB_TABLE_LOCATIONS	This view displays the locations of tables and partitions, including system tables, user tables, index tables, and so on.

View name	Description
DBA_OB_OUTLINES	This view displays the outline information of the execution plans of the current tenant.
DBA_OB_CONCURRENT_LIMIT_SQL	This view displays the outline information of the throttling rules of the current tenant.
DBA_OB_OUTLINE_CONCURRENT_HISTORY	This view displays the outline information of the execution plans and throttling rules of the current tenant.

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

View name	Description
DBA_CONTEXT	This view displays the information of all context namespaces in the database.
DBA_OB_DATABASES	This view displays the database metadata of the current tenant.
DBA_OB_MAJOR_COMPACTION	This view displays the global information of the current tenant.
DBA_OB_ZONE_MAJOR_COMPACTION	This view displays the information of the major compactions in each zone of the current tenant.
ALL_OBJECTS	This view displays all database objects accessible to the current user.
DBA_OBJECTS	This view displays all database objects.
USER_OBJECTS	This view displays all database objects owned by the current user.
ALL_DEPENDENCIES	This view displays the dependencies between all database objects.
DBA_DEPENDENCIES	This view displays all dependencies between database objects.
USER_DEPENDENCIES	This view displays the dependencies between objects in the current user schema.
DBA_OB_FREEZE_INFO	This view displays the version information generated by major freeze.

View name	Description
ALL_ARGUMENTS	This view displays the parameters of all functions and procedures accessible to the current user.
ALL_PROCEDURES	This view displays all functions and procedures accessible to the current user, along with their related attributes.
ALL_SOURCE	This view displays the text source of all stored objects accessible to the current user.
DBA_ARGUMENTS	This view displays the parameters of all functions and procedures available in the database. Its columns are the same as those in `ALL_ARGUMENTS`.
DBA_PROCEDURES	This view displays all functions and procedures available in the database, along with their related attributes. Its columns are the same as those in `ALL_PROCEDURES`.
DBA_SOURCE	This view displays the text source of all stored objects in the database. Its columns are the same as those in `ALL_SOURCE`.
USER_ARGUMENTS	This view displays the parameters of all functions and procedures owned by the current user. Its columns are the same as those in `ALL_ARGUMENTS`, excluding the `OWNER` column.
USER_PROCEDURES	This view displays all functions and procedures owned by the current user, along with their related attributes. Its columns are the same as those in `ALL_PROCEDURES`, excluding the `OWNER` column.
USER_SOURCE	This view displays the text source of all stored objects owned by the current user. Its columns are the same as those in `ALL_SOURCE`, excluding the `OWNER` column.
DBA_JOBS	This view displays an overview of all submitted tasks.
USER_JOBS	This view displays an overview of all submitted tasks.
DBA_JOBS_RUNNING	This view displays all running tasks.

View name	Description
DBA_OB_BACKUP_JOBS	This view displays the backup jobs of the current tenant.
DBA_OB_BACKUP_JOB_HISTORY	This view displays the history of backup jobs of the current tenant.
DBA_OB_BACKUP_TASKS	This view displays the task-level backup jobs of the current tenant.
DBA_OB_BACKUP_TASK_HISTORY	This view displays the history of task-level backup jobs of the current tenant.
DBA_OB_BACKUP_SET_FILES	This view displays the status of files in a backup set.
DBA_OB_RESTORE_PROGRESS	This view displays the progress of ongoing restore tasks.
DBA_OB_RESTORE_HISTORY	This view displays the history of completed restore tasks.
DBA_OB_ARCHIVE_DEST	This view displays the archive path configuration.
DBA_OB_BACKUP_STORAGE_INFO	This view displays the information about the backup destination used for backup and restore in the current tenant.
DBA_OB_BACKUP_STORAGE_INFO_HISTORY	This view displays the historical information about the backup destination used for backup and restore in the current tenant.
DBA_OB_BACKUP_DELETE_POLICY	This view displays the deletion policy set for expired or automatic deletion in the current tenant.
DBA_OB_BACKUP_DELETE_JOBS	This view displays the progress of backup deletion jobs at the tenant level.
DBA_OB_BACKUP_DELETE_JOB_HISTORY	This view displays the history of backup deletion jobs executed in the current tenant.
DBA_OB_BACKUP_DELETE_TASKS	This view displays the information about the backup_set/backup_piece deletion tasks being executed in the current tenant.
DBA_OB_BACKUP_DELETE_TASK_HISTORY	This view displays the history of backup_set/backup_piece deletion tasks completed in the current tenant.
DBA_OB_ARCHIVELOG	This view displays the status of log backups on each path.
DBA_OB_ARCHIVELOG_SUMMARY	This view displays the status of all log backups, including historical and current ones.
DBA_OB_ARCHIVELOG_PIECE_FILES	This view displays the status of pieces in a backup set.
DBA_OB_BACKUP_PARAMETER	This view displays the backup parameters.
DBA_OB_RECOVER_TABLE_JOBS	This view displays information about table-level restore tasks.
DBA_OB_IMPORT_TABLE_JOBS	This view displays information about import tasks.
DBA_OB_IMPORT_TABLE_TASKS	This view displays records of table-level import tasks.
DBA_OB_RECOVER_TABLE_JOB_HISTORY	This view displays the results of table-level restore tasks.
DBA_OB_IMPORT_TABLE_JOB_HISTORY	This view displays the results of import tasks.
DBA_OB_IMPORT_TABLE_TASK_HISTORY	This view displays the history of cross-tenant table-level import tasks.

View name	Description
ALL_PART_COL_STATISTICS	This view displays column statistics and histogram information for partitions of all partitioned tables accessible to the current user.
ALL_PART_HISTOGRAMS	This view displays histogram information for all partitions.
ALL_SUBPART_COL_STATISTICS	This view displays column statistics and histogram information for subpartitions of all partitioned tables accessible to the current user.
ALL_SUBPART_HISTOGRAMS	This view displays histogram information for all subpartitions.
ALL_TAB_COL_STATISTICS	This view displays column statistics and histogram information for all tables accessible to the current user.
ALL_TAB_HISTOGRAMS	This view displays histogram information for all tables.
ALL_TAB_STATISTICS	This view displays optimizer statistics for all tables accessible to the current user.
DBA_PART_COL_STATISTICS	This view displays column statistics and histogram information for partitions of all partitioned tables in the database.
DBA_PART_HISTOGRAMS	This view displays histogram information for all partitions.
DBA_SUBPART_COL_STATISTICS	This view displays column statistics and histogram information for subpartitions of all partitioned tables in the database.
DBA_SUBPART_HISTOGRAMS	This view displays histogram information for all subpartitions.
DBA_TAB_COL_STATISTICS	This view displays column statistics and histogram information for all tables in the database.
DBA_TAB_HISTOGRAMS	This view displays histogram information for all tables.
DBA_TAB_STATISTICS	This view displays optimizer statistics for all tables.
USER_PART_COL_STATISTICS	This view displays column statistics and histogram information for partitions of all partitioned tables accessible to the current user.
USER_PART_HISTOGRAMS	This view displays histogram information for all partitions.
USER_SUBPART_COL_STATISTICS	This view displays column statistics and histogram information for subpartitions of all partitioned tables accessible to the current user.
USER_SUBPART_HISTOGRAMS	This view displays histogram information for all subpartitions.
USER_TAB_COL_STATISTICS	This view displays column statistics and histogram information for all tables accessible to the current user.
USER_TAB_HISTOGRAMS	This view displays histogram information for all tables.
USER_TAB_STATISTICS	This view displays the optimizer statistics for all tables of the current user.
ALL_TAB_STATS_HISTORY	This view displays the table statistics modification history for all tables accessible to the current user.
DBA_TAB_STATS_HISTORY	This view displays the table statistics modification history for all tables in the database.
USER_TAB_STATS_HISTORY	This view displays the table statistics modification history for all tables owned by the current user.
ALL_IND_STATISTICS	This view displays the optimizer statistics for indexes on tables accessible to the current user.
DBA_IND_STATISTICS	This view displays the optimizer statistics for all indexes in the database.
USER_IND_STATISTICS	This view displays the optimizer statistics for indexes on tables owned by the current user.
ALL_TAB_MODIFICATIONS	This view displays the modification information for tables accessible to the current user since the last statistics collection.
DBA_TAB_MODIFICATIONS	This view displays the modification information for all tables in the database since the last statistics collection.
USER_TAB_MODIFICATIONS	This view displays the modification information for tables owned by the current user since the last statistics collection.

View name	Description
ALL_USERS	This view displays all database users visible to the current user.
DBA_USERS	This view displays all users in the database.
USER_USERS	This view displays information about the current user.
ALL_COL_PRIVS	This view displays column object privileges granted to the current user as the owner, grantor, or grantee. Column object privileges granted to enabled roles or PUBLIC are also displayed.
ALL_TAB_PRIVS	This view displays object privileges granted to the current user as the owner, grantor, or grantee. Object privileges granted to activated roles or the PUBLIC role are also displayed.
DBA_COL_PRIVS	This view displays all column object privileges granted in the database.
DBA_SYS_PRIVS	This view displays system privileges granted to users and roles.
DBA_TAB_PRIVS	This view displays all object privileges granted in the database.
USER_TAB_PRIVS	This view displays object privileges owned by the current user.
USER_COL_PRIVS	This view displays column object privileges granted to the current user as the owner, grantor, or grantee.
USER_ROLE_PRIVS	This view displays roles granted to the current user.
USER_SYS_PRIVS	This view displays system privileges granted to the current user.
ROLE_TAB_PRIVS	This view displays table privileges granted to roles. It provides information about roles that users can access.
ROLE_SYS_PRIVS	This view displays system privileges granted to roles.
ROLE_ROLE_PRIVS	This view displays roles granted to other roles. It provides information about roles that users can access.
DBA_ROLE_PRIVS	This view displays roles granted to all users and roles in the database.
DBA_ROLES	This view displays all roles in the database.
ALL_DIRECTORIES	This view displays all directories accessible to the current user.
DBA_DIRECTORIES	This view displays all directories accessible to the current user.

View name	Description
ALL_CONSTRAINTS	This view displays constraint information for all tables accessible to the current user.
ALL_CONS_COLUMNS	This view displays column information for all constraints in all tables accessible to the current user.
DBA_CONSTRAINTS	This view displays constraint information for all tables in the database.
DBA_CONS_COLUMNS	This view displays column information for all constraints in all tables in the database.
USER_CONSTRAINTS	This view displays constraint information for all tables owned by the current user.
USER_CONS_COLUMNS	This view displays column information for all constraints in all tables owned by the current user.

View name	Description
ALL_DEF_AUDIT_OPTS	This view displays audit conditions for default auditing of any object.
AUDIT_ACTIONS	This view displays the Action ID and corresponding name in audit records.
DBA_AUDIT_EXISTS	This view displays audit trail entries generated by the `AUDIT EXISTS` and `AUDIT NOT EXISTS` statements.
DBA_AUDIT_OBJECT	This view displays audit trail records for all objects in the database.
DBA_AUDIT_SESSION	This view displays audit trail records for `CONNECT` and `DISCONNECT` events.
DBA_AUDIT_STATEMENT	This view displays audit trail records for `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements in the database.
DBA_AUDIT_TRAIL	This view displays all audit trail entries.
DBA_OBJ_AUDIT_OPTS	This view displays detailed object-level audit configurations.
DBA_STMT_AUDIT_OPTS	This view displays detailed statement-level audit configurations.
STMT_AUDIT_OPTION_MAP	This view displays the type, name, and priority of statement-level audit options.
USER_AUDIT_OBJECT	This view displays audit trail records for objects accessible to the current user.
USER_AUDIT_SESSION	This view displays audit trail records for the current user's connections and disconnections.
USER_AUDIT_STATEMENT	This view displays audit trail entries for `GRANT`, `REVOKE`, `AUDIT`, `NOAUDIT`, and `ALTER SYSTEM` statements issued by the current user.
USER_AUDIT_TRAIL	This view displays standard audit trail entries related to the current user.

View Name	Description
ALL_INDEXES	This view displays the index column information of all tables accessible to the user.
ALL_IND_COLUMNS	This view displays the index column information of all tables accessible to the user.
ALL_IND_EXPRESSIONS	This view displays the information of function-based indexes accessible to the user in the database.
ALL_IND_PARTITIONS	This view displays the information of index partitions accessible to the user in the database.
ALL_IND_SUBPARTITIONS	This view displays the information of all index subpartitions accessible to the user in the database.
ALL_PART_INDEXES	This view displays the partition information of partition indexes accessible to the current user.
DBA_INDEXES	This view displays the index information of all tables in the database.
DBA_IND_COLUMNS	This view displays the index column information of all tables in the database.
DBA_IND_EXPRESSIONS	This view displays the information of all function-based indexes in the database.
DBA_IND_PARTITIONS	This view displays the information of all index partitions in the database.
DBA_IND_SUBPARTITIONS	This view displays the information of all index subpartitions in the database.
USER_INDEXES	This view displays the index information of all tables owned by the user.
USER_IND_COLUMNS	This view displays the index column information of all tables owned by the user.
USER_IND_EXPRESSIONS	This view displays the information of function-based indexes owned by the user in the database.
USER_IND_PARTITIONS	This view displays the information of index partitions owned by the current user in the database. This view does not contain the `INDEX_OWNER` column, which is present in `ALL_IND_PARTITIONS` and `DBA_IND_PARTITIONS`.
USER_IND_SUBPARTITIONS	This view displays the information of all index subpartitions owned by the user in the database. This view does not contain the `INDEX_OWNER` column, which is present in `DBA_IND_SUBPARTITIONS` and `ALL_IND_SUBPARTITIONS`.
USER_PART_INDEXES	This view displays the partition information of partition indexes owned by the current user.

View	Description
ALL_PART_KEY_COLUMNS	This view displays the columns of the partition key in all partitioned objects accessible to the current user.
ALL_PART_TABLES	This view displays partition information of all partitioned tables accessible to the current user.
ALL_SUBPARTITION_TEMPLATES	Description
ALL_SUBPART_KEY_COLUMNS	This view lists the subpartition key columns of all user-accessible subpartitioned objects.
ALL_TAB_PARTITIONS	This view displays the partitions of all partitioned tables. The view also provides storage and statistics parameters of partitions.
ALL_TAB_SUBPARTITIONS	This view displays partition level information, storage parameters, and statistics generated by the `DBMS_STATS` package for partitions accessible by the current user.
DBA_PART_INDEXES	This view displays information about partitions of all indexes.
DBA_PART_KEY_COLUMNS	This view displays the columns in the partitioning key for all partitioned objects in the database.
DBA_PART_TABLES	This view displays the partition information of the partitioned tables that the current user has access to.
DBA_SUBPARTITION_TEMPLATES	Description
DBA_SUBPART_KEY_COLUMNS	This view displays the columns of the subpartition key for all partitioned objects in the database.
DBA_TAB_PARTITIONS	This view displays partitioning information, partition storage parameters, and partition statistics of all tables and clusters that are accessible to the current user.
DBA_TAB_SUBPARTITIONS	This view displays subpartition names, table names, partition names, storage attributes, and statistics generated by the `DBMS_STATS` package.
USER_PART_KEY_COLUMNS	This view displays the columns in partitioning keys of all partitioned objects owned by the current user.
USER_PART_TABLES	This view displays the partition information of the current user's partitioned tables.
USER_SUBPARTITION_TEMPLATES	Description
USER_SUBPART_KEY_COLUMNS	This view displays all columns included in the subpartition key for all partitioned objects owned by the current user.
USER_TAB_SUBPARTITIONS	This view displays subpartition names, table names, partition names, and storage attributes for each subpartition of the tables owned by the current user.
USER_TAB_PARTITIONS	This view displays the hierarchical partitioning information, storage parameters, and statistics for partitions of the current user.

View	Description
DBA_OB_DEADLOCK_EVENT_HISTORY	This view displays the history of deadlock events. In a non-root tenant, the view shows the history of events within that tenant.

View	Description
ALL_SEQUENCES	This view displays all SEQUENCEs accessible to the current user.
DBA_SEQUENCES	This view displays all SEQUENCE in the database.
USER_SEQUENCES	This view displays all sequences of the current user.
TENANT_VIRTUAL_GLOBAL_VARIABLE	This view displays information about global variables.
TENANT_VIRTUAL_SESSION_VARIABLE	This view displays session variable information.

View	Description
ALL_SYNONYMS	This view displays all synonyms accessible by the current user.
DBA_SYNONYMS	This view displays all synonyms in the database.
USER_SYNONYMS	This view displays synonyms owned by the current user.

View	Description
ALL_TRIGGERS	Description
DBA_TRIGGERS	This view displays all triggers in the database.
USER_TRIGGERS	This view displays all triggers owned by the current user.

View	Description
DBA_RECYCLEBIN	This view displays information about the recyclebins in the database.
USER_RECYCLEBIN	This view displays information of the recycle bin owned by the current user. Its columns are the same as those in `DBA_RECYCLEBIN`, but without the `OWNER` column.

View	Description
DBA_RSRC_GROUP_MAPPINGS	This view displays the mappings between users and resource groups.
DBA_RSRC_CONSUMER_GROUPS	This view displays information about all resource consumer groups in the database.
DBA_RSRC_PLANS	This view displays all resource management plans defined by the system.
DBA_RSRC_PLAN_DIRECTIVES	This view displays the details of each resource plan directive for a database.

View	Description
NLS_DATABASE_PARAMETERS	This view displays NLS parameters at the database level (OceanBase database tenant level).
NLS_INSTANCE_PARAMETERS	This view displays NLS parameters at the instance level (tenant level).
NLS_SESSION_PARAMETERS	This view displays NLS parameters at the session level.

View	Description
ALL_COLL_TYPES	Type
ALL_TYPES	Type
ALL_TYPE_ATTRS	Type
DBA_COLL_TYPES	Type
DBA_TYPES	Type
DBA_TYPE_ATTRS	Type
USER_COLL_TYPES	Type
USER_TYPES	Type
USER_TYPE_ATTRS	Type

View name	Description
ALL_ERRORS	This view displays the errors of the storage objects that the current user can access.
DBA_ERRORS	This view displays the errors of the storage objects in the database.
USER_ERRORS	This view displays the errors of the storage objects that the current user can access.
DBA_SEGMENTS	This view displays the storage information of all segments in the database.
USER_SEGMENTS	This view displays the storage information of the segments of the objects in the current user.

View name	Description
ALL_PROFILES	This view displays the profiles and their limits.
DBA_PROFILES	This view displays the profiles and their limits.
USER_PROFILES	This view displays the profiles and their limits.

View name	Description
DBA_OB_LS_LOCATIONS	This view displays the distribution information of the log stream (LS) replicas in the current tenant.
DBA_OB_TABLEGROUPS	This view displays the metadata of the table groups, mainly the partition information of the table groups.
DBA_OB_TABLEGROUP_PARTITIONS	This view displays the primary partition information of the partitioned table groups.
DBA_OB_TABLEGROUP_SUBPARTITIONS	This view displays the secondary partition information of the partitioned table groups.
DBA_OB_TABLET_REPLICAS	This view displays the information of all tablets in the current tenant. Each tablet replica is uniquely determined by the joint key: `<TABLET_ID, SVR_IP, SVR_PORT, LS_ID>`.
DBA_OB_TABLET_TO_LS	This view displays the list of all tablets in the current tenant and the information of the log streams to which the tablets belong.
DBA_OB_LS	This view displays the status and recovery progress of the log streams.

View name	Description
DBA_WR_SNAPSHOT	This view displays the `SNAPSHOT` information of the current tenant.
DBA_WR_ACTIVE_SESSION_HISTORY	This view displays the ASH data of the current tenant.
DBA_WR_STATNAME	This view displays the names of the system statistics of the current tenant.
DBA_WR_SYSSTAT	This view displays the details of the system statistics of the current tenant.
DBA_WR_CONTROL	This view displays the WR-related configuration information.
DBA_WR_SYSTEM_EVENT	This view displays the tenant-level wait event information of the current tenant.
DBA_WR_EVENT_NAME	This view displays the tenant-level wait event names of the current tenant.
DBA_WR_SQLTEXT	This view displays the SQL texts collected by WR of the current tenant.

View name	Description
DBA_WR_SQLSTAT	This view displays the basic performance statistics of the SQL statements executed by the current tenant.

View name	Description
DBA_WR_SYS_TIME_MODEL	This view displays the WR data of the Time Model statistics of the current tenant.

View name	Description
DBA_OB_TRANSFER_PARTITION_TASKS	This view displays the Transfer Partition tasks being processed by the current tenant.
DBA_OB_TRANSFER_PARTITION_TASK_HISTORY	This view displays the history of the Transfer Partition tasks executed by the current tenant.

View name	Description
DBA_SCHEDULER_JOBS	This view displays the scheduler jobs accessible to the current user.
DBA_SCHEDULER_PROGRAM	This view displays all the scheduler information in the database.
DBA_SCHEDULER_JOB_RUN_DETAILS	This view displays all the scheduler jobs in the tenant.

View name	Description
ALL_DB_LINKS	This view displays all the DBLINKs accessible to the current user.
DBA_DB_LINKS	This view displays all the DBLINKs created in the current tenant.
USER_DB_LINKS	This view displays all the DBLINKs created by the current user.

View	Description
ALL_METHOD_PARAMS	Type
ALL_SCHEDULER_JOB_ARGS	This view displays the parameters of scheduler jobs that can be queried by users.
ALL_SCHEDULER_PROGRAM_ARGS	This view displays user-specified parameter information of all scheduler programs.
ALL_TYPE_METHODS	Type
DBA_METHOD_PARAMS	Type
DBA_SCHEDULER_JOB_ARGS	This view displays the information about job arguments of database scheduler jobs.
USER_SCHEDULER_JOB_ARGS	This view displays parameters of the current user's jobs.
DBA_SCHEDULER_PROGRAM_ARGS	This view displays the information about the parameters of a scheduled program.
USER_SCHEDULER_PROGRAM_ARGS	This view displays the scheduler program arguments of the current user.
DBA_TYPE_METHODS	Type
USER_TYPE_METHODS	Type

View name	Description
GV$OB_ACTIVE_SESSION_HISTORY	Displays the active session history.

View name	Description
GV$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
GV$OB_PARAMETERS	Displays the configuration information on all OBServer nodes where the tenant is located.
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 is located. The system tenant can view the unit information on all OBServer nodes in the cluster.
GV$SYSSTAT	Displays the system-level statistical events on all servers.
GV$DML_STATS	Displays the DML information in the current user table.
V$DML_STATS	Displays the DML information in the current user table.
V$GLOBALCONTEXT	Displays the `CLIENT_IDENTIFIER` value of the global context attributes accessible to the current session.
V$OB_KVCACHE	Displays the KVCACHE information on each OBServer node.
V$OB_PARAMETERS	Displays the configuration information on the current OBServer node.
V$SYSSTAT	Displays the system-level statistical events on the current server.
V$OB_UNITS	Displays the unit information on the current OBServer node.
V$VERSION	Displays the names and versions of all components of the database product.
V$STATNAME	Displays the names of statistical items.

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	This view displays the memory usage of each tenant on all servers.
GV$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on all servers.
GV$OB_SQL_WORKAREA_MEMORY_INFO	This view displays information about the SQL workarea, including the maximum available memory, current used memory, and current held memory.
GV$OB_SSTABLES	This view displays the SSTable information for each tenant.
GV$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
V$OB_MEMSTORE_INFO	This view displays the details of MemTables for all partitions of all tenants on all servers.
V$OB_MEMORY	This view displays the memory statistics at the tenant level.
V$OB_MEMSTORE	This view displays the memory usage of MemTables for all tenants on the current server.
V$OB_SSTABLES	This view displays the SSTable information for each tenant.
GV$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the cluster.
V$OB_TENANT_MEMORY	This view displays the memory usage of each tenant in the current observer process.

View name	Description
GV$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache of all servers.
GV$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache of all servers for the current tenant.
GV$OB_PLAN_CACHE_STAT	This view records the overall status of each plan cache in all servers for the current tenant.
V$OB_PLAN_CACHE_PLAN_EXPLAIN	This view displays the physical execution plans cached in the plan cache of the current server.
V$OB_PLAN_CACHE_PLAN_STAT	This view records the status of each cached object in the plan cache of the current server for the current tenant.
V$OB_PLAN_CACHE_STAT	This view records the overall status of each plan cache in all servers for the current tenant.
V$RSRC_PLAN	This view displays the resource management plan of the current active tenant.
GV$OB_PL_CACHE_OBJECT	This view displays the basic information of PL-related cached objects for all tenants.
V$OB_PL_CACHE_OBJECT	This view displays the basic information of PL-related cached objects for all tenants.

View name	Description
GV$OB_LOG_STAT	This view displays the status of Palf.
V$OB_LOG_STAT	This view displays the status of Palf.

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

View name	Description
GV$OB_PROCESSLIST	This view displays session information on all OBServer nodes of the tenant.
GV$SESSION_WAIT	This view displays information about the current or previous wait events of all sessions on all servers, including the wait event name and wait time.
GV$SESSION_WAIT_HISTORY	This view displays information about the most recent 10 wait events of all sessions on all servers.
GV$SESSTAT	This view displays session-level statistics on all servers.
GV$ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$ACTIVE_SESSION_HISTORY	This view displays the active session history.
V$NLS_PARAMETERS	This view displays NLS parameters at the session level.
V$OB_PROCESSLIST	This view displays session information on the current OBServer node.
V$SESSION_WAIT	This view displays information about the current or previous wait events of all sessions on the current server, including the wait event name and wait time.
V$SESSION_WAIT_HISTORY	This view displays information about the most recent 10 wait events of all sessions on the current server.
V$SESSTAT	This view displays session-level statistics.
V$EVENT_NAME	This view displays event definitions under the tenant.

View name	Description
GV$OB_CGROUP_CONFIG	This view queries the cgroup configurations of the OBServer node.
V$OB_CGROUP_CONFIG	This view queries the cgroup configurations of the OBServer node.

View	Description
GV$OB_SQL_AUDIT	This view displays the source and execution status of each SQL request on all servers.
V$OB_SQL_AUDIT	This view displays the source and execution status of each SQL request on the current server.
GV$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistic, and the trace information of the plan is recorded.
V$SQL_PLAN_MONITOR	This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistic, and the trace information of the plan is recorded.
GV$OB_FLT_TRACE_CONFIG	This view displays the diagnostic information of full-link tracing.

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

View	Description
GV$SQL_WORKAREA	This view displays the workarea statistics of all operators executed by SQL automatic memory management.
GV$SQL_WORKAREA_ACTIVE	This view displays the workarea information of active operators.
GV$SQL_WORKAREA_HISTOGRAM	This view displays the workarea statistics of all operators executed by SQL automatic memory management.
V$OB_SQL_WORKAREA_MEMORY_INFO	This view queries some information about the SQL workarea, including the maximum available memory, current used memory, and current hold memory.
V$SQL_WORKAREA	This view displays the workarea statistics of all operators executed by SQL automatic memory management.
V$SQL_WORKAREA_ACTIVE	This view displays the workarea information of active operators.
V$SQL_WORKAREA_HISTOGRAM	This view displays the workarea statistics of all operators executed by SQL automatic memory management.

View name	Description
GV$OB_COMPACTION_PROGRESS	This view displays the OBServer-level major compaction progress of the tenant.
GV$OB_COMPACTION_SUGGESTIONS	This view displays the major compaction suggestions.
GV$OB_COMPACTION_DIAGNOSE_INFO	This view displays the major compaction diagnostic information.
GV$OB_TABLET_COMPACTION_HISTORY	This view displays the major compaction history at the tablet level.
GV$OB_TABLET_COMPACTION_PROGRESS	This view displays the major compaction progress at the tablet level.
GV$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participants on all OBServer nodes.
GV$SYSTEM_EVENT	This view displays the system-level wait events on all servers, including the number of occurrences, wait time, and timeout count for each type of wait event.
GV$GLOBAL_TRANSACTION	This view displays the information of active global transactions.
V$OB_COMPACTION_PROGRESS	This view displays the server-level major compaction progress of the tenant.
V$OB_COMPACTION_SUGGESTIONS	This view displays the major compaction suggestions.
V$OB_COMPACTION_DIAGNOSE_INFO	This view displays the major compaction diagnostic information.
V$OB_TABLET_COMPACTION_HISTORY	This view displays the major compaction history at the tablet level.
V$OB_TABLET_COMPACTION_PROGRESS	This view displays the major compaction progress at the tablet level.
V$OB_TRANSACTION_PARTICIPANTS	This view displays the transaction participants on all OBServer nodes.
V$SYSTEM_EVENT	This view displays the system-level wait events on the current server, including the number of occurrences, wait time, and timeout count for each type of wait event.
V$GLOBAL_TRANSACTION	This view displays the information of active global transactions.
GV$OB_GLOBAL_TRANSACTION	This view displays the information of all XA transactions in the cluster.
V$OB_GLOBAL_TRANSACTION	This view displays the information of all XA transactions whose original scheduler is the current node.

View name	Description
V$TIMEZONE_NAMES	This view displays valid time zone names.

View name	Description
V$OB_ENCRYPTED_TABLES	This view displays the encryption status of tables with encryption enabled.
V$ENCRYPTED_TABLESPACES	This view displays the encryption status of tablespaces with encryption enabled.

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

View name	Description
GV$OB_SQLSTAT	This view displays basic performance statistics for SQL statements in the cluster. Each SQL statement is represented as a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).
V$OB_SQLSTAT	This view displays basic performance statistics for SQL statements on the current node. Each SQL statement is represented as a row (i.e., each unique combination of `SQL_ID` and `Plan_Hash` is a row).

View name	Description
GV$OB_SESS_TIME_MODEL	This view displays session-level Time Model statistics in the cluster.
V$OB_SESS_TIME_MODEL	This view displays session-level Time Model statistics on the current node.
GV$OB_SYS_TIME_MODEL	This view displays tenant-level Time Model statistics in the cluster.
V$OB_SYS_TIME_MODEL	This view displays tenant-level Time Model statistics on the current node.

OceanBase

Customer Stories

Documentation

Overview of system views

Overview of views in the SYS tenant

Overview of dictionary views

Tables and columns

Outline

Basic information about the databases

Partition-related views

Load balancing related

Session related

Views related to backup and restore

Statistics and histograms

Tenant-related

Resource-related

Views related to replicas and logs

WR-related views

Privilege-related

System variable-related

OBKV-related

Overview of the performance view

Cgroup-related views

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 on the time model

Statistics on dumps

Thread-related statistics

Workarea-related statistics

Statistics on encrypted tables

Transaction-related statistics

ASH-related statistics

Views in a MySQL tenant

Overview of dictionary views

Help command

SPM-related

Privilege-related

OBKV-related

Scheduler

Storage-related

Time zone-related

Character sets

Tables and columns

Outline

Basic information about databases

Partition related

Load balancing-related

Session related

Backup and restore

Statistics and histogram

Tenant-related

Resource-related

Replica and log-related

WR-related views

Privilege-related

System variable-related

OBKV-related

Overview of performance views

Cgroup related

Event-related statistics

Statistics related to monitoring

Cache related statistics

SQL statistics

Log statistics

Network statistics

Database-related statistics

Time Model-related statistics

Statistics related to dumps

Statistics related to threads

Statistics related to workareas

Statistics related to encrypted tables

Statistics related to transactions

ASH related statistics

Overview of views in a MySQL tenant