You can enable uncommitted read (dirty read) if needed. By default it is disabled. Enabling uncommitted read allows you to read the values from the first transaction in a multi-transaction process before the changed values are committed.
Before you enable uncommitted read:
-
Understand the implications of uncommitted read (or dirty read) - for example, it is only for transactions that are slow or if the possibility of errors are low.
-
Verify that your database supports uncommitted read. Consult with their DBA or database vendor for additional information.