Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$BUFFER_POOL

This view displays information about all buffer pools available for the instance. The "sets" pertain to the number of LRU latch sets.

See Also:

"DB_BLOCK_SIZE"

Column Datatype Description

ID

NUMBER

Buffer pool ID number

NAME

VARCHAR2(20)

Buffer pool name. Possible values: 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