Oracle 视图 V$IO_CALIBRATION_STATUS 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图V$IO_CALIBRATION_STATUS用于显示最近的I/O校准的调节器的状态信息。它报告数据库在检测I/O性能时使用的调节器,以及调节器的状态。

该视图返回下列列:

1. CALIBRATION_ID: 调节器ID;
2. STATE:调节器状态;
3. START_TIME:调节器起始时间;
4. END_TIME:调节器结束时间;
5. RESULT:调节器调整结果;
6. COMPONENT_TYPE:调节器组件类型;
7. COMPONENT_NAME:调节器组件名称;
8. ACTION:调节器动作类型;
9. ACTION_TIME:调节器动作时间;
10.IO_MB_SEC:I/O的 MB/秒。

使用该视图的语法格式如下:

SELECT * FROM V$IO_CALIBRATION_STATUS;

官方英文解释

V$IO_CALIBRATION_STATUS displays the status of I/O calibration in the instance.

Column Datatype Description

STATUS

VARCHAR2(13)

Calibration status:

  • IN PROGRESS – Calibration in Progress (Results from a previous calibration run are displayed, if available)

  • READY Results are ready and available from an earlier run

  • NOT AVAILABLE Calibration results are not available

CALIBRATION_TIME

TIMESTAMP(3)

End time of the last calibration run

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 V$IO_CALIBRATION_STATUS 官方解释,作用,如何使用详细说明