4.298 DBA_HIST_BUFFER_POOL_STAT
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 |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Buffer pool identifier number |
|
|
|
Name of the buffer pool |
|
|
|
Block Size |
|
|
|
Buffer pool maximum set size |
|
|
|
Number of buffers on the replacement list |
|
|
|
Number of buffers on the write list |
|
|
|
Number of buffers in the 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 database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: