raja

• 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

ahmed

• 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.

Somesh Menaria

 Profile Answers by Somesh Menaria 

• Feb 22nd, 2016

 

When checkpoint occurs the datafiles and control file header are updated and also dbwr writes dirty buffer to datafiles checkpoint give the signal.