We are upgrading our SAP ECC 6.0 systems.
After migration from:
windows 2003 + Oracle 188.8.131.52 + NO COMPRESSION
windows 2008 + Oracle 184.108.40.206 + COMPRESS FOR OLTP
I have jobs that use the view CAUFV very very slow
Before the upgrade near 10000 secs. now on 33000 not yet finished.
The bad select is:
"MANDT"=:A0 AND "PLNBEZ"=:A1 AND "GLTRP" BETWEEN :A2 AND :A3 AND "WERKS"=:A4 AND "GETRI"=:A5 AND
"LOEKZ"=:A6 AND "IDAT2"=:A7
Do anyone know any issue on Oracle with the compression activated?
What could I check?
thanks a lot for your help.