The out put of

SELECT * FROM v$fixed_view_definition
WHERE UPPER(view_name) IN ('V$SYSSTAT', 'V$BUFFER_POOL_STATISTICS');


V$SYSSTAT
select STATISTIC# , NAME , CLASS , VALUE from GV$SYSSTAT where inst_id = USEREN
V('Instance')

V$BUFFER_POOL_STATISTICS
select id, name, set_msize, cnum_repl, cnum_write, cnum_set, buf_got, sum_write,
sum_scan, free_buffer_wait, write_complete_wait, buffer_busy_wait, free_buffer_
inspected, dirty_buffers_inspected, db_block_change, db_block_gets, consistent_g
ets, physical_reads, physical_writes from gv$buffer_pool_statistics where inst_i
d = USERENV('Instance')


The output of :
SELECT * FROM v$fixed_view_definition
2 WHERE UPPER(view_name) IN ('GV$BUFFER_POOL_STATISTICS', 'GV$SYSSTAT');

GV$SYSSTAT
select inst_id,indx,ksusdnam,ksusdcls,ksusgstv from x$ksusgsta

GV$BUFFER_POOL_STATISTICS
select kcbwbpd.inst_id, kcbwbpd.bp_id, kcbwbpd.bp_name, sum(kcbwds.cnum_set),sum
(kcbwds.cnum_repl), sum(kcbwds.cnum_write), sum(kcbwds.cnum_set), sum(kcbwds.buf
_got), sum(kcbwds.sum_wrt), sum(kcbwds.sum_scn), sum(kcbwds.fbwait), sum(kcbwds.
wcwait), sum(kcbwds.bbwait), sum(kcbwds.fbinsp), sum(kcbwds.dbinsp), sum(kcbwds.
dbbchg), sum(kcbwds.dbbget), sum(kcbwds.conget), sum(kcbwds.pread), sum(kcbwds.p
write) from x$kcbwds kcbwds, x$kcbwbpd kcbwbpd where kcbwds.set_id >= kcbwbpd.bp
_lo_sid and kcbwds.set_id <= kcbwbpd.bp_hi_sid and kcbwbpd.bp_size != 0 group by
kcbwbpd.inst_id, kcbwbpd.bp_id, kcbwbpd.bp_name


Which to trust the most?

Sam