Subscriber Count

    457

Subscribe2

Pages

Performance Tuning: Oracle Top Wait events, Causes, Resolutions

Hello,

In case you want to know more about Oracle Wait events please read here

What are the causes for those wait event and how you can troubleshoot and resolve the same was neatly written in this document.

This document is very good, structured (apologies I do not remember the source and who written it,  […]

Performance Tuning Basics: Oracle Common Wait events

 

Just an excerpt from the Documentation/Note as a ready reference who reads this post.

Oracle Wait events can be divided into two categories , that is idle (IDLE) to wait for events and non-idle (NON-IDLE) .

1) Idle wait event represents ORACLE is waiting on some work at the time of diagnosis […]