This topic describes the performance views of OceanBase Database in detail.
Views related to statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameters on all OBServer nodes of a tenant. |
| GV$OB_SERVER_SCHEMA_INFO | Displays the information about the schemas on all OBServers. |
| V$OB_SERVER_SCHEMA_INFO | Displays the information about the schemas on all OBServers. |
| GV$OB_UNITS | Displays the information about the units on the OBServer node where the current tenant is located. You can view the units of all OBServer nodes in the current cluster from the sys tenant. |
| GV$SYSSTAT | Displays the system-level statistical events on all OBServers. |
| GV$DML_STATS | Displays the information about the DML operations performed in the current user table. |
| V$DML_STATS | Displays the information about the DML operations performed in the current user table. |
| V$GLOBALCONTEXT | Displays the CLIENT_IDENTIFIER values of the global context attribute that can be accessed by the current session. |
| V$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameters on the current OBServer node. |
| V$SYSSTAT | Displays the system-level statistical events on the current OBServer node. |
| V$OB_UNITS | Displays the information about the units on the current OBServer node. |
| V$VERSION | Displays the names and versions of all components of the database. |
Views related to instances
| View name | Description |
|---|---|
| GV$INSTANCE | Displays the status of the current database instance. |
| V$INSTANCE | Displays the status of the current database instance. |
Views related to memory
| View name | Description |
|---|---|
| GV$OB_MEMORY | Displays the memory usage of each tenant on all OBServers. |
| GV$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on all OBServers. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| GV$OB_SSTABLES | Displays the SSTables of tenants. |
| GV$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all OBServers. |
| V$OB_MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all OBServers. |
| V$OB_MEMORY | Displays the tenant-level memory statistics. |
| V$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on the current OBServer. |
| V$OB_SSTABLES | Displays the SSTables of tenants. |
| GV$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the current observer process. |
Views related to plan cache
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all OBServers. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all OBServers. |
| GV$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current OBServer. |
| V$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current OBServer. |
| V$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServers. |
| V$RSRC_PLAN | Displays the active resource management plans of the tenant. |
Views related to logs
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | Displays the Palf status information. |
| V$OB_LOG_STAT | Displays the Palf status information. |
Views related to monitoring information
| View name | Description |
|---|---|
| GV$OB_PX_TARGET_MONITOR | Displays the usage of PX threads on all OBServers. |
| GV$OB_PS_ITEM_INFO | Displays monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| GV$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_PX_TARGET_MONITOR | Displays the usage of PX threads on OBServer nodes. |
| V$OB_PS_ITEM_INFO | Displays monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| V$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| V$SQL_MONITOR_STATNAME | Describes the numbers in the OTHERSTAT_X_ID field of the GV$SQL_PLAN_MONITOR view. |
Views related to sessions
| View name | Description |
|---|---|
| GV$OB_PROCESSLIST | Displays the session information about all OBServer nodes of a tenant. |
| GV$SESSION_WAIT | Displays information about the current or last wait events of all sessions on all OBServers, such as the event name and the amount of time spent on waiting. |
| GV$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on all OBServers. |
| GV$SESSTAT | Displays the session-level statistics about all OBServers. |
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$NLS_PARAMETERS | Displays the session-level National Language Support (NLS) parameters. |
| V$OB_PROCESSLIST | Displays the session information about the current OBServer node. |
| V$SESSION_WAIT | Displays information about the current or last wait events of all sessions on the current OBServer, such as the event name and the amount of time spent on waiting. |
| V$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on the current OBServer. |
| V$SESSTAT | Displays the session-level statistics about the current OBServer. |
| V$EVENT_NAME | Describes each event in the tenant. |
Views related to SQL statements
| View name | Description |
|---|---|
| GV$OB_SQL_AUDIT | Displays the statistics of each SQL request on all OBServers, such as the source and execution status. |
| V$OB_SQL_AUDIT | Displays the statistics about each SQL request on the current OBServer, such as the source and execution status. |
| GV$SQL_PLAN_MONITOR | Displays plan-level statistics about slow queries on all OBServer nodes. Each slow query has one row in this view. It also records the trace information of the plan. |
| V$SQL_PLAN_MONITOR | Displays plan-level statistics about slow queries on all OBServer nodes. Each slow query has one row in this view. It also records the trace information of the plan. |
Views related to threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
| V$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
Views related to workareas
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workarea information of active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| V$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workarea information of active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas. |
Views related to transactions
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the OBServer-level compaction progress of a tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostics. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the data shard-level compaction history. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of a data shard-level compaction. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays the information about the transaction participants on all OBServer nodes. |
| GV$SYSTEM_EVENT | Displays system wait events of tenants on all OBServers, including the number of occurrences, wait time, and number of timeouts of each type of wait event. |
| GV$GLOBAL_TRANSACTION | Displays information about currently active global transactions. |
| V$OB_COMPACTION_PROGRESS | Displays the OBServer-level compaction progress of a tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostics. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the data shard-level compaction history. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of a data shard-level compaction. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays the information about the transaction participants on all OBServer nodes. |
| V$SYSTEM_EVENT | Displays system wait events of tenants on the current OBServer, including the number of occurrences, wait time, and number of timeouts of each type of wait event. |
| V$GLOBAL_TRANSACTION | Displays information about currently active global transactions. |
| GV$OB_GLOBAL_TRANSACTION | Displays information about all XA transactions in the cluster. |
| V$OB_GLOBAL_TRANSACTION | Displays information about all XA transactions whose original scheduler is the current OBServer node. |
Views related to time zones
| View name | Description |
|---|---|
| V$TIMEZONE_NAMES | Displays the valid time zone names. |
Views related to encrypted tables
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with encryption enabled. |
Views related to database links
| View name | Description |
|---|---|
| GV$DBLINK | Displays all database links (the links with IN_TRANSACTION set to YES) opened by the session that issues the query on this view. These database links must be committed or rolled back before they are closed. |
| V$DBLINK | Displays all database links (the links with IN_TRANSACTION set to YES) opened by the session that issues the query on this view. These database links must be committed or rolled back before they are closed. |