IO


Orion inside Oracle 11g or DBMS_RESOURCE_MANAGER.CALIBRATE_IO

In Oracle 11g there is this new procedure which runs Orion (likely) from inside the database. You can get the IO per second, latency and MB per second of your disk sub-system.
Asynch IO needs to be set to true not to get an error.


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 (4, 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;
/

And the results:

max_iops = 13817
latency  = 3
max_mbps = 103