How to Get Current SCN for Oracle 10g 11g Database? DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER and V$database

_____________________________________________________________________________________________________________________

There are two ways to get the current scn (System Change Number) for an oracle database.

Method 1

Select current_scn from v$database;

e.g. SQL>  select CURRENT_SCN from v$database;

      CURRENT_SCN

-----------------

   11626841778008

Method 2  

Using DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER function

SQL> select DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER  from dual;

GET_SYSTEM_CHANGE_NUMBER

------------------------

          11626841778005

_____________________________________________________________________________________________________________________

Website Stats