RE: Do selects block truncates?

  • From: "Tony Aponte" <Tony_Aponte@xxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Dec 2007 13:48:43 -0500

Never mind, I think I have it backwards in that the writer can block a
Select.  It makes more sense as I think about it.


Tony Aponte



From: Tony Aponte 
Sent: Thursday, December 20, 2007 1:46 PM
To: oracle-l
Subject: RE: Do selects block truncates?


Could it be that the reader is part of an XA transaction?  I think I
remember a paper or presentation by one of the Wise Men detailing how a
reader that's part of a distributed transaction can block others simply
by executing a Select.


Tony Aponte


Other related posts: