ctcgag_at_hotmail.com wrote:
>>How do you determine ORACLE is doing a dirty read?
>
>
> If T1 deletes a value, and then T2 tries to insert that value, T2 will
> block until T1 commits or rolls back. (T2 errors if T1 rollsback,
> completes if T1 commits). If T2 never did a dirty read, it would not know
> to block.
>
>>John
You may well be correct about the Oracle internals. But a dirty read is
not necessary: All Oracle should need is the block header and/or SCN.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Jan 05 2004 - 13:13:25 CST
