Re: alter tablespace read only hangs

From: Anurag Varma <avoracle_at_gmail.com>
Date: 14 Mar 2007 12:45:26 -0700
Message-ID: <1173901526.605334.118800@p15g2000hsd.googlegroups.com>

On Mar 14, 3:21 pm, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> Oracle 9.2.0.5.
>
> Session 1 is running "alter tablespace A read only;" and is hung. The
> wait event is enqueue. The lock tree shows that session 2 is blocking it
> and that the lock is on a table *not* in tablespace A. How can this be?

Because IIRC alter tablespace read only waits for ALL transactions to finish
... yes it will wait for a transaction to finish even if its happening on another
tablespace.

Anurag Received on Wed Mar 14 2007 - 14:45:26 CDT