CBO, Data Warehouse, ETL, Oracle, parallel DML, PDML, SQL, ...
Issue with the Hint ENABLE_PARALLEL_DML
Performing an ETL with large data sets, it is often a good idea to run DML in parallel. But, in contrast to parallel query or DDL, parallel DML have to be explicitly enabled. You had to issue ALTER SESSION ENABLE PARALLEL DML in the past….
Admin, 4 Jahren ago 1 min read