v$sysmetric, measuring IOPs

From: Vladimir Barac <vbarac_at_Alghanim.com>
Date: Wed, 25 May 2011 12:56:16 +0300
Message-ID: <C85D70C785B07043A485C8AE85E8F6711F43CDCF8D_at_ALGMB.Alghanim.com>

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

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

Received on Wed May 25 2011 - 04:56:16 CDT

This message: [ Message body ]
Next message: Paulo Gomes: "Need help with compatibility list for oracle 8.1.5 and windows nt"
Previous message: Mark Brinsmead: "Re: Disaster Recovery solutions for Oracle..."
Next in thread: Guenadi Jilevski: "Re: v$sysmetric, measuring IOPs"
Reply: Guenadi Jilevski: "Re: v$sysmetric, measuring IOPs"
Reply: Niall Litchfield: "Re: v$sysmetric, measuring IOPs"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message