RE: I/O performance

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Fri, 8 Jun 2012 13:54:18 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B30649BF83CFC9_at_mail02.mba.xifin.com>

Just did it over the weekend for DW on 11.2.0.2

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 (256, 11, iops, mbps, lat);  

  DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);
  DBMS_OUTPUT.PUT_LINE ('latency  = ' || lat);
  DBMS_OUTPUT.PUT_LINE ('max_mbps = ' || mbps);

end;
/

Michael Dinh
Disparity Breaks Automation (DBA)

Confidence comes not from always being right but from not fearing to be wrong - Peter T Mcintyre Great minds discuss ideas; average minds discuss events; small minds discuss people - Eleanor Roosevelt  When any rule or formula becomes a substitute for thought rather than an aid to thinking, it is dangerous and should be discarded -Thomas William Phelps

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: Thursday, June 07, 2012 11:03 PM
To: ORACLE-L
Subject: I/O performance

I'm curious how many of you measure I/O performance ( IOPS, service times and MB/s ) regularly on your databases? And for those in SAN environments if you have access to ballpark figures for what you should be getting.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 08 2012 - 15:54:18 CDT