dbms_resource_manager.calibrate_io - interpreting/comparing the results
- From: anthony Sanchez <anthonycsanchez@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Mar 2012 14:08:50 -0700
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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
