Skip to Content
avatar image
Former Member

IO-related wait events usually take up the most DB time

Hi Folks,

In ECC  EWA Report we see  'IO-related wait events usually take up the most DB time" . can anyone suggest how to  do

further analysis.

Regards,

Sharma TVK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 05, 2013 at 02:30 PM

    As long as you don't have a problem performance wise, don't panic. Only fix something when it is broken and not when there only is a general message somewhere.

    If you have performance issues, you might want to look out for expensive SQL or missing indexes and the like. The EWA report may show a bunch bad statements as well.

    766349 - FAQ: Oracle SQL optimization

    Cheers Michael

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Michael,

      Thanks for the above info.  we have already taken expensive sql  statements and given to Functional team

      for further analysis.  we  will also check above mentioned note as well.

      Regards

      Sharma TvK

  • Apr 05, 2013 at 10:50 AM

    hi sharma

    please see the link below

    http://ayyudba.blogspot.de/2007/10/tuning-io-related-waits.html

    best regards

    marius

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 05, 2013 at 11:34 AM

    Hi Sharma,

    Check disk queue length and utilization statistics over the substorage and/or local disks over the system. It may be caused by high disk utilization or utilizing disk controller over capacity. Additionally, high CPU utilization may cause this problem.

    I suggest you investigate the performance statistics on ST06 and ST04

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded