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