My Oracle Support Banner

Delay During Connection While Running A "Select" From A Table Using 11g ODP (Doc ID 1083774.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Data Provider for .NET - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Microsoft Windows (32-bit)
Oracle Data Provider for .Net version 11.1.10.7.20
.Net Framework version 3.5

Symptoms

When doing the connection and issuing a SELECT from a table in a Oracle database using their application and the Oracle Data Provider for .Net results in a 25 second delay. If the same query is run from a Java application the results take less than 1 second.This delay happens in the connection with the database. Once the connection is established, the query is fast.

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
  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.