select
  ID,                                      -- ID NUMBER
  CHUNK,                                   -- CHUNK NUMBER
  OFFSET,                                  -- OFFSET NUMBER
  FREE,                                    -- FREE VARCHAR2(3)
  OBJECT_ID,                               -- OBJECT_ID NUMBER
  POSITION                                 -- POSITION NUMBER
from
  GV$RESULT_CACHE_MEMORY
where
  inst_id=USERENV('Instance')