My Oracle Support Banner

ODPU Taking Longer Time To Execute The Stored Procedure Having User Defined Type (Doc ID 2514048.1)

Last updated on NOVEMBER 20, 2019

Applies to:

Oracle Data Provider for .NET - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Symptoms

Unmanaged OPD.NET (4.121.2.0) driver taking longer time to execute the stored procedure having user defined type.

Below is the part of the trace where it could be seen that most amount of time during OpsUdtSetData().

OpsUdtSetData() internally calls OCIObjectNew() and from deliverer's analysis OCIObjectNew() is taking most amount of time during OpsUdtSetData() call

Changes

 Upgraded driver to 12c

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.