dbms_resource_manager.calibrate_io - interpreting/comparing the results

From: anthony Sanchez <anthonycsanchez_at_gmail.com>
Date: Wed, 7 Mar 2012 14:08:50 -0700
Message-ID: <CAEwv4fFCC1BOvBcO-R1BFLSpMKReZ_BScjhOfTrcBHAogspieQ_at_mail.gmail.com>

Hi Oracle folks,
I'm relatively new to the capacity planning business (and oracle-L) and am looking for some other real world calibrate_io metrics to compare against.  How do these metrics compare to what you've seen?

I know it ultimately comes down to SLA's and what our storage vendor's promise (trying to get that info) but I'd like to have a frame of reference for comparison.

I guess what I'm looking for is whether what I'm seeing is a Ford (Opel for some of you):

1. Focus
2. Mustang
3. Shelby GT500
4. other? :)

Our system:

Oracle 11.2.0.3 on RHEL5 x64 (virtualized via vmware) HP Left hand P4500 G2 120TB storage cluster with 120 1,000 GB 7.2K MDL SAS disk drives (RAID 10)

*My script:*

set serveroutput on

declare

     l_latency   integer;
     l_iops      integer;
     l_mbps      integer;

 begin

    dbms_resource_manager.calibrate_io (120,10,l_iops,l_mbps,l_latency);

     dbms_output.put_line('I/O Ops/sec = '||l_iops);
     dbms_output.put_line('Actual Latency = '||l_latency);
     dbms_output.put_line('MB/sec = '||l_mbps);

end;
/

*Results:*

sys_at_MUDRPRD> @calibrate_io.sql
*I/O Ops/sec = 6922*
*Actual Latency = 10*
*MB/sec = 655*

begin
 print_table('
select max_iops,max_mbps,max_pmbps,latency,num_physical_disks from DBA_RSRC_IO_CALIBRATE
');
end;
/

*MAX_IOPS : 6922*
*MAX_MBPS : 655*
*MAX_PMBPS : 372*
*LATENCY : 10*
*NUM_PHYSICAL_DISKS : 120*

---

Any feedback would be appreciated!

thank you,

Anthony Sanchez

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

Received on Wed Mar 07 2012 - 15:08:50 CST