very poor performance while loading into oracle tables

sheema · Post by **sheema** » Thu Jan 18, 2007 9:22 pm

My job uses a flat-file as source that passes through a transformer, where 7 or 8 new fields are appended with some values and then
i have 4 hash files as lookups to 2nd transformer.I check if row exists i perform an update operation or else insert operation into Oracle via 2 OCI stages. The problem is it starts loading about 250 rows/sec and starts decreasing steadily, finally to 1 row/sec.
I have set the array size to 100 and transaction size to 200 for both Insert and Update operation.can anyone help me with reason for rows/sec decreasing.

Thanks
sheema

rleishman · Post by **rleishman** » Thu Jan 18, 2007 9:28 pm

Try some of these suggestions: viewtopic.php?t=95526

Krazykoolrohit · Post by **Krazykoolrohit** » Fri Jan 19, 2007 10:27 am

Check out the warning log. there must be a lot of warnings. Get rid of those and your job will run faster.

Warning are basically caused due to data mismatch issues. check for all these kind of stuff.

sheema · Post by **sheema** » Fri Jan 19, 2007 12:27 pm

I did not get any warnings.
But when i created Indexes on the table today,it is running fine.
Thanks for the help.

Thanks
sheema