Search Results set_cdb_setting

Overview

SYS.DBMS_WLM is an Oracle Database-supplied PL/SQL package that exposes the Database Resource Manager and Workload Manager (WLM) control interfaces to calling sessions. Within Oracle E-Business Suite 12.1.1 and 12.2.2, the package is not an EBS-authored API. It is a kernel-level utility invoked indirectly when EBS internal services or database administration routines need to define, submit, validate, and remove Workload Manager plans and their associated classifier and consumer-group mappings. Its presence in the ETRM inventory reflects the fact that EBS schemas can reference SYS-owned packages through public or private synonyms, and that certain resource-governance operations performed during EBS installation, cloning, or tuning require the WLM plan management capabilities the package provides.

Key Procedures and Functions

The documented interface groups into several functional clusters. Plan lifecycle procedures manage the overall WLM plan: CREATE_WLMPLAN instantiates a plan for a given number of classifiers; SUBMIT_WLMPLAN activates it; DELETE_WLMPLAN, ABORT_WLMPLAN, and CHECK_WLMPLAN remove, terminate, or validate an existing plan.

Classifier and planning-set management is handled by ADD_WLMCLASSIFIERS, SUBMIT_WLM_PCS (SUBMIT_WLMPCS), and SUBMIT_WLMPCINFO, which attach classifiers, planning sets, and planning-set information to a plan in a defined order sequence.

Resource Manager enablement and mapping procedures include CHECK_RM_PLAN, CHECK_RM_ENABLE, SET_RM_PLAN, SET_PDB_RM_PLAN, and SET_DBI_RM_PLAN. These verify plan availability, confirm that Resource Manager is enabled, and bind a plan at the container, pluggable database, or database-instance level.

Consumer-group mapping maintenance is performed by DELETE_CG_MAPPINGS, UPDATE_CG_MAPPINGS, and UP_CG_MAPS, which manipulate the mapping tables shared with DBMS_RMIN.

Multi-tenant and capacity reporting functions include GET_PDB_INFO, GET_CDB_SETTING, SET_CDB_SETTING, GET_CPU_COUNT, SET_CPU_COUNT, GET_CAPABILITIES, GET_PO_MULTIPLIER, and SET_PO_MULTIPLIER. These report pluggable database counts, CDB-level settings, physical and logical CPU counts, package capability versions, and parallel-degree multipliers.

Tables Accessed

The ETRM metadata for this package lists no referenced application tables. DBMS_WLM operates on Data Dictionary and internal fixed objects rather than on EBS application tables. Consumer-group mapping operations interact with the structures underlying DBMS_RMIN, and plan submission updates Resource Manager plan definitions held in the SYS schema. No APPS synonyms to EBS tables are documented as being read or written by this package.

Usage Notes

Because the package is owned by SYS, EBS custom code should not invoke it directly against application data. It is normally exercised by database administrators through SQL*Plus or by DBA scripts during resource-plan configuration, database consolidation, or multitenant setup, not by EBS concurrent programs or forms. The package defines a series of named error constants, including err_null_num_classifiers, err_null_wlm_classifiers, err_no_new_cls_list, err_plan_in_transition, err_plan_not_created, err_no_classifier, and err_extra_classifiers. These are raised as standard exceptions, so calling code that requires programmatic error handling would associate them with PRAGMA EXCEPTION_INIT using the corresponding negative error numbers. No other EBS package in the inventory references DBMS_WLM, confirming its role as an isolated infrastructure utility rather than an integration point.