Updating window weight
You can also grant the to users and to applications so that they can switch their sessions from one consumer group to another.
You can create hierarchical plans with any number of subplans.See "The Types of Resources Managed by the Resource Manager" for more information.In addition to the resource plans that are predefined for each Oracle database, you can create any number of resource plans.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.There is a parent-child relationship between a resource plan and its resource plan directives.
Each directive references one consumer group, and no two directives for the currently active plan can reference the same consumer group.
In an environment with multiple concurrent user sessions that run jobs with differing priorities, all sessions should not be treated equally.
The Resource Manager enables you to classify sessions into groups based on session attributes, and to then allocate resources to those groups in a way that optimizes hardware utilization for your application environment.
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 initial consumer group of a session is determined by the mapping rules that you configure.