获取系统当前的scn值
SYS>select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
SYS>select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
1393146
scn to timestamp
SYS>select dbms_flashback.get_system_change_number scn,SCN_TO_TIMESTAMP(dbms_flashback.get_system_change_number) time from dual;
SCN TIME
---------- ---------------------------------------------------------------------------
1392412 24-MAY-13 12.12.44.000000000 PM
timestamp to scn
SYS>select timestamp_to_scn(SYSTIMESTAMP) scn from dual;
SCN
----------
1392500
scn to timestamp
SYS>select dbms_flashback.get_system_change_number scn,SCN_TO_TIMESTAMP(dbms_flashback.get_system_change_number) time from dual;
SCN TIME
---------- ---------------------------------------------------------------------------
1392412 24-MAY-13 12.12.44.000000000 PM
timestamp to scn
SYS>select timestamp_to_scn(SYSTIMESTAMP) scn from dual;
SCN
----------
1392500
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/27181165/viewspace-775868/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
rman之基于时间点的不完全恢复
下一篇：
查看并修改oracle最大连接数
请登录后发表评论
登录
全部评论
