How to execute any DML statement in Parallel mode??
(1) ALTER SESSION ENABLE PARALLEL DML;
(2) Apply Parallel(table_name, parallel_degree) in hint. You can see three new clumns (TQ, IN-OUT, PQ Distribut) in execution plan of
“select * from table(dbms_xplan.display())”. These new columns will specify the query is running in parallel mode.