CKPT Information please [message #59750] |
Sun, 21 December 2003 09:42 |
scott
Messages: 73 Registered: September 1999
|
Member |
|
|
Hi All,
This is got nothing to do with implementation or real world. It's rather a question of academic interest.
Oracle Docs say
An event called Checkpoint occurs when the Oracle background process DBWn writes the modified database buffers in the SGA including both COMMITTED and UNCOMMITTED data to the data files.
Can someone explain in detail the above statement. If DBWn starts writing both committed and uncommitted data to the data files how is integrity of data files maintained ?
Thanks
Scott
|
|
|
|
Re: CKPT Information please [message #59753 is a reply to message #59751] |
Sun, 21 December 2003 15:33 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Mahesh,
it looks like the information from this website is outdated.
For eg) "Log writer (LGWR) updates both the controlfile and the datafiles to indicate when the last checkpoint occurred (SCN). "
is not true ever since CKPT process was made mandatory(since Oracle 8). CKPT does that. Further , in case of incremental checkpoints since 8.1 , only the controlfile is updated and not all the datafile headers.
-Thiru
|
|
|
|