FAQ
All,

What is the range I should be looking at for file i/o average read in
milli second in a ASM environment.

I see some of my database have average read between 3ms and 8ms .

appreciate any suggestion

thanks
Kart

Search Discussions

  • Niall Litchfield at May 18, 2011 at 5:55 am
    Which statistic are you looking at? There are a number of read statistics.
    On Wed, May 18, 2011 at 1:15 AM, K R wrote:

    All,

    What is the range I should be looking at for file i/o average read in
    milli second in a ASM environment.

    I see some of my database have average read between 3ms and 8ms .

    appreciate any suggestion

    thanks
    Kart
    --
    Niall Litchfield
    Oracle DBA
    http://www.orawin.info

    --
    http://www.freelists.org/webpage/oracle-l
  • K R at May 19, 2011 at 8:07 pm
    Thanks Niall,

    In the AWR I am looking at this section.
    File IO Stats

    ordered by Tablespace, File

    Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av
    Writes/s Buffer
    Waits Av Buf Wt(ms)

    On Tue, May 17, 2011 at 10:55 PM, Niall Litchfield <
    niall.litchfield_at_gmail.com> wrote:
    Which statistic are you looking at? There are a number of read statistics.
    On Wed, May 18, 2011 at 1:15 AM, K R wrote:

    All,

    What is the range I should be looking at for file i/o average read in
    milli second in a ASM environment.

    I see some of my database have average read between 3ms and 8ms .

    appreciate any suggestion

    thanks
    Kart


    --
    Niall Litchfield
    Oracle DBA
    http://www.orawin.info
    --
    http://www.freelists.org/webpage/oracle-l
  • Sriram Kumar at May 20, 2011 at 11:24 am
    Hi Kart,

    In my opinon there is no magical number that suits any environment. It
    depends on the application workload and how much IO contributes to the
    workload (Contributing to top events in AWR). Higher the IO contribution,
    lower would be the requirement for the response time if you intend to tune
    it.

    I Do have to state that this number would be averaged over REAL physical
    reads coming from the disks and logical reads coming from layers outside
    oracle ( JFS cache, SAN Cache) etc

    Best Regards

    Sriram
    On Wed, May 18, 2011 at 3:15 AM, K R wrote:

    All,

    What is the range I should be looking at for file i/o average read in
    milli second in a ASM environment.

    I see some of my database have average read between 3ms and 8ms .

    appreciate any suggestion

    thanks
    Kart
    --
    http://www.freelists.org/webpage/oracle-l
  • Pavel at May 23, 2011 at 9:58 am
    Hi
    I think 3-8 ms is a good time for read :) (in most environment)

    Sincerely,
    Pavel.

    2011/5/20 Sriram Kumar
    Hi Kart,

    In my opinon there is no magical number that suits any environment. It
    depends on the application workload and how much IO contributes to the
    workload (Contributing to top events in AWR). Higher the IO contribution,
    lower would be the requirement for the response time if you intend to tune
    it.

    I Do have to state that this number would be averaged over REAL physical
    reads coming from the disks and logical reads coming from layers outside
    oracle ( JFS cache, SAN Cache) etc

    Best Regards

    Sriram


    On Wed, May 18, 2011 at 3:15 AM, K R wrote:

    All,

    What is the range I should be looking at for file i/o average read in
    milli second in a ASM environment.

    I see some of my database have average read between 3ms and 8ms .

    appreciate any suggestion

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 18, '11 at 12:15a
activeMay 23, '11 at 9:58a
posts5
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase