14.1.1.2.3 AUTO

When the PARALLEL_DEGREE_POLICY option in the FSI_OPTIMIZATION_SETTINGS 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 must execute in parallel or not and what Degree of Parallelism it must use. The database also determines if the statement can be executed immediately or if it must 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.