Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: querying x$ tables can cause DB to hang?
Been there. Done that. Bounced the instance.
This is the rare case they are right. ;-)
2006/7/7, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net>:
> 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-lReceived on Sat Jul 08 2006 - 02:11:27 CDT
![]() |
![]() |