Thursday, May 10, 2007

All About SCN

select start_scnw, start_scnb from v$transaction;

alter system checkpoint;

select CONTROLFILE_CHANGE# from v$database;

select dbms_flashback.get_system_change_number flashback_scn from v$database;

SELECT dbms_flashback.get_system_change_number FROM dual;