Oracle
1Z0-117 · Question #77
Examine the parallelism parameters for your instance: Examine the Exhibit to view the query and its explain plan output. All sessions use default parallelism settings. What two steps could you take…
The correct answer is A. Add a parallel hint. B. Decrease the value of PARALLEL_MIN_TIMETHRESHOLD. A: You can rely on hints to set the degree of parallelism, but these can be hard to set correctly. Decision tree for query parallelization
Understanding and Influencing the Optimizer
Question
Examine the parallelism parameters for your instance:
Examine the Exhibit to view the query and its explain plan output. All sessions use default parallelism settings. What two steps could you take to make the query execute in parallel?
Exhibits
Options
- AAdd a parallel hint.
- BDecrease the value of PARALLEL_MIN_TIMETHRESHOLD.
- CIncrease the value of PARALLEL_MIN_SERVERS.
- DIncrease the value of PARALLEL_MAX_SERVERS.
- EDecrease the value of PARALLEL_MIN_PERCENT.
How the community answered
(23 responses)- A78% (18)
- C4% (1)
- D4% (1)
- E13% (3)
Explanation
A: You can rely on hints to set the degree of parallelism, but these can be hard to set correctly. Decision tree for query parallelization
Topics
#parallel execution#PARALLEL_MIN_TIME_THRESHOLD#parallel hint#PARALLEL_MAX_SERVERS
Community Discussion
No community discussion yet for this question.