Re: What's generating all these logs?

  • From: Tanel Poder <tanel@xxxxxxxxxx>
  • To: "eugene.pipko" <eugene.pipko@xxxxxxxxxxxx>
  • Date: Tue, 1 Dec 2009 18:14:02 +0000

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@xxxxxxxxxxxx>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

Other related posts: