Location: Business Intelligence

Discussion: SCN with ROW-LEVEL-DEPENDENCYReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 2 posts

pat_ioset@hispeed.ch
SCN with ROW-LEVEL-DEPENDENCY
Feb 12 2009, 3:47 AM EST | Post edited: Feb 12 2009, 3:47 AM EST
When the ROW-LEVEL-DEPENDENCY IS SET on RAWDEPENDENCY in a table, Oracle generate an SCN for every transaction.
My questions are the following:
how is the SCN generated by Oracle ?
is the value of the generated SCN increasing within each table after each transaction ?
or is the value of the generated SCN randomly generated ?

Thank you

 Do you find this valuable?    
Keyword tags: None
luciofer
luciofer
1. RE: SCN with ROW-LEVEL-DEPENDENCY
Feb 12 2009, 9:15 AM EST | Post edited: Feb 12 2009, 9:15 AM EST
"When the ROW-LEVEL-DEPENDENCY IS SET on RAWDEPENDENCY in a table, Oracle generate an SCN for every transaction.
My questions are the following:
how is the SCN generated by Oracle ?
is the value of the generated SCN increasing within each table after each transaction ?
or is the value of the generated SCN randomly generated ?

Thank you

"
Hello,

The SCN is used by Oracle to know the latest 'version' of the data among the multi-session versions.
It's incremental, and so he considers the greater number as the 'current'.
Each committed transaction, a new SCN.

Cheers Do you find this valuable?