Re: selects on the data dictionary hang

Hi All. Thanks for the input. I forgot to mention we had already opened an sr with oracle and sent them hang traces. Here is the answer back from oracle. I will post further if this fails to resolve the issue.

Bug 5907779 - DDR info BugDesc 5907779
Abstract: Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS)
Fixed-Releases: A204
Details:
This problem is introduced in 10.2.0.3
@ by a missed line of code for the backport of bug 4702993 . A process may hang with a self deadlock typically when executing DBMS_STATS. The hung process shows itself waiting on a "cursor: pin S wait on X" waitevent waiting for an object that it has pinned itself.

On Dec 18, 2007 5:43 PM, Jeremiah Wilton <jeremiah_at_ora-600.net> wrote:

> 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_at_gmail.com> 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_at_gmail.com>
> 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?
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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