Re: Why 2 rows in x$kgllk for package .

From: <Kurt-Franke_at_web.de>
Date: Fri, 17 Feb 2012 03:58:00 +0100 (CET)
Message-ID: <502067306.1061237.1329447480013.JavaMail.fmail_at_mwmweb048>


Greg,

x$kglob.kglobtyp holds the object type number . to translate it to a type name just look at the definition of dba_objects .

this will give you the desired information .

best regards

kf

-----Urspr√ľngliche Nachricht-----
...
>select t.* , (select sid from v$session where saddr = t.KGLLKUSE) sid
>from x$kgllk t
>where
> kglnahsh in (select /*+ no_unnest */ kglnahsh
> from x$kglob
> where
> upper(kglnaown) like upper('TEST')
> and upper(kglnaobj) like upper('DEMO_PKG')
> )

...
>Question is why we have 2 rows in x$kgllk for 1 session (is that because
>separate lock for package header and package body )?
...

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 16 2012 - 20:58:00 CST

Original text of this message