PARALLEL_DEGREE_POLIC

The initialization parameter PARALLEL_DEGREE_POLICY controls whether automatic degree of parallelism (DOP), parallel statement queuing, and in-memory parallel execution are enabled. This parameter has three possible values:

• MANUAL - Disables automatic DOP, statement queuing and in-memory parallel execution. It reverts the behavior of parallel execution to what it was previous to Oracle Database 11g, Release 2 (11.2), which is the default.

• LIMITED - Enables automatic DOP for some statements but parallel statement queuing and in-memory parallel execution are disabled. Automatic DOP is applied only to statements that access tables or indexes declared explicitly with the PARALLEL clause. Tables and indexes that have a DOP specified use that explicit DOP setting

• AUTO - Enables automatic DOP, parallel statement queuing, and in-memory parallel execution.
  
  
   manual        關閉 AUTO DOP,使用預設的並行引數。
   limited         限制方式，表是使用oracle預設並行度時，oracle會根據資源負載自動評估調整並行度。
   auto            自動方式，auto DOP 針對所有的表。
  
  

  Database VLDB and Partitioning Guide
   Using Parallel Execution