SYS.DBMS_FEATURE_SEGADV_USER dependencies on DBA_ADVISOR_EXECUTIONS

Line 15: FROM dba_advisor_executions

11: BEGIN
12: -- executions since last sample
13: SELECT count(*)
14: INTO execs_since_sample
15: FROM dba_advisor_executions
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)

Line 25: FROM dba_advisor_executions

21:
22: -- total # of executions
23: SELECT count(*)
24: INTO total_execs
25: FROM dba_advisor_executions
26: WHERE advisor_name = 'Segment Advisor' AND
27: task_name not like 'SYS_AUTO_SPCADV%';
28:
29: -- total # of recommendations and total potential space saving