This topic describes the performance views of OceanBase Database in detail.
| 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. |
| 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$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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
