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
very poor performance while loading into oracle tables
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio