Initialization Parameters, 135 of 188

PARALLEL_AUTOMATIC_TUNING

Parameter type:	Boolean
Parameter class:	Static
Default value:	`FALSE`
Range of values:	`TRUE` \| `FALSE`
Note: This parameter applies to parallel execution in exclusive mode as well as in the Oracle Parallel Server environment.
When `PARALLEL_AUTOMATIC_TUNING` is set to `TRUE`, Oracle determines the default values for parameters that control parallel execution. In addition to setting this parameter, you must specify the `PARALLEL` clause for the target tables in the system. Oracle then tunes all subsequent parallel operations automatically.
If you used parallel execution in a previous release and are now enabling `PARALLEL_AUTOMATIC_TUNING`, you should reduce the amount of memory allocated from the shared pool to account for the decreased demand on that pool. This memory will be now be allocated from the large pool, and will be computed automatically if `LARGE_POOL_SIZE` is left unset.
As part of the automatic tuning, Oracle will enable the `PARALLEL_ADAPTIVE_MULTI_USER` parameter. You can override any of the system-provided defaults if desired. See Also: Oracle8i Designing and Tuning for Performance for more information on tuning parallel execution.