Note
This view is available starting with V4.3.3.
Purpose
This view displays the real-time status of each resource group in the current tenant on the current OBServer node.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| GROUP_ID | NUMBER(38) | NO | The ID of the corresponding resource group. |
| GROUP_NAME | VARCHAR2(128) | NO | The name of the corresponding resource group. |
| MODE | VARCHAR2(128) | NO | The read/write mode. Valid values:
|
| MIN_IOPS | NUMBER(38) | NO | The minimum IOPS in the resource group. |
| MAX_IOPS | NUMBER(38) | NO | The maximum IOPS in the resource group. |
| NORM_IOPS | NUMBER(38) | NO | The current IOPS converted to the value corresponding to 16 KB reads.
Note
|
| REAL_IOPS | NUMBER(38) | NO | The current IOPS. |
| MAX_NET_BANDWIDTH | NUMBER(38) | NO | The maximum network bandwidth in the resource group, in bytes. |
| MAX_NET_BANDWIDTH_DISPLAY | VARCHAR2(128) | NO | The maximum network bandwidth in the resource group, converted to a displayable format, such as 10 GB/s or 10 MB/s. |
| REAL_NET_BANDWIDTH | NUMBER(38) | NO | The current network bandwidth, in bytes. |
| REAL_NET_BANDWIDTH_DISPLAY | VARCHAR2(128) | NO | The current network bandwidth, converted to a displayable format, such as 10 GB/s or 10 MB/s. |
Sample query
Query the real-time status of each resource group in the current tenant on the current OBServer node.
obclient [SYS]> SELECT * FROM SYS.V$OB_GROUP_IO_STAT WHERE ROWNUM <= 2\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1004
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
GROUP_ID: 0
GROUP_NAME: OTHER_GROUP
MODE: READ
MIN_IOPS: 9223372036854775807
MAX_IOPS: 9223372036854775807
NORM_IOPS: 0
REAL_IOPS: 0
MAX_NET_BANDWIDTH: 9223372036854775807
MAX_NET_BANDWIDTH_DISPLAY: unlimited
REAL_NET_BANDWIDTH: 0
REAL_NET_BANDWIDTH_DISPLAY: 0B/s
*************************** 2. row ***************************
TENANT_ID: 1004
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
GROUP_ID: 0
GROUP_NAME: OTHER_GROUP
MODE: WRITE
MIN_IOPS: 9223372036854775807
MAX_IOPS: 9223372036854775807
NORM_IOPS: 0
REAL_IOPS: 0
MAX_NET_BANDWIDTH: 9223372036854775807
MAX_NET_BANDWIDTH_DISPLAY: unlimited
REAL_NET_BANDWIDTH: 0
REAL_NET_BANDWIDTH_DISPLAY: 0B/s
2 rows in set
References
View the real-time status of each resource group on all nodes: GV$OB_GROUP_IO_STAT
View the I/O statistics at the function level by querying the following views: