Re: What's generating all these logs?

From: Tanel Poder <tanel_at_poderc.com>
Date: Tue, 1 Dec 2009 18:14:02 +0000
Message-ID: <4602f23c0912011014m21bd6a2cp9a808a416a4594e7_at_mail.gmail.com>

Identify the sessions generating most redo using snapper:

http://blog.tanelpoder.com/2008/05/30/oracle-troubleshooting-with-snapper-detecting-whos-causing-excessive-redo-generation/

Then see what these sessions are running...

--
Tanel Poder
http://blog.tanelpoder.com


On Tue, Dec 1, 2009 at 6:02 PM, Eugene Pipko <eugene.pipko_at_unionbay.com>wrote:



>  Hi all,

>

> I working on Oracle Fin on 9.2

>

> For some reason d/b generates almost 1G of arch logs per min.

>

> What may cause this? How do I find out what process is generating all these

> logs?

>

> I will have less than an hour before arch log destination fills up.

>

>

> Thanks,

>

>

>

> Regards,

>

>

>

> Eugene Pipko

>

> Seattle Pacific Industries

>

> office: 253.872.5243

>

> cell: 206.304.7726

>

> P  Please consider the environment before printing this e-mail.

>

>

>




-- 
Tanel Poder
http://blog.tanelpoder.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 01 2009 - 12:14:02 CST