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: <genegurevich_at_discover.com>
Date: Fri, 21 Dec 2007 09:43:59 -0600
Message-ID: <OF45F9DC24.E4E52ABA-ON862573B8.00565B15-862573B8.00566CD9@discover.com>


I have executed the following SQL, which indicated that two of my truncate sessions were waiting on the same session. When I looked at what was running by that session it was a select

thank you

Gene Gurevich
Oracle MySQL Operations - OMO
224-405-4079

                                                                           

<krish.hariharan@
quasardb.com> To 12/20/2007 08:07 <genegurevich_at_discover.com>, PM "'oracle-l'" <oracle-l_at_freelists.org> cc Please respond to
<krish.hariharan@ Subject
quasardb.com> RE: Do selects block truncates?

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 Fri Dec 21 2007 - 09:43:59 CST

Original text of this message

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