[Oracle] Parallel DML (Insert)

Oracle Parallel Insert 처리시 참고

 

ALTER SESSION FORCE PARALLEL DML PARALLEL 4;
ALTER SESSION FORCE PARALLEL QUERY PARALLEL 4;
 
INSERT /*+ ENABLE_PARALLEL_DML APPEND FULL(A) PARALLEL(A 4) */ INTO SAMPLE_T1 A
SELECT /*+ FULL(B) PARALLEL(B 4) */ * FROM SAMPLE_T B
;
 
COMMIT;

 

CREATE TABLE ITEMS_20221020 AS SELECT * FROM ITEMS WHERE 1 = 2;
 
ALTER TABLE ITEMS_20221020  NOLOGGING;
 
ALTER SESSION ENABLE PARALLEL DML;
 
INSERT /*+ ENABLE_PARALLEL_DML APPEND FULL(A) PARALLEL(A 4) */ INTO ITEMS_20221020 A
SELECT /*+ FULL(B) PARALLEL(B 4) */ * FROM ITEMS B
;
 
COMMIT;