Note
This view is available starting with V2.2.77.
Purpose
The V$SQL_MONITOR_STATNAME view displays the meaning of the numeric values in the OTHERSTAT_X_ID column of the [G]V$SQL_PLAN_MONITOR view.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CON_ID | NUMBER | NO | The tenant ID. |
| ID | NUMBER | NO | The field ID. |
| GROUP_ID | NUMBER | NO | The field category ID. Operators of the same category share the same category ID. |
| NAME | VARCHAR2(40) | NO | The field name. |
| DESCRIPTION | VARCHAR2(200) | NO | The detailed description of the field. |
| TYPE | NUMBER | NO | Reserved for internal use. |
| FLAGS | NUMBER | NO | Reserved for internal use. |
Sample query
Query the meaning of the numeric values in the OTHERSTAT_X_ID column of the GV$SQL_PLAN_MONITOR view and display the first record.
obclient [SYS]> SELECT * FROM SYS.V$SQL_MONITOR_STATNAME WHERE ROWNUM = 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.012 sec)