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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: querying x$ tables can cause DB to hang?

Re: querying x$ tables can cause DB to hang?

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Sat, 8 Jul 2006 09:11:27 +0200
Message-ID: <c2213f680607080011y712bca8dhaf93d8e2a806658b@mail.gmail.com>


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-l
Received on Sat Jul 08 2006 - 02:11:27 CDT

Original text of this message

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