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 ADAPTIVE, AUTO, or LIMITED.

If all tables referenced by a SQL statement use In-Memory Column Store (IM column store), then PARALLEL_MIN_TIME_THRESHOLD defaults to 1.