TXE Data Collector

"TXE" Data Collector

For a detailed discussion of these metrics, see ProTop Real-Time - Latches and Resources (w) and ProTop Trends - Latches and Resources.

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_txe     (temptable name)
concurrLk ConLk num Not in use
concurrLkPct ConLk% num Not in use
concurrWt ConWt num Not in use
txeLockPct Lock% num Percent of time the transaction holds locks
txeLocks Locks num The number of locks a transaction holds
txeType TXEType char Transaction type
txeWaits Waits num Number of times the process fails to get a latch because of excess spin