Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

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

Powell, Mark D

2006-07-07

Replies:

Do you believe everything that Oracle support says?
 
The x$ tables are protected by latches.  If you were to set up a process that constantly queried some of the more latch intensive views you could create a performance problem.  A query here and there should not be an issue.  Constant querying is however a slightly different issue.  The total load on your database is obviously a factor.  If your database already has a latching problem then adding a task that itself is latch intensive is probably not a wise idea.  But I have yet to see where an occasional query on x$ information does much harm.
 
HTH -- Mark D Powell --
 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of ryan_gaffuri@comcast.net
Sent: Friday, July 07, 2006 11:16 AM
To: oracle-l@freelists.org
Subject: querying x$ tables can cause DB to hang?

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?
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.