GV$DB_CACHE_ADVICE

select
A.inst_id,               -- INST_ID NUMBER
A.bpid,                  -- ID NUMBER
B.bp_name,               -- NAME VARCHAR2(20)
A.blksz,                 -- BLOCK_SIZE NUMBER
decode                   -- ADVICE_STATUS VARCHAR2(3)
  (A.status, 2, 'ON', 'OFF'),
A.poolsz,                -- SIZE_FOR_ESTIMATE NUMBER
round                    -- SIZE_FACTOR NUMBER
  ((A.poolsz / A.actual_poolsz), 4),
A.nbufs,                 -- BUFFERS_FOR_ESTIMATE NUMBER
decode                   -- ESTD_PHYSICAL_READ_FACTOR NUMBER
  (A.base_preads, 0, to_number (null), round ((A.preads / A.base_preads), 4)),
decode                   -- ESTD_PHYSICAL_READS NUMBER
  (A.base_preads, 0, A.actual_preads, round ((A.preads * (A.actual_preads / A.base_preads)), 0)),
A.estd_time_for_disk_reads, -- ESTD_PHYSICAL_READ_TIME NUMBER
decode                   -- ESTD_PCT_OF_DB_TIME_FOR_READS NUMBER
  (A.total_db_time, 0, A.estd_time_for_disk_reads, round ((100 * A.estd_time_for_disk_reads / A.total_db_time), 1)),
A.estd_rac_reads,        -- ESTD_CLUSTER_READS NUMBER
A.estd_rac_time          -- ESTD_CLUSTER_READ_TIME NUMBER
from
x$kcbsc A,
x$kcbwbpd B 
where
A.bpid = B.bp_id and A.inst_id = B.inst_id order by A.inst_id,
A.bpid,
A.poolsz
home |  up  |  mailbox