select
  inst_id,                                 -- INST_ID NUMBER
  kgllkuse,                                -- SADDR RAW(8)
  kgllksnm,                                -- SID NUMBER
  user_name,                               -- USER_NAME VARCHAR2(30)
  kglhdpar,                                -- ADDRESS RAW(8)
  kglnahsh,                                -- HASH_VALUE NUMBER
  kgllksqlid,                              -- SQL_ID VARCHAR2(13)
  kglnaobj,                                -- SQL_TEXT VARCHAR2(60)
  kgllkest,                                -- LAST_SQL_ACTIVE_TIME DATE
  decode(                                  -- SQL_EXEC_ID NUMBER
    kgllkexc, 0, to_number(NULL), kgllkexc),
  kgllkctp                                 -- CURSOR_TYPE VARCHAR2(64)
from
  x$kgllk
where
  kglhdnsp = 0 and kglhdpar != kgllkhdl