GV$SHARED_POOL_RESERVED

select
avg (x$ksmspr.inst_id),  -- INST_ID NUMBER
sum                      -- FREE_SPACE NUMBER
  (decode (ksmchcls, 'R-free', ksmchsiz, 0)),
avg                      -- AVG_FREE_SIZE NUMBER
  (decode (ksmchcls, 'R-free', ksmchsiz, 0)),
sum                      -- FREE_COUNT NUMBER
  (decode (ksmchcls, 'R-free', 1, 0)),
max                      -- MAX_FREE_SIZE NUMBER
  (decode (ksmchcls, 'R-free', ksmchsiz, 0)),
sum                      -- USED_SPACE NUMBER
  (decode (ksmchcls, 'R-free', 0, ksmchsiz)),
avg                      -- AVG_USED_SIZE NUMBER
  (decode (ksmchcls, 'R-free', 0, ksmchsiz)),
sum                      -- USED_COUNT NUMBER
  (decode (ksmchcls, 'R-free', 0, 1)),
max                      -- MAX_USED_SIZE NUMBER
  (decode (ksmchcls, 'R-free', 0, ksmchsiz)),
avg (kghlurcn),          -- REQUESTS NUMBER
avg (kghlurmi),          -- REQUEST_MISSES NUMBER
avg (kghlurmz),          -- LAST_MISS_SIZE NUMBER
avg (kghlurmx),          -- MAX_MISS_SIZE NUMBER
avg (kghlunfu),          -- REQUEST_FAILURES NUMBER
avg (kghlunfs),          -- LAST_FAILURE_SIZE NUMBER
avg (kghlumxa),          -- ABORTED_REQUEST_THRESHOLD NUMBER
avg (kghlumer),          -- ABORTED_REQUESTS NUMBER
avg (kghlumes)           -- LAST_ABORTED_SIZE NUMBER
from
x$ksmspr,
x$kghlu 
where
ksmchcom not like '%reserved sto%'
home |  up  |  mailbox