Oracle 11g R1中资源管理器增强

核心提示： l_actual_latency PLS_INTEGER;BEGINDBMS_RESOURCE_MANAGER.calibrate_io (num_physical_disks => 1,max_latency => 20,max_iops => l_max_iops,m

l_actual_latency PLS_INTEGER;

BEGIN

DBMS_RESOURCE_MANAGER.calibrate_io (

num_physical_disks => 1,

max_latency => 20,

max_iops => l_max_iops,

max_mbps => l_max_mbps,

actual_latency => l_actual_latency);

DBMS_OUTPUT.put_line ('l_max_iops = ' || l_max_iops);

DBMS_OUTPUT.put_line ('l_max_mbps = ' || l_max_mbps);

DBMS_OUTPUT.put_line ('l_actual_latency = ' || l_actual_latency);

END;

/

l_max_iops = 556

l_max_mbps = 48

l_actual_latency = 17

PL/SQL procedure successfully completed.

SQL>

同一时间只能执行一个校准操作，在RAC环境中，工作量发起的所有节点都可以执行。

[G]V$IO_CALIBRATION_STATUS视图显示了当前校准运行的状况。在运行过程中，会显示一个'IN PROGRESS' 的状态'。一旦运行完成状态切换到'READY'，并且会显示校准时间。　

SQL> SELECT * FROM v$io_calibration_status;

STATUS CALIBRATION_TIME

------------- -------------------------------

IN PROGRESS

SQL> SELECT * FROM v$io_calibration_status;

STATUS CALIBRATION_TIME

---------------------------------------------------------------------------

READY 28-JUL-2008 14:37:38.410

1 row selected.

SQL>

通过DBA_RSRC_IO_CALIBRATE视图可以显示校准信息。　　

SET LINESIZE 150

COLUMN start_time FORMAT A30