> Does anyone know why Oracle provides serializable transactions through
> the history information in the data blocks (set by the INITRANS parameter
> when creating the table) - why isn't the undo-retention used for that ?
Reading two pages further in my book got me to the idea why Oracle
doesn't use the undo-retention: Oracle would have to check every
previous version of the data-block in which the row lies up to the
SCN when the transaction started. That wouldn't be really efficient.
Received on Fri Oct 04 2002 - 16:55:49 CDT
