Re: What is an RO enqueue?

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