Comparison of class 2 elapsed and class 2 CPU times
The ratio of class 2 elapsed and class 2 CPU times indicates a potential problem with SQL.
If the difference between the class 2 elapsed time and class 2
CPU times is between 10% and 50% (when CL2 CPU/CL2 ELAPSED
is
greater than 0.5), the problem probably lies with SQL. Use an EXPLAIN
or SQL Activity report.
If the class 2 elapsed time is significantly greater (when CL2 CPU/CL2 ELAPSED is less than 0.5), the application is experiencing long wait times. Verify the class 3 suspension times.