SQL Statement Using Oracle.DataAccess Changes Explain Plan
(Doc ID 1322807.1)
Last updated on MARCH 04, 2022
Applies to:
Oracle Data Provider for .NET - Version 11.2.0.2 and laterMicrosoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
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 |