Subscriber Count

    448

Subscribe2

Pages

Contact for Online learnings
* indicates required field
Thanks for the inquiry. You will be receiving a mail shortly with course details. If not please check the spam folder once and mark our mail as not a spam.

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 […]