| Very Urgent - Plez reply [message #63731] |
Tue, 02 November 2004 20:25  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Hi, Can anyone tell me wat exactly is SCN and when its changed
- When checkpoint occurs
- At commit
- When log switch occurs
Plez reply to this query and will appreciate if anyone can give explain the same.
thanks in anticipation
Vivek
|
|
|
|
| Re: Very Urgent - Plez reply [message #63732 is a reply to message #63731] |
Tue, 02 November 2004 23:40  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
SCN stands for System Change Number and it get incremented whenever the transaction commits. This number is used by oracle for many aspects like to provide read consistency, for recovery etc.
Checkpoint is an event which flush the dirty buffers to disk and that time also it catch and record the current SCN which is known as checkpoint SCN. For info refer oracle doc.
Daljit Singh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
