GV$DB_CACHE_ADVICE

select
A.inst_id,               -- INST_ID NUMBER
A.bpid,                  -- ID NUMBER
B.bp_name,               -- NAME VARCHAR2(20)
A.poolsz,                -- SIZE_FOR_ESTIMATE NUMBER
A.nbufs,                 -- BUFFERS_FOR_ESTIMATE NUMBER
decode                   -- ESTD_PHYSICAL_READ_FACTOR VARCHAR2(40)
  (A.base_preads, 0, NULL, round ((A.preads / A.base_preads), 4)),
decode                   -- ESTD_PHYSICAL_READS NUMBER
  (A.base_preads, 0, A.preads, round ((A.preads * (A.actual_preads / A.base_preads)), 0)) 
from
x$kcbsc A,
x$kcbwbpd B 
where
A.bpid = B.bp_id and A.inst_id = B.inst_id
home |  up  |  mailbox