Hi,

Just a strange change.
No activity is going on (ofcourse oracle internal activities keep scn moving)

The first query gives me same scn (always) but the reverse always gives one incremented......

Any particular reason ??

thx



SQL> Select CURRENT_SCN from v$database
2 union all
3 Select dbms_flashback.get_system_change_number AS CURRENT_SCN from dual;

CURRENT_SCN
-----------
514882
514882

SQL> Select dbms_flashback.get_system_change_number AS CURRENT_SCN from dual
2 union all
3 Select CURRENT_SCN from v$database;

CURRENT_SCN
-----------
514890
514891