Re: analyzing library cache locks in RAC

From: Tim Gorman <tim_at_evdbt.com>
Date: Fri, 27 Apr 2007 06:36:43 -0600
Message-ID: <4631EE5B.6050500@evdbt.com>

v$session_event?

Sai Selvaganesan wrote:
> hi
>
> is there any way (other than taking a system state dump/hang analyze)
> to figure out which are the SESSIONs HOLDING A LIBRARY CACHE LOCK in
> rac. i am working on a 10.2.0.2 10 node rac system.
>
> taking a system dump and trying to figure out is just very tedious and
> time consuming. Hence this question
>
> thx for your time
> sai
>

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

Received on Fri Apr 27 2007 - 07:36:43 CDT