Oracle OCI Vs Oracle OCI Load Stage

userds · Post by **userds** » Wed Apr 06, 2005 7:50 am

I need to load data from Sequential file to Oracle 9i database. The average file size will have 30k rows. Please let me know which stage(Oracle OCI or Oracle OCI Load) shall i use to improve the performance.

TIA.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Apr 06, 2005 8:08 am

You need to know more information such as record size (i.e. record length), network constraints, tablespace arrangement etc to determine the effective method. Taking an average situation, doing an OCI must be fine.