declare
    counter number;
begin
counter:=0;
WHILE counter < 3 LOOP
   BVEBDEV.SMS_FILL_SMS_TABLE; --procedure
   commit;
   dbms_lock.sleep(8);
   counter:=counter+1;
END LOOP;
BVEBDEV.SMS_REFILL_SMS_TABLE; --procedure
commit;
end; rewrite for oltp database oracle 19 use transaction ускорит выполнение