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')