Home » RDBMS Server » Server Administration » checkpoint time
checkpoint time [message #205673] Mon, 27 November 2006 01:09 Go to next message
Messages: 1
Registered: November 2006
Junior Member
During a checkpoint the following occurs:
- The database writer (DBWR) writes all modified database
blocks in the buffer cache back to datafiles,
- Log writer (LGWR) updates both the controlfile and
the datafiles to indicate when the last checkpoint
occurred (SCN)

Checkpoint process updates the file headers of the data files and flushes the dirty buffers in cache to data files.

i) Is there any propotional relation between "number of datafiles" and time spent to perform a checkpoint ?
ii) Is the majority of the time spent to checkpoint caused by "header update" or "flushing dirty buffers" ?
Re: checkpoint time [message #205698 is a reply to message #205673] Mon, 27 November 2006 03:16 Go to previous message
Messages: 114
Registered: August 2005
Senior Member

I think he has to set a checkpoint in every datafile, so normally the more datafiles you have the longer this wil take. But I don't think it will slow down your system just by adding a new datafile. If that is what you are asking.

And I think it is fair to say that the most time consuming action of checkpointing is flushing the buffers and updating the headers.

Previous Topic: Starting Week from Saturday
Next Topic: High watermark identyfying
Goto Forum:

Current Time: Thu Oct 27 10:15:46 CDT 2016

Total time taken to generate the page: 0.26620 seconds