我在我的测试库上查询都会看到SCN的增进的呀
一直都是这样的
select dbms_flashback.get_system_change_number current_scn from dual;
这样的查询也应该会看到SCN的增进呀
SCN是一个不断调动的“时钟”
只有不断的增进才符合的呀
下面是我的测试
ENV:10g R2 for Linux with ASM
20:02:05 ixora10g@IXORA10G> select current_scn from v$database;
CURRENT_SCN
-----------
1786814
Elapsed: 00:00:00.00
20:02:07 ixora10g@IXORA10G> select current_scn from v$database;
CURRENT_SCN
-----------
1786816
Elapsed: 00:00:00.00
20:02:08 ixora10g@IXORA10G> select current_scn from v$database;
CURRENT_SCN
-----------
1786818
Elapsed: 00:00:00.00
20:02:11 ixora10g@IXORA10G> select dbms_flashback.get_system_change_number current_scn from dual;
CURRENT_SCN
-----------
1786823
Elapsed: 00:00:00.04
20:02:26 ixora10g@IXORA10G> select dbms_flashback.get_system_change_number current_scn from dual;
CURRENT_SCN
-----------
1786823
Elapsed: 00:00:00.00
20:02:28 ixora10g@IXORA10G> select dbms_flashback.get_system_change_number current_scn from dual;
CURRENT_SCN
-----------
1786824
Elapsed: 00:00:00.01
20:02:30 ixora10g@IXORA10G> select dbms_flashback.get_system_change_number current_scn from dual;
CURRENT_SCN
-----------
1786827
Elapsed: 00:00:00.01
20:02:32 ixora10g@IXORA10G> select dbms_flashback.get_system_change_number current_scn from dual;
CURRENT_SCN
-----------
1786827
Elapsed: 00:00:00.01
20:02:33 ixora10g@IXORA10G> select dbms_flashback.get_system_change_number current_scn from dual;
CURRENT_SCN
-----------
1786827
Elapsed: 00:00:00.00
20:02:35 ixora10g@IXORA10G> select dbms_flashback.get_system_change_number current_scn from dual;
CURRENT_SCN
-----------
1786830
Elapsed: 00:00:00.01
20:02:44 ixora10g@IXORA10G> select dbms_flashback.get_system_change_number current_scn from dual;
CURRENT_SCN
-----------
1786831
Elapsed: 00:00:00.00
20:02:48 ixora10g@IXORA10G> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Elapsed: 00:00:00.03
20:03:03 ixora10g@IXORA10G>