RE: dbms_resource_manager.calibrate_io, strange numbers

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_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
---

From: goran bogdanovic [mailto:goran00_at_gmail.com] Sent: woensdag 5 oktober 2011 21:01
To: D'Hooge Freek
Cc: oracle-l_at_freelists.org
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 Received on Wed Oct 05 2011 - 17:56:25 CDT