【wri$_adv_objects】清理 19C

select count(*) from wri$_adv_objects where task_id=(select distinct id from wri$_adv_tasks where name='AUTO_STATS_ADVISOR_TASK');
 
create table wri$_adv_objects_new as select * from wri$_adv_objects where task_id !=(select distinct id from wri$_adv_tasks where name='AUTO_STATS_ADVISOR_TASK');

select count(*) from wri$_adv_objects_new;
 
truncate table wri$_adv_objects;

insert /*+ APPEND */ into wri$_adv_objects(ID,TYPE,TASK_ID,EXEC_NAME,ATTR1,ATTR2,ATTR3,ATTR4,ATTR5 ,ATTR6,ATTR7,ATTR8 ,ATTR9 ,ATTR10,ATTR11,ATTR12 ,ATTR13,ATTR14,ATTR15,ATTR16,
 ATTR17,ATTR18,ATTR19,ATTR20,OTHER ,SPARE_N1,SPARE_N2 ,SPARE_N3 ,SPARE_N4,SPARE_C1,SPARE_C2  ,SPARE_C3 ,SPARE_C4) select ID,TYPE,TASK_ID,EXEC_NAME,ATTR1,ATTR2,ATTR3,ATTR4,ATTR5 ,ATTR6,ATTR7,ATTR8 ,ATTR9 ,ATTR10,ATTR11,ATTR12 ,ATTR13,ATTR14,ATTR15,ATTR16,
 ATTR17,ATTR18,ATTR19,ATTR20,OTHER ,SPARE_N1,SPARE_N2 ,SPARE_N3 ,SPARE_N4,SPARE_C1,SPARE_C2  ,SPARE_C3 ,SPARE_C4 from wri$_adv_objects_new;
commit;
drop table wri$_adv_objects_new;

alter index wri$_adv_objects_idx_01 rebuild;

alter index wri$_adv_objects_pk rebuild;

EXEC dbms_stats.init_package();