Tag Archives: sql tuning task

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

Many 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 Task DECLARE my_task_name VARCHAR2(30); BEGIN my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK( … Continue reading How to run sql tuning advisor for particular sql -id in the Cursor cache »