Oracle wait events

[Former Member]

Hello colleagues,

Could you please let me know where can I find detailed information with regards to Oracle wait events?

I'm interested in methods that allow me to know how to identify performance issues on the system that are related to DB wait events.

Thanks and best regards

Rod

[Former Member]

Thanks for your help,

Best regards,

Rod

Coca Cola FEMSA

[Former Member]

Hi Rod,

Check the note 619188 - FAQ: Oracle wait events. You can find idle and non-idle events and their explanations in it.

Best regards,

Orkun Gedik

[lbreddemann]

Hi there,

in addition to the already mentioned SAP notes, why don't you just check the Oracle documentation?

Most of the wait events are fully explained in there, along with the approach how to use the wait event data.

If you want to grasp a better understanding of the technique of wait time analysis, I highly recommend that you check the website of Cary Millsap and Method R. Cary provides great introductions into the theory behind the wait events and does a perfect job with explaining it.

regards,

Lars