H.2.1.3.3 AUTO

When the PARALLEL_DEGREE_POLICY option in the FSI_PARALLEL_PARAMETERS table is set to AUTO, the engine will begin each rule by issuing the following statement:

ALTER SESSION SET PARALLEL_DEGREE_POLICY = 'AUTO';

Under the AUTO policy, the automatic Degree of Parallelism, statement queuing, and in-memory parallel execution features are all enabled. Under this policy, the Oracle database automatically decides if a statement should execute in parallel or not and what Degree of Parallelism it should use. The database also determines if you can execute the statement immediately or if it should be queued until more system resources are available. Finally, the database decides if the statement can take advantage of the aggregated cluster memory or not. For more details, see the documentation resources as follows.