GV$OBJECT_DEPENDENCY

select
d.inst_id,               -- INST_ID NUMBER
d.kglhdpar,              -- FROM_ADDRESS RAW(4)
d.kglnahsh,              -- FROM_HASH NUMBER
o.kglnaown,              -- TO_OWNER VARCHAR2(64)
o.kglnaobj,              -- TO_NAME VARCHAR2(1000)
o.kglhdadr,              -- TO_ADDRESS RAW(4)
o.kglnahsh,              -- TO_HASH NUMBER
o.kglobtyp               -- TO_TYPE NUMBER
from
x$kglob o,
x$kgldp d 
where
o.kglnahsh = d.kglrfhsh and o.kglhdadr = d.kglrfhdl
home |  up  |  mailbox