Re: reset the SCN for the database

From: Karl Arao <>
Date: Thu, 16 Jul 2009 14:39:25 +0800
Message-ID: <>

> 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