GV$LIBRARY_CACHE_MEMORY
select inst_id, -- INST_ID NUMBER decode -- LC_NAMESPACE VARCHAR2(15) (kglsim_namespace, 0, 'SQL AREA', 1, 'TABLE/PROCEDURE', 2, 'BODY', 3, 'TRIGGER', 4, 'INDEX', 5, 'CLUSTER', 6, 'OBJECT', 7, 'PIPE', 13, 'JAVA SOURCE', 14, 'JAVA RESOURCE', 32, 'JAVA DATA', '?'), kglsim_pincnt, -- LC_INUSE_MEMORY_OBJECTS NUMBER kglsim_pinmem, -- LC_INUSE_MEMORY_SIZE NUMBER kglsim_unpincnt, -- LC_FREEABLE_MEMORY_OBJECTS NUMBER kglsim_unpinmem -- LC_FREEABLE_MEMORY_SIZE NUMBER from x$kglmem where kglsim_namespace<8 or kglsim_namespace=13 or kglsim_namespace=14 or kglsim_namespace=32 union select inst_id, -- INST_ID NUMBER 'OTHER/SYSTEM', -- LC_NAMESPACE VARCHAR2(15) sum -- LC_INUSE_MEMORY_OBJECTS NUMBER (kglsim_pincnt) sum_pincnt, sum -- LC_INUSE_MEMORY_SIZE NUMBER (kglsim_pinmem) sum_pinmem, sum -- LC_FREEABLE_MEMORY_OBJECTS NUMBER (kglsim_unpincnt) sum_unpincnt, sum -- LC_FREEABLE_MEMORY_SIZE NUMBER (kglsim_unpinmem) sum_unpinmem from x$kglmem where not (kglsim_namespace<8 or kglsim_namespace=13 or kglsim_namespace=14 or kglsim_namespace=32) group by inst_id

home |  up  |  mailbox