V$BUFFER_POOL

V$BUFFER_POOL displays information about all buffer pools available for the instance.

Column Datatype Description
ID NUMBER Buffer pool identifier number
NAME VARCHAR2(20) Name of the buffer pool:
  • DEFAULT

  • KEEP

  • RECYCLE

    Note: Currently, KEEP and RECYCLE pools only exist for the standard block size. All non-standard block size pools are DEFAULT.

BLOCK_SIZE NUMBER Block size (in bytes) for buffers in this pool. Possible values: the standard block size, the power of 2 non-standard block sizes, 2048, 4096, 8192, 16384, 32768.
RESIZE_STATE VARCHAR2(10) Current state of the resize operation:

STATIC - Not being resized

ALLOCATING - Memory is being allocated (can be cancelled by the user)

ACTIVATING - New buffers are being created (user cannot cancel)

SHRINKING - Buffers are being deleted (can be cancelled by the user)

CURRENT_SIZE NUMBER Present size of the sub-cache (in megabytes)
BUFFERS NUMBER Current instantaneous number of buffers
TARGET_SIZE NUMBER If a resize is in progress (state is not STATIC), records new target size (in megabytes). If the pool is STATIC, the value in this column is the same as the current size of the pool.
TARGET_BUFFERS NUMBER If a resize is in progress, records new target size in terms of buffers. Otherwise, the value in this column is the same as the current number of buffers.
PREV_SIZE NUMBER Previous buffer pool size. If the buffer pool has never been resized, the previous size is zero.
PREV_BUFFERS NUMBER Previous number of buffers in the buffer pool. Value is zero if the buffer pool has never been resized.
LO_BNUM NUMBER Obsolete column
HI_BNUM NUMBER Obsolete column
LO_SETID NUMBER Obsolete column
HI_SETID NUMBER Obsolete column
SET_COUNT NUMBER Obsolete column

See Also:

"DB_BLOCK_SIZE"