Note
This view is available starting with V2.2.77.
Purpose
The V$SQL_MONITOR_STATNAME view is used to display 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 | bigint(0) unsigned | NO | The tenant ID. |
| ID | bigint(20) | NO | The field ID. |
| GROUP_ID | bigint(20) | NO | The ID of the field category. The same category of operators share the same category ID. |
| NAME | varchar(40) | NO | The name of the field. |
| DESCRIPTION | varchar(200) | NO | The detailed description of the field. |
| TYPE | bigint(20) | NO | Reserved for internal use. |
| FLAGS | bigint(1) | 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 [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)