Go Up to Supported Objects
Resource plans define how database resources are allocated among resource consumer groups. Oracle databases include a number of predefined resource plans in addition to any custom plans. While there are multiple resource plans, there can be only one active resource plan at any time.
A resource plan comprises directives that manage the distribution of database resources among resource consumer groups. Directives allow you to have multiple ways to limit resource allocation for a consumer group. For example, a directive can limit the maximum execution time allowed for an operation and also automatically switch a session to from a consumer group that utilizes a high proportion of system resources to a lower priority consumer group based on the expected resource consumption for a typical session in the group.
Note that each directive within a resource plan references a single consumer group. In an active resource plan, each directive controls resource allocation for a different consumer group. In addition, each plan also must include a directive that allocates resources to all sessions belonging to a consumer group outside of the currently active plan, named OTHER_GROUPS.
About Resource Consumer Groups
A resource consumer group contains user sessions with similar processing needs. User-defined Consumer Group Mappings dictate where a session is automatically placed when it is created, although you can manually override this mapping when necessary.
The mapping rules for a session consist of a set of attribute or consumer group pairs that determine how a session is matched to a consumer group.
Add Consumer Group Mapping
To add consumer group mapping
- In Resource Manager, select Consumer Group Mappings and the attribute to which you want to match.
- In the Properties tab, click Add.
- In the Consumer Group Mapping dialog box, select the appropriate Consumer Group.
- Move the value(s) you want to include by selecting the value, and then clicking the arrow to move from one side to the other.
- Click OK when complete.