SELECT
  TYPE,                                    -- TYPE VARCHAR2(4)
  ADDR,                                    -- ADDR RAW(8)
  HOLDING_USER_SESSION,                    -- HOLDING_USER_SESSION RAW(8)
  HOLDING_SESSION,                         -- HOLDING_SESSION RAW(8)
  OBJECT_HANDLE,                           -- OBJECT_HANDLE RAW(8)
  LOCK_HELD,                               -- LOCK_HELD RAW(8)
  REFCOUNT,                                -- REFCOUNT NUMBER
  MODE_HELD,                               -- MODE_HELD NUMBER
  MODE_REQUESTED,                          -- MODE_REQUESTED NUMBER
  SAVEPOINT_NUMBER                         -- SAVEPOINT_NUMBER NUMBER
FROM
  GV$LIBCACHE_LOCKS
WHERE
  INST_ID = USERENV('INSTANCE')