DBA Data[Home] [Help]

SYS.DBMS_FEATURE_AUTOSTA dependencies on DBA_FEATURE_USAGE_STATISTICS

Line 35: FROM dba_feature_usage_statistics);

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);
36:
37: -- total # of executions
38: SELECT count(*)
39: INTO total_execs