Skip to Content
0
Former Member
Oct 09, 2006 at 02:00 PM

Analysis of Workload Statistics through ST03n

72 Views

Hello All,

I am monitoring performance of transaction Vl01n. The workload table access statistics(St03n) for this transaction shows 0 modificatios, 0 direct reads, 0 sequential reads on table LTAK and has the top access time for the transaction (almost 90% of the total response time of the transaction).

My question here is that, <b>what other operation can cause such high response time when the Workload shows 0 modificatios, 0 direct reads, 0 sequential reads.</b>

Also the STAD data shows that this transaction has high response time with LTAK being the major contributor, when the Work process type Is <b>'U'</b>. Can we make assumptions that the operation being performed is Update?