RE: Redo Logs Problem

[Wiegand, Kurt]

Title: RE: Redo Logs Problem

Update activity is obviously occuring at an alarming rate.  Look at the times of the log switches

and you should be able to pinpoint the 'when'  Then, catch them in the act!  Look at v$sess_io and

find your 'heavy hitters', then grab their SQL or ,better yet, call them while it's running. 

Kurt Wiegand  Cable & Wireless 

 -----Original Message-----
From:   Munish Bajaj [SMTP:[EMAIL PROTECTED]

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