New 12c Hint: ENABLE_PARALLEL_DML Lets you Easily Enable Parallel DML (PDML) at the Statement Level
(Doc ID 1991034.1)
Last updated on FEBRUARY 21, 2023
Oracle Database - Enterprise Edition - Version 22.214.171.124 and later PeopleSoft Enterprise PT PeopleTools - Version 8.55 to 8.55 [Release 8.4] Information in this document applies to any platform.
Parallel DML (PDML) must be explicitly enabled in order for DML to be considered for parallel execution. In RDBMS versions lower than 12c, you could accomplish this only at the session level by using an ALTER SESSION statement. Assuming restrictions on parallel DML do not apply to your situation, once the session is altered, all further statements in the session will be candidates for execution of DML in parallel.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!