../E40402-16.epub /> ../E40402-16.mobi />

PARALLEL_MIN_TIME_THRESHOLD

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