This element shows the lock timeout value in effect for the statement while it was being run.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Locking | - | - |
Deadlocks with Details History Values1 | event_stmt_history | - |
Deadlocks with Details History1 | event_stmt_history | - |
Activities | event_activitystmt | - |
You can use this element in conjunction with other statement history entries to understand the cause of the deadlock and the execution behavior of a particular SQL statement.