checkpoint happened when:
1. log_checkpoint_interval and timeout.
2. alter system switch logfile
3. log switch
4. alter system checkpoint.
5. db shutdown but not abort.

what else?
normally how often should we setup checkpoint
half an hour?