Updating a database Aduld uk cams
In the previous example, if the Instead of referencing a consumer group, a resource plan directive (directive) can reference another resource plan.
In this case, the plan is referred to as a subplan.
Each plan must include a directive that allocates resources to the consumer group named Figure 27-1 shows a simple resource plan for an organization that runs online transaction processing (OLTP) applications and reporting applications simultaneously during the daytime.
The currently active plan, Note: The currently active resource plan does not enforce allocations until CPU usage is at 100%.
Because the Resource Manager allocates resources (such as CPU) only to consumer groups, when a session becomes a member of a consumer group, its resource allocation is determined by the allocation for the consumer group.
There are special consumer groups that are always present in the data dictionary. They are: The Resource Manager allocates resources to consumer groups according to the set of resource plan directives (directives) that belong to the currently active resource plan.
To find out more about insecticides, herbicides and other pesticides select one of the choices below.
If the CPU usage is below 100%, the database is not CPU-bound and hence there is no need to enforce allocations to ensure that all sessions get their designated resource allocation.
In addition, when allocations are enforced, unused allocation by any consumer group can be used by other consumer groups.
The subplan itself has directives that allocate resources to consumer groups and other subplans.
The resource allocation scheme then works like this: The resource plan (the currently active plan) divides resources among consumer groups and subplans.