select
ID, -- ID NUMBER
NAME, -- NAME VARCHAR2(128)
VALUE -- VALUE VARCHAR2(81)
from
GV$RESULT_CACHE_STATISTICS
where
inst_id=USERENV('Instance')