GV$DB_CACHE_ADVICE definition in Oracle 9i / www.oracledba.ru
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.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 order by A.inst_id,
A.bpid,
A.poolsz