What Is Parallel Degree Limit?

1.	What Is Parallel Degree Limit?
Answer» Parallel DEGREE limit is an allocation METHOD for degree of parallelism. It specifies the maximum degree of parallelism for an operation. It can be set using the PARALLEL_DEGREE_LIMIT_P1 parameter. The default value of this parameter is NULL which INDICATES no limit is imposed. Parallel degree limit is an allocation method for degree of parallelism. It specifies the maximum degree of parallelism for an operation. It can be set using the PARALLEL_DEGREE_LIMIT_P1 parameter. The default value of this parameter is null which indicates no limit is imposed.

Answer»

Parallel DEGREE limit is an allocation METHOD for degree of parallelism. It specifies the maximum degree of parallelism for an operation. It can be set using the PARALLEL_DEGREE_LIMIT_P1 parameter.
The default value of this parameter is NULL which INDICATES no limit is imposed.

Parallel degree limit is an allocation method for degree of parallelism. It specifies the maximum degree of parallelism for an operation. It can be set using the PARALLEL_DEGREE_LIMIT_P1 parameter.
The default value of this parameter is null which indicates no limit is imposed.

Discussion

No Comment Found

Related InterviewSolutions

Can You Import Objects From Oracle Version 7.3 To 9i?
Suppose A Column Has Many Repeated Values. Which Type Of Index You Should Create On This Column?
If A Table Has Few Rows, Should You Create Indexes On This Table?
How Do You Capture An Exception In Oracle?
What Is Recursive Sql?
What Are Different Types Of Cursors?
Can You Pivot The Results Of A Query?
What Is Null?
What Is Execute Immediate?
What Is A Database Link? What Is The Difference Between A Public And A Private Database Link? What Is A Fixed User Database Link?