RE: Redo Generation - Excessive ?

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Sat, 04 Aug 2001 08:23:07 -0700
Message-ID: <F001.00360A35.20010804082547@fatcity.com>

Okay..

In this case waht you can do is , you can randomly dump few redo logs (few blocks) and SEE what actually is in those files. Without checking those file dumps it is bit difficult to tell it is excessive or not.

And to avoid the redo generation. during the batch loads you can use direct load optios with no logging. This will significantly reduce the redo.

• VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com> wrote:
  > Gopal
  >
  > NO , Hot backup is NOT Running
  >
  > Good to have you back
  >
  > Thanks
  >
  >
  

  ---

Have a nice day !!

---

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

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

Received on Sat Aug 04 2001 - 10:23:07 CDT