Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OCIObjectSetAttr performance deteriorates when binding too many Type params

792937Nov 19 2012
Hi,

In my application, when I passed a Type Array as parameter to the stored procedure and when the Type Array is large enough(normally 3000 type objects， each objects has about 15 attributes), the OCIObjectSetAttr performance deteriorates large enough from below 1 millisecond to 1~3 miliseconds.

I am using OCI 11gR2, does anyone notice it and know how to optimize it?

Regards,
-Bruce

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 17 2012
Added on Nov 19 2012
#oracle-call-interface-oci
0 comments
522 views