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: