Database Administration (MOSC)

MOSC Banner

SCN max theory

edited Nov 20, 2017 10:34AM in Database Administration (MOSC) 3 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center