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 |
