Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> alter tablespace read only hangs

alter tablespace read only hangs

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Wed, 14 Mar 2007 19:21:04 GMT
Message-ID: <AWXJh.7649$rp4.2516@trnddc02> 





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?
Received on Wed Mar 14 2007 - 14:21:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US