Search Results dbms_rmin

Overview

SYS.DBMS_RMIN is an Oracle-supplied PL/SQL package that resides in the SYS schema and provides the internal runtime management infrastructure for the Oracle Database Resource Manager. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, the package is not an EBS application object but a core database component on which EBS depends. Its business function is to support the enforcement of resource allocation policies—such as CPU, parallel execution, and session limits—that the database applies to EBS workload. This is particularly relevant in EBS environments where the concurrent manager, online forms sessions, and Oracle Applications database accounts compete for finite server resources. The ETRM metadata classifies DBMS_RMIN as an OTHER API with owner SYS and status VALID, confirming it is a functioning database-resident package rather than a deprecated or invalid object. Because Resource Manager policies are frequently used to protect interactive EBS users from long-running batch jobs, DBMS_RMIN is indirectly tied to EBS performance and stability.

Key Procedures and Functions

The documented ETRM metadata for SYS.DBMS_RMIN lists zero procedures or functions exposed in the ETRM registry. This reflects the fact that DBMS_RMIN is an internal implementation package: its callable units are not intended for direct invocation by EBS developers or DBAs. Its routines manipulate resource manager state and are invoked on behalf of the public-facing packages that wrap it. Parameter lists are intentionally not enumerated here, as the metadata does not document them and they must not be inferred. Administrators and developers requiring resource manager operations should use the documented public interfaces—DBMS_RESOURCE_MANAGER and DBMS_RESOURCE_MANAGER_PRIVS—which delegate to DBMS_RMIN internally.

Tables Accessed

The ETRM metadata does not document specific tables accessed by DBMS_RMIN via APPS synonyms. As an internal package, it operates primarily on data dictionary and fixed resource manager objects that back the resource plan configuration. No application-owned tables are recorded, which is consistent with its SYS ownership and database-level scope. EBS application tables are not read or written by this package.

Usage Notes

DBMS_RMIN is not invoked directly from EBS forms, concurrent programs, or custom code. It is reached indirectly whenever Resource Manager operations are performed through the public API packages. The dependency metadata shows that DBMS_RMIN is referenced by DBMS_RESOURCE_MANAGER, DBMS_RESOURCE_MANAGER_PRIVS, DBMS_RMIN_SYS, and DBMS_WLM, and that it depends on STANDARD and the SYS schema. In practice, a DBA administering an EBS database configures resource plans and consumer groups using DBMS_RESOURCE_MANAGER; those calls flow to DBMS_RMIN for execution. Custom EBS code should never call DBMS_RMIN directly, as its interface is unsupported and subject to change across database versions. Its presence and VALID status in ETRM simply confirm that the resource management infrastructure required by the EBS database stack is intact.

PACKAGE: SYS.DBMS_RMIN 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_RMIN, status:VALID,
PACKAGE: SYS.DBMS_RMIN 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_RMIN, status:VALID,
PACKAGE BODY: SYS.DBMS_RMIN 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RMIN, status:VALID,
SYNONYM: PUBLIC.DBMS_RMIN 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_RMIN, status:VALID,
SYNONYM: PUBLIC.DBMS_RMIN 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_RMIN, status:VALID,
PACKAGE BODY: SYS.DBMS_RMIN 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RMIN, status:VALID,
PACKAGE: SYS.DBMS_RMIN 12.1.1
PACKAGE BODY: SYS.DBMS_RMIN 12.1.1
LIBRARY: SYS.DBMS_RMGR_LIB 12.2.2
owner:SYS, object_type:LIBRARY, object_name:DBMS_RMGR_LIB, status:VALID,
LIBRARY: SYS.DBMS_RMGR_LIB 12.1.1
owner:SYS, object_type:LIBRARY, object_name:DBMS_RMGR_LIB, status:VALID,
PACKAGE: SYS.DBMS_WLM 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_WLM, status:VALID,
PACKAGE: SYS.DBMS_WLM 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_WLM, status:VALID,
PACKAGE BODY: SYS.DBMS_RMIN 12.2.2
PACKAGE BODY: SYS.DBMS_RESOURCE_MANAGER_PRIVS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RESOURCE_MANAGER_PRIVS, status:VALID,
PACKAGE BODY: SYS.DBMS_WLM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_WLM, status:VALID,
PACKAGE BODY: SYS.DBMS_WLM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_WLM, status:VALID,
PACKAGE: SYS.DBMS_RMIN 12.2.2
PACKAGE: SYS.DBMS_RMIN_SYS 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_RMIN_SYS, status:VALID,
PACKAGE: SYS.DBMS_RMIN_SYS 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_RMIN_SYS, status:VALID,
PACKAGE BODY: SYS.DBMS_RESOURCE_MANAGER_PRIVS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RESOURCE_MANAGER_PRIVS, status:VALID,
PACKAGE BODY: SYS.DBMS_RESOURCE_MANAGER 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RESOURCE_MANAGER, status:VALID,
PACKAGE BODY: SYS.DBMS_RESOURCE_MANAGER 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RESOURCE_MANAGER, status:VALID,
PACKAGE BODY: SYS.DBMS_RMIN_SYS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RMIN_SYS, status:VALID,
PACKAGE BODY: SYS.DBMS_RMIN_SYS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RMIN_SYS, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
SYS.DBMS_RMIN dependencies on DBMS_RMIN 12.1.1
SYS.DBMS_RESOURCE_MANAGER_PRIVS dependencies on DBMS_RMIN 12.2.2
PUBLIC.DBMS_RMIN dependencies on DBMS_RMIN 12.2.2
SYS.DBMS_WLM dependencies on DBMS_RMIN 12.1.1
PUBLIC.DBMS_RMIN dependencies on DBMS_RMIN 12.1.1
SYS.DBMS_WLM dependencies on DBMS_RMIN 12.2.2
SYS.DBMS_RMIN_SYS dependencies on DBMS_RMIN 12.1.1
SYS.DBMS_RMIN_SYS dependencies on DBMS_RMIN 12.2.2
SYS.DBMS_RESOURCE_MANAGER dependencies on DBMS_RMIN 12.1.1
SYS.DBMS_RESOURCE_MANAGER_PRIVS dependencies on DBMS_RMIN 12.1.1
SYS.DBMS_WLM dependencies on DBMS_RMIN 12.1.1
SYS.DBMS_RMIN dependencies on DBMS_RMIN 12.2.2
SYS.DBMS_WLM dependencies on DBMS_RMIN 12.2.2
SYS.DBMS_RESOURCE_MANAGER dependencies on DBMS_RMIN 12.2.2
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,