How to find the current SCN

-- Works on 9i and 10g
select DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER from dual;

-- Works on 10g
select CURRENT_SCN from v$database;

-- Other useful tables
select * from v$log_history
select * from v$log;