SNAPSHOT_ID |
✔ |
Oracle monitor: snapshot ID |
ORA_SNAPSHOT_ID |
NUMC |
10 |
* |
INST_ID |
✔ |
Oracle monitor: Instance ID |
ORA_INST_ID |
DEC |
22 |
|
ID |
✔ |
Oracle Monitoring: ID: Buffer Pool ID |
ORA_BPID |
DEC |
22 |
|
NAME |
✔ |
Oracle Monitoring: NAME: Buffer Pool Name |
ORA_BPNAME |
CHAR |
20 |
|
BLOCK_SIZE |
|
Oracle Monitoring: BLOCK_SIZE: Block Size |
ORA_BPBLOCK_SIZE |
DEC |
22 |
|
SET_MSIZE |
|
Oracle Monitoring: SET_MSIZE: Buffer pool maximum set size |
ORA_SET_MSIZE |
DEC |
22 |
|
CNUM_REPL |
|
Oracle Monitoring: CNUM_REPL: Number of buffers on repl. lst |
ORA_CNUM_REPL |
DEC |
22 |
|
CNUM_WRITE |
|
Oracle Monitoring: CNUM_WRITE: No. of buffers on write list |
ORA_CNUM_WRITE |
DEC |
22 |
|
CNUM_SET |
|
Oracle Monitoring: CNUM_SET: Number of buffers in set |
ORA_CNUM_SET |
DEC |
22 |
|
BUF_GOT |
|
Oracle Monitoring: BUF_GOT: No. of buffers gotten by the set |
ORA_BUF_GOT |
DEC |
22 |
|
SUM_WRITE |
|
Oracle Monitoring: SUM_WRITE: Buffers written by set |
ORA_SUM_WRITE |
DEC |
22 |
|
SUM_SCAN |
|
Oracle Monitoring: SUM_SCAN: Buffers scanned in the set |
ORA_SUM_SCAN |
DEC |
22 |
|
FREE_BUFFER_WAIT |
|
Oracle Monitoring: FREE_BUFFER_WAIT: Free buffer wait stat. |
ORA_FREE_BUFFER_WAIT |
DEC |
22 |
|
WRITE_COMPLETE_W |
|
Oracle Monitoring: WRITE_COMPLETE_WAIT: Write complete wait |
ORA_WRITE_COMPLETE_WAIT |
DEC |
22 |
|
BUFFER_BUSY_WAIT |
|
Oracle Monitoring: BUFFER_BUSY_WAIT: Buffer busy wait stat. |
ORA_BUFFER_BUSY_WAIT |
DEC |
22 |
|
FREE_BUFFER_INSP |
|
Oracle Monitoring: FREE_BUFFER_INSPECTED: Free buffer inspec |
ORA_FREE_BUFFER_INSPECTED |
DEC |
22 |
|
DIRTY_BUFFERS_IN |
|
Oracle Monitoring: DIRTY_BUFFERS_INSPECTED: Dirty buffers in |
ORA_DIRTY_BUFFERS_INSPECTED |
DEC |
22 |
|
DB_BLOCK_CHANGE |
|
Oracle Monitoring: DB_BLOCK_CHANGE: Database blocks changed |
ORA_DB_BLOCK_CHANGE |
DEC |
22 |
|
DB_BLOCK_GETS |
|
Oracle Monitoring: DB_BLOCK_GETS: Database blocks gotten |
ORA_DB_BLOCK_GETS |
DEC |
22 |
|
CONSISTENT_GETS |
|
Oracle Monitoring: CONSISTENT_GETS: Consistent gets statisti |
ORA_BPCONSISTENT_GETS |
DEC |
22 |
|
PHYSICAL_READS |
|
Oracle Monitoring: PHYSICAL_READS: Physical reads statistic |
ORA_BPPHYSICAL_READS |
DEC |
22 |
|
PHYSICAL_WRITES |
|
Oracle Monitoring: PHYSICAL_WRITES: Physical writes statisti |
ORA_BPPHYSICAL_WRITES |
DEC |
22 |
|