RE: Truncate table - interaction with a long running query

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Wed, 15 Aug 2007 19:01:52 +0100
Message-ID: <9C4B34D12BA5FC42AEF7E3A6AC8A263B41FC810E@enyc11p32002.corpny.csfb.com>

Truncate should require an exclusive lock, which would be incompatible with the row share lock held by the query; therefore the truncate should block (or automatically time out after 5 minutes, depending on version I think) until the query is complete.

Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: Wednesday, August 15, 2007 1:15 PM To: oracle-l_at_freelists.org
Subject: Truncate table - interaction with a long running query

If one process attempts to truncate a table while another process is accessing it in a long running query, what happens? (Oracle 8.1.7.4)

Thanks,
Peter Schauss

--

http://www.freelists.org/webpage/oracle-l

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 15 2007 - 13:01:52 CDT