Writing to OCI Stage
Posted: Wed Aug 22, 2001 7:14 pm
Scenerio:
I am writing from a source file(no transform) to a OCI stage with 20 fields. The first 7 fields are key fields and they are setup as unique constraint key fields in Oracle. Per Informix/Ascential techs, I have the array size set to 1 and rows per transaction set to 1.
I am not able to acheive more than a 45-65 rec/sec ratio.
Short of using SQLLDR from the command line, is there anything more I can do to speed up this performance?
--
Michael Feckler mfeckler@onel.com
Minneapolis, MN
952-996-9145
I am writing from a source file(no transform) to a OCI stage with 20 fields. The first 7 fields are key fields and they are setup as unique constraint key fields in Oracle. Per Informix/Ascential techs, I have the array size set to 1 and rows per transaction set to 1.
I am not able to acheive more than a 45-65 rec/sec ratio.
Short of using SQLLDR from the command line, is there anything more I can do to speed up this performance?
--
Michael Feckler mfeckler@onel.com
Minneapolis, MN
952-996-9145