Did you look at db_blockers? Which session was blocking it and what was
that session doing at the time?

-----Original Message-----
From: Paul Walker
[mailto:oracledba-ezmlmshield-x38985979.[Email address protected]
Sent: Friday, July 30, 2004 9:39 AM
To: LazyDBA Discussion
Subject: read only command


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/>




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


The information contained in this e-mail message is confidential, may
be legally privileged, and is intended for use only by the individual(s)
named above. If you are not the intended recipient of this message, you
must not copy, forward, disclose or otherwise use it, or any part of
it, in any way whatsoever. If you have received this message in error,
please notify the sender immediately by return e-mail and delete the
message and any attachments from your system. Thank you

Oracle LazyDBA home page