Been there. Done that. Bounced the instance.
This is the rare case they are right. ;-)

2006/7/7, ryan_gaffuri@(protected)>:
> I just talked to Oracle Support and they state that if you are not careful
> you can cause your db to 'hang' and people cannot log in if you query the x$
> tables. This forces you to shutdown the database if you have a connection
> open or hard kill it from the OS.
>
> Has anyone ever seen this?


--
Best regards,
Alex Gorbachev

http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l