Re: ID This Wait stat

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
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 21 May 2002 20:57

|
|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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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).