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

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