Re: enq: tx - contention on selects

Jonathan Lewis wrote:
> For more notes on Srivenu's comment, here's a note I wrote
> a few years back. Oracle changed the handling of distibributed
> transactions around 9.2.0.5 to deal with this issue in the case
> of XA processing, but the issue still exists for pure Oracle activity
> across database links.
>
> Your select can wait for another transaction if that transaction
> is between the "prepare" and "commit" of a two-phase commit.

You forgot to include the note, here's the "missing link":

http://www.jlcomp.demon.co.uk/02_tpm.rtf

Cheers!

-- 
Jeroen