Conclusion


The database administrator monitors the report, to check the number if compilations and finds that, the workload modified to have parameter markers, performance as expected.

Having named parameter markers result in :



The results are displayed on the view in the right pane.

Note: Set the refresh interval on the top right pane to 5 seconds.

The database administrator has answered most of the questions posed at the start of this scenario. The only unknown question is why the system suddenly encountered this slowdown after performing normally, and what changed to trigger this problem. The database administrator contacts the application support team and finds out that an update to the application was promoted to production. Further investigation reveals that the SQL statements identified were a part of the application update and were coded by a team member not familiar with the expected coding practices.

Answers to the questions that the database administrator had for the SQL compilation problem: