RE: LGWR using lots of CPU time, low CPU usage

Hmmmm. I got to thinking about a previous reply which was while doing something else:

>I don't think changing the logmembers will do much good
I agree.

> 4 groups, they are on the local drive.
BOOM!! Then got to thinking .... This is not right at all. I think I was making a subconscious interpretation based on the context of your usage of the terms. If your groups look like
GROUP1

	redo_01a.dbf_or_log
	redo_01b.dbf_or_log
	redo_01c.dbf_or_log

GROUP2
	redo_02a.dbf_or_log
	redo_02b.dbf_or_log
	redo_02c.dbf_or_log

etc.

Then, this all this extra writing will definitely incur overhead.

Now, the part about it all being on "the local drive": That still is BOOM!!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: slee_at_dollar.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).