Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: What is an RO enqueue?

Re: What is an RO enqueue?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 23 May 2006 19:07:37 -0400
Message-Id: <1148425657l.2840l.2l@medo.noip.com>

On 05/23/2006 03:37:53 PM, Bobak, Mark wrote:
> I'm seeing lots of waits for it in a 9.2.0.6 instance on Solaris....
>
> It does not appear to be in the 9iR2 Reference manual...?
>
> Now, I can't even log in....not even as "/ as sysdba".....sigh.....
>

It's library cache instance lock. "O" is the namespace. Try killing processes manually, using something like

ps -ef|grep "ora_"|awk '{ print $2; }'|xargs kill -9

On a Solaris system you can do something like "pkill -9 ora_"

and then removing SGA by iprm.

That would be the equivalent of "shutdown abort".

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 23 2006 - 18:07:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US