FAQ
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

Search Discussions

  • Tim Gorman at Apr 27, 2007 at 12:36 pm
    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 27, '07 at 5:50a
activeApr 27, '07 at 12:36p
posts2
users2
websiteoracle.com

2 users in discussion

Tim Gorman: 1 post Sai Selvaganesan: 1 post

People

Translate

site design / logo © 2022 Grokbase