VIEW: SYS.GV_$SUBCACHE

Source

View Text - Preformatted

select "INST_ID","OWNER_NAME","NAME","TYPE","HEAP_NUM","CACHE_ID","CACHE_CNT","HEAP_SZ","HEAP_ALOC","HEAP_USED","CON_ID" from gv$subcache

View Text - HTML Formatted

SELECT "INST_ID"
, "OWNER_NAME"
, "NAME"
, "TYPE"
, "HEAP_NUM"
, "CACHE_ID"
, "CACHE_CNT"
, "HEAP_SZ"
, "HEAP_ALOC"
, "HEAP_USED"
, "CON_ID"
FROM GV$SUBCACHE