This topic describes the performance views of OceanBase Database in detail.
Views related to events
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the OBServer-level compaction progress of a tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compaction. |
| GV$OB_PROCESSLIST | Displays the session information about all OBServer nodes of a tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostics. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the 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$SESSION_EVENT | Displays the session-level wait events of all OBserver nodes in the cluster. |
| GV$SESSION_WAIT | Displays information about the current or last wait events of all sessions on all OBServers, such as the event names and the amount of time spent on waiting. |
| GV$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on all OBServers. |
| GV$SYSTEM_EVENT | Displays all tenant-level wait events in the cluster. |
| GV$SESSTAT | Displays the session-level statistical events on all OBserver nodes. |
| GV$SYSSTAT | Displays information about tenant-level statistical events on all OBServers. |
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$OB_COMPACTION_PROGRESS | Displays the OBServer-level compaction progress of a tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compaction. |
| V$OB_PROCESSLIST | Displays the session information of the current OBServer node. |
| 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$STATNAME | Displays definitions related to all the statistical events. |
| V$EVENT_NAME | Displays the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | Displays detailed information about the current wait events in each session. Each wait event has three parameters. |
| V$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on the current OBServer. |
| V$SESSTAT | Displays an overview of session-level statistical events. |
| V$SYSSTAT | Displays information about tenant-level statistical events on the current server. |
| V$SYSTEM_EVENT | Displays the tenant-level wait events. |
| GV$SESSION_LONGOPS | Displays the progress of index creation in the cluster. |
| V$SESSION_LONGOPS | Displays the progress of index creation on the current OBServer node. |
Views related to monitoring
| 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. |
Views related to I/O statistics
| View name | Description |
|---|---|
| GV$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| V$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| GV$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
| V$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
Views related to cache statistics
| View name | Description |
|---|---|
| GV$OB_MEMORY | Displays the tenant-level memory statistics. |
| V$OB_MEMORY | Displays the tenant-level memory statistics. |
| GV$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on all OBServers. |
| V$OB_MEMSTORE | Displays session-level MemStore statistics. |
| GV$OB_MEMSTORE_INFO | Displays details about MemTables in all partitions of all tenants on all OBServers. |
| V$OB_MEMSTORE_INFO | Displays details about MemTables in all partitions of all tenants on all OBServers. |
| GV$OB_SSTABLES | Displays the SSTables of tenants. |
| V$OB_SSTABLES | Displays the SSTables of tenants. |
| GV$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the current observer process. |
Views related to SQL statistics
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | Displays the outlines of the current tenant. It is for outline migration. |
| V$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on 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. |
| 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. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all OBServers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current OBServer. |
| GV$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| V$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| GV$OB_PX_TARGET_MONITOR | Displays the usage of PX threads on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | Displays the usage of PX threads on the OBServer node. |
| GV$OB_SQL_AUDIT | Displays the statistics about each SQL request on all 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 the operation-level statistics of slow queries. Each operation has one row. |
| V$SQL_MONITOR_STATNAME | Displays the numbers in the OTHERSTAT_X_ID field of the GV$SQL_PLAN_MONITOR view. |
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 network statistics
| View name | Description |
|---|---|
| GV$OB_RPC_OUTGOING | Displays the RPC sending statistics of all OBServer nodes. |
| GV$OB_RPC_INCOMING | Displays the RPC receiving statistics of all OBServer nodes. |
| V$OB_RPC_OUTGOING | Displays the data sending status of all RPC packet codes under each tenant on the OBServer node. |
| V$OB_RPC_INCOMING | Displays the data receiving status of all RPC packet codes under each tenant on the OBServer node. |
Views related to database statistics
| View name | Description |
|---|---|
| GV$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameters on all OBServer nodes of a tenant. |
| GV$OB_SERVER_SCHEMA_INFO | Displays the information about the schemas on all OBServers. |
| GV$OB_SERVERS | Displays the information about all OBServer nodes. |
| GV$OB_UNITS | Displays the information about the units on the OBServer node where the current tenant is located. You can view the units of all OBServer nodes in the current cluster from the sys tenant. |
| V$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameters on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays the information about the schemas on all OBServers. |
| V$OB_SERVERS | Displays the information about the current OBServer node. |
| V$OB_UNITS | Displays the information about the units on the current OBServer node. |
| GV$DML_STATS | Displays the information about the DML operations performed in the current user table. |
| V$DML_STATS | Displays the information about the DML operations performed in the current user table. |
Views related to minor compactions
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | Displays the statistics about compactions that are completed in the cluster. |
| V$OB_MERGE_INFO | Displays the statistics about compactions that are completed in the cluster. |
Views related to threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
| V$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
Views related to workareas
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workarea information of active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions consumed 1 MB to 2 MB of memory and the number of executions in one pass mode. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| V$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workarea information of active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions consumed 1 MB to 2 MB of memory and the number of executions in one pass mode. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, including the maximum available memory, current memory usage, and currently held memory. |
Views related to encrypted tables
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with encryption enabled. |