The Oracle Data Provider for .Net (ODP.Net) version 10g does not support local database locking unless Patch 5916667 is applied. Because all transactions will be treated as distributed (i.e., spanning multiple databases), this might have adverse affects...