如果是从一张表拷贝到另一张表,那么用append加并行DML,不过这样在未COMMIT前会产生表级锁。例如:
begin
execute immediate 'alter session enable parallel dml';
insert /*+append parallel(4)*/ into a select * from b where ...;
end;
begin
execute immediate 'alter session enable parallel dml';
insert /*+append parallel(4)*/ into a select * from b where ...;
end;
可以考虑 修改日志模式NOLOGGING、并行、执行路径加载