RE: Do selects block truncates?

From: "Enkhbold Dashdondog" <enkhbold@xxxxxxxxxxxx>
To: <genegurevich@xxxxxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 24 Dec 2007 10:36:31 +0800

Do you update Oracle version to 10.2.0.3?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of genegurevich@xxxxxxxxxxxx
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

References:

Do selects block truncates?
From: genegurevich

RE: Do selects block truncates?

Other related posts: