Re: Redo Logs [message #51326] |
Wed, 15 May 2002 20:48 |
Vikas Gupta
Messages: 115 Registered: February 2002
|
Senior Member |
|
|
Hello,
Every time there is a log switch, Oracle initiates a checkpoint.
If your logs are small -- Checkpoints will occur frequently.
If your logs are large -- checkpoint will not occur frequently and hence there is a crash, it could take a long time to recover.
Frequent checkpoints can effect your performance.
Well in general log switch should occur in every 20-30
minutes, its history can also be viewed in your alertlog file.
You should size ( drop and add) your redo logs until you receive this target.
|
|
|