Re: What else will cause the SCN to increment?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Thu, 26 Jun 2003 20:22:51 +1000
Message-ID: <20030626102251.GA16841@deuteronomy.ixora.com.au>

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:
> Beside the "commit" statement, what else will cause the SCN to
> increment?
Received on Thu Jun 26 2003 - 05:22:51 CDT