You enabled auto degree of parallelism (DOP) for your instance. Examine the query: Which two are true about the execution of this query?

Question

Exhibit

Options

• AIf the execution time is less than the threshold limit, the SQL statement is run serially.
• BIf the execution time is greater than the threshold limit, the statement is run in parallel based on
• CDOP is calculated automatically.
• DCalculated DOP will always by 2 or more.
• EThe statement will execute with auto DOP only when PARALLEL_DEGREE_POLICY is set to AUTO.

• A
  4% (2)
• B
  5% (3)
• C
  76% (42)
• E
  15% (8)

Explanation

C: * You can use the PARALLEL hint to force parallelism. It takes an optional parameter: the DOP at which the statement should run. In addition, theNO_PARALLEL hint overrides a PARALLEL parameter in the DDL that created or altered the table. The following example illustrates computing the DOP the statement should use: Not A: to override the dictionary dop, we could use hints at object level Not E: statement hints override the PARALLEL_DEGREE_POLICY. * Automatic Parallel Degree Policy When the parameter PARALLEL_DEGREE_POLICY is set to AUTO, Oracle Database automatically decides if a statement should execute in parallel or not and what DOP it should use. Oracle Database also determines if the statement can be executed immediately or if it is queued until more system resources are available. Finally, Oracle Database decides if the statement can take advantage of the aggregated cluster memory or not. The following is a summary of parallel statement processing when parallel degree policy is set to 1. A SQL statement is issued. 2. The statement is parsed and the optimizer determines the execution plan. 3. The threshold limit specified by the PARALLEL_MIN_TIME_THRESHOLD initialization parameter is checked. the DOP that the optimizer calculates.

No community discussion yet for this question.