GV$LIBRARYCACHE

select
inst_id,                 -- INST_ID NUMBER
decode                   -- NAMESPACE VARCHAR2(15)
  (indx, 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', '?'),
kglstget,                -- GETS NUMBER
kglstght,                -- GETHITS NUMBER
decode                   -- GETHITRATIO NUMBER
  (kglstget, 0, 1, kglstght/kglstget),
kglstpin,                -- PINS NUMBER
kglstpht,                -- PINHITS NUMBER
decode                   -- PINHITRATIO NUMBER
  (kglstpin, 0, 1, kglstpht/kglstpin),
kglstrld,                -- RELOADS NUMBER
kglstinv,                -- INVALIDATIONS NUMBER
kglstlrq,                -- DLM_LOCK_REQUESTS NUMBER
kglstprq,                -- DLM_PIN_REQUESTS NUMBER
kglstprl,                -- DLM_PIN_RELEASES NUMBER
kglstirq,                -- DLM_INVALIDATION_REQUESTS NUMBER
kglstmiv                 -- DLM_INVALIDATIONS NUMBER
from
x$kglst 
where
indx<8 or indx=13 or indx=14 or indx=32
home |  up  |  mailbox