查询数据库当前SCN

来源:互联网 发布:如何把淘宝网店关闭 编辑:程序博客网 时间:2024/05/19 17:50

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
    2014669

SQL> select dbms_flashback.get_system_change_number() from dual;

DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER()
-----------------------------------------
      2014684

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
    2014691

原创粉丝点击