oracle9i 查询scn,Oracle10g的current_scn是如何计算的?

我在我的测试库上查询都会看到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>