SYS.DBMS_FEATURE_AUTOSTA dependencies on DBA_ADVISOR_EXECUTIONS

Line 31: FROM dba_advisor_executions

27:
28: -- execs since last sample
29: SELECT count(*)
30: INTO execs_since_sample
31: FROM dba_advisor_executions
32: WHERE task_name = asqlt_task_name AND
33: execution_last_modified >= (SELECT nvl(max(last_sample_date),
34: sysdate-7)
35: FROM dba_feature_usage_statistics);

Line 40: FROM dba_advisor_executions

36:
37: -- total # of executions
38: SELECT count(*)
39: INTO total_execs
40: FROM dba_advisor_executions
41: WHERE task_name = asqlt_task_name;
42:
43: -- #execs with auto implement ON
44: SELECT count(*)