Note
This view is available starting with V4.3.4.
Purpose
This view displays the I/O statistics at the Function level on all OBServer nodes for the current tenant. If the resource group corresponding to the background task at the Function level is not enabled for resource management plans, the displayed I/O information is only for statistical reference, and the corresponding resources cannot be restricted.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| FUNCTION_NAME | VARCHAR2(32) | NO | The name of the background task corresponding to the Function:
|
| MODE | VARCHAR2(32) | NO | The read/write mode corresponding to the I/O operation. Shared storage requests are remote requests, and other types of requests are local requests:
|
| SIZE | NUMBER(38) | NO | The average I/O size. |
| REAL_IOPS | NUMBER(38) | NO | The actual IOPS. |
| REAL_MBPS | NUMBER(38) | NO | The actual bandwidth, in MB/s. |
| SCHEDULE_US | NUMBER(38) | NO | The average time consumed by I/O scheduling, in us. |
| IO_DELAY_US | NUMBER(38) | NO | The average execution time of disk I/O, in us. |
| TOTAL_US | NUMBER(38) | NO | The overall average execution time of I/O, in us. |
Sample query
Query the I/O statistics at the Function level on all OBServer nodes for the current tenant.
obclient [SYS]> SELECT * FROM SYS.GV$OB_FUNCTION_IO_STAT WHERE ROWNUM >= 5;
The query result is as follows:
+----------------+----------+-----------+------------------+--------------+------+-----------+-----------+-------------+-------------+----------+
| SVR_IP | SVR_PORT | TENANT_ID | FUNCTION_NAME | MODE | SIZE | REAL_IOPS | REAL_MBPS | SCHEDULE_US | IO_DELAY_US | TOTAL_US |
+----------------+----------+-----------+------------------+--------------+------+-----------+-----------+-------------+-------------+----------+
| 172.xx.xxx.xxx | 2882 | 0 | DEFAULT_FUNCTION | LOCAL READ | 0 | 0 | 0 | 0 | 0 | 0 |
| 172.xx.xxx.xxx | 2882 | 0 | DEFAULT_FUNCTION | LOCAL WRITE | 0 | 0 | 0 | 0 | 0 | 0 |
| 172.xx.xxx.xxx | 2882 | 0 | DEFAULT_FUNCTION | REMOTE READ | 0 | 0 | 0 | 0 | 0 | 0 |
| 172.xx.xxx.xxx | 2882 | 0 | DEFAULT_FUNCTION | REMOTE WRITE | 0 | 0 | 0 | 0 | 0 | 0 |
| 172.xx.xxx.xxx | 2882 | 0 | COMPACTION_HIGH | LOCAL READ | 0 | 0 | 0 | 0 | 0 | 0 |
+----------------+----------+-----------+------------------+--------------+------+-----------+-----------+-------------+-------------+----------+
5 rows in set
References
Query the I/O statistics at the Function level on the current OBServer node: V$OB_FUNCTION_IO_STAT
Query the real-time status of each resource group for the tenant:
For more information about resource isolation, see the following topics: