Transaction Summary

Reports committed transactions. “Committed Xacts” reports the number of transactions committed during the sample interval.

The transactions counted include implicit and explicit, chained (ANSI-style), or unchained:

If there were transactions that started before the sample interval began and completed during the interval, “Committed Xacts” reports a larger number of transactions than the number that started and completed during the sample interval. If transactions do not complete during the interval, “Total # of Xacts” does not include them. In Figure 2-1, both T1 and T2 are counted, but T3 is not.

Figure 2-1: How transactions are counted

Image shows three transsactions occuring at separate times during an interval. Each of the transactions are represented by a horizontal lines T1, T2, and T3. These lines do not intersect or overlap.