RE: dbms_resource_manager.calibrate_io, strange numbers

It seems to depend on the number of disks and / or the latency.

When running with 1 disk and a latency of 20, the max_mbps is filled in (but 
the actual_latency is still 0):

START_TIME                     END_TIME                         MAX_IOPS   
MAX_MBPS  MAX_PMBPS    LATENCY   NPD
------------------------------ ------------------------------ ---------- 
---------- ---------- ---------- -----
05-OCT-11 04.43.02.766110 PM   05-OCT-11 04.57.38.945132 PM        13061        
224        190          0     1

Elapsed: 00:00:00.00

When I run the calibration on a different 11.2.0.2 system, which is using ASM 
instead of dNFS

SQL> select * from dba_rsrc_io_calibrate;

START_TIME                     END_TIME                         MAX_IOPS   
MAX_MBPS  MAX_PMBPS    LATENCY   NPD
------------------------------ ------------------------------ ---------- 
---------- ---------- ---------- -----
05/10/11 18:21:51,323672       05/10/11 18:47:22,379584            10405        
491        187         18     1

Both max_mbs and latency are given now.

The numbers of the test with latency 20 and 1 disk, are matching what I see 
when doing full table scan speed tests, so I will leave it for now.

Thanks to everyone who responded.


Kind regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
---
From: goran bogdanovic [mailto:goran00@xxxxxxxxx] 
Sent: woensdag 5 oktober 2011 21:01
To: D'Hooge Freek
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: dbms_resource_manager.calibrate_io, strange numbers

really strange results ... did you try to run orion and compare the results?

afaik, calibrate_io should be based on orion logic/implementation

regards,
goran

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


Other related posts: