create or replace procedure DELETE_DATA(v in varchar2) is
begin
for i in 1..2647 loop
begin
delete from cert t where ROWNUM <=10000 and substr(key_id,0,8)='955661AA';
commit;
end;
end loop;
end DELETE_DATA;
共计删除2647w条数据
如果一块delete的话回归日志将会填满空间,日志空间是环形的,如果有commit就不会被填满,由于delete一次的话commit就一次,也就是一直没有机会清理环形日志