Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Thu Dec 20 2007 - 11:43:30 CST
![]() |
![]() |