SELECT
  INST_ID,                                 -- INST_ID NUMBER
  'LOCK',                                  -- TYPE VARCHAR2(4)
  KGLLKADR,                                -- ADDR RAW(8)
  KGLLKUSE,                                -- HOLDING_USER_SESSION RAW(8)
  KGLLKSES,                                -- HOLDING_SESSION RAW(8)
  KGLLKHDL,                                -- OBJECT_HANDLE RAW(8)
  KGLLKPNC,                                -- LOCK_HELD RAW(8)
  KGLLKCNT,                                -- REFCOUNT NUMBER
  KGLLKMOD,                                -- MODE_HELD NUMBER
  KGLLKREQ,                                -- MODE_REQUESTED NUMBER
  KGLLKSPN                                 -- SAVEPOINT_NUMBER NUMBER
FROM
  X$KGLLK
union
SELECT
  INST_ID,                                 -- INST_ID NUMBER
  'PIN',                                   -- TYPE VARCHAR2(4)
  KGLPNADR,                                -- ADDR RAW(8)
  KGLPNUSE,                                -- HOLDING_USER_SESSION RAW(8)
  KGLPNSES,                                -- HOLDING_SESSION RAW(8)
  KGLPNHDL,                                -- OBJECT_HANDLE RAW(8)
  KGLPNLCK,                                -- LOCK_HELD RAW(8)
  KGLPNCNT,                                -- REFCOUNT NUMBER
  KGLPNMOD,                                -- MODE_HELD NUMBER
  KGLPNREQ,                                -- MODE_REQUESTED NUMBER
  KGLPNSPN                                 -- SAVEPOINT_NUMBER NUMBER
FROM
  X$KGLPN