Re: reset the SCN for the database

From: Karl Arao <karlarao_at_gmail.com>
Date: Thu, 16 Jul 2009 14:39:25 +0800
Message-ID: <12ee65600907152339u5292c518r200676c867874186_at_mail.gmail.com>



> That would mean that the SCN is a 6-byte integer, or 48 bits, which makes
> the max SCN exactly 281,474,976,710,656.
>
> Seems that overcommitting in procedures/apps is bad then.. it could lead to
> a SCN "reset" before the 500 years are over (on a very fast system).. :)
>

By the year 2509 (+500 years) and on the rate Oracle releases new database version (every two years)
that would be Oracle Database 261g Release 1

and I suppose there would be a bug fix for that :p

Received on Thu Jul 16 2009 - 01:39:25 CDT

Original text of this message