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

Home -> Community -> Mailing Lists -> Oracle-L -> analyzing library cache locks in RAC

analyzing library cache locks in RAC

From: Sai Selvaganesan <ssaisundar_at_sbcglobal.net>
Date: Thu, 26 Apr 2007 22:50:43 -0700 (PDT)
Message-ID: <83280.77410.qm@web81604.mail.mud.yahoo.com> 





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 - 00:50:43 CDT












Original text of this message













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