How to Get Current SCN for Oracle 10g 11g Database? DBMS_FLASHBACK.GET_SYSTEM_CHANGE

advertisements

_____________________________________________________________________________________________________________________

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

_____________________________________________________________________________________________________________________

A visitor from Sydney viewed 'How to K**l or Resume [1]+ Stopped Unix Jobs' 11 mins ago

A visitor from Kennewick viewed 'How to Find out / Check SGA and PGA size of Oracle' 3 hrs 57 mins ago

A visitor from Asuncion viewed 'Data Pump Impdp show=y Replaced with SQLFILE Optio' 4 hrs 56 mins ago

A visitor from California viewed 'Fix ORA-01927: cannot REVOKE privileges you did no' 4 hrs 58 mins ago

Archive