SCN max theory
Hi,
for my interests I read some blogs (e.g. https://orainternals.wordpress.com/2012/01/19/scn-what-why-and-how/ ) about SCN theories.
For my confirmation/conclusion:
- You have a SCN wrap counter as a 16Bit number
- You have a SCN base counter as a 32Bit number
- The wrap is increased at limit of SCN base of 4.294.967.296 (2^32)
- assuming max wrap is 2^16 then there is a possible SCN maximum of 2^16 * 2^32 => 281.474.976.710.656
If you have a SCN increasing of ~1.000.000.000 per month, that means the DB could have in theory ~20.000 years runtime - not my problem yet
Is that true or where is my mistake?
Cheers Peter