Re: Do selects block truncates?

The blocking session may be running a select now, but possibly it did some updates to the same table without committing before running the select.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

> Subject: Do selects block truncates?
> From: genegurevich_at_discover.com
> Date: Thu, 20 Dec 2007 11:43:30 -0600
>
> 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?
>
>

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