RE: Redo Logs Problem

[Munish Bajaj]

Thanks to all who have replied   But the problem has been resolved. It was due to a background scheduled process which was deleting records from log tables. I was able to find out this by joining v$session,v$transaction and v$sql dynamic performance views.   However thanks again to all for your enlightening answers. This list is great.   Regards Munish Bajaj -----Original Message----- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:19 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