Thursday, March 19, 2015

12c: New hint to enable statement level Parallel DML

You may be familiar with Degree of Parallelism or Auto Degree of Parallelism (ADoP) settings for your instance, but did you know that 12c introduces a new way of using parallelism?  The My Oracle Support document "New 12c Hint: ENABLE_PARALLEL_DML Lets you Easily Enable Parallel DML (PDML) at the Statement Level" from note ID 1991034.1 introduces this new option for you with a very simple example of a table being loaded with and without this enabled so you can see it in action.  Even though the article linked at the end is for DW, there could be reasons to use this in your OLTP installation!

No comments:

Post a Comment