Oracle-L: RE: Redo Logs Problem

From: Munish Bajaj <mbajaj_at_quark.co.in>
Date: Sun, 03 Aug 2003 22:29:23 -0800
Message-ID: <F001.005C8A9E.20030803222923@fatcity.com>

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-----
Sent: Monday, August 04, 2003 11:19
To: Multiple recipients of list ORACLE-L

Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation

-----Original Message-----
Sent: Friday, August 01, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L

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

<http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3 bst%3b&SG=&RAND=47891> Upgrade Your Email - Click here!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Munish Bajaj
INET: mbajaj_at_quark.co.in

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 Mon Aug 04 2003 - 01:29:23 CDT