Oracle 12c : ENABLE_PARALLEL_DML / DISABLE_PARALLEL_DML Hint

Prior to Oracle 12c if we want to execute DML statement in parallel then we have explicitly enable the Parallel DML at session as given below.

ALTER SESSION ENABLE PARALLEL DML;
<<execute DML statement>>

Oracle 12c introduces new way for enabling and disabling the parallel DML at statement level. Oracle 12c introduces below two hints

1. ENABLE_PARALLEL_DML – for enabling parallel DML
2. DISABLE_PARALLEL_DML – for disabling parallel DML

We need to add above hint in DML statement as shown in the below example. This is one of the best feature of Oracle 12c.

Example:

INSERT /*+ENABLE_PARALLEL_DML parallel */ INTO TABLE_PARALLEL_TEST
SELECT * FROM TABLE_PARALLEL_TEST A;

parallel_dml

For more information visit here

Oracle 12c : ENABLE_PARALLEL_DML / DISABLE_PARALLEL_DML Hint

Leave a Reply