Overview
The V$SQL_MONITOR_STATNAME view is used to describe the meaning of the numbers in the OTHERSTAT_X_ID field of [G]V$SQL_PLAN_MONITOR.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| CON_ID | bigint(0) unsigned | NO | Tenant ID |
| ID | bigint(20) | NO | Field ID |
| GROUP_ID | bigint(20) | NO | Field category ID. Operators of the same category share a category ID. |
| NAME | varchar(40) | NO | Field Name |
| DESCRIPTION | varchar(200) | NO | Field Description |
| TYPE | bigint(20) | NO | Reserved Fields |
| FLAGS | bigint(1) | NO | Reserved Fields |
Sample query
Query the OTHERSTAT_X_ID field in the GV$SQL_PLAN_MONITOR view to display the value of the first record.
obclient [oceanbase]> SELECT * FROM oceanbase.V$SQL_MONITOR_STATNAME limit 1\G
The query result is as follows:
*************************** 1. row ***************************
CON_ID: NULL
ID: 1
GROUP_ID: 0
NAME: min hash entry count
DESCRIPTION: element count in shortest hash slot
TYPE: 1
FLAGS: 0
1 row in set (0.011 sec)