RE: Do selects block truncates?
- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
- To: <genegurevich@xxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Dec 2007 12:07:30 -0600
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@xxxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
genegurevich@xxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
