Re: Lock on Compiling Package

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 30 Dec 1999 08:04:37 -0000
Message-ID: <946541223.4366.0.nnrp-10.9e984b29@news.demon.co.uk>

You could look at catblock.sql and see if the various items in there help. Alternatively you could dive in with:

select sid, username from v$session where saddr in (

     select kglpnuse
     from x$kglpn
     where kglpnhdl in (
          select p1raw
          from v$session_wait
          where event = 'library cache pin'
         )

    )
;

I don't think you can do anything other than terminate the other session.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Martin Haltmayer wrote in message <386A39D1.228E16FB_at_0800-einwahl.de>...
>Whenever I try to compile a package that another session right now uses
>I get a timeout in the compiling session because of a library lock.
>(Oracle 8.1.5 on Sun Solaris 2.6)
>
>This happens whenever some other session uses the package.
>
>How do I find out which session this is?
>
>Is there a way to enforce the compilation and therefore invalidating the
>other session's objects without killing or terminating the other
>session?
>
>Martin
Received on Thu Dec 30 1999 - 02:04:37 CST