Re: What's generating all these logs?

You can you logminer to look inside the archive log and find the SQL statements causing high redo usage.

Harel Safra

Eugene Pipko 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.