select
  ADDR,                                    -- ADDR RAW(8)
  TYPE,                                    -- TYPE VARCHAR2(2)
  ID1,                                     -- ID1 NUMBER
  ID2                                      -- ID2 NUMBER
from
  GV$RESOURCE
where
  inst_id = USERENV('Instance')