Re: v$sysmetric, measuring IOPs

From: Guenadi Jilevski <gjilevski_at_gmail.com>
Date: Wed, 25 May 2011 13:01:54 +0300
Message-ID: <BANLkTi=vnmpYwoG6hy4SZ8wib-4Msk51DQ_at_mail.gmail.com>



Hi,

You could use Orion or if in Oracle 11g IO calibration.

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_resmgr.htm#CJGHGFEA

Regards,

Guenadi Jilevski

On Wed, May 25, 2011 at 12:56 PM, Vladimir Barac <vbarac_at_alghanim.com>wrote:

> Hi, listers
>
>
>
> I want to measure IOPs generated by Oracle and then to use these values
> when sizing new SAN array.
>
>
>
> My idea is to sample v$sysmetric ('Physical Read Total IO Requests Per Sec'
> + 'Physical Write Total IO Requests Per Sec') values and store them in some
> table for reference later on.
>
>
>
> Is this valid approach? Is there some other way to find out what are IOPs
> generated by Oracle?
>
>
>
> Regards,
>
> Vladimir Barac
>
>
>
>
>
> ______________________________________________________________________
> This e-mail message and any attachments to it are for the sole use of the
> intended recipients and may contain confidential and privileged information.
> This e-mail message and any attachments are the property of Yusuf A.
> Alghanim & Sons w.l.l. or any of its subsidiaries or affiliates (“Alghanim
> Industries”). Any unauthorized review, use, disclosure, or distribution of
> this e-mail message or its attachments is prohibited. Any opinions expressed
> in this message are those of the author and do not necessarily reflect the
> opinion of Alghanim Industries. If you are not an intended recipient, please
> notify the sender by reply e-mail and destroy all copies of the original
> message and any attachments.
> ______________________________________________________________________
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 25 2011 - 05:01:54 CDT

Original text of this message