Note
This view is available starting with V4.0.0.
Purpose
This view displays the execution status of I/O calibration tasks on all nodes.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| STORAGE_NAME | varchar(1024) | NO | The name of the storage, for example, DATA or REDO. |
| STATUS | varchar(256) | NO | The I/O calibration status. Valid values:
|
| START_TIME | timestamp(6) | NO | The start time of the last I/O calibration. |
| FINISH_TIME | timestamp(6) | NO | The end time of the last I/O calibration. |
Sample query
Query the execution status of I/O calibration tasks on all nodes.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_IO_CALIBRATION_STATUS;
The query result is as follows:
+----------------+----------+--------------+--------+----------------------------+----------------------------+
| SVR_IP | SVR_PORT | STORAGE_NAME | STATUS | START_TIME | FINISH_TIME |
+----------------+----------+--------------+--------+----------------------------+----------------------------+
| 172.xx.xxx.xxx | 2882 | DATA | READY | 2025-01-02 10:20:23.299385 | 2025-01-02 10:22:03.578395 |
| 172.xx.xxx.xxx | 2882 | DATA | READY | 2025-01-02 10:20:23.299880 | 2025-01-02 10:22:03.590106 |
| 172.xx.xxx.xxx | 2882 | DATA | READY | 2025-01-02 10:20:23.300319 | 2025-01-02 10:22:03.589117 |
+----------------+----------+--------------+--------+----------------------------+----------------------------+
3 rows in set
References
View the I/O calibration task status on the current OBServer node: V$OB_IO_CALIBRATION_STATUS
View the disk calibration data:
For more information about disk performance calibration, see Calibrate disk performance.