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: