GV$OPEN_CURSOR

select
inst_id,                 -- INST_ID NUMBER
kgllkuse,                -- SADDR RAW(4)
kgllksnm,                -- SID NUMBER
user_name,               -- USER_NAME VARCHAR2(30)
kglhdpar,                -- ADDRESS RAW(4)
kglnahsh,                -- HASH_VALUE NUMBER
kglnaobj                 -- SQL_TEXT VARCHAR2(60)
from
x$kgllk 
where
kglhdnsp = 0 and kglhdpar != kgllkhdl
home |  up  |  mailbox