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]

Hi Experts,

We had below upgrades in the recent past:

1. SAP BW Support package upgrade to 701-012

2. Oracle DB schema upgrade from version 10 to 11.

Anything to do with these upgrades?

Regards,

Madhu

[former_member182470]

HI,

Increase the datapackage size to 200000 and BGDs as 8. This will improve the performance.

[marcel_scherbinek]

Hi Madhu,

as it takes too long by requesting the data with SQL and the WHERE conditions of the DTP filter. I guess it has something to do with the Oracle DB schema upgrade. Did you already try to reduce the filter values of the DTP to a minimum? If performance already increases by reducing the amount of filters to minimum it might indicate a problem with the Oracle database upgrade. But I have no actual overview of SAP notes refering to this issue.

Regards,

Marcel

[MGrob]

Hi

You can generate the side effects report on the market place to see if there is a know issue related to the newly expirienced DTP performance issues.

hope that helps

Martin

[Former Member]

Hi All,

Is the issue solved i am also facing same issue DTP load from W/DSO is struck at SM66.

Thnaks

Venkat