Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 10143 invoked from network); 19 Dec 2007 08:35:29 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 19 Dec 2007 08:35:29 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 065067DC7B2; Wed, 19 Dec 2007 09:35:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21058-09; Wed, 19 Dec 2007 09:35:28 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 535957DC7CF; Wed, 19 Dec 2007 09:35:28 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 19 Dec 2007 08:48:02 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1231B7DB9CF for ; Wed, 19 Dec 2007 08:48:02 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09960-07-2 for ; Wed, 19 Dec 2007 08:48:01 -0500 (EST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.228]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C4BF87DB7C4 for ; Wed, 19 Dec 2007 08:48:01 -0500 (EST) Received: by nz-out-0506.google.com with SMTP id s18so1529561nze.1 for ; Wed, 19 Dec 2007 05:48:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=CsarOhwdwlONe8U9mAGyVZ3/qDPdVuWWAvXyfNTsJJo=; b=lZnSTvodoUTs2aAivPXO/Rk7hrkJCubOi3P2gpcsONsIgkeAREWrJEi+GAEa6bqKXlTFX1pW8rsQQuSglCgW3AS6rVo7RRXSSKicI3IIw1bI6IIT5eS5BfnmgRmlxJs43Udlz7oIinfoFyBtTJDWyAUhli0ve3znYQ+gF7eMNWs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=EVYdowLzM1X+rkNLSZfSfZIJX5tPMO3zoSNQsdKoX09zPXkvDcmgAiG60LzD3KC4kUyrMtQBCbl/xHCbHDAwo1kfw1Qs2Wipd7YgKjknBBkI8OmMo3qYJYZmkyJ5aHm9IOlgjsIiv8Ut3JDNvuvBA9BBSF/KpGRV24v16Lb91xg= Received: by 10.142.203.13 with SMTP id a13mr2392122wfg.148.1198072080770; Wed, 19 Dec 2007 05:48:00 -0800 (PST) Received: by 10.70.51.18 with HTTP; Wed, 19 Dec 2007 05:48:00 -0800 (PST) Message-ID: Date: Wed, 19 Dec 2007 07:48:00 -0600 From: "Andrew Kerber" To: "Jeremiah Wilton" Subject: Re: selects on the data dictionary hang Cc: oracle-l In-Reply-To: <47685B09.9090605@ora-600.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_795_2205935.1198072080715" References: <666b99c70712181342j7d23557aja8204b6e3512d0fe@mail.gmail.com> <47685B09.9090605@ora-600.net> X-archive-position: 4014 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: andrew.kerber@gmail.com Precedence: normal Reply-to: andrew.kerber@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_795_2205935.1198072080715 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 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 > 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.' ------=_Part_795_2205935.1198072080715 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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@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@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@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.' ------=_Part_795_2205935.1198072080715-- -- http://www.freelists.org/webpage/oracle-l