Search Results dbms_rmin_sys




Overview
Explore in AI Chat

Overview

SYS.DBMS_RMIN_SYS is an Oracle-supplied, internal PL/SQL package that resides in the SYS schema and carries a status of VALID in Oracle E-Business Suite 12.1.1 and 12.2.2. It is the private implementation layer beneath the public Database Resource Manager interfaces exposed by DBMS_RESOURCE_MANAGER and DBMS_RMIN. The _SYS suffix denotes that the package exists primarily to support internal database resource management operations and is not intended for direct invocation by application or EBS module code.

Within an EBS environment, resource management matters because a single database instance hosts multiple concurrent EBS application tiers, concurrent managers, batch jobs, and reporting workloads. The Database Resource Manager subsystem allows DBAs to allocate CPU and session resources across consumer groups, and DBMS_RMIN_SYS provides the low-level plumbing that the public resource manager packages depend upon. ETRM classifies the package under API classification OTHER, reflecting its internal, non-application-facing nature.

Key Procedures and Functions

The documented metadata for this object lists zero procedures or functions, and no parameter lists are published. This is consistent with an internal support package whose entry points are referenced only by other SYS-owned packages rather than by application APIs. Consequently, no public callable interface should be assumed or constructed from this documentation.

What the metadata does establish is the dependency chain. SYS.DBMS_RMIN_SYS is referenced by SYS.DBMS_RESOURCE_MANAGER, SYS.DBMS_RMIN, and by itself, and the package is further exposed through a public synonym declared as PUBLIC.DBMS_RMIN_SYS. These references confirm that the public resource manager packages delegate their implementation work to DBMS_RMIN_SYS. In practice, the package provides the internal routines used when a DBA creates or modifies resource plans, consumer groups, and plan directives through DBMS_RESOURCE_MANAGER. Because ETRM documents no procedures, no functional signature should be inferred; the package must be treated strictly as a dependency, not as an integration point.

Tables Accessed

The ETRM metadata records no tables accessed through APPS synonyms for this package. This is expected, since the package belongs to SYS and operates on data dictionary and fixed objects internal to the database rather than on EBS application tables such as those in the AP, GL, or FND schemas. Resource manager configuration is held in underlying data dictionary tables managed by the database itself, and DBMS_RMIN_SYS interacts with that internal storage on behalf of its callers.

Because no application tables are documented, the package has no direct impact on EBS transactional data. Any table-level dependency would be confined to database-internal objects and is not surfaced through the ETRM dependency listing.

Usage Notes

DBMS_RMIN_SYS is never invoked directly by EBS forms, concurrent programs, or custom code. It is reached only indirectly when a DBA or automated maintenance script calls DBMS_RESOURCE_MANAGER or DBMS_RMIN to configure database resource plans. EBS administrators interacting with Workload Manager or resource allocation settings ultimately exercise this package through those supported public interfaces.

  • Do not reference SYS.DBMS_RMIN_SYS or PUBLIC.DBMS_RMIN_SYS in custom EBS code; use the documented public packages instead.
  • Treat the package as an internal dependency during impact analysis for database upgrades, as changes introduced by Oracle patches can affect it.
  • Confirm status remains VALID after cloning, patching, or database upgrades, since invalidation here can disrupt resource manager operations that depend on the public packages.

In summary, DBMS_RMIN_SYS is an internal Oracle resource manager support package in the EBS database, documented as referenced by two other packages and offering no published application-level API.