V$BUFFER_POOL_STATISTICS
displays statistics 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, |
|
|
Buffer pool maximum set size |
|
|
Number of buffers on replacement list |
|
|
Number of buffers on write list |
|
|
Number of buffers in set |
|
|
Number of buffers gotten by the set |
|
|
Number of buffers written by the set |
|
|
Number of buffers scanned in the set |
|
|
Free buffer wait statistic |
|
|
Write complete wait statistic |
|
|
Buffer busy wait statistic |
|
|
Free buffer inspected statistic |
|
|
Dirty buffers inspected statistic |
|
|
Database blocks changed statistic |
|
|
Database blocks gotten statistic |
|
|
Consistent gets statistic |
|
|
Physical reads statistic |
|
|
Physical writes statistic |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: