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

Thread: checkpoint

  1. #1
    Join Date
    Sep 2005
    Posts
    9

    checkpoint

    wats the difference between an incremental and a normal checkpoint?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

  3. #3
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78

    Checkpoint

    Quote Originally Posted by d.goddess
    wats the difference between an incremental and a normal checkpoint?
    By Normal checkpoint if you mean Full checkpoint, then it occurs at shutdown, this checkpoint writes all the dirty buffers from database buffer cache to datafiles and instruct log writter (logwr) to write checkpoint information to all the datafiles and controlfiles.
    Incremental checkpoint occurs if fast_start_mttr_target is set. it writes dirty buffers from the last incremental checkpoint or full checkpoint to the time specified specified by fast_start_mttr_target. this parameter minimizes the time taken for instance recovery.

  4. #4
    Join Date
    Aug 2005
    Location
    Nigeria
    Posts
    14

    Smile

    I think by normal checkpiont which is full checkpoint anyway, its the checkpoint that notify the log writer (logwr) to write dirty buffers to datafile while the checkpoint update the controfile and the header of datafile with the information and not the other way round as dhar_kiran had said.
    Last edited by wole; 09-08-2005 at 02:49 AM.
    The purpose of life is a life of purpose.

  5. #5
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78

    Checkpoint

    Quote Originally Posted by wole
    I think by normal checkpiont which is full checkpoint anyway, its the checkpoint that notify the log writer (logwr) to write dirty buffers to datafile while the checkpoint write the information to the controfile and the header of datafile. not the other way round as dhar_kiran had said.
    the function of logwr is not to write dirty buffers as it is the job of dbwr, logwr writes from redo log buffer to redolog files and when checkpoint happens it writes checkpoint information to controlfile.

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