RE: ID This Wait stat

2002-05-22 Thread Tom Schruefer
of list ORACLE-L Subject: Re: ID This Wait stat You can ignore them. See: http://www.ixora.com.au/q+a/waits.htm Tom Schruefer [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 01:32 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

RE: ID This Wait stat

2002-05-22 Thread Grabowy, Chris
Lots... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 7:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: ID This Wait stat You can ignore them. See: http://www.ixora.com.au/q

Re: ID This Wait stat

2002-05-21 Thread Rachel Carmichael
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 [EMAIL PROTECTED] wrote: You know I could have all the documentation for Oracle printed on

Re: ID This Wait stat

2002-05-21 Thread Jonathan Lewis
I think if you look at the v$session_event view, you will find that these are idle waits by the various dbw slave processes. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August

RE: ID This Wait stat

2002-05-21 Thread Gogala, Mladen
That is a wait for parallel query slave to finish processing. -Original Message- From: Tom Schruefer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 4:32 PM To: Multiple recipients of list ORACLE-L Subject: ID This Wait stat You know I could have all the documentation

RE: ID This Wait stat

2002-05-21 Thread Tom Schruefer
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 [EMAIL PROTECTED] wrote: You know I could

Re: ID This Wait stat

2002-05-21 Thread Jared . Still
You can ignore them. See: http://www.ixora.com.au/q+a/waits.htm Tom Schruefer [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 01:32 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ID This

RE: ID This Wait stat

2002-05-21 Thread Deshpande, Kirti
on to the next item on my list. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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