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