1Z0-058 · Question #101
Which three statements are true about services and the Resource Manager?
The correct answer is A. The Resource Manager can manage the relative priority of services within an instance by binding B. When a client connects using a service, the service can be mapped to a consumer group, D. The Resource Manager offers benefits In managing workloads because priority is given to. A resource consumer group (consumer group) is a collection of user sessions that are grouped together based on their processing needs. When a session is created, it is automatically mapped to a consumer group based on mapping rules that you set up. As a database administrator…
Question
Which three statements are true about services and the Resource Manager?
Options
- AThe Resource Manager can manage the relative priority of services within an instance by binding
- BWhen a client connects using a service, the service can be mapped to a consumer group,
- CThe srvctl utility is used to map services to consumer groups.
- DThe Resource Manager offers benefits In managing workloads because priority is given to
How the community answered
(39 responses)- A77% (30)
- C23% (9)
Explanation
A resource consumer group (consumer group) is a collection of user sessions that are grouped together based on their processing needs. When a session is created, it is automatically mapped to a consumer group based on mapping rules that you set up. As a database administrator (DBA), you can manually switch a session to a different consumer group. Before you enable the Resource Manager, you must specify how user sessions are assigned to resource consumer groups. You do this by creating mapping rules that enable the Resource Manager to automatically assign each session to a consumer group upon session startup, based upon session attributes. Oracle Database Resource Manager (the Resource Manager) enables you to manage multiple workloads within a database that are contending for system and database resources. In addition, the Database Resource Manager can map services to consumer groups. Therefore, you can automatically manage the priority of one service relative to others. You can use consumer groups to define relative priority in terms of either ratios or resource consumption. Oracle Database Administrator's Guide
Topics
Community Discussion
5A, B, and D are your three correct answers here. The Resource Manager works hand in hand with services by letting you bind services to consumer groups (B) and then manage the relative priority of those groups within an instance (A), which is exactly how you give workload priority to the right sessions (D). Option C is the trap because srvctl handles service creation and administration in a cluster environment, not the mapping of services to consumer groups, that mapping is done through the DBMS_RESOURCE_MANAGER package.
Yep ABD, DBMS_RESOURCE_MANAGER maps consumer groups, srvctl just manages services.
Yeah A, B, and D make sense to me, my senior explained that the key thing with Resource Manager and services is that the mapping happens at the consumer group level when a client connects, not through srvctl (which is why C trips people up). srvctl handles service administration on the cluster side, but the actual workload priority binding is wired through the Resource Manager plan directives.
Solid point on the consumer group binding, though it is worth flagging that srvctl does play an indirect role here because the service-to-consumer-group mapping in the Resource Manager plan only fires correctly when the service name you defined in srvctl matches exactly what the client passes in the connect string, so a misconfigured service name is a silent failure mode that trips up a lot of candidates on exam scenarios.
Which package actually maps services to consumer groups, since srvctl cannot?