RE: Need some ideas to create a disk IOPS profile for a RHEL 5.3 64bit system

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor_at_ingrambarge.com<mailto:chris.taylor_at_ingrambarge.com>

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

From: Scott Heisey [mailto:oraracdba_at_yahoo.com] Sent: Friday, February 11, 2011 2:04 PM
To: Taylor, Chris David; oracle-l_at_freelists.org Subject: RE: Need some ideas to create a disk IOPS profile for a RHEL 5.3 64bit system

Chris, I use the scripts for IOPS I downloaded from this site

http://www.jameskoopmann.com/?page_id=43

Also, OSW will convert information from iostat into a graph. There is java program included with OSW that will create gif chart.

Scott

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David Sent: Friday, February 11, 2011 12:11 PM To: 'oracle-l_at_freelists.org'
Subject: Need some ideas to create a disk IOPS profile for a RHEL 5.3 64bit system

Ok,

The subject pretty much says it all - I need some ideas on how to create an IO profile (specific to the disk I/O) for a server over "x" amount of time under the following constraints:

1.) Grid Control is not installed, but DBConsole is

2.) I have access to all standard system tools such as iostat, sar, etc

3.) I have access to the database itself with AWR data collection enabled

I need to capture average reads & writes along with queue amounts and times.

I have used sar -dp for short intervals, but I have to modify the output with vim and then import into excel to get it in a nice readable format. There has got to be a better way.

Thanks,

Chris

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