Oracle Database Resource Manager Reference

The following sections provide reference information for Oracle Database Resource Manager (the Resource Manager):

Predefined Resource Plans and Consumer Groups
DBMS_RESOURCE_MANAGER Package Procedures Summary
Resource Manager Data Dictionary Views

Predefined Resource Plans and Consumer Groups

Table 25-1 lists the resource plans and Table 25-2 lists the resource consumer groups that are predefined for each Oracle database.

Table 25-1 Predefined Resource Plans

Resource Plan	Description
`DEFAULT_MAINTENANCE_PLAN`	Default plan for maintenance windows. See "About Resource Allocations for Automated Maintenance Tasks" for details of this plan.
`DEFAULT_PLAN`	Basic default plan that prioritizes `SYS_GROUP` operations and allocates minimal resources for automated maintenance and diagnostics operations.
`INTERNAL_PLAN`	For disabling the resource manager. For internal use only.
`INTERNAL_QUIESCE`	For quiescing the database. This plan cannot be activated directly. To activate, use the `QUIESCE` command.
`MIXED_WORKLOAD_PLAN`	Example plan for a mixed workload that prioritizes interactive operations over batch operations. See "An Oracle-Supplied Mixed Workload Plan" for details.
`ORA$AUTOTASK_HIGH_SUB_PLAN`	Default sub-plan for high-priority, automated maintenance tasks. This sub-plan is referenced by `ORA$AUTOTASK_SUB_PLAN` and should not be referenced directly. This plan is a sub-plan of `DEFAULT_MAINTENANCE_PLAN`.
`ORA$AUTOTASK_SUB_PLAN`	Default sub-plan for automated maintenance tasks. A directive to this sub-plan should be included in every top-level plan to manage the resources consumed by the automated maintenance tasks. This plan is a sub-plan of `DEFAULT_MAINTENANCE_PLAN`.

Table 25-2 Predefined Resource Consumer Groups

Resource Consumer Group	Description
`BATCH_GROUP`	Consumer group for batch operations.
`DEFAULT_CONSUMER_GROUP`	Initial consumer group for all sessions started by user accounts other than `SYS` and `SYSTEM`. This initial consumer group can be overridden by session-to–consumer group mapping rules. `DEFAULT_CONSUMER_GROUP` cannot be named in a resource plan directive.
`INTERACTIVE_GROUP`	Consumer group for interactive, OLTP operations.
`LOW_GROUP`	Consumer group for low-priority sessions.
`ORA$DIAGNOSTICS`	Consumer group used by database processes that create diagnostic dumps when critical errors occur.
`ORA$AUTOTASK_HEALTH_GROUP`	Reserved for future use. Included in `ORA$AUTOTASK_HIGH_SUB_PLAN`.
`ORA$AUTOTASK_MEDIUM_GROUP`	Consumer group for medium-priority maintenance tasks.
`ORA$AUTOTASK_SPACE_GROUP`	Consumer group for Automatic Segment Advisor maintenance task. Included in `ORA$AUTOTASK_HIGH_SUB_PLAN`.
`ORA$AUTOTASK_SQL_GROUP`	Consumer group for Automatic SQL Tuning Advisor maintenance task. Included in `ORA$AUTOTASK_HIGH_SUB_PLAN`.
`ORA$AUTOTASK_STATS_GROUP`	Consumer group for optimizer statistics gathering maintenance task. Included in `ORA$AUTOTASK_HIGH_SUB_PLAN`.
`ORA$AUTOTASK_URGENT_GROUP`	Consumer group for urgent maintenance tasks.
`OTHER_GROUPS`	Consumer group that applies collectively to all sessions that belong to a consumer group that is not part of the currently active plan, including sessions that belong to `DEFAULT_CONSUMER_GROUP`. `OTHER_GROUPS` must have a resource plan directive specified in every plan. It cannot be explicitly assigned to sessions through mapping rules.
`SYS_GROUP`	Consumer group for system administrators. It is the initial consumer group for all sessions created by user accounts `SYS` or `SYSTEM`. This initial consumer group can be overridden by session-to–consumer group mapping rules.

DBMS_RESOURCE_MANAGER Package Procedures Summary

Table 25-3 summarizes the procedures in the DBMS_RESOURCE_MANAGER package. You must have the ADMINISTER_RESOURCE_MANAGER privilege to run these procedures.

Table 25-3 DBMS_RESOURCE_MANAGER Package Procedures

Procedure	Description
`CREATE_SIMPLE_PLAN`	Creates a simple resource plan, containing up to eight consumer groups, in one step. This is the quickest way to get started with Oracle Database Resource Manager.
`CREATE_PLAN`	Creates a resource plan and specifies its allocation methods.
`UPDATE_PLAN`	Updates a resource plan.
`DELETE_PLAN`	Deletes a resource plan and its directives.
`DELETE_PLAN_CASCADE`	Deletes a resource plan and all of its descendents.
`CREATE_CONSUMER_GROUP`	Creates a resource consumer group.
`UPDATE_CONSUMER_GROUP`	Updates a consumer group.
`DELETE_CONSUMER_GROUP`	Deletes a consumer group.
`CREATE_PLAN_DIRECTIVE`	Specifies the resource plan directives that allocate resources to resource consumer groups or subplans in a plan.
`UPDATE_PLAN_DIRECTIVE`	Updates plan directives
`DELETE_PLAN_DIRECTIVE`	Deletes plan directives
`CREATE_PENDING_AREA`	Creates a pending area (scratch area) within which changes can be made to a plan schema
`VALIDATE_PENDING_AREA`	Validates the pending changes to a plan schema
`CLEAR_PENDING_AREA`	Clears all pending changes from the pending area
`SUBMIT_PENDING_AREA`	Submits all changes for a plan schema
`SET_INITIAL_CONSUMER_GROUP`	Sets the initial consumer group for a user. This procedure has been deprecated. Oracle recommends that you use the `SET_CONSUMER_GROUP_MAPPING` procedure to specify the initial consumer group for a user or session.
`SWITCH_CONSUMER_GROUP_FOR_SESS`	Switches the consumer group of a specific session
`SWITCH_CONSUMER_GROUP_FOR_USER`	Switches the consumer group of all sessions belonging to a specific user
`SWITCH_PLAN`	Sets the current resource manager plan.
`SET_CONSUMER_GROUP_MAPPING`	Maps sessions to consumer groups
`SET_CONSUMER_GROUP_MAPPING_PRI`	Establishes session attribute mapping priorities

Resource Manager Data Dictionary Views

Table 25-4 lists views that are associated with the Resource Manager.

Table 25-4 Resource Manager Data Dictionary Views

View	Description
`DBA_RSRC_CONSUMER_GROUP_PRIVS` `USER_RSRC_CONSUMER_GROUP_PRIVS`	`DBA` view lists all resource consumer groups and the users and roles to which they have been granted. `USER` view lists all resource consumer groups granted to the user.
`DBA_RSRC_CONSUMER_GROUPS`	Lists all resource consumer groups that exist in the database.
`DBA_RSRC_MANAGER_SYSTEM_PRIVS` `USER_RSRC_MANAGER_SYSTEM_PRIVS`	`DBA` view lists all users and roles that have been granted Resource Manager system privileges. `USER` view lists all the users that are granted system privileges for the `DBMS_RESOURCE_MANAGER` package.
`DBA_RSRC_PLAN_DIRECTIVES`	Lists all resource plan directives that exist in the database.
`DBA_RSRC_PLANS`	Lists all resource plans that exist in the database.
`DBA_RSRC_GROUP_MAPPINGS`	Lists all of the various mapping pairs for all of the session attributes.
`DBA_RSRC_MAPPING_PRIORITY`	Lists the current mapping priority of each attribute.
`DBA_HIST_RSRC_PLAN`	Displays historical information about resource plan activation. This view contains AWR snapshots of `V$RSRC_PLAN_HISTORY`.
`DBA_HIST_RSRC_CONSUMER_GROUP`	Displays historical statistical information about consumer groups. This view contains AWR snapshots of `V$RSRC_CONS_GROUP_HISTORY`.
`DBA_USERS` `USERS_USERS`	`DBA` view contains information about all users of the database. It contains the initial resource consumer group for each user. `USER` view contains information about the current user. It contains the current user's initial resource consumer group.
`V$ACTIVE_SESS_POOL_MTH`	Displays all available active session pool resource allocation methods.
`V$PARALLEL_DEGREE_LIMIT_MTH`	Displays all available parallel degree limit resource allocation methods.
`V$QUEUEING_MTH`	Displays all available queuing resource allocation methods.
`V$RSRC_CONS_GROUP_HISTORY`	For each entry in the view `V$RSRC_PLAN_HISTORY`, contains an entry for each consumer group in the plan showing the cumulative statistics for the consumer group.
`V$RSRC_CONSUMER_GROUP`	Displays information about active resource consumer groups. This view can be used for tuning.
`V$RSRC_CONSUMER_GROUP_CPU_MTH`	Displays all available CPU resource allocation methods for resource consumer groups.
`V$RSRCMGRMETRIC`	Displays a history of resources consumed and cumulative CPU wait time (due to resource management) per consumer group for the past minute.
`V$RSRCMGRMETRIC_HISTORY`	Displays a history of resources consumed and cumulative CPU wait time (due to resource management) per consumer group for the past hour on a minute-by-minute basis. If a new resource plan is enabled, the history is cleared.
`V$RSRC_PLAN`	Displays the names of all currently active resource plans.
`V$RSRC_PLAN_CPU_MTH`	Displays all available CPU resource allocation methods for resource plans.
`V$RSRC_PLAN_HISTORY`	Shows when Resource Manager plans were enabled or disabled on the instance. It helps you understand how resources were shared among the consumer groups over time.
`V$RSRC_SESSION_INFO`	Displays Resource Manager statistics for each session. Shows how the session has been affected by the Resource Manager. Can be used for tuning.
`V$SESSION`	Lists session information for each current session. Specifically, lists the name of the resource consumer group of each current session.