Printable View
I have a database and during a normal day I can have up to 30 redo log space requests.
Is the best course of action to resolve this to increase the log_buffer or to increase the size of my redo log files?
This is an oracle 7.3.4.5 database running on AIX 4.2
Check out
http://www.ixora.com.au/q+a/0010/17075858.htm and
http://www.ixora.com.au/q+a/redo.htm
He suggests that increasing log_buffer is ineffective and can have a worse impact on performance than just the redo log requests.
If your requests are only happening at log swtiches, you should consider increasing the log files, however if the requests are happening at times other than log switches you could consider tuning the log buffer.
If you want to decrease number of archive logs generated during the day you can increase size of your redo log files but you cannot decrease total size of redo log information generated daily. It depends on database activity. I have production databases with hundreds and thousands archive log files generated daily.
Sergey.