Oracle Wait Events - Explained!

January 06, 2020  

• db file scattered read – oracle wait event
• db file sequential reads – Oracle wait event
• Direct Path Read/Direct Path Read Temp – Oracle Wait Event
• Buffer busy waits – Oracle Wait Event
• Library Cache lock – Oracle Wait Event
• Library Cache Pin – Oracle Wait Event
• log file switch – Oracle Wait Event
• log file sync – Oracle Wait Event
• row cache lock – Oracle Wait Event
• enq: TM – contention – Oracle wait event
• enq: TX – index contention – Oracle wait event
• latch: cache buffers chains – Oracle wait event

We will see each and every wait events with detailed analysis in next posts.....