GVD_BUFF_POOL_ST - Oracle Monitoring: Copy of gv$buffer_pool_statistics
Oracle Monitoring: Copy of gv$buffer_pool_statistics information is stored in SAP table GVD_BUFF_POOL_ST.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table GVD_BUFF_POOL_ST
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
| ID | Oracle Monitoring: ID: Buffer Pool ID | X | ORA_BPID | DEC | 12 | |
| NAME | Oracle Monitoring: NAME: Buffer Pool Name | X | ORA_BPNAME | CHAR | 20 | |
| BLOCK_SIZE | Oracle Monitoring: BLOCK_SIZE: Block Size | ORA_BPBLOCK_SIZE | DEC | 12 | ||
| SET_MSIZE | Oracle Monitoring: SET_MSIZE: Buffer pool maximum set size | ORA_SET_MSIZE | DEC | 12 | ||
| CNUM_REPL | Oracle Monitoring: CNUM_REPL: Number of buffers on repl. lst | ORA_CNUM_REPL | DEC | 12 | ||
| CNUM_WRITE | Oracle Monitoring: CNUM_WRITE: No. of buffers on write list | ORA_CNUM_WRITE | DEC | 12 | ||
| CNUM_SET | Oracle Monitoring: CNUM_SET: Number of buffers in set | ORA_CNUM_SET | DEC | 12 | ||
| BUF_GOT | Oracle Monitoring: BUF_GOT: No. of buffers gotten by the set | ORA_BUF_GOT | DEC | 12 | ||
| SUM_WRITE | Oracle Monitoring: SUM_WRITE: Buffers written by set | ORA_SUM_WRITE | DEC | 12 | ||
| SUM_SCAN | Oracle Monitoring: SUM_SCAN: Buffers scanned in the set | ORA_SUM_SCAN | DEC | 12 | ||
| FREE_BUFFER_WAIT | Oracle Monitoring: FREE_BUFFER_WAIT: Free buffer wait stat. | ORA_FREE_BUFFER_WAIT | DEC | 12 | ||
| WRITE_COMPLETE_W | Oracle Monitoring: WRITE_COMPLETE_WAIT: Write complete wait | ORA_WRITE_COMPLETE_WAIT | DEC | 12 | ||
| BUFFER_BUSY_WAIT | Oracle Monitoring: BUFFER_BUSY_WAIT: Buffer busy wait stat. | ORA_BUFFER_BUSY_WAIT | DEC | 12 | ||
| FREE_BUFFER_INSP | Oracle Monitoring: FREE_BUFFER_INSPECTED: Free buffer inspec | ORA_FREE_BUFFER_INSPECTED | DEC | 12 | ||
| DIRTY_BUFFERS_IN | Oracle Monitoring: DIRTY_BUFFERS_INSPECTED: Dirty buffers in | ORA_DIRTY_BUFFERS_INSPECTED | DEC | 12 | ||
| DB_BLOCK_CHANGE | Oracle Monitoring: DB_BLOCK_CHANGE: Database blocks changed | ORA_DB_BLOCK_CHANGE | DEC | 12 | ||
| DB_BLOCK_GETS | Oracle Monitoring: DB_BLOCK_GETS: Database blocks gotten | ORA_DB_BLOCK_GETS | DEC | 12 | ||
| CONSISTENT_GETS | Oracle Monitoring: CONSISTENT_GETS: Consistent gets statisti | ORA_BPCONSISTENT_GETS | DEC | 12 | ||
| PHYSICAL_READS | Oracle Monitoring: PHYSICAL_READS: Physical reads statistic | ORA_BPPHYSICAL_READS | DEC | 12 | ||
| PHYSICAL_WRITES | Oracle Monitoring: PHYSICAL_WRITES: Physical writes statisti | ORA_BPPHYSICAL_WRITES | DEC | 12 |