03-28-2012 10:34 AM
While trying to delete a work center(ARBPL) from T-Code CR02, the time taken is around an hour or so. Was not able to find any related SAP notes for the same. Any help would be appreciated!!!
SAP ECC 6.0
03-29-2012 5:51 AM
Thanks for your quick responses. I did run ST05 and SE30. It seems max time is taken on two select queries.
In include LCRA0F25
SELECT SINGLE * FROM AFRU WHERE ARBID = OBJID_CRHD.
IF SY-SUBRC = 0.
FLG-ARBPL_USED = KREUZ.
EXIT.
ENDIF.
SELECT SINGLE * FROM CATSDB WHERE ARBID = OBJID_CRHD.
IF SY-SUBRC = 0.
FLG-ARBPL_USED = KREUZ.
EXIT.
ENDIF.
Gaurav: There is no BADI or enhancement spot being used.
Will run STAD and ST12 today and post findings soon. Thanks for this info.
03-28-2012 11:23 AM
It's very unlikely that there are performance problem due to standard sap. One hour for deleting one entry might not be due SAP standard code.
Check if any exit or Badi is activated for the transaction. One I faced such a situation where inside an exit a select was done with FOR ALL ENTRIES and the table used for for all entires was initial.
Such things might be causeing problem in your system.
03-28-2012 11:31 AM
Use transactions SE30 or ST05 analyze in which statements you have problem in performance.
03-28-2012 1:22 PM
I'd say better use transaction ST12: http://wiki.sdn.sap.com/wiki/display/ABAP/Single+Transaction+Analysis
03-28-2012 12:15 PM
Hi,
get the STAD record as a start for you analysis. Then take traces ...
Kind regards,
Hermann
03-29-2012 5:51 AM
Thanks for your quick responses. I did run ST05 and SE30. It seems max time is taken on two select queries.
In include LCRA0F25
SELECT SINGLE * FROM AFRU WHERE ARBID = OBJID_CRHD.
IF SY-SUBRC = 0.
FLG-ARBPL_USED = KREUZ.
EXIT.
ENDIF.
SELECT SINGLE * FROM CATSDB WHERE ARBID = OBJID_CRHD.
IF SY-SUBRC = 0.
FLG-ARBPL_USED = KREUZ.
EXIT.
ENDIF.
Gaurav: There is no BADI or enhancement spot being used.
Will run STAD and ST12 today and post findings soon. Thanks for this info.
03-29-2012 7:23 AM
Hi,
how much percentage of the total run time is spent on these selects? (look it up in SE30).
For AFRU:
Make sure index AFRU~3 on columns MANDT, ARBID is active (created) on your DB.
For CATSDB:
Make sure index CATSDB~6 on columns MANDT, ARBID is active (created) on your DB.
Use SE14 to activate the indexes (if they don't exist on your DB).
Kind regards,
Hermann
03-29-2012 7:46 AM
03-29-2012 12:13 PM
He can also do Explain in ST05 for both statements
And mention the numbers that one can see in ST05 statement summary.
04-05-2012 12:01 PM
Hi..
Thanks guys we have updated the index and now its working fine