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 |