ANNOUNCEMENT: community.oracle.com is currently Read only due to planned maintenance until 02:30 AM PST, 28-March-2015. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Database Application Development
Oracle Call Interface (OCI)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 19, 2012 4:06 AM by
OCICollAppend has performance issue in my test
Apr 13, 2011 11:29 PM
I am doing a program which will pass an Type Array as input parameter to oracle. In one case, there is a input parameter which has an type array with 5000 Type objects.
I construct the object one by one and pass the object to the OCICollAppend, finally in my test, I fount oci doing the 5000 OCICollAppend takes about 120 seconds to finish.
Is there an other way to optimize the performance of pass Type Array by OCI?
Edited by: Bruce on 2011-4-13 下午11:28
This content has been marked as final.
Show 1 reply
Re: OCICollAppend has performance issue in my test
Nov 19, 2012 4:06 AM
in response to
The performance lies in the OCIObjectSetAttr function, not OCICollAppend function.