RE: I/O performance
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: "'niall.litchfield@xxxxxxxxx'" <niall.litchfield@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Jun 2012 13:54:18 -0700
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
