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

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

querying x$ tables can cause DB to hang?

From: <ryan_gaffuri_at_comcast.net>
Date: Fri, 07 Jul 2006 15:15:42 +0000
Message-Id: <070720061515.2668.44AE7A9E000AE63600000A6C2200762302079D9A00000E09A1020E979D@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?

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 07 2006 - 10:15:42 CDT

Original text of this message

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