This forum is my last hope for help on this issue.
We just recently went from 4.6c, oracle 9-something to ecc 6, oracle 10g.
We have found that report performance in the background has been TERRIBLE in comparison to the old version. Especially CO reports and PS reports. We have spent countless hours on analyss and program changes, and OSS note applications, and have exhausted evey means to find the underlying issue that the upgrade seems to have caused.
The biggest issue we found were changes to the PSJ logical database, and we fixed that.
We have looked both on the Oracle side and the SAP side.
Still reports are running 3-4 times longer.
We are non-unicode
Has anyone else run into this issue?