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

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 7 Jul 2006 11:33:52 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410507D30DA9@usahm236.amer.corp.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan_gaffuri_at_comcast.net

	Sent: Friday, July 07, 2006 11:16 AM
	To: oracle-l_at_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?

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 07 2006 - 10:33:52 CDT