Menu

SAP Table GVD_BUFF_POOL_ST

Oracle Monitoring: Copy of gv$buffer_pool_statistics

The table GVD_BUFF_POOL_ST (Oracle Monitoring: Copy of gv$buffer_pool_statistics) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table GVD_BUFF_POOL_ST
Short Text Oracle Monitoring: Copy of gv$buffer_pool_statistics
Package STUN
Table Type Transparent Table

Fields for Table GVD_BUFF_POOL_ST

Field Name Key Description Data Element Type Length Check Table
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