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 126.96.36.199 to 188.8.131.52 [Release 11.2 to 12.1]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
Unmanaged OPD.NET (184.108.40.206) 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
Upgraded driver to 12c
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