Setting Automatic Degree of Parallelism Using ALTER SESSION Statements

You can set the DOP using an ALTER SESSION statement, as in the following:

ALTER SESSION SET parallel_degree_policy = limited;

ALTER TABLE employees parallel degree;