Tutorial Flow:
- Determining the problem category (completed)
- Performing detailed diagnosis of the problem
- Identifying the scope of the SQL statements involved
Performing a detailed diagnosis
The database administrator had localized the slowdown to occurring in some aspect of data server processing
before or after statement execution. The database administrator returns to the report generated
earlier to examine it in more detail, focusing on monitor data for these aspects of processing. The database
administrator compares this report to a baseline report obtained earlier during normal performance conditions.
Note: Set the refresh interval on the top right pane to 5 seconds.
Few processing time metrics for detailed aspects of data server processing before or after statement execution
- TOTAL_COMPILE_PROC_TIME (Reported value : Higher than normal)
- TOTAL_COMMIT_PROC_TIME (Normal)
This evidence suggests that SQL compilation warrants further investigation. The database administrator returns to the DBSUMMARY report to look at other metrics relevant to compilation.