Poor Performance When Querying Database From ODP.NET Application
(Doc ID 2133358.1)
Last updated on FEBRUARY 01, 2022
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |