Note
This view was introduced in OceanBase Database V2.2.77.
Purpose
The V$SQL_MONITOR_STATNAME view displays the meanings of the numbers in the OTHERSTAT_X_ID column of the [G]V$SQL_PLAN_MONITOR view.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CON_ID | NUMBER | NO | Tenant ID |
| ID | NUMBER | NO | Field ID |
| GROUP_ID | NUMBER | NO | Field category ID. The same category of operators share the same category ID. |
| NAME | VARCHAR2(40) | NO | Field name |
| DESCRIPTION | VARCHAR2(200) | NO | Field description |
| TYPE | NUMBER | NO | Reserved field |
| FLAGS | NUMBER | NO | Reserved field |
Sample query
obclient [SYS]> SELECT * FROM SYS.V$SQL_MONITOR_STATNAME WHERE ROWNUM = 1\G
The sample 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.012 sec)