Re: selects on the data dictionary hang

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.  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@xxxxxxxxx
------------------------------------------------------------------------
"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

Other related posts: