DBA_HIST_BUFFER_POOL_STAT displays historical statistics about all buffer pools available for the instance. This view contains snapshots of V$BUFFER_POOL_STATISTICS.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAP_ID |
NUMBER |
NOT NULL |
Unique snapshot ID |
DBID |
NUMBER |
NOT NULL |
Database ID for the snapshot |
INSTANCE_NUMBER |
NUMBER |
NOT NULL |
Instance number for the snapshot |
ID |
NUMBER |
NOT NULL |
Buffer pool identifier number |
NAME |
VARCHAR2(20) |
Name of the buffer pool | |
BLOCK_SIZE |
NUMBER |
Block Size | |
SET_MSIZE |
NUMBER |
Buffer pool maximum set size | |
CNUM_REPL |
NUMBER |
Number of buffers on the replacement list | |
CNUM_WRITE |
NUMBER |
Number of buffers on the write list | |
CNUM_SET |
NUMBER |
Number of buffers in the 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 |