v$sysmetric, measuring IOPs

  • From: Vladimir Barac <vbarac@xxxxxxxxxxxx>
  • To: "'Oracle-L@xxxxxxxxxxxxx'" <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 25 May 2011 12:56:16 +0300

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

Other related posts: