1.系统当前SCN:
两个语句都可以:
select current_scn from v$database;
CURRENT_SCN
-----------
1859456
select dbms_flashback.get_system_change_number,
SCN_TO_TIMESTAMP(dbms_flashback.get_system_change_number) from dual;
GET_SYSTEM_CHANGE_NUMBER SCN_TO_TIMESTAMP(DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER)
---------------------------------------------------------------------------
1859442 10-JAN-17 08.57.41.000000000 PM