select
  OWNER_NAME,                              -- OWNER_NAME VARCHAR2(64)
  NAME,                                    -- NAME VARCHAR2(1000)
  TYPE,                                    -- TYPE NUMBER
  HEAP_NUM,                                -- HEAP_NUM NUMBER
  CACHE_ID,                                -- CACHE_ID NUMBER
  CACHE_CNT,                               -- CACHE_CNT NUMBER
  HEAP_SZ,                                 -- HEAP_SZ NUMBER
  HEAP_ALOC,                               -- HEAP_ALOC NUMBER
  HEAP_USED                                -- HEAP_USED NUMBER
from
  GV$SUBCACHE
where
  inst_id = USERENV('Instance')