Re: What else will cause the SCN to increment?

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Thu, 26 Jun 2003 23:23:31 +0800
Message-ID: <3EFB0FF3.3D4ABB50@singnet_nospam.com.sg>

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

Steve Adams wrote:
>
> 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 - 10:23:31 CDT