15 lines
389 B
SQL
15 lines
389 B
SQL
SET SERVEROUTPUT ON
|
|
DECLARE
|
|
lat INTEGER;
|
|
iops INTEGER;
|
|
mbps INTEGER;
|
|
BEGIN
|
|
-- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (<DISKS>, <MAX_LATENCY>, iops, mbps, lat);
|
|
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (&no_of_disks, 10, iops, mbps, lat);
|
|
|
|
DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);
|
|
DBMS_OUTPUT.PUT_LINE ('latency = ' || lat);
|
|
dbms_output.put_line('max_mbps = ' || mbps);
|
|
end;
|
|
/
|