RACHELP | Solutions for Oracle Real Applications Clusters

Scripts

Topic	RAC
Description	I/O Calibarion procedure, modify the number of physical disks to your need.
Content	DECLARE l_max_iops PLS_INTEGER; l_max_mbps PLS_INTEGER; l_actual_latency PLS_INTEGER; BEGIN DBMS_RESOURCE_MANAGER.calibrate_io ( num_physical_disks => 10, max_latency => 15, 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;