Note
This view was introduced in OceanBase Database V2.2.77.
Purpose
The V$SQL_MONITOR_STATNAME view displays 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 | The ID of the tenant. |
| ID | NUMBER | NO | The ID of the column. |
| GROUP_ID | NUMBER | NO | The ID of the group to which the column belongs. Operators of the same type share the same group ID. |
| NAME | VARCHAR2(40) | NO | The name of the column. |
| DESCRIPTION | VARCHAR2(200) | NO | The detailed description of the column. |
| TYPE | NUMBER | NO | Reserved for future use. |
| FLAGS | NUMBER | NO | Reserved for future use. |
Sample query
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)