Resource Plans

From DBArtisan
Jump to: navigation, search

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

  1. In Resource Manager, select Consumer Group Mappings and the attribute to which you want to match.
  2. In the Properties tab, click Add.
  3. In the Consumer Group Mapping dialog box, select the appropriate Consumer Group.
  4. 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.
  5. Click OK when complete.