Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Do selects block truncates?

RE: Do selects block truncates?

From: <krish.hariharan_at_quasardb.com>
Date: Thu, 20 Dec 2007 19:07:26 -0700
Message-ID: <007501c84376$3d4fc8e0$6401a8c0@BHAIRAVIPC01> 





Perhaps, what I am about to say has already been considered and ruled out. 



That said, how was the conclusion drawn that the statement that is in
execution is the statement that is blocking the other two. If this has not
been ruled out then I would try to ensure that no other DML is pending form
the "other" session (ASH, v$transaction, etc).



I tend to look for the simpler explanation first before I take the red pill
to find out how deep the rabbit hole is.



-Krish




--



http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 20 2007 - 20:07:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US