" background checkpoints completed " Meaning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: " background checkpoints completed " Meaning

  1. #1
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96

    " background checkpoints completed " Meaning

    According to ref manual (8.1.7) The Definition of the
    " background checkpoints completed "
    is
    The number of checkpoints completed by the background process. This statistic is incremented when the background process successfully advances the thread checkpoint.

    Means it only counts the checkpoints at the log switch ?
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268

    checkpoint

    checkpoint does not occur only at log switch.
    Checkpoint is also performed when these parameters conditions are met:
    LOG_CHECKPOINT_TIMEOUT
    LOG_CHECKPOINT_INTERVAL

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