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: Help Designing a Billion rows System
Next Topic: V$SESSION during a DAY
Goto Forum:

Current Time: Sun Apr 30 02:37:46 CDT 2017

Total time taken to generate the page: 0.27310 seconds