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

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 11 Feb 2011 14:16:13 -0600
Message-ID: <AANLkTikWxik=s1797rXP4vgDR0oDr=toRQ8AYLcVZRVt_at_mail.gmail.com>

I have some scripts that pull most of that, except for the queues, from the oracle AWR tables. Let me know if you would like them.

On Fri, Feb 11, 2011 at 2:12 PM, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com> wrote:

> Thanks as well!
>
>
>
> *Chris Taylor*
>
> *Sr. Oracle DBA*
>
> Ingram Barge Company
>
> Nashville, TN 37205
>
> Office: 615-517-3355 <+16155173355>
>
> Cell: 615-663-1673 <+16156631673>
>
> Email: 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
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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

Received on Fri Feb 11 2011 - 14:16:13 CST