DBA Data[Home] [Help]

VIEW: SYS.V_$BUFFER_POOL

Source

View Text - Preformatted

select "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 v$buffer_pool
View Text - HTML Formatted

SELECT "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 V$BUFFER_POOL