Re: reset the SCN for the database
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: tony_vanlingen@xxxxxxxxxxxxxxxxxxxxx
- Date: Thu, 16 Jul 2009 14:39:25 +0800
> 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
- Karl Arao
http://karlarao.wordpress.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
