Report take a long time in table TST03

[Former Member]

Hi,

Our developpers have done a job to create a spool order to file. Among others, this job run the SAPLSPOX, and SAPLSPOC reports, but they takes a long time when they read or insert in table TST03.

The spool order has about 40.000 or 50.000 pages and the job can last 5.000 or 6.000 seconds. Is it normal?. If not what can I do?.

Regards.

[Former Member · Accepted solution]

Hi,

Do an SQL trace with Tx ST05 while the reportis running.

Check accesses to TST03 and see if something is wrong.

Regards,

Olivier

[Former Member]

Thanks gorku, but I have already done that. Lately it seems that works better.

Regards

[Former Member]

Hi Olivier,

I did a SQL trace but I didn't see something unusual. The developers must have patience.

Regards

[Former Member]

Hi,

update statatics for TST03 table and rebuild indixes in low system workload time.

-gokul

[Former Member]

Thanks Markus for your help,

I deleted the old spool but the report still taking a long time. Do you think these are normal times?.

Regards

[markus_doehr2]

Do you clean you old spools regularly?

Note 130978 - RSPO1041 - Replacement for RSPO0041

Markus