Analytics Software

Hi Gurus,


I have a task SDE_ORA_GLCOGSFact_Full has been running for 23 hours and only 8 million records have been affected so far. The throughput is very low which is 100 rows/sec. The performance is slow.
We are on 7.9.6.1 running on a linux platform. This is the first load out of the box, and have shrinked the initial extract date to get less load to 01/01/2010.

In the workflow session properties are, the commit interval is 10000. DTM is like 32000000. Default buffer block size is 1280000. line sequential buffer size is 1024. The only
thing I could think of is increase the commit interval. Is there anything else thats causing this tasks to be this slow.

Thanks

Simmz