Database Administration (MOSC)

MOSC Banner

Current SCN and Soft Limit

edited Feb 1, 2012 7:00PM in Database Administration (MOSC) 3 comments

My current understanding is this:-

"At any point in time, the Oracle Database calculates a "not to exceed" limit for the SCN a database can have used, based on the number of seconds elapsed since 1988, multiplied by 16,384. This is known as the 'Soft Limit'. If the soft limit is likely to be exceeded in the next SCN increment then Oracle will issue an ORA-0600 error and the process will be cancelled."

Is the soft limit always calculated from the point in 1988 or from the point at which the database was created ?

Are there ANY circumstances under which the current SCN can exceed the soft limit ?  (cloned DB for instance ?)

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