V$BUFFER_POOL_STATISTICS

V$BUFFER_POOL_STATISTICS displays statistics about all buffer pools available for the instance.

Column Datatype Description
ID NUMBER Buffer pool identifier number
NAME VARCHAR2(20) Name of the buffer pool
SET_MSIZE NUMBER Buffer pool maximum set size
CNUM_REPL NUMBER Number of buffers on replacement list
CNUM_WRITE NUMBER Number of buffers on write list
CNUM_SET NUMBER Number of buffers in set
BUF_GOT NUMBER Number of buffers gotten by the set
SUM_WRITE NUMBER Number of buffers written by the set
SUM_SCAN NUMBER Number of buffers scanned in the set
FREE_BUFFER_WAIT NUMBER Free buffer wait statistic
WRITE_COMPLETE_WAIT NUMBER Write complete wait statistic
BUFFER_BUSY_WAIT NUMBER Buffer busy wait statistic
FREE_BUFFER_INSPECTED NUMBER Free buffer inspected statistic
DIRTY_BUFFERS_INSPECTED NUMBER Dirty buffers inspected statistic
DB_BLOCK_CHANGE NUMBER Database blocks changed statistic
DB_BLOCK_GETS NUMBER Database blocks gotten statistic
CONSISTENT_GETS NUMBER Consistent gets statistic
PHYSICAL_READS NUMBER Physical reads statistic
PHYSICAL_WRITES NUMBER Physical writes statistic

See Also:

"DB_CACHE_SIZE"