ST02 select very low hit ratio in call stat section

[Former Member]

Hello,

I have very low hit ratio for selects in ST02. It is about 4%.

Select single is ok, about 99,6%. DB Hit Ratio is about 98,9%.

How can I investigate this problem? What should I check first?

I'm looking for advice

Best regards,

Michal

[former_member197561 · Accepted solution]

Hi,

Use transaction ST05 and record SQL trace. In this trace check if you see accesses to buffered tables. If there are, maybe it is related to the type of sql statement , e.g. it could be with explicit "bypass buffer" or with options like "order by", "group by" and so on which bypass the table buffers too.

http://help.sap.com/saphelp_nw2004s/helpdata/en/aa/4734a00f1c11d295380000e8353423/content.htm

Best Regards,

Sylvia

[Former Member]

Hi

Which param in st02 showing low hit ratio

Regards

Arun.H

[rajesh_kumar71]

Hi ,

As you mentioned , are you facing performance issue ? Check the R/3 login possible ex.r3trans , Dpmon - check the work process statistics, DB02 - check the table space , ST04 ,ST01 ,ST30 specific DB checks , if the DB connection is hanging then check DB level login is possible ?

regards,

S.Rajeshkumar