Update Oracle table taking long time
Posted: Tue Sep 30, 2014 3:59 am
Hi,
I have a job developed in 9.1 Parallel versioin. Job design is
Dataset -> Trf -> Ora Connector.
Updating target table which contains 11mn records from Dataset(Dataset also contains same no of records as Fact, its a replica).
The table has constraints, tablespace and partitions created on it.
Its running very poorly, it was updating 1st 1mn records 1000r/s and second 1mn recrods 500r/s. and its still running.
we have also set Transaction size as 10000 and Array size as 20000 for the current run.
In the before run, we set Transaction size 3000 and Array size 6000, the performance was same as the current run.
Can anybody has any idea on how to solve this issue.
Thanks in advance.
I have a job developed in 9.1 Parallel versioin. Job design is
Dataset -> Trf -> Ora Connector.
Updating target table which contains 11mn records from Dataset(Dataset also contains same no of records as Fact, its a replica).
The table has constraints, tablespace and partitions created on it.
Its running very poorly, it was updating 1st 1mn records 1000r/s and second 1mn recrods 500r/s. and its still running.
we have also set Transaction size as 10000 and Array size as 20000 for the current run.
In the before run, we set Transaction size 3000 and Array size 6000, the performance was same as the current run.
Can anybody has any idea on how to solve this issue.
Thanks in advance.