| SCN [message #61430] |
Thu, 22 April 2004 16:35  |
Upperm
Messages: 95
Registered: July 2003
|
Member |
|
|
Hello Folks,
I'm somehow a little bit confused.. !
How can I understand and retain once for ever the concept and meaning of the CHECKPOINT ?
Thank so much for any help :)
|
|
|
|
| Re: SCN [message #61431 is a reply to message #61430] |
Thu, 22 April 2004 20:24  |
Gajanan Kini
Messages: 8
Registered: January 2002
|
Junior Member |
|
|
CHECKPOINT MEANS
LGWR tells DBWR to write all dirty data blocks from buffer cache to disk.
When one redo log file fills over it starts writing to another redo log file , that time it generates a log sequence number and invokes checkpoint.
|
|
|
|
| Re: SCN [message #61489 is a reply to message #61431] |
Wed, 28 April 2004 23:33 |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
CHECKPOINT:
is a synchronization process of the buffer cache with the data files. The Checkpoint process(CKPT) updates all data file headers and control files whenenever checkpoint occurs and simultaneously it signals LGWR and DBWR to write the redo entries and dirty buffer to disk respectively. The CKPT writes the Checkpoint SCN value to all the datafile headers that are involved in a checkpoint.
regards
Vivek.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
