Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The V$OB_IO_CALIBRATION_STATUS view displays the execution status of the I/O calibration task on the current node.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| STORAGE_NAME | varchar(1024) | NO | The storage name, 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 status of the I/O calibration task on the current node.
obclient [oceanbase]> SELECT * FROM oceanbase.V$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 |
+----------------+----------+--------------+--------+----------------------------+----------------------------+
1 row in set
References
To view the I/O calibration status on all OBServer nodes, see GV$OB_IO_CALIBRATION_STATUS.
To view the calibration data of disks:
For more information about disk performance calibration, see Calibrate disk performance.