| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | PARALLEL_MIN_TIME_THRESHOLD = { AUTO | integer } |
| Default value | AUTO |
| Modifiable | ALTER SESSION, ALTER SYSTEM |
| Basic | No |
PARALLEL_MIN_TIME_THRESHOLD specifies the minimum execution time a statement should have before the statement is considered for automatic degree of parallelism. By default, this is set to 10 seconds. Automatic degree of parallelism is only enabled if PARALLEL_DEGREE_POLICY is set to AUTO or LIMITED.
See Also:
Oracle Database VLDB and Partitioning Guide for information about automatic degree of parallelism