GV$SUBCACHE
select inst_id, -- INST_ID NUMBER kglnaown, -- OWNER_NAME VARCHAR2(64) kglnaobj, -- NAME VARCHAR2(1000) kglobtyp, -- TYPE NUMBER kqlfshpn, -- HEAP_NUM NUMBER kqlfscid, -- CACHE_ID NUMBER kqlfsscc, -- CACHE_CNT NUMBER kqlfsesp, -- HEAP_SZ NUMBER kqlfsasp, -- HEAP_ALOC NUMBER kqlfsusp -- HEAP_USED NUMBER from x$kqlset

home |  up  |  mailbox