GV$BUFFER_POOL
select inst_id, -- INST_ID NUMBER bp_id, -- ID NUMBER bp_name, -- NAME VARCHAR2(20) bp_lo_sid, -- LO_SETID NUMBER bp_hi_sid, -- HI_SETID NUMBER bp_set_ct, -- SET_COUNT NUMBER bp_size, -- BUFFERS NUMBER 0, -- LO_BNUM NUMBER 0 -- HI_BNUM NUMBER from x$kcbwbpd where bp_id > 0

home |  up  |  mailbox