LOB Activity (l)

img00100

This screen shows LOB activity in the database. Sorry for the blank screen capture. On the TODO list.

Metric Alertable Metric* Description
LOB# LOBNum Unique LOB ID
Area# LOBAreaNum Database area containing the LOB
BX LOBPool Shows whether cached LOB blocks are found in the primary buffer pool (B1) or alternate buffer pool (B2)
LOB Name LOBName Name of the LOB
#Recs LOBRecs Number of records containing the LOB field
Min Sz LOBMinRow Minimum size of the LOB
Max Sz LOBMaxRow Maximum size of the LOB
Avg Sz LOBAvgRow Average size of the LOB
Create LOBCr Number of LOBs created
Read LOBRd Number of LOB reads
Update LOBUp Number of LOB updates
Delete LOBDl Number of LOBs deleted
OS Read LOBOSRd Number of operating system reads

*Requires data collector "LOBActivity" in pt3agent.cfg. With the commercial version of ProTop, you can configure alerts using the metric names in this column. For a full list of metrics, see the Alertable Metrics section.