Poor Performance When Querying Database From ODP.NET Application
Last updated on AUGUST 30, 2017
Applies to:Oracle Data Provider for .NET - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
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 (220.127.116.11.0) database. The ODP.NET client version on the affected servers is 18.104.22.168. 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.
*** Checked for relevance on 30-Aug-2017 ***
Poor performance observed when querying database from ODP.NET application
-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.
No known changes
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