Which three tasks are performed by the parallel execution coordinator process?

Question

Options

• AAllocating parallel execution processes from the parallel execution server pool.
• BDetermining the parallel execution method for each operation in the execution plan.
• CManaging the data flow between the producers and consumers during inter-operation parallelism.
• DAny serial processing that is part of the execution plan.
• EDetermining the desired number of parallel execution processes
• FManaging the data flow between the producers and consumers during intra-operation parallelism.

• A
  74% (32)
• D
  14% (6)
• E
  7% (3)
• F
  5% (2)

Explanation

A: When executing a parallel operation, the parallel execution coordinator obtains parallel execution servers from the pool and assigns them to the operation. If necessary, Oracle Database can create additional parallel execution servers for the operation. These parallel execution servers remain with the operation throughout execution. After the statement has been processed completely, the parallel execution servers return to the pool. * The parallel execution coordinator examines each operation in a SQL statement's execution plan then determines the way in which the rows operated on by the operation must be divided or redistributed among the parallel execution servers. * After the optimizer determines the execution plan of a statement, the parallel execution coordinator determines the parallel execution method for each operation in the plan. * Oracle Database can process a parallel operation with fewer than the requested number of processes. If all parallel execution servers in the pool are occupied and the maximum number of parallel execution servers has been started, the parallel execution coordinator switches to serial

No community discussion yet for this question.