Frequente Archive Log Generation

classic Classic list List threaded Threaded
2 messages Options
big
Reply | Threaded
Open this post in threaded view
|

Frequente Archive Log Generation

big
Hi,

On 11.2.0.4 on AIX

We have Frequente Archive Log Generation.

One reason is smal redolog files.

Might be any other reson for that?

Thanks and regards.
Reply | Threaded
Open this post in threaded view
|

Re: Frequente Archive Log Generation

ErmanArslansOracleBlog
Administrator
There is no correlation or casual connection between producing excessive amount of archive logs and having small redolog files.

You need to check your DML operations, and actually all the operations that changes data in your database.. You can also check your archive logs (using logminer maybe) and see what you have inside of them.. That might also give you a clue..