My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.