GV$BUFFER_POOL

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             -- CURRENT_SIZE NUMBER
  * bp_gransz,
bp_size,                 -- BUFFERS NUMBER
bp_tgtgrans * bp_gransz, -- TARGET_SIZE NUMBER
bp_tgtgrans              -- TARGET_BUFFERS NUMBER
  * bp_bufpergran,
bp_prevgrans             -- PREV_SIZE NUMBER
  * bp_gransz,
bp_prevgrans             -- PREV_BUFFERS NUMBER
  * bp_bufpergran,
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
home |  up  |  mailbox