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 |