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

Previous Topic: Apply archive logs
Next Topic: accessing DB through excel
Goto Forum:

Current Time: Wed Aug 23 01:26:38 CDT 2017

Total time taken to generate the page: 0.01749 seconds