Finding current SCN of a database
There are two ways to get the current SCN (System Change Number) for an oracle 10g and 11g database
DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER and V$database
Method 1:Using DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER function
SQL>SELECT TO_CHAR(dbms_flashback.get_system_change_number) FROM dual;
GET_SYSTEM_CHANGE_NUMBER
----------------------------------------
11626841778005
Method 2:Using current_scn column from v$database;
SQL> SELECT TO_CHAR(CURRENT_SCN) FROM V$DATABASE;
CURRENT_SCN
--------------------
11626841778008
There are two ways to get the current SCN (System Change Number) for an oracle 10g and 11g database
DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER and V$database
Method 1:Using DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER function
SQL>SELECT TO_CHAR(dbms_flashback.get_system_change_number) FROM dual;
GET_SYSTEM_CHANGE_NUMBER
----------------------------------------
11626841778005
Method 2:Using current_scn column from v$database;
SQL> SELECT TO_CHAR(CURRENT_SCN) FROM V$DATABASE;
CURRENT_SCN
--------------------
11626841778008
No comments:
Post a Comment