Examine the parallelism parameters for your instance: What are true about the execution of the query?

Question

Exhibit

Options

• AIt will execute in parallel only if the LINEITEM table has a dictionary DOP defined.
• BDOP for the statement is determined by the dictionary DOP of the accessed objects.
• CIt is generated to execute in parallel.
• DIt will execute in parallel only if the estimated execution time is 10 or more seconds.
• EDOP for the statement is calculated automatically.
• FIt may execute serially.

• A
  5% (1)
• B
  16% (3)
• C
  5% (1)
• E
  74% (14)

Explanation

F (not C): It may execute serially. See note below. A, B: Dictionary DOP not used with PARALLEL (AUTO) hint. D: The default value of parallel_min_time_threshold is 30 (not 10) seconds. * parallel_min_percent PARALLEL_MIN_PERCENT operates in conjunction with PARALLEL_MAX_SERVERS and PARALLEL_MIN_SERVERS. It lets you specify the minimum percentage of parallel execution processes (of the value of PARALLEL_MAX_SERVERS) required for parallel execution. Setting this parameter ensures that parallel operations will not execute sequentially unless adequate resources are available. The default value of 0 means that no minimum percentage of processes Consider the following settings: PARALLEL_MIN_PERCENT = 50 PARALLEL_MIN_SERVERS = 5 PARALLEL_MAX_SERVERS = 10 If 8 of the 10 parallel execution processes are busy, only 2 processes are available. If you then request a query with a degree of parallelism of 8, the minimum 50% will not be met.

No community discussion yet for this question.