7.117 V$BUFFER_POOL
V$BUFFER_POOL
displays information about all buffer pools available for the instance.
Column | Datatype | Description |
---|---|---|
|
|
Buffer pool identifier number |
|
|
Name of the buffer pool:
|
|
|
Block size (in bytes) for buffers in this pool. Possible values: the standard block size, the power of 2 nonstandard block sizes, |
|
|
Current state of the resize operation:
|
|
|
Present size of the sub-cache (in megabytes) |
|
|
Current instantaneous number of buffers |
|
|
If a resize is in progress (state is not |
|
|
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. |
|
|
Previous buffer pool size. If the buffer pool has never been resized, the previous size is zero. |
|
|
Previous number of buffers in the buffer pool. Value is zero if the buffer pool has never been resized. |
|
|
Obsolete column |
|
|
Obsolete column |
|
|
Obsolete column |
|
|
Obsolete column |
|
|
Obsolete column |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: