可以在线做,不需要停业务 (Doc ID 2354960.1)
1. Disable future monitoring:
alter system set "_column_tracking_level"=17 scope=both;
--wait 10 minutes
2. To purge data from tables:
exec DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO(); --执行时间比较久(30分钟左右)
truncate table sys.exp_head$ drop storage;
truncate table sys.exp_obj$ drop storage;
truncate table sys.exp_stat$ drop storage;
alter index SYS.I_EXP_HEAD$ rebuild tablespace sysaux online;
alter index SYS.I_EXP_STAT$ rebuild tablespace sysaux online;
alter index SYS.I_EXP_OBJ$ rebuild tablespace sysaux online;
3.To re-enable expression statistics monitoring later :
alter system set "_column_tracking_level"=21 scope=both; --非oracle19c 执行这条
Starting in 19c we would change this to 53 since that is the default value for this version higher.
alter system set "_column_tracking_level"=53 scope=both; --oracle 19c需要执行这条