Database Administration (MOSC)

MOSC Banner

SCN

edited Feb 28, 2020 1:36PM in Database Administration (MOSC) 12 commentsAnswered

Hi experts,


    How to know the SCN number at specific point in time.  We can get the current SCN from v$database view, but I need current_scn at specific second 

Example:
SQL> select current_scn from v$database;

CURRENT_SCN
-----------
   10279050

SQL> /

CURRENT_SCN
-----------
   10279072

SQL> /

CURRENT_SCN
-----------
   10279073


CURRENT_SCN is getting changed every time.   I want to see all the SCN and want to know what was the current_scn at what time



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