This element shows the
isolation value in effect for the statement
while it was being run.
Table 1. Event Monitoring
InformationEvent Type |
Logical Data Grouping |
Monitor Switch |
Deadlocks with Details History Values |
event_stmt_history |
- |
Deadlocks
with Details History |
event_stmt_history |
- |
Activities |
event_activitystmt |
- |
The possible isolation level values are:
- SQLM_ISOLATION_LEVEL_NONE
0 (no isolation level specified)
- SQLM_ISOLATION_LEVEL_UR 1
(uncommitted read)
- SQLM_ISOLATION_LEVEL_CS 2 (cursor stability)
- SQLM_ISOLATION_LEVEL_RS 3 (read stability)
- SQLM_ISOLATION_LEVEL_RR
4 (repeatable read)
- Usage
- 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.