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

Home -> Community -> Usenet -> c.d.o.server -> Persistent library cache pin

Persistent library cache pin

From: Julio German Rojas Pelaez <jgrp_at_tid.es>
Date: Mon, 21 Jan 2002 17:27:23 +0100
Message-ID: <a2hfe9$8a72@tid.tid.es>


Often connections get blocked due to a library cache pin exclusive. The lock seems to be on the sentence -> different spelling no block, and it seems to
lay on the database. Shooting down the database has no effect on the lock, next
time sentence is runned, lock is there again even if executed just on depart.
The query I use to find the locking is included at the end. It returns to lock with
exclusive mode belonging to the same session and processing same statement.

Anybody has idea what is going on?

The query to find the lock I'm using is:  select s.sid,

    decode(ob.kglhdnsp, 0, 'Cursor', 1, 'Table/Procedure/Type', 2, 'Body',       3, 'trigger', 4, 'Index', 5, 'Cluster', to_char(ob.kglhdnsp))    || ' Definition ' || lk.kgllktype,
    decode(lk.kgllkmod, 0, 'None', 1, 'Null', 2, 'Share', 3, 'Exclusive',     to_char(lk.kgllkmod)),
    decode(lk.kgllkreq, 0, 'None', 1, 'Null', 2, 'Share', 3, 'Exclusive',     to_char(lk.kgllkreq)),
    decode(ob.kglnaown, null, '', ob.kglnaown || '.') || ob.kglnaobj ||     decode(ob.kglnadlk, null, '', '@' || ob.kglnadlk),     rawtohex(lk.kgllkhdl)
   from v$session s, x$kglob ob, dba_kgllock lk

     where lk.kgllkhdl = ob.kglhdadr
      and  lk.kgllkuse = s.saddr
Received on Mon Jan 21 2002 - 10:27:23 CST

Original text of this message

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