Either of the solutions suggested by Prasad and Bill may work, but they just as easily may not, since we don't really know anything about the problem besides that the queries do not seem to be returning in a timely fashion.
In order for anyone to provide a suggestion to you based on something other than personal experience, we would need for you to post the event for which the queries are waiting when the problem occurs.
That's the easiest and most dependable way to diagnose a problem of slowness or hanging.
Thanks, Jeremiah Wilton ORA-600 Consulting http://www.ora-600.net Prasad wrote:
This might help
exec dbms_stats.gather_schema_stats('SYS',gather_fixed =>TRUE);
On Dec 18, 2007 9:54 AM, bill thater <shrekdba@xxxxxxxxx> wrote:
was this database an upgrade? and if so, was it upgraded "in place"?
i've seen this happen on that before.
On Dec 18, 2007 10:46 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote:
> We are running into something strange. We have queries on the data
> dictionary hanging, while other queries appear to run correctly.
> ... have an idea what is going on?
-- //www.freelists.org/webpage/oracle-l
