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

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

Do selects block truncates?

From: <genegurevich_at_discover.com>
Date: Thu, 20 Dec 2007 11:43:30 -0600
Message-ID: <OF51C7C2C5.357B046A-ON862573B7.00611597-862573B7.00615E1B@discover.com>


Hi all:

I am running oracle 10.2.0.2 and I see two sessions running truncate commands being stuck. It looks like they are waiting on another session which is currently running a long select. That select accesses both of the tables that
the other two sessions are trying to truncate. I was not aware that a select can block a truncate. Is that the case or is there something else here which I am missing?

thank you

Gene Gurevich

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 20 2007 - 11:43:30 CST

Original text of this message

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