Home » RDBMS Server » Server Administration » CKPT
CKPT [message #186044] Sat, 05 August 2006 02:55 Go to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Hey all,

With every log switch there occurs a checkpoint and with every checkpoint DBWn writes to datafiles.
Is it worth saying that with every log switch DBWn writes to datafiles?

Secondly, is it only with log switch that CKPT updates the headers of datafiles or it updates the datafiles with evry action causing checkpoint?

Any reply would be appreciated.

Thanks and Regards
Yasir Hashmi
icon14.gif  Re: CKPT [message #186046 is a reply to message #186044] Sat, 05 August 2006 03:30 Go to previous message
ninja
Messages: 6
Registered: August 2006
Location: INDIA
Junior Member
hi yasir,

first of all it is true that with every check point your dbwr is going to write in db files
secondly with every action that causes the checkpoint , ckpt process activates and update the header of data files Smile

regards
hardik
Previous Topic: Help Designing a Billion rows System
Next Topic: V$SESSION during a DAY
Goto Forum:
  


Current Time: Sun Dec 04 10:53:55 CST 2016

Total time taken to generate the page: 0.15353 seconds