Version: 11.2.0.3.3
Platfomrm: RHEL 5.4
Below are the results from a moderately busy 3-node RAC DB which has transactions of DSS nature (Only few OLTP transactions ).
As you can see below , I queried v$database.current_scn multiple times. I subtracted results of first and second execution just to get a rough idea on the increment. There is an increment of 2575 in less than a second. Is this normal ?
Apart from Transaction Commits what are the other things that could increment SCN ?
Is there a Limit to the SCN number ? Like a trillion or something ?
SQL> set timing on
SQL> select current_scn from v$database;
CURRENT_SCN
------------------
246746857456
Elapsed: 00:00:00.01
SQL> /
CURRENT_SCN
------------------
246746860031
Elapsed: 00:00:00.01
SQL> /
CURRENT_SCN
------------------
246746864845
Elapsed: 00:00:00.01
SQL> /
CURRENT_SCN
------------------
246746867908
Elapsed: 00:00:00.03
SQL> /
CURRENT_SCN
------------------
246746870275
Elapsed: 00:00:00.01
SQL> /
CURRENT_SCN
------------------
246746873429
Elapsed: 00:00:00.01
-- Subtracting the first two SCNs just to see the difference
SQL>
SQL> select 246746860031 - 246746857456 from dual;
246746860031-246746857456
-------------------------
2575
Elapsed: 00:00:00.01