DBA Data[Home] [Help]

SYS.DBMS_FEATURE_AUTOSTA dependencies on DBA_ADVISOR_OBJECTS

Line 64: dba_advisor_objects o,

60: INTO savedsecs
61: FROM (SELECT nvl(o.attr8, 0) before_usec,
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