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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google