DECLARE
v_lower NUMBER :=1;
v_upper NUMBER :=1000000;
BEGIN
FOR i IN v_lower .. v_upper LOOP
DBMS_LOCK.SLEEP(1);
insert into sp
select (select count(0) from v$session) s,(select count(0) from v$process) p,sysdate d from dual;
commit;
END LOOP;
v_lower NUMBER :=1;
v_upper NUMBER :=1000000;
BEGIN
FOR i IN v_lower .. v_upper LOOP
DBMS_LOCK.SLEEP(1);
insert into sp
select (select count(0) from v$session) s,(select count(0) from v$process) p,sysdate d from dual;
commit;
END LOOP;
END;
/