Seema:
Regarding the "Checkpoint not completed." message, make sure you're
checkpointing only at redo log switches.
Check loc_checkpoint_timeout and log_checkpoint_interval values.
If these values are OK and you still keep getting "Checkpoint not
completed." messages in the alert.log
Seema
First remember the old rule : If it's not broken don't fix it.
There is a rule of thumb that redo log switches should happened app.
every 30 minutes, but if you se redo log switches
happening more often at some times and nobody is complaining then just
ignore the it. If you have a perfor