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:content-transfer-encoding:content-disposition:references;
        b=OMhSbotrG3lg+Fsq2UYtcOPJ/6xA/u/3GaYNWBs7Zf8YRDv4GjSTEvs295nnz0yY8A+Oc8N6rasaXB+d6bDEAb1QyDdU781C63ZCHLHamIqfVjLKFvtyBJ8SzOKi/5oftPcxaPPsiWcKvCmSUTbBo1IZ0uz0Z2IucS12XTSpaiA=
Message-ID: <a1d204910712180954u6614033bt31bbf9187013373e@mail.gmail.com>
Date: Tue, 18 Dec 2007 11:54:32 -0600
From: "bill thater" <shrekdba@gmail.com>
To: andrew.kerber@gmail.com
Subject: Re: selects on the data dictionary hang
Cc: oracle-l <oracle-l@freelists.org>
In-Reply-To: <ad3aa4c90712180846t2c29b226h9324b3f383f812cc@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
References: <ad3aa4c90712180846t2c29b226h9324b3f383f812cc@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: shrekdba@gmail.com

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