log_buffer and archive redo logs

[grimwyre]

We have recently increased the size of the log_buffer from 10MB to 20MB. Since then we have seen far more archive redo logs being created than before.

The users are not aware of any additional work being done and the log buffer increase is the only obvious change that has been made.

I cannot see why increasing the log_buffer should increase the amount of redo activity.

Does anyone have any suggestions?

 

[SantaMufasa]

What are the sizes of your on-line redo log files? Do you have/use Oracle's "LogMiner"? It can confirm the contents of the log files.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.