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 ;-)
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