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