Oracle Wait Event reference

February 9th, 2010

Kyle Hailey has started putting together a much needed Oracle wait event reference.

You can access it here.

By the way, Oracle documentation also has a wait event reference section, it has more events, but it’s less detailed…

I have plans to go deep into some wait events and cover some less common ones in tech.E2SN too… in the future ;-)

  • Share/Bookmark

Tanel Poder
Cool stuff, Internals, Oracle, Performance, Tuning

  1. Trackbacks

  2. No trackbacks yet.
  1. Comments

  2. Paul Janda
    February 11th, 2010 at 13:05 | #1

    Thanks for the link. I’ve got that marked for future reading, as he adds more. I like the “old way – before ASH”. I think the ASH is the cat’s meow. I’ve solved quite a few problems without being forced to write my own v$ snapshots combined with “please do it again so I can run my diagnostic”. BTW, do you remember “mutex problem”. You and I had a lengthy conversation in Dec. OSS says that it is a bug in the Oracle kernel.
    -paul