Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Redo Logs Problem

RE: Redo Logs Problem

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Fri, 01 Aug 2003 07:39:25 -0800
Message-ID: <F001.005C83F9.20030801073925@fatcity.com>


Probably an application has started generating lots of changes, causing the jump in redo generation rate. The client needs to get a delta of each session's value for 'redo size' in v$sesstat when this is happening, then they can identify the culprit session.

There is one bug that could cause this. Bug 2186174 is triggered under certain circumstances under 9.x if fast_start_parallel_rollback is set to TRUE. It causes instances to SPEW redo in a big way.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Fri, 1 Aug 2003, Whittle Jerome Contr NCI wrote:


> >> This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client).
>
> Clients lie.
>
> Jerry Whittle
> ASIFICS DBA
> NCI Information Systems Inc.
> jerome.whittle_at_scott.af.mil
> 618-622-4145
>
> > -----Original Message-----
> > From: Munish Bajaj [SMTP:mbajaj_at_quark.co.in]
> >
> > 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
> >
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: jwilton_at_speakeasy.net 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 Fri Aug 01 2003 - 10:39:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US