This topic describes the performance views of OceanBase Database in detail.
| View name |
Description |
| gv$session_event |
Displays the session-level wait events on all the OBServer nodes in the cluster. |
| gv$session_wait |
Displays information about the current or last wait events of all sessions on all OBServer nodes, 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 OBServer nodes. |
| gv$system_event |
Displays all tenant-level wait events in the cluster. |
| gv$sesstat |
Displays the session-level statistics events on all OBServer nodes. |
| gv$sysstat |
Displays tenant-level statistical events on all OBServer nodes. |
| v$statname |
Displays definitions related to all the statistical events. |
| v$event_name |
Displays definitions related to all the statistics events on the current OBServer node. |
| v$session_event |
Displays the information about wait events in each session. |
| 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 node. |
| v$sesstat |
Displays an overview of session-level statistical events. |
| v$sysstat |
Displays the tenant-level statistics events. |
| v$system_event |
Displays the tenant-level wait events. |
| View name |
Description |
| gv$sql_audit |
Displays the statistics about each SQL request on all OBServer nodes, such as the source and execution status. |
| gv$sql |
Displays the statistics about SQL plans that are updated in real time. It records the statistics about each plan and every execution of the plan. Each plan has one row in this view. |
| gv$sql_plan_monitor |
Displays the 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_audit |
Displays the statistics about each SQL request on the current OBServer node, such as the source and execution status. |
| v$sql |
Displays the statistics about SQL plans that are updated in real time. It records the statistics about each plan and every execution of the plan. Each plan has one row in this view. |
| v$sql_plan_monitor |
Displays the operation-level statistics of slow queries. Each operation has one row. |
| v$sql_monitor_statname |
Describes the numbers in the OTHERSTAT_X_ID field of the GV$SQL_PLAN_MONITOR view. |
| View name |
Description |
| gv$memory |
Displays the tenant-level memory statistics. |
| 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$server_memstore |
Displays the memory usage of MemStores in each OBServer node in the cluster. |
| gv$tenant_memstore_allocator_info |
Displays some information about MemTables on the connected OBServer node. You can use this view to troubleshoot the problem that the MemStore memory of a tenant no longer in use is not released. |
| gv$sstable |
Displays the SSTables of tenants. |
| v$memory |
Displays the tenant-level memory statistics. |
| v$memstore |
Displays tenant-level MemStore statistics. |
| v$memstore_info |
Displays details about MemTables of all partitions of all tenants on all OBServer nodes. |
| v$tenant_memstore_allocator_info |
Displays some information about MemTables on the connected OBServer node. You can use this view to troubleshoot the problem that the MemStore memory of a tenant no longer in use is not released. |
| 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_stat |
Displays the outlines of the current tenant. The information is used for outline migration. |
| v$plan_cache_stat |
Displays the overall status of each plan cache of the current tenant on 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. |
| 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. |
| gv$plan_cache_plan_explain |
Displays the physical execution plans cached in the plan caches of all OBServer nodes. |
| v$plan_cache_plan_explain |
Displays the physical execution plans that are cached in the plan cache on the current OBServer node. |
| gv$ps_stat |
Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| v$ps_stat |
Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| gv$ps_item_info |
Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| v$ps_item_info |
Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| V$RSRC_PLAN |
Displays the active resource management plans of the tenant. |
| View name |
Description |
| gv$obrpc_outgoing |
Displays the statistics about outgoing RPCs on all OBServer nodes. |
| gv$obrpc_incoming |
Displays the statistics about RPC requests received by all OBServer nodes. |
| v$obrpc_outgoing |
Displays the sending status of RPC data of all RPC packet codes under each tenant on the OBServer node. |
| v$obrpc_incoming |
Displays the receiving status of RPC data of all RPC packet codes under each tenant on the OBServer node. |
| View name |
Description |
| gv$outline |
Displays the outlines of the current tenant. The information is used for outline migration. |
| View name |
Description |
| gv$unit_load_balance_event_history |
Displays the results of replica migrations in the cluster. |
| gv$tenant |
Displays the information about system tenants in the whole cluster. |
| gv$database |
Displays the metadata of all databases in the cluster. |
| gv$table |
Displays the metainformation of all tables in the cluster. |
| gv$unit |
Displays the metadata of all units in the cluster. |
| gv$partition |
Displays the metadata information of all partitions in the cluster. |
| gv$server_schema_info |
Displays the information about the schemas on all OBServer nodes. |
| v$unit |
Displays the metadata of the units on the current OBServer node. |
| v$partition |
Displays the metadata about the partitions on the current OBServer node. |
| v$ob_cluster |
Displays the basic information about the current cluster. |
| v$ob_standby_status |
Displays the status and configurations of all standby clusters for the primary cluster, and is empty for a standby cluster. |
| v$ob_cluster_stats |
Displays the statistics of all tenants in the current cluster. |
| v$ob_cluster_event_history |
Displays the event history related to the primary and standby databases in the current cluster. This view allows you to track detailed information on O&M, switchover processes, and error logs to facilitate problem diagnosis. |
| v$ob_timestamp_service |
Displays the clock sources of different tenants in the system and their values. |
| v$server_schema_info |
Displays the information about the schemas on all OBServer nodes. |
| v$restore_point |
Displays the information about restore points. |
| v$ob_cluster_failover_info |
Displays the information about each failover operation performed for a tenant. |
| v$ob_all_clusters |
Displays information about all clusters in the primary/standby database configuration. |
| gv$concurrent_limit_sql |
Displays all the throttling information of the current tenant. |
| gv$sql_plan_statistics |
Displays the statistics about the physical execution plans in the whole cluster. |
| v$sql_plan_statistics |
Displays the statistics about physical execution plans on the current OBServer node. |
| View name |
Description |
| gv$lock_wait_stat |
Displays the status of row locks in the whole cluster. |
| gv$lock |
Displays the row locks of the OceanBase database. |
| v$lock_wait_stat |
Displays the status of row locks on the current OBServer node. |
| v$lock |
Displays the row locks of the OceanBase database. |
| View name |
Description |
| 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. |
| View name |
Description |
| gv$minor_merge_info |
Displays the start time and the end time of minor compactions under different tenants on each OBServer node in the cluster. |
| gv$merge_info |
Displays the statistics related to compactions that have been completed in the OceanBase cluster. |
| gv$ob_trans_table_status |
Displays the details of dirty transactions generated after each minor freeze. |
| v$merge_info |
Displays the statistics related to compactions that have been completed in the OceanBase cluster. |
| v$ob_trans_table_status |
Displays the details of dirty transactions generated after each minor freeze in the current tenant. |
| View name |
Description |
| gv$tenant_px_worker_stat |
Displays the execution information of each PX worker thread in parallel execution. |
| v$tenant_px_worker_stat |
Displays the execution information of each PX worker thread in parallel execution. Unlike the gv$tenant_px_worker_stat view, this view displays only the threads under the current tenant. |
| View name |
Description |
| gv$sql_workarea |
Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| 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. |
| View name |
Description |
| gv$latch |
Displays information about the latches on all OBServer nodes in the cluster. |
| v$latch |
Displays information about the latches on all OBServer nodes in the cluster. |
