Skip to Content
0
Jun 11, 2015 at 04:08 PM

Performance problem after upgrade to 11.2.0.4 and COMPRESS for OLTP on view CAUFV

167 Views

Hallo.

We are upgrading our SAP ECC 6.0 systems.

After migration from:
windows 2003 + Oracle 11.2.0.3 + NO COMPRESSION

to

windows 2008 + Oracle 11.2.0.4 + 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:

SELECT

*

FROM

"CAUFV"

WHERE

"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.

Mario