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