Note: With the instrumentation level set to anything other than MAX, the values may be less accurate for TimeStatistics and CountStatistics (and in the case of CountStatistics, such as numConnectionHandles, can even be negative). This is due to counters not being synchronized. Synchronizing counters is very expensive in terms of resources, so it is only done when the instrumentation level is set to MAX.
Name | Key | Description | Version | Granularity | Type | Level |
Global trans begun | transactionModule.globalTransBegun | The total number of global transactions started on the server | 4.0 and later | Per transaction manager or server | CountStatistic | Low |
Global trans involved | transactionModule.globalTransInvolved | The total number of global transactions involved on the server (for example, begun and imported) | 4.0 and later | Per transaction manager or server | CountStatistic | Low |
Local trans begun | transactionModule.localTransBegun | The total number of local transactions started on the server | 4.0 and later | Per transaction manager or server | CountStatistic | Low |
Active global trans | transactionModule.activeGlobalTrans | The number of concurrently active global transactions | 3.5.5 and later | Per transaction manager or server | CountStatistic | Low |
Active local trans | transactionModule.activeLocalTrans | The number of concurrently active local transactions | 4.0 and later | Per transaction manager or server | CountStatistic | Low |
Global tran duration | transactionModule.globalTranDuration | The average duration of global transactions | 3.5.5 and later | Per transaction manager or server | TimeStatistic | Medium |
Local tran duration | transactionModule.localTranDuration | The average duration of local transactions | 4.0 and later | Per transaction manager or server | TimeStatistic | Medium |
Global before completion duration | transactionModule.globalBeforeCompletionDuration | The average duration of before_completion for global transactions | 4.0 and later | per transaction manager or server | TimeStatistic | Medium |
Global commit duration | transactionModule.globalCommitDuration | The average duration of commit for global transactions | 4.0 and later | Per transaction manager or server | TimeStatistic | Medium |
Global prepare duration | transactionModule.globalPrepareDuration | The average duration of prepare for global transactions | 4.0 and later | Per transaction manager or server | TimeStatistic | Medium |
Local before completion duration | transactionModule.localBeforeCompletionDuration | The average duration of before_completion for local transactions | 4.0 and later | Per transaction manager or server | TimeStatistic | Medium |
Local commit duration | transactionModule.localCommitDuration | The average duration of commit for local transactions | 4.0 and later | Per transaction manager or server | TimeStatistic | Medium |
Global trans committed | transactionModule.globalTransCommitted | The total number of global transactions committed | 3.5.5 and later | Per transaction manager or server | CountStatistic | Low |
Global trans rolled back | transactionModule.globalTransRolledBack | The total number of global transactions rolled back | 3.5.5 and later | Per transaction manager or server | CountStatistic | Low |
Num optimizations | transactionModule.numOptimization | The number of global transactions converted to single phase for optimization | 4.0 and later | Per transaction manager or server | CountStatistic | Low |
Local trans committed | transactionModule.localTransCommitted | The number of local transactions committed | 4.0 and later | Per transaction manager or server | CountStatistic | Low |
Local trans rolled back | transactionModule.localTransRolledBack | The number of local transactions rolled back | 4.0 and later | Per transaction manager or server | CountStatistic | Low |
Global trans timeout | transactionModule.globalTransTimeout | The number of global transactions timed out | 4.0 and later | Per transaction manager or server | CountStatistic | Low |
Local trans timeout | transactionModule.localTransTimeout | The number of local transactions timed out | 4.0 and later | Per transaction manager or server | CountStatistic | Low |