querying x$ tables can cause DB to hang?
- From: ryan_gaffuri@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 07 Jul 2006 15:15:42 +0000
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?