SQL Statement Using Oracle.DataAccess Changes Explain Plan (Doc ID 1322807.1)

Last updated on JULY 22, 2017

Applies to:

Oracle Data Provider for .NET - Version 11.2.0.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

***Checked for relevance on 22-Jul-2017***

Symptoms

A SQL statement is changing the explain plan using Oracle Data Provider for .NET. When running a select query through Oracle Sql Developer, it completes in 4 seconds. The same select statement using Oracle Data Provider for .NET takes 20 hours to complete and appears to hang.

i.e. we observe slow performance with ODP.NET driver compared to SQLPLUS or SQLDeveloper

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms