Overview
Displays the execution status of I/O calibration tasks on all nodes.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | Server IP Address |
| SVR_PORT | bigint(20) | NO | Server Port Number |
| STORAGE_NAME | varchar(1024) | NO | Storage name, for example, DATA or REDO. |
| STATUS | varchar(256) | NO | I/O calibration status. Valid values:
|
| START_TIME | timestamp(6) | NO | Last I/O Calibration Start Time |
| FINISH_TIME | timestamp(6) | NO | 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 status of I/O calibration tasks on the current OBServer node: V$OB_IO_CALIBRATION_STATUS
View disk calibration data:
For detailed operations on calibrating disk performance, see Calibrate disk performance.