Hey Tim
The code does not do anything active, but we run backup 4 times a day.
I have tried batching the delete, so that one batch runs in a autonomous
transaction, and made at count on the table after each batch, but with no luck.
The idea was to reduce the number of deleted rows that the garbage collector
should process.
v_deletedcnt = 1000;
while (:v_deletedcnt = 1000) do
begin
in autonomous transaction do
begin
delete from requests where created < :delete_all_before rows 1000;
v_deletedcnt = row_count;
select count(*) from requests into :TEMP_CNT;
end
end
