Poor performance when acessing LTAK/LTAP tables from standard SAP t-code

[Former Member]

Hi Gurus,

System:

• OS - Win 2K3 Enterprise

• DB - Oracle 10.2.0.2

• SAP - ECC6 patch 14

We have just upgraded to ECC6.0 and the system is now with poor performance on T-Code LT26 when performing a sequential read at LTAP.

After reading a lot (sap notes, google and here), we found some instructions to use the prameter DBS/ORA/SUBSTITUTE_LITERALS = 1

However, nobody tels for sure if it brings other consequences that we are not expecting.

Does anyone use this parameter? Its OK to use it? What could be the side-efects?

Best Regards,

Carlos Constantino

[former_member204746]

I had similar problems with LTAP. I had to add one index and problem cleared away.

[sunny_pahuja2]

Hi,

Have you implemented SAP note 830576 for oracle ?

Thanks

Sunny

[stefan_koehler]

Hello Carlos,

at first ...

> Does anyone use this parameter? Its OK to use it? What could be the side-efects?

DO NOT SET (!!!) this parametet to "1" .. it can cause a lot of execution plan changes and force a lot of hard parsing. The massive hard parsing can cause shared pool fragmentation and a lot of CPU usage.

> We have just upgraded to ECC6.0 and the system is now with poor performance on T-Code LT26 when performing a sequential read at LTAP.

Ok, if you just have performance problems with this particular transaction, please provide us the SQL statement, the corresponding execution plan and the statistics. If you don't know how to gather all the needed information, just check sapnote #1257075 and run the sql script. After that upload the output to SDN or any other hosting platform so that we can take a look at it.

Regards

Stefan