【SQL开源代码栏目提醒】:本文主要为网学会员提供27.5.2.4.5.sql,希望对需要27.5.2.4.5.sql网友有所帮助,学习一下!
--在V$ADVISOR_PROGRESS视图中检查SQL调整顾问的执行进展情况
SELECT sofar, totalwork
FROM V$ADVISOR_PROGRESS
WHERE username = 'HR' AND
task_id = (SELECT task_id
FROM USER_ADVISOR_TASKS
WHERE task_name = 'my_sql_tuning_task');