Search Results set_initial_consumer_group
Overview
DBMS_RESOURCE_MANAGER is a server-supplied PL/SQL package owned by the SYS schema and delivered as part of the Oracle Database kernel. Within an Oracle E-Business Suite 12.1.1 or 12.2.2 environment it provides the programmatic interface to the database Resource Manager, the facility that allocates CPU and enforces session-level resource limits across competing workloads. In EBS terms, the package allows administrators and internal database components to define the policies that prevent a single runaway batch job, online report, or concurrent manager worker from monopolizing database resources and degrading interactive response time.
Although the package is not an EBS application object and carries an API classification of OTHER in the ETRM documentation, it is a foundational dependency for several database utilities shipped with the product. The ETRM dependency listing confirms that DBMS_RESOURCE_MANAGER is referenced by DBMS_AUTO_TASK_EXPORT, DBMS_PRVTRMIE, DBMS_RMIN_SYS, and DBMS_WLM, and it is exposed through a PUBLIC synonym alongside its own internal package body. This dependency chain matters to EBS administrators because automatic maintenance tasks, workload capture and replay, and internal resource manager plumbing all rely on the same underlying definitions that the package maintains.
Key Procedures and Functions
The documented interface exposes thirty-eight procedures and functions grouped around a consistent plan-and-directive model. The core lifecycle procedures operate on resource plans: CREATE_PLAN, UPDATE_PLAN, DELETE_PLAN, and DELETE_PLAN_CASCADE establish, modify, and remove the top-level allocation strategies, with the cascade variant removing dependent elements in a single call.
- Plan construction: CREATE_PENDING_AREA, CLEAR_PENDING_AREA, VALIDATE_PENDING_AREA, and SUBMIT_PENDING_AREA form the mandatory staging workflow. All structural changes are made in a pending area, validated for consistency, and only then submitted to the active data dictionary.
- Consumer groups: CREATE_CONSUMER_GROUP, UPDATE_CONSUMER_GROUP, and DELETE_CONSUMER_GROUP define the classes of sessions to which resources are allocated, such as OLTP users versus batch workers.
- Directives: CREATE_PLAN_DIRECTIVE, UPDATE_PLAN_DIRECTIVE, and DELETE_PLAN_DIRECTIVE attach allocation percentages and limits to a given consumer group within a named plan.
- Categories: CREATE_CATEGORY, UPDATE_CATEGORY, and DELETE_CATEGORY define groupings used when mapping sessions to consumer groups.
- Session mapping: SET_CONSUMER_GROUP_MAPPING and SET_CONSUMER_GROUP_MAPPING_PRI establish and prioritize the rules that assign a connecting session to a consumer group, while SET_INITIAL_CONSUMER_GROUP assigns the default group for a user.
Tables Accessed
The ETRM metadata does not enumerate specific base tables for this package, which is expected because DBMS_RESOURCE_MANAGER maintains the database's own resource manager dictionary rather than EBS application tables. Its operations persist definitions that are surfaced through the standard data dictionary views for the Resource Manager, and the pending-area mechanism means changes are held, validated, and then materialized as a coherent plan set rather than written piecemeal. No APPS synonyms are documented against this package, reinforcing that it acts purely at the database layer and does not touch EBS transactional or setup tables.
Usage Notes
DBMS_RESOURCE_MANAGER is normally invoked by a DBA or by internal database packages rather than from EBS forms or concurrent programs. EBS customers typically interact with it indirectly, either through database tooling that manages resource plans or through the automatic maintenance infrastructure that depends on it. When tuning an EBS instance, administrators should recognize that any change to a resource plan affects all sessions on the database, including EBS concurrent managers and online users, and should therefore be staged, validated, and submitted through the pending-area procedures during a controlled maintenance window.