[Oracle-l] ** wait events

What a list of wait events!!! :)

That's why Oracle has built the support site called metalink and supplied
official manual documents.

Dion Cho

2008/7/22 A Joshi :

You will fine a good explanation of wait interface in this book:

http://www.amazon.com/Oracle-Wait-Interface-Performance-Diagnostics/dp/007222729X/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1216693950&sr=8-1

I think Steve Adams still has some details at ixora.com.au
Hope that helps

On Jul 21, 2008, at 8:54 PM, A Joshi wrote:

Hi,
Can someone explain the wait events like rdbms ipc message, jobq slave wait, PX Deque wait, direct path read, enqueue and how to tackle them. Thanks

Before learning how to 'fix' them, you need to learn how to determine
which, if any, of them are actually a problem.

What are you trying to accomplish?

Reduce numbers seen on a statspack report?

User complaining about performance?