Tag Archives: sql tuning task

How to run sql tuning advisor for particular sql -id in the Cursor cache

Last updated on November 14th, 2017 at 04:49 amMany times a sql may be running long and we may need to run sql tuning advisor to get the recommendation to resolve the long running issue.In this post, we would be looking at the steps to achieve it Steps for running¬† sql tuning ¬†advisor on the particular sql -id in the Cursor cache Create sql Tuning … Continue reading How to run sql tuning advisor for particular sql -id in the Cursor cache »