../E40402-16.epub /> ../E40402-16.mobi />

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
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