BI Upgrade 3.5 to 701 DB02 refresh takes long time

[Former Member]

Hello

I successfully completed a BI Upgrade from 3.5 to 701.

When trying to execute DB02 for tablespace analysis it took almost 6000 sec to give me the output.

Why is it taking so much time ?

Is any activity to be done so as to reduce the time taken for db02 analysis.

Regards

Siddhesh Naik

[Former Member]

Hi

Problem resolved...

There is a feature in Oracle 10g Recycle Bin which has to be set off for sap environment.

Once it was set off and then deleted the contents in recycle bin the problem got solved.

Sap Note Referred : 838982

Regards

Siddhesh Naik

[Former Member]

What database are you running?

Kind regards,

Mark

[Former Member]

hi

Oracle 10.2.0.4

Regards

Siddhesh Naik

[Former Member]

Have you performed a statistics update after the upgrade?

Kind regards,

Mark

[Former Member]

hi

Yes Statistic Update were performed after completion of upgrade.

Regards

Siddhesh Naik