SYS.DBMS_FEATURE_AUTOSTA dependencies on DBA_ADVISOR_RECOMMENDATIONS

Line 54: FROM dba_advisor_recommendations r

50:
51: -- total profiles recommended so far
52: SELECT count(*)
53: INTO profs_rec
54: FROM dba_advisor_recommendations r
55: WHERE r.task_name = asqlt_task_name AND
56: r.type = 'SQL PROFILE';
57:
58: -- db time saved by AUTO impl profiles

Line 66: dba_advisor_recommendations r

62: nvl(o.attr8, 0) * (1 - r.benefit/10000) after_usec
63: FROM dba_sql_profiles sp,
64: dba_advisor_objects o,
65: dba_advisor_findings f,
66: dba_advisor_recommendations r
67: WHERE o.task_name = asqlt_task_name AND
68: o.type = 'SQL' AND
69: sp.task_id = o.task_id AND
70: sp.task_obj_id = o.object_id AND