Re: enq: tx - contention on selects

From: Jonathan Lewis <>
Date: Sat, 20 Sep 2008 15:12:48 +0100
Message-ID: <>

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.


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ
Received on Sat Sep 20 2008 - 09:12:48 CDT

Original text of this message