Search notes:
Oracle: X$KCBWBPD
This table shows how the
buffer cache is split between the default, the recycle and the keep buffer pool.
select
inst_id,
bp_id id,
bp_name name,
bp_blksz /1024 block_size_kb ,
bp_gransz,
bp_size buffers,
decode(bp_state,
0, 'STATIC',
1, 'ALLOCATING',
2, 'ACTIVATING',
3, 'SHRINKING'
) ressize_state,
bp_currgrans * bp_gransz current_size,
bp_tgtgrans * bp_gransz target_size,
bp_tgtgrans * bp_bufpergran target_buffers,
bp_prevgrans * bp_gransz prev_size,
bp_prevgrans * bp_bufpergran preb_buffers,
bp_lo_sid lo_setid,
bp_hi_sid hi_setid,
bp_set_ct set_count,
con_id
from
x$kcbwbpd
-- where
-- bp_id > 0 and
-- bp_currgrans > 0 and bp_tgtgrans > 0
;