RE: ID This Wait stat

Arrggghhh. Well that was a easy problem to fix, just define 'wait' differently.

Now on to the next item on my list.

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rachel
> Carmichael
> Sent: Tuesday, May 21, 2002 5:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ID This Wait stat
>
>
> according to the docs and a friend in COE, slave wait is an "idle
> event" -- it means that the dbwr slave is waiting for something to do
>
> in other words, it ain't busy... not a "real" wait
>
>
> --- Tom Schruefer <tschruefer_at_mail.howard.k12.md.us> wrote:
> >
> > You know I could have all the documentation for Oracle printed on my
> > brain,
> > buy all the books ever written about the subject, but the primary
> > wait
> > problem that comes up will never be directly addressed.
> >
> > So, what exactly does 'Slave Wait' mean and what can I do about it?
> >
> >
> > I am using DBWR Slaves, since it did not seem as though starting
> > additional
> > DBWR's was appropriate on a Win2000 system.
> >
> > Here are the Top 5 wait events as per Statpack and my shinny new
> > 'Oracle
> > Performance Tuning 101' book:
> >
> > Top 5 Wait Events
> > ~~~~~~~~~~~~~~~~~ Wait
> > %
> > Total
> > Event Waits Time (cs)
> > Wt
> > Time
> > -------------------------------------------- ------------
> > ------------ -----
> > --
> > slave wait 66,593
> > 6,793,939
> > 88.85
> > PX Deq: Execution Msg 28,960
> > 407,167
> > 5.33
> > PX Deq: Table Q Normal 19,864
> > 302,480
> > 3.96
> > PX Deq Credit: send blkd 3,685
> > 123,671
> > 1.62
> > PX Deq: Signal ACK 3,214
> > 5,294
> > .07
> >
> >
> > I have a pretty good idea that 2-5 are for parallel query option,
> > although I
> > still have to figure out just what they mean.
> >
> >
> > Any help would be greatly appreciated.
> >
> > _____________________________________________________________
> > Tom Schruefer - tschruefer_at_mail.howard.k12.md.us
> > 410-313-6825
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Tom Schruefer
> > INET: tschruefer_at_mail.howard.k12.md.us
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> > Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tom Schruefer
  INET: tschruefer_at_mail.howard.k12.md.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).