|
ID
|
NUMBER
|
Buffer pool ID number
|
|
NAME
|
VARCHAR2(20)
|
Buffer pool name
|
|
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
|
