B2 Data Collector

B2 buffer pool metrics.

For a detailed discussion of these metrics, see ProTop Real-Time - Buffer Pools (ctrl-b).


To set up an alert on a metric listed here, make note of the Data Collector name at the top of this page, the Alertable Metric and Data Type from the table below and visit Alert Configuration.

Alertable Metric ProTop RT Label Data Type Description
tt_b2     (temptable name)
bpActive Active num Number of active buffers in the buffer pool
bpArea Area num Only available in late 11.x versions. Number of area blocks in the buffer pool
bpBMap BMap num Nummber of block map blocks in the buffer pool
bpCMap CMap num Number of cluster map blocks in the buffer pool
bpCtrl Ctrl num Only available in late 11.x versions. Number of control blocks in the buffer pool
bpData DataBlk num Only available in late 11.x versions. Number of data blocks in the buffer pool
bpHitPct Hit% num Percentage of read requests filled from the buffer pool
bpIdx IdxBlk num Only available in late 11.x versions. Number of index blocks in the buffer pool
bpIndexes Idxs num Number of indices in the buffer pool
bpLOBS LOB num Number of LOBs in the buffer pool
bpLogRd LogRd num Number of logical reads from the buffer pool
bpLogWr logWr num Number of logical writes to the buffer pool
bplruStat LRU Stat char Status of the LRU chain. See below for discussion
bpMstr Mstr num Only available in late 11.x versions. Number of master blocks in the buffer pool
bpName Pool char Primary or Alternate buffer ppol
bpObj Obj num Only available in late 11.x versions. Number of object blocks in the buffer pool.
bpOCList OCL num Number of object cluster list blocks in the buffer pool
bpOList OLst num Number of object list blocks in the buffer pool
bpOSRd OSRd num Number of reads from storage (disk)
bpOSWr OSWr num Number of writes to storage (disk)
bpSeq SEQ num Only available in late 11.x versions. Number of sequence blocks in the buffer pool
bpSize Buffers num Number of buffer blocks in the pool
bpTables Tbls num Number of tables in the buffer pool
bpUnused Unused num Number of unused buffers in the buffer pool