SCN generation
Dear Oracle
Experts,
For a long time I am looking to get an idea about the process and memory area where SCN is being generated/incremented. As per couple of references over the internet showing that SCN is actually a combination of two fields SCN_WRAP and SCN_BASE
For a long time I am looking to get an idea about the process and memory area where SCN is being generated/incremented. As per couple of references over the internet showing that SCN is actually a combination of two fields SCN_WRAP and SCN_BASE
SCN = (SCN_WRAP * 2^32) + SCN_BASE
we can see current SCN by following two sources as well dbms_flashback.get_system_change_number and current_scn column of v$database
May be implementation of SCN is platform specific but the SCN propagation scheme that was actually selected can be determined from the alert.log. Oracle updates the "Picked” scheme to generate SCNs" line during instance startup.
0