Upgrading SAP to ECC 6.0 and Oracle 9.2 to 10.2.0.2.0 (HP-UX) we got a system wide performance issue. It impacts almost all the business functions.
Example: We did trace for one HR function. For the same data selection, sqlplus get the result much faster than SAP.
If we do the same selection in SE16, it takes about 10 mins to get the result. When we check in oracle session, it actually shows index PPOIX~0 is used but the right one should be ~001. That will explain why the performance is so bad.
When we run following SQL statement using Oracle sqlplus. We get the result immediately.
select * from sapr3.ppoix where mandt='200' and runid ='0000000700' and tslin = '0000016440';