Monitoring Isolation That Sessions Use

The onstat -g ses and onstat -g sql statements list the isolation level that a session is currently using. The following table summarizes the values in the IsoLvl column.

Value

Description

DR

Dirty Read

CR

Committed Read

CS

Cursor Stability

RR

Repeatable Read

DRU

Dirty Read with RETAIN UPDATE LOCKS

CRU

Committed Read with RETAIN UPDATE LOCKS

CSU

Cursor Stability with RETAIN UPDATE LOCKS

If a great deal of lock contention occurs, check the isolation level of sessions to make sure it is appropriate for the application.