Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

PARALLEL_DEGREE_POLICY

Property Description
Parameter type String
Syntax PARALLEL_DEGREE_POLICY = { MANUAL | LIMITED | AUTO }
Default value MANUAL
Modifiable ALTER SESSION, ALTER SYSTEM
Basic No

PARALLEL_DEGREE_POLICY specifies whether or not automatic degree of Parallelism, statement queuing, and in-memory parallel execution will be enabled.

Values:

Note:

Automatic degree of parallelism will be enabled regardless of the value of PARALLEL_DEGREE_POLICY if a PARALLEL hint is used at the SQL statement level.

See Also: