SYS.DBMS_FEATURE_SEGADV_USER dependencies on DBA_FEATURE_USAGE_STATISTICS

Line 20: FROM dba_feature_usage_statistics);

16: WHERE advisor_name = 'Segment Advisor' AND
17: task_name not like 'SYS_AUTO_SPCADV%' AND
18: execution_last_modified >= (SELECT nvl(max(last_sample_date),
19: sysdate-7)
20: FROM dba_feature_usage_statistics);
21:
22: -- total # of executions
23: SELECT count(*)
24: INTO total_execs