RE: Do selects block truncates?

From: Enkhbold Dashdondog <enkhbold_at_khanbank.com>
Date: Mon, 24 Dec 2007 10:36:31 +0800
Message-ID: <000001c845d5$d011fed0$7035fc70$@com>

Do you update Oracle version to 10.2.0.3?

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
Sent: Friday, December 21, 2007 1: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 Sun Dec 23 2007 - 20:36:31 CST