Skip to Content
0
Former Member
Mar 23, 2009 at 07:39 AM

Diagnosis of the expensive ABAP programs having database time > 90%

580 Views

Hullo,

We have an issue with the Production server running very slow. On diagnosis through ST03N we found out that the database time in percentile for the total response time is 50%. Eg if response time for a task is 100 then 50 % of the time is spent in the database.

Details of my environment:

SAP ECC 6.0

AIX 5.3

Oracle 10g

Through further diagnosis ST03N we sorted out several Z* (custom) programs that have database time between 97% to 99%. Now my confusion is that can this be possible ? or am I getting wrong statistics. If these are correct statistics then how can all the other reponse times(wait time, cu time, roll time etc) be within 1% and database time is 99%.

Also how can I further troubleshoot this, because as I understand this could be an issue with expensive SQL statements / bad programming of the ABAP programs.

Experts please suggest !

Thank you,

Kind regards,

Zaheer Shaikh