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
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
|
|
|