create table test(a integer,b integer,c integer,d integer);
begin
for i in 1..999999999 loop
for j in 1..999999999 loop
insert into test values(i,j,i,j);
commit;
end loop;
commit;
end loop;
commit;
end;
/
测试结果:每分钟产生4个50M的归档日志,效果不错。
SQL> set linesize 180
SQL> col name for a70
SQL> select name,completion_time from v$archived_log order by 2 asc;