Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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"