Our program use dotConnect for Oracle, and today I get following feedback from Oracle guru:
"
Found 173.571 calls SET TRANSACTION ISOLATION LEVEL READ COMMITTED. The READ COMMITTED setting is the default Oracle Database transaction behavior. If the transaction contains DML that requires row locks held by another transaction, then the DML statement waits until the row locks are released.
I STRONGLY recommend to remove with calls.
"
Is it possible to remove this calls from dotConnect source code or make it optional?
Personally, I do not think that this somehow affects Oracle performance, but is obliged to respond to oracle dba inquiries.
Thanks in advance
How to avoid SET ISOLATION LEVEL READ COMMITTED calls
New build of dotConnect for Oracle 6.30.165 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21148 .
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21148 .