Hi,

I've created a tablespace and was trying to to issue the following command:

alter tablespace ts_name read only

this command hung over the weekend even though all other processing on the
database was in different tablespaces

looking in dba_waiters showed that my command was waiting on another
session. Can anyone explain why?

I have tried the command as a normal user as well as sysdba, some effect.

I'm running 9.2.0.5 on Windows 2003



regards

Paul Walker
Database Administrator
Tel: 020 7871 9029
Fax: 020 7871 9009

Email: [Email address protected] <mailto:[Email address protected]

Web: www.wegenerdm.co.uk <http://www.wegenerdm.co.uk/>

<http://www.wegenerdm.co.uk/>



Oracle LazyDBA home page