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? On Mon, Jul 21, 2008 at 6:54 PM, A Joshi <ajoshi977@xxxxxxxxx> 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 > > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist