Re: enq: tx - contention on selects

From: The Boss <usenet_at_No.Spam.Please.invalid>
Date: Sat, 20 Sep 2008 17:39:21 +0200
Message-ID: <48d51929$0$3130$>

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 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":


Received on Sat Sep 20 2008 - 10:39:21 CDT

Original text of this message