How to avoid SET ISOLATION LEVEL READ COMMITTED calls

How to avoid SET ISOLATION LEVEL READ COMMITTED calls

Postby mars » Fri 06 May 2011 13:34

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
mars
 
Posts: 14
Joined: Tue 14 Jul 2009 13:56

Postby Shalex » Wed 11 May 2011 14:27

Thank you for your suggestion. We will investigate the possibility of excluding this call after every transaction opening.
Shalex
Devart Team
 
Posts: 7343
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Wed 18 May 2011 16:06

The issue with redundant setting isolation level to READ COMMITTED on every transaction opening is fixed. I will post here when the corresponding build of dotConnect for Oracle is available for download.
Shalex
Devart Team
 
Posts: 7343
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Thu 02 Jun 2011 11:49

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 .
Shalex
Devart Team
 
Posts: 7343
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle