"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 |