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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:23:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.