Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Tuesday, March 15, 2011

Library Cache Locks

Create Or Replace Force View Sys.Av_lock_lib_cache (Sid,

   Select S.Sid, P.Kglpnmod Lockmode, P.Kglpnreq Lockrequest,
          B.Kglnaown Objectowner, B.Kglnaobj Objectname
     From X$kglpn P, X$kglob B, V$session S
    Where S.Saddr = P.Kglpnuse
      And P.Kglpnhdl = B.Kglhdadr
      And P.Kglpnhdl In (Select P1raw
                           From V$session_wait
                          Where Event Like '%library cache lock%');

No comments: