|
Re: should i change size of log files as there is 20 log switch in 24hr? [message #123101 is a reply to message #123086] |
Thu, 09 June 2005 18:39 |
DMcG
Messages: 51 Registered: May 2005 Location: Auckland, New Zealand
|
Member |
|
|
If nobody is complaining, why bother changing anything ?
Rule of thumb for log switches is more than once every 15 to 20 minutes and you MAY be affecting the performance of the database.
If you're seeing log switches once a minute, you need to fix it, if you're seeing switches once an hour, don't bother.
Dougie McGibbon
|
|
|