Re: What is an RO enqueue?

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: Mark.Bobak@xxxxxxxxxxxxxxx
  • Date: Tue, 23 May 2006 19:07:37 -0400

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: