Beside the "commit" statement, what else will cause the SCN to
increment?


Thanks

Hi Peter,

Other than explicit COMMIT statements, there are also implicit commits
associated with service transactions, recursive transactions and the
timeout actions of some of the background processes.

Beyond that, if more than 253 changes are applied to a block at the
same SCN then the SCN must be incremented to allow the sequence number
in the cache layer header of the block to wrap.

If 'log_parallelism' is set to something greater than 1, then the SCN
is incremented by LGWR on *every* write.

In OPS/RAC the SCN may be forced higher in relatively idle instances to
protect recovery.

Opening a database also increments the SCN.

There are probably other cases that I am not aware of.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ For DBAs
@ http://www.christianity.net.au/ For all


On 2003.06.26 18:57, Peter wrote:

Distributed Database Transactions, as well -- the highest SCN
of the databases in the transaction is used.
Hemant

Steve Adams wrote: