$ more delggsa.sql
delete from ggs_marker where sysdate - to_date(OPTIME, 'yyyy-mm-dd hh24:mi:ss') > 10;
delete from GGS_DDL_HIST where sysdate - to_date(OPTIME, 'yyyy-mm-dd hh24:mi:ss') > 10;
delete from GGS_DDL_HIST_ALT where sysdate - to_date(OPTIME, 'yyyy-mm-dd hh24:mi:ss') > 10;
commit;
execute dbms_stats.gather_table_stats(ownname => 'GGSA',tabname => 'GGS_DDL_HIST');
execute dbms_stats.gather_table_stats(ownname => 'GGSA',tabname => 'GGS_MARKER');
execute dbms_stats.gather_table_stats(ownname => 'GGSA',tabname => 'GGS_DDL_HIST_ALT');
commit;
$
ggsa的自动释放历史垃圾日志
最新推荐文章于 2021-04-05 11:15:30 发布