DBA Data[Home] [Help]

SYS.DBMS_FEATURE_SEGADV_USER dependencies on WRI$_ADV_FINDINGS

Line 33: sys.wri$_adv_findings fin,

29: -- total # of recommendations and total potential space saving
30: SELECT count(task.task_id), NVL(sum(msg.p3),0)
31: INTO total_recs, total_space_saving
32: FROM dba_advisor_tasks task,
33: sys.wri$_adv_findings fin,
34: sys.wri$_adv_recommendations rec,
35: sys.wri$_adv_message_groups msg
36: WHERE task.advisor_name = 'Segment Advisor' AND
37: task.task_name not like 'SYS_AUTO_SPCADV%' AND