SCN
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
1