What happen after ckeck point?

What will happen after checkpoint ?
i means .. dbwr write or redo log entries like that .. i am asking..

Showing Answers 1 - 3 of 3 Answers


  • Apr 14th, 2015

1)Check point raises when DBWR wants to write the data into DATA FILES from data buffer cache and every log switch causes CKPT.

2) Update Headers with SCN.(system change number) which is generated for every committed transaction.

3) Stores Current SCN in control files

  Was this answer useful?  Yes


  • Jul 10th, 2015

Whenever switch log occur, checkpoint event will occur, and ckpt event will invoke checkpoint process, then ckpt process will generate SCN No. for specific transaction, and that SCN info will be load into control file and SCN No. writes into data file header, and invoke to dbwr.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions