RE: Do selects block truncates?

From: Tony Aponte <Tony_Aponte_at_Jabil.com>
Date: Thu, 20 Dec 2007 13:48:43 -0500
Message-ID: <C6594C4B5C99CF4E9F536C038021F82B06A3B0CD@alfarsmsg07.corp.jabil.org>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 20 2007 - 12:48:43 CST