scrip to check the Progress of the SQL Tuning Advisor job in oracle database?

You can check the execution progress of the SQL Tuning Advisor in the V$ADVISOR_PROGRESS view.


SELECT sofar, totalwork FROM V$ADVISOR_PROGRESS
WHERE user_name = <USER_NAME>' AND task_name = '<sql_tuning_task_NAME>';