Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 21157 invoked from network); 18 Dec 2007 16:29:30 -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; 18 Dec 2007 16:29:30 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B8F9C7DBA3C; Tue, 18 Dec 2007 17:29:30 -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 10040-03; Tue, 18 Dec 2007 17:29:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 340877DBA10; Tue, 18 Dec 2007 17:29:30 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 18 Dec 2007 16:42:04 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6F74A7DBE6F for ; Tue, 18 Dec 2007 16:42:04 -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 03243-07 for ; Tue, 18 Dec 2007 16:42:04 -0500 (EST) Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.158]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DE9747DBE97 for ; Tue, 18 Dec 2007 16:42:03 -0500 (EST) Received: by fg-out-1718.google.com with SMTP id d23so423118fga.32 for ; Tue, 18 Dec 2007 13:42:03 -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=Zid8ud1/bKfo8EqOrs+Mkoby5FWhbBnyC2gf0PYMYq4=; b=UJndBnLfwbuXkRW4txATCLOHv6MGoezZ4Bhvh84QC//PCmnC5Vh1qSf+Se1qI2vVjlY6ucnMGu+oso2jYVVWP3Fd1FUheEuekI6TV8RXqN3BicGJXfvgFyOaolSGsh3uq1XYVHKyYtJM748zbAwLaMJ5CWzOas6YUTpwczdA/50= 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=SJITSNhbTHI9SY5Ig/bBJdjtQ5+hSOh+Vfn1+J5MQZCJ6oVHq+RaLo5X4gvR1SiUn773RQ1TcISRshYAHPQcc80Zv0GAMt5Eo7frVtY08oHW3jtFXLc+nNBEHUm8xlueKdMsh0mzdG6pZAjTv9eiIHfc+fTMiqe51Ftp7WEsY88= Received: by 10.86.99.9 with SMTP id w9mr8138659fgb.44.1198014123007; Tue, 18 Dec 2007 13:42:03 -0800 (PST) Received: by 10.86.27.8 with HTTP; Tue, 18 Dec 2007 13:42:02 -0800 (PST) Message-ID: <666b99c70712181342j7d23557aja8204b6e3512d0fe@mail.gmail.com> Date: Tue, 18 Dec 2007 13:42:02 -0800 From: Prasad To: shrekdba@gmail.com Subject: Re: selects on the data dictionary hang Cc: andrew.kerber@gmail.com, oracle-l In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_12160_1648489.1198014123007" References: X-archive-position: 4001 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: p4cldba@gmail.com Precedence: normal Reply-to: p4cldba@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_12160_1648489.1198014123007 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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. We are > in > > Oracle 10gR2 on AIX. It appears that Patrol is doing something that > manages > > to hang itself and any other query or update on the data dictionary, > such as > > statspack snapshots and statistics jobs. We end up having to kill > patrol > > and the other jobs to get things working again. Has anyone else seen > this > > or have an idea what is going on? > > > > -- > > Andrew W. Kerber > > > > 'If at first you dont succeed, dont take up skydiving.' > > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > shrekdba@gmail.com > ------------------------------------------------------------------------ > "He's one who knows that life is just a leap of faith, > so spread your arms and hold your breath and always trust your cape." > -- "The Cape" > -- > http://www.freelists.org/webpage/oracle-l > > > ------=_Part_12160_1648489.1198014123007 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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.  We are in
> Oracle 10gR2 on AIX.  It appears that Patrol is doing something that manages
> to hang itself and any other query or update on the data dictionary, such as
> statspack snapshots and statistics jobs.  We end up having to kill patrol
> and the other jobs to get things working again.  Has anyone else seen this
> or have an idea what is going on?
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'



--
--
Bill "Shrek" Thater     ORACLE DBA
      shrekdba@gmail.com
------------------------------------------------------------------------
"He's one who knows that life is just a leap of faith,
so spread your arms and hold your breath and always trust your cape."
-- "The Cape"
--
http://www.freelists.org/webpage/oracle-l



------=_Part_12160_1648489.1198014123007-- -- http://www.freelists.org/webpage/oracle-l