Re: enq: tx - contention on selects
Date: Sat, 20 Sep 2008 17:39:21 +0200
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 18.104.22.168 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":
-- JeroenReceived on Sat Sep 20 2008 - 10:39:21 CDT