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.

[marcel_scherbinek]

Has something changed on Oracle site?

As selecting the result set takes the most of the time (according due to your information) there might be problems by fetching the data from the database with the SQL statement.

As far as I know the SELECT statement is created individually with all the DTP filters for the database. So I would do a SQL trace or take a closer look on Oracle site about the main consumption of the time. Maybe playing a little bit with the DTP filters to find the "corrupt" characteristic which causes the long runtime.

Regards,

Marcel

[Former Member]

The only change performed at Oracle side was the schema upgrade from version 10 to 11. Will this have any impacts?

[RamanKorrapati]

Hi Madhu,

Try to do RSRV test on WDSO.

Tx - RSRV , All elementary test --> DSO. later try to load data to target.

Thanks

[Former Member]

No RSRV since the DSO is write optimized.