GV$BUFFER_POOL_STATISTICS
select kcbwbpd.inst_id, -- INST_ID NUMBER kcbwbpd.bp_id, -- ID NUMBER kcbwbpd.bp_name, -- NAME VARCHAR2(20) kcbwbpd.bp_blksz, -- BLOCK_SIZE NUMBER sum (kcbwds.cnum_set), -- SET_MSIZE NUMBER sum (kcbwds.cnum_repl), -- CNUM_REPL NUMBER sum (kcbwds.cnum_write), -- CNUM_WRITE NUMBER sum (kcbwds.cnum_set), -- CNUM_SET NUMBER sum (kcbwds.buf_got), -- BUF_GOT NUMBER sum (kcbwds.sum_wrt), -- SUM_WRITE NUMBER sum (kcbwds.sum_scn), -- SUM_SCAN NUMBER sum (kcbwds.fbwait), -- FREE_BUFFER_WAIT NUMBER sum (kcbwds.wcwait), -- WRITE_COMPLETE_WAIT NUMBER sum (kcbwds.bbwait), -- BUFFER_BUSY_WAIT NUMBER sum (kcbwds.fbinsp), -- FREE_BUFFER_INSPECTED NUMBER sum (kcbwds.dbinsp), -- DIRTY_BUFFERS_INSPECTED NUMBER sum (kcbwds.dbbchg), -- DB_BLOCK_CHANGE NUMBER sum (kcbwds.dbbget), -- DB_BLOCK_GETS NUMBER sum (kcbwds.conget), -- CONSISTENT_GETS NUMBER sum (kcbwds.pread), -- PHYSICAL_READS NUMBER sum (kcbwds.pwrite) -- PHYSICAL_WRITES NUMBER 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, kcbwbpd.bp_blksz

home |  up  |  mailbox