checkpoint? Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: checkpoint?

  1. #1
    Join Date
    Jun 2001
    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?
    guru is on the way!!!!

  2. #2
    Join Date
    Nov 2000
    Originally posted by beginner

    normally how often should we setup checkpoint
    half an hour?
    Depends, how much data can you lose?
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2000

    Surely you shouldn't 'lose' any data!

    The frequency of your checkpoint will affect the time it takes the database to recover after a crash as more redo is required to bring the datafiles upto the current SCN.

    The frequency of your checkpointing should therefore be set to meet your Time to Recovery requirements.

    The more time between checkpoints the more redo required therefore the longer the recovery time.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width