Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORION and DBMS_RESOURCE_MANAGER.CALIBRATE_IO output

user10274093Oct 17 2014 — edited Oct 21 2014

Hi all,

on Windows 2008 server , Oracle 11.2.0.3.0 - 64bit Production

I ran :

orion -simple -testname ob-test

And my iops.csv file is :

Capture.PNG

When I run DBMS_RESOURCE_MANAGER.CALIBRATE_IO

it gives me :

| 7 | DBMS_RESOURCE_MANAGER.CALIBRATE_IO (1, 10, iops, mbps, lat); |

8

| 9 | DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops); |
| 10 | DBMS_OUTPUT.PUT_LINE ('latency = ' || lat); |
| 11 | dbms_output.put_line('max_mbps = ' || mbps); |

12 end;

13 /

max_iops = 76

latency = 12

max_mbps = 45

Then ORION gives max_iops=189 and DBMS package gives max_iops=76.

How to explain such difference ?

my db_block_size is 8192.

Thanks.

This post has been answered by user10274093 on Oct 21 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2014
Added on Oct 17 2014
4 comments
569 views