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

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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

0 comments:

Post a Comment

Labels

Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer