RE: Do selects block truncates?

Is he doing a 'FOR UPDATE' at the end of the SELECT?

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
Sent: Thursday, December 20, 2007 11:44 AM To: oracle-l
Subject: Do selects block truncates?

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

--

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