DBA Data[Home] [Help]

VIEW: SYS.GV_$BUFFER_POOL

Source

View Text - Preformatted

select "INST_ID","ID","NAME","BLOCK_SIZE","RESIZE_STATE","CURRENT_SIZE","BUFFERS","TARGET_SIZE","TARGET_BUFFERS","PREV_SIZE","PREV_BUFFERS","LO_BNUM","HI_BNUM","LO_SETID","HI_SETID","SET_COUNT","CON_ID" from gv$buffer_pool
View Text - HTML Formatted

SELECT "INST_ID"
, "ID"
, "NAME"
, "BLOCK_SIZE"
, "RESIZE_STATE"
, "CURRENT_SIZE"
, "BUFFERS"
, "TARGET_SIZE"
, "TARGET_BUFFERS"
, "PREV_SIZE"
, "PREV_BUFFERS"
, "LO_BNUM"
, "HI_BNUM"
, "LO_SETID"
, "HI_SETID"
, "SET_COUNT"
, "CON_ID"
FROM GV$BUFFER_POOL