select
  TYPE,                                    -- TYPE VARCHAR2(64)
  NAME,                                    -- NAME VARCHAR2(64)
  ID1_TAG,                                 -- ID1_TAG VARCHAR2(64)
  ID2_TAG,                                 -- ID2_TAG VARCHAR2(64)
  IS_USER,                                 -- IS_USER VARCHAR2(3)
  DESCRIPTION                              -- DESCRIPTION VARCHAR2(4000)
from
  GV$LOCK_TYPE
where
  INST_ID = USERENV('Instance')