Besides the other suggestions, consider the following:
- At times you as the DBA do some very intensive operations. You
probably want to ignore the message at these times.
- The larger a redo-log is, the longer it will take to archive it.
- The larger a redo-log is, the longer it will take to write dirty
buffers. If you use very large redo-logs, you may want to consider causing
checkpoints at more than just the default log switch times.
Pedro Tavares wrote in message <76qs0j$1kr$1_at_duke.telepac.pt>...
>My database has lots of activity, and if I monitor de alert log, I'm
>constantly receiving the message - checkpoint not complete. I believe that
>this is affecting the overall performance. What can I do to avoid this? I
>have 4 redo log files of 1M each.
>Thanks in advance.
>
>Pedro Tavares
>Lisbon, Portugal
>
>
Received on Mon Jan 04 1999 - 18:24:40 CST
