Validating cluster resource name Lobby chat cam
You create a resource subplan in the same way that you create a resource plan.
To create a plan that is to be used only as a subplan, you use the consumer group is ignored, and resource plan directives are not shown, even though they are part of the plan.
Oracle Database Resource Manager (the Resource Manager) enables you to manage multiple workloads within a database that are contending for system and database resources.
The following sections provide an overview of the Resource Manager: The Resource Manager helps to overcome these problems by allowing the database more control over how hardware resources are allocated.
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.
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.
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 subplan allocates its portion of the total resource allocation among its consumer groups and subplans.
You can create hierarchical plans with any number of subplans.