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