1 ) insert /*+ append */ into tab1 select * from hyper;
2) 减少 COMMIT 的次数
3) alter table tab1 nologging; alter table tb1 logging;
4)
INSERT ALL INTO TABLE_A(A,B) VALUES(1,2)
INTO TABLE_A(A,B) VALUES(2,3)
INTO TABLE_A(A,B) VALUES(3,4)
SELECT 1 FROM DUAL;
5) alter session enable parallel dml; alter session disable parallel dml;
ALTER TABLE T1 PARALLEL;alter table t1 noparallel;