Poor Performance When Querying Database From ODP.NET Application (Doc ID 2133358.1)

Last updated on MAY 19, 2016

Applies to:

Oracle Data Provider for .NET - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Generic Windows
Customer installed the oracle client on VMWare ESXi virtual Windows Server 2012R2 server.
An application written mainly in VB.NET that makes extensive use of ODP.NET unmanaged driver for connection to an Oracle 11GR2 (11.2.0.3.0) database. The ODP.NET client version on the affected servers is 2.112.1.0. The application is run on several different Windows terminal servers, with ~10-30 users per server. One of these servers is running Windows Server 2008, several are running Windows Server 2008 R2, and several are running Windows Server 2012R2.

Symptoms

Poor performance observed when querying database from ODP.NET application

 Steps taken:

-Inspected application logs, which show that the delays occur when the application is talking to the database via ODP.NET (e.g. calls to DataAdapter.Fill). But application on the other servers is not affected, even at the same time.
-Query performance from other clients (SQL Developer, SQL Plus) is unaffected.
-Network traffic appears normal, as does server performance (CPU, memory, etc).
-Changed application to use the newest version of the Managed ODP.NET client, but performance was unaffected.

It isobserved only on windows 2012 R2 Servers

Over the last several weeks, the performance on the 2012 R2 servers has intermittently become very poor ; queries that normally run in just a few milliseconds are taking 300-500 ms, queries that normally take a few seconds can take over a minute to return.

Changes

 No known changes

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