alter session set plsql_optimize_level=0; declare l_sid number; begin select sid into l_sid from v$mystat where rownum = 1; while true loop execute immediate 'insert into t values('||to_char(l_sid)||')'; execute immediate 'commit'; execute immediate 'delete from t where a = '||to_char(l_sid); execute immediate 'commit'; end loop; end; /