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 | bigint(0) unsigned | NO | The ID of the tenant. |
| ID | bigint(20) | NO | The ID of the column. |
| GROUP_ID | bigint(20) | NO | The ID of the group to which the column belongs. Operators of the same type share the same group ID. |
| NAME | varchar(40) | NO | The name of the column. |
| DESCRIPTION | varchar(200) | NO | The detailed description of the column. |
| TYPE | bigint(20) | NO | Reserved for future use. |
| FLAGS | bigint(1) | NO | Reserved for future use. |
Sample query
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.012 sec)