DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: checkpoint?

  1. #1
    Join Date
    Jun 2001
    Posts
    193
    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
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by beginner

    normally how often should we setup checkpoint
    half an hour?
    Depends, how much data can you lose?
    Jeff Hunter

  3. #3
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    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.

    Cheers
    Moff.

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