GV$SHARED_POOL_RESERVED definition in Oracle Database 11.2
GV$SHARED_POOL_RESERVED

select
  p.inst_id,                               -- INST_ID NUMBER
  p.free_space,                            -- FREE_SPACE NUMBER
  p.avg_free_size,                         -- AVG_FREE_SIZE NUMBER
  p.free_count,                            -- FREE_COUNT NUMBER
  p.max_free_size,                         -- MAX_FREE_SIZE NUMBER
  p.used_size,                             -- USED_SPACE NUMBER
  p.avg_used_size,                         -- AVG_USED_SIZE NUMBER
  p.used_count,                            -- USED_COUNT NUMBER
  p.max_used_size,                         -- MAX_USED_SIZE NUMBER
  s.requests,                              -- REQUESTS NUMBER
  s.request_misses,                        -- REQUEST_MISSES NUMBER
  s.last_miss_size,                        -- LAST_MISS_SIZE NUMBER
  s.max_miss_size,                         -- MAX_MISS_SIZE NUMBER
  s.request_failures,                      -- REQUEST_FAILURES NUMBER
  s.last_failure_size,                     -- LAST_FAILURE_SIZE NUMBER
  s.aborted_request_threshold,             -- ABORTED_REQUEST_THRESHOLD NUMBER
  s.aborted_requests,                      -- ABORTED_REQUESTS NUMBER
  s.last_aborted_size                      -- LAST_ABORTED_SIZE NUMBER
from
  (
  select
    avg(x$ksmspr.inst_id) inst_id,
    sum(decode(ksmchcls,'R-free',ksmchsiz,0)) free_space,
    avg(decode(ksmchcls,'R-free',ksmchsiz,0)) avg_free_size,
    sum(decode(ksmchcls,'R-free',1,0)) free_count,
    max(decode(ksmchcls,'R-free',ksmchsiz,0)) max_free_size,
    sum(decode(ksmchcls,'R-free',0,ksmchsiz)) used_size,
    avg(decode(ksmchcls,'R-free',0,ksmchsiz)) avg_used_size,
    sum(decode(ksmchcls,'R-free',0,1)) used_count,
    max(decode(ksmchcls,'R-free',0,ksmchsiz)) max_used_size
  from
    x$ksmspr
  where
    ksmchcom not like '%reserved sto%') p, (
  select
    sum(kghlurcn) requests,
    sum(kghlurmi) request_misses,
    max(kghlurmz) last_miss_size,
    max(kghlurmx) max_miss_size,
    sum(kghlunfu) request_failures,
    max(kghlunfs) last_failure_size,
    max(kghlumxa) aborted_request_threshold,
    sum(kghlumer) aborted_requests,
    max(kghlumes) last_aborted_size
  from
    x$kghlu) s

home |  up