7.118 V$BUFFER_POOL_STATISTICS
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: