Performance issue with TSP01.

ronaldo_aparecido — Tue, 26 Nov 2013 14:25:57 GMT

Good morning experts.

I changed the logic of a program called (ZCX_FEBRABANT)

wrote a logic:

DATA:t_zcaixa_loja TYPE TABLE OF zcaixa_loja,

w_zcaixa_loja TYPE zcaixa_loja.

SELECT SINGLE *

FROM zcaixa_loja

INTO w_zcaixa_loja

WHERE vkbur = t_loja-vkbur.

IF sy-subrc = 0.

CLEAR w_zcaixa_loja-seqp2k.

w_zcaixa_loja-seqp2k = t_header-numseq.

APPEND w_zcaixa_loja TO t_zcaixa_loja.

ENDIF.

IF NOT t_zcaixa_loja[] IS INITIAL.

MODIFY zcaixa_loja FROM TABLE t_zcaixa_loja[].

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

wait = 'X'.

ENDIF.

He used EarlyWatchAlert-EWA report.

He also says:

We found that this table has two indexes, one of which consists of 3 columns and in one month it was not used once. The oracle loses time to do maintenance on the indexes after the inserts.

This is the index: TSP01 ~ A (table: TSP01). This index could be eliminated?

INSERT INTO "TSP01" VALUES(:A0 ,:A1 ,:A2 ,:A3 ,:A4 ,:A5 ,:A6 ,:A7 ,:A8 ,:A9 ,:A10 ,:A11 ,:A12 ,:A13 ,:A14 ,:A15 ,:A16 ,:A17 ,:A18 ,:A19 ,:A20 ,:A21 ,:A22 ,:A23 ,:A24 ,:A25 ,:A26 ,:A27 ,:A28 ,:A29 ,:A30 ,:A31 ,:A32 ,:A33 ,:A34 ,:A35 ,:A36 ,:A37 ,:A38 ,:A39 ,:A40 ,:A41 ,:A42 ,:A43 ,:A44 ,:A45 ,:A46 )

He says my ZCX_FEBRABANT program is consuming lot of resources Production server.

How can I check where my program is causing problems which tools should I use?

Thanks for help

Re: Performance issue with TSP01.

volker_borowski2 — Thu, 28 Nov 2013 21:52:57 GMT

So you have an overall of 9 physical reads on TSP01 !

This does not really fit with all the other values.

Based on the data given, I'd assume someone activated compression on that table,

which is a bad idea for TSP01.

If yes, do a reorg with brspace to turn off compression for this table.

Volker

topic Performance issue with TSP01. in Application Development and Automation Discussions

Performance issue with TSP01.

Re: Performance issue with TSP01.