select dbms_stats.get_stats_history_retention from dual; exec dbms_stats.alter_stats_history_retention(3); declare v_tname varchar2(32767); begin v_tname := 'AUTO_STATS_ADVISOR_TASK'; dbms_stats.drop_advisor_task(v_tname); end; / exec dbms_stats.init_package(); alter table wri$_adv_objects move; alter index wri$_adv_objects_idx_01 rebuild; alter index wri$_adv_objects_idx_02 rebuild; alter index..