RE: Do selects block truncates?

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: