Tutorial Flow:




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



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.