"LOBActivity" Data Collector


For a detailed discussion of these metrics, see ProTop Real Time - LOB Activity (l).

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