RE: I/O performance

http://docs.oracle.com/cd/E11882_01/appdev.112/e10577/d_resmgr.htm

SET SERVEROUTPUT ON
DECLARE

  lat  INTEGER;
  iops INTEGER;
  mbps INTEGER;

   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);

SQL> _at_pr 'select * from DBA_RSRC_IO_CALIBRATE';

START_TIME                    : 03-JUN-12 02.16.08.904588 PM
END_TIME                      : 03-JUN-12 02.24.15.534572 PM
MAX_IOPS                      : 10525
MAX_MBPS                      : 1245
MAX_PMBPS                     : 585
LATENCY                       : 10
NUM_PHYSICAL_DISKS            : 256
==============================

PL/SQL procedure successfully completed.

I do not know the exact number of disk so I guessed.

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 - 16:07:33 CDT