select
  inst_id,                                 -- INST_ID NUMBER
  bp_id,                                   -- ID NUMBER
  bp_name,                                 -- NAME VARCHAR2(20)
  bp_blksz,                                -- BLOCK_SIZE NUMBER
  decode(                                  -- RESIZE_STATE VARCHAR2(10)
    bp_state, 0, 'STATIC', 1, 'ALLOCATING', 2, 'ACTIVATING', 3, 'SHRINKING'),
  bp_currgrans * bp_gransz,                -- CURRENT_SIZE NUMBER
  bp_size,                                 -- BUFFERS NUMBER
  bp_tgtgrans * bp_gransz,                 -- TARGET_SIZE NUMBER
  bp_tgtgrans * bp_bufpergran,             -- TARGET_BUFFERS NUMBER
  bp_prevgrans * bp_gransz,                -- PREV_SIZE NUMBER
  bp_prevgrans * bp_bufpergran,            -- PREV_BUFFERS NUMBER
  0,                                       -- LO_BNUM NUMBER
  0,                                       -- HI_BNUM NUMBER
  bp_lo_sid,                               -- LO_SETID NUMBER
  bp_hi_sid,                               -- HI_SETID NUMBER
  bp_set_ct                                -- SET_COUNT NUMBER
from
  x$kcbwbpd
where
  bp_id > 0 and bp_currgrans > 0 and bp_tgtgrans > 0