Re: ** wait events
From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 22 Jul 2008 09:13:40 -0700
Message-ID: <bf46380807220913n75c11179q44853652d2a834bd@mail.gmail.com>
Date: Tue, 22 Jul 2008 09:13:40 -0700
Message-ID: <bf46380807220913n75c11179q44853652d2a834bd@mail.gmail.com>
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_at_yahoo.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 22 2008 - 11:13:40 CDT