查看task状态.txt

来自「在oracle中」· 文本 代码 · 共 12 行

Checking the Status of a SQL Tuning Task
You can check the status of the task by reviewing the information in the USER_ADVISOR_TASKS view 
 or check execution progress of the task in the V$SESSION_LONGOPS view. For example:

SELECT status FROM USER_ADVISOR_TASKS WHERE task_name = 'my_sql_tuning_task';

Checking the Progress of the SQL Tuning Advisor 
You can check the execution progress of the SQL Tuning Advisor in the V$ADVISOR_PROGRESS view. 
For example:

SELECT sofar, totalwork FROM V$ADVISOR_PROGRESS WHERE user_name = 'HR' AND task_name = ’my_sql_tuning_task’;
是否有user_advisor_progress这个视图?