Oracle
1Z0-117 · Question #126
Examine the parallelism parameter for your instance: parallel_servers_target Now examine the resource plan containing parallel statement directives: Consumer Group resource plan containing parallel st
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #126. The question stem and answer options stay visible for context.
Understanding and Influencing the Optimizer
Question
Examine the parallelism parameter for your instance:
parallel_servers_target Now examine the resource plan containing parallel statement directives:
Consumer Group resource plan containing parallel statement directives:
Which two are true about parallel statement queuing when this plan is active?
Exhibits
Options
- AUrgent_group sessions collectively can consume up to 64 parallel execution servers before queuing
- BETL_GROUP sessions can collectively consume up to 64 parallel execution servers before the queuing
- CA single OTHER_GROUPS session will execute serially once it is queued for six minutes.
- DA single ETL_GROUP session can consume up to eight parallel execution servers.
- EA single ETL_GROUP session can consume up to 32 parallel execution servers.
- FA single OTHER_GROUPS session will execute in parallel once it is queued for six minutes.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#parallel statement queuing#resource manager#consumer groups#DOP limits