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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

Hello,

Thanks for the reply .

We will check as  suggested above

Regards,

Sharma TvK

[former_member206552]

hi sharma

please see the link below

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

best regards

marius