Monitoring isolation levels that sessions use
The onstat -g ses and onstat -g sql output shows the isolation level that a session is currently using.
The following table summarizes the values in the IsoLvl column in onstat -g ses and onstat -g sql output.
- Value
- Description
- DR
- Dirty Read
- CR
- Committed Read
- CS
- Cursor Stability
- CRU
- Committed Read with RETAIN® UPDATE LOCKS
- CSU
- Cursor Stability with RETAIN UPDATE LOCKS
- DRU
- Dirty Read with RETAIN UPDATE LOCKS
- LC
- Committed Read, Last Committed
- RR
- Repeatable Read
If a great deal of lock contention occurs, check the isolation level of sessions to make sure it is appropriate for the application.