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_member182470]

Please ask your BASIS to check any other jobs are running in Parallel in over all BW system. This can slow down your DTP job. Hope you have not touched data Package size settings recently.