Oracle-L: RE: LGWR using lots of CPU time, low CPU usage

From: John Shaw <John.Shaw_at_correctionscorp.com>
Date: Wed, 27 Nov 2002 07:23:46 -0800
Message-ID: <F001.0050D847.20021127072346@fatcity.com>

I should have said spread across local drives.

>>> slee_at_dollar.com 11/26/02 05:35PM >>>

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Shaw
  INET: John.Shaw_at_correctionscorp.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).

Received on Wed Nov 27 2002 - 09:23:46 CST