Data load from Write Optimized DSO taking long time

[Former Member]

Hello Experts,

We are facing an issue with the DTP load from Write Optimized DSO.

Till some time back, a full load from Write Optimized DSO used to complete in 1-2 hours maximum. However it is taking more than 6 hours to load data currently. (This system is live from 2010, hence the increase in records will not be the reason. Also NO transformation routines - so no ABAP coding issues).

Maximum time takes in fetching data for first data package and once this is completed (after 6 hours), the remaining steps completes fast.

In SM50, sequential read from the active table of DSO is taking the time (program CL_SQL_RESULT_SET=============CP).

How can we improve the performance?

SAP version is SAP_BW, 701, SP 0012.

Oracle DB 11.2.0.3.0.

Regards,

Madhu.

[Former Member]

No semantic keys. In order to improve the performance, we have created secondary indexes based on the DTP filters, still no improvement.

[former_member182470]

Try reducing data package size to 50000 in DTP.

[Former Member]

It was initially 50,000. It was not working then. Hence tried 100,000.

[former_member182470]

That's what, revert back to 50000 or 75000.