Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> System Change Number

System Change Number

From: Peter <peter_at_nomorenewspamin.ca>
Date: Mon, 29 Sep 2003 19:35:15 GMT
Message-ID: <m9ufnv8l3o8ka46g95n6ls89gpsh36kk7l@4ax.com>

When there is a commit Oracle will assign a system change number to the redo records of the committed transaction. All redo logs will be flushed out from the redo log buffer including those of transactions that are not committed. How does Oracle identify these uncommitted transactions if they do not have a SCN? Received on Mon Sep 29 2003 - 14:35:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US