获取当前的SCN

SELECT dbms_flashback.get_system_change_number FROM dual;

or

select current_scn
from v$database