RE: Redo Logs Problem

[VIVEK_SHARMA]

Substantial Redo Generation during a BATCH process was Reduced after Converting to LMT .   NOT sure of reasons though , other than reduced updates to Data Dictionaries   Request the List to respond to this   HTH     -----Original Message----- From: RAJESH DAYAL [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo Logs Problem   Just Out of curiosity….   How come changing the TS to LMT would reduce the excessive Redo generation.   Regards, Rajesh   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of VIVEK_SHARMA Sent: Monday, August 04, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo Logs Problem   Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation     -----Original Message----- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Subject: Redo Logs Problem   Hi Listers,   One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client).   Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated.   Regards   Munish Bajaj