| My logs are switching every 5 mins, why? [message #184397] |
Wed, 26 July 2006 07:26  |
aidi-h
Messages: 45
Registered: November 2005
|
Member |
|
|
|
My DB was writing to my redo log files too fast and causing errors. As this was the case, I increased my redo logs from 5 * 50M to 5 * 100M files. Although checkpoints are all being reached now, the logs are switching every 5 mins regardless of the amount of people on the system. Is there some setting anywhere that is forcing the logs to be switched every 5 mins regardless of whether the log is filled up or not. Could my log buffer be too small and is this causing the problems?
|
|
|
|
|
|
|
|
| Re: My logs are switching every 5 mins, why? [message #184593 is a reply to message #184456] |
Thu, 27 July 2006 03:11  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
So it's not just down to the amount of data? The logs aren't full?
The parameter Archive_Lag_Target sets how long (in seconds) the Db will go before forcing a log switch.
But, I'd say if you're not having a problem with the amount of data in the redo logs, just leave it.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
