This topic describes the performance views of OceanBase Database in detail.
Views related to statistics
View name |
Description |
|---|---|
| GV$LOCK | Displays the row locks of an OceanBase database. |
| GV$CONCURRENT_LIMIT_SQL | Displays all throttling information about the current tenant. |
| GV$OUTLINE | Displays information about the outlines of the current tenant. |
| GV$SYSSTAT | Displays the system-level statistics about all OBServer nodes. |
| V$SYSSTAT | Displays the system-level statistics about the current OBServer node. |
| V$VERSION | Displays the names and versions of all components of the database. |
| V$LOCK | Displays the row locks of an OceanBase database. |
| V$GLOBALCONTEXT | Displays the CLIENT_IDENTIFIER values of the global context attribute that can be accessed by the current session. |
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$MEMORY | Displays the memory usage of each tenant on all OBServer nodes. |
| GV$MEMSTORE | Displays the memory usage of all MemTables of all tenants on all OBServer nodes. |
| GV$MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on all OBServer nodes. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and current Hold memory. |
| GV$SERVER_MEMSTORE | Displays the summary information about MemTable usage on the current OBServer node. |
| GV$SSTABLE | Displays the SSTables of tenants. |
| V$MEMORY | Displays the tenant-level memory statistics. |
| V$MEMSTORE | Displays the memory usage of all MemTables of all tenants on the current OBServer node. |
| V$MEMSTORE_INFO | Displays details about MemTables of all partitions of all tenants on the current OBServer node. |
| V$SSTABLE | Displays the SSTables of tenants. |
| GV$TENANT_MEMORY_INFO | Displays the memory usage of each tenant in the cluster. |
| V$TENANT_MEMORY_INFO | Displays the memory usage of each tenant in the current observer process. |
Views related to plan caches
View name |
Description |
|---|---|
| GV$PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all OBServer nodes. |
| GV$PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all OBServer nodes. |
| GV$PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServer nodes. |
| GV$OPEN_CURSOR | Displays the execution plans that are cached in the plan cache. |
| V$PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current OBServer node. |
| V$PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current OBServer node. |
| V$PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServer nodes. |
| V$RSRC_PLAN | Displays the resource plan for the currently active tenant. |
| V$OPEN_CURSOR | Displays the execution plans that are cached in the plan cache. |
Views related to monitoring information
View name |
Description |
|---|---|
| GV$PS_ITEM_INFO | Displays monitoring information about prepared statements, including the basic information about all prepared statements in the PS cache. |
| GV$PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information about the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information about the DTL intermediate result manager. |
| V$PS_ITEM_INFO | Displays monitoring information about prepared statements, including the basic information about all prepared statements in the PS cache. |
| V$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 | Explains the meaning of the numbers in the OTHERSTAT_X_ID field of the GV$SQL_PLAN_MONITOR view. |
Views related to sessions
View name |
Description |
|---|---|
| GV$SESSION_WAIT | Displays information about the current or last wait event of all sessions on all OBServer nodes, such as the wait event name and duration. |
| GV$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on all OBServer nodes. |
| GV$SESSTAT | Displays the session-level statistics about all OBServer nodes. |
| V$NLS_PARAMETERS | Displays session-level National Language Support (NLS) parameters. |
| V$SESSION_WAIT | Displays information about the current or last wait event of all sessions on the current OBServer node, such as the wait event name and duration. |
| V$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on the current OBServer node. |
| V$SESSTAT | Displays the session-level statistics about the current OBServer node. |
Views related to SQL requests
View name |
Description |
|---|---|
| GV$SQL_AUDIT | Displays the statistics about each SQL request on all OBServer nodes, such as the source and execution status. |
| V$SQL_AUDIT | Displays the statistics about each SQL request on the current OBServer node, such as the source and execution status. |
Views related to workareas
View name |
Description |
|---|---|
| GV$SQL_WORKAREA | Displays the workarea statistics of all operators previously executed by automatic SQL memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workarea information about active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the statistics about all workareas that were previously executed. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and current Hold memory. |
| V$SQL_WORKAREA | Displays the workarea statistics of all operators previously executed by automatic SQL memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workarea information about active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Displays the statistics about all workareas that were previously executed. |
Views related to transactions
View name |
Description |
|---|---|
| GV$SYSTEM_EVENT | Displays the system-level wait events of tenants on all OBServer nodes, including the occurrence count, wait time, and timeout count of each type of wait event. |
| GV$GLOBAL_TRANSACTION | Displays information about currently active global transactions. |
| V$SYSTEM_EVENT | Displays the system-level wait events of tenants on the current OBServer node, including the occurrence count, wait time, and timeout count of each type of wait event. |
| V$GLOBAL_TRANSACTION | Displays information about currently active global transactions. |
| V$RESTORE_POINT | Displays information about restore points. |
Views related to time zones
View name |
Description |
|---|---|
| V$TIMEZONE_NAMES | Displays valid time zone names. |
Views related to encrypted tables
View name |
Description |
|---|---|
| V$ENCRYPTED_TABLES | Displays the encryption status of tables that have encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces that have encryption enabled. |
Views related to DBLinks
View name |
Description |
|---|---|
| GV$DBLINK | Displays all DBLinks (the links with IN_TRANSACTION set to YES) opened by query sessions on this view. These DBLinks must be committed or rolled back before being closed. |
| V$DBLINK | Displays all DBLinks (the links with IN_TRANSACTION set to YES) opened by query sessions on this view. These DBLinks must be committed or rolled back before being closed. |