Search Results recomp_serial

Overview

SYS.UTL_RECOMP is an Oracle-supplied PL/SQL package that provides a controlled, server-side mechanism for recompiling invalid PL/SQL objects and other schema objects within the database. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, the package is a core component of the SYS schema and is chiefly used by database administrators and EBS patching utilities to restore validity to invalidated program units following upgrades, patch application, or DDL changes against underlying tables and views.

The package is classified in the ETRM documentation as an OTHER API, and its documented status is VALID. Its principal role in the EBS technology stack is to reduce the manual effort and risk associated with bulk recompilation. Because EBS releases 12.1.1 and 12.2.2 contain many thousands of PL/SQL program units that reference each other across the APPLSYS, APPS, and product schemas, any modification to a shared object can cascade invalidations throughout the dependency chain. UTL_RECOMP addresses this by orchestrating recompilation in a dependency-aware manner, using parallel workers where appropriate to shorten overall processing time.

Key Procedures and Functions

The ETRM metadata documents three callable entry points within SYS.UTL_RECOMP:

• RECOMP_PARALLEL — The primary parallel recompilation driver. It recompiles invalid objects concurrently using multiple slave processes, materially reducing elapsed time on large EBS instances where serial recompilation would be prohibitively slow.
• RECOMP_SERIAL — The serial counterpart to the parallel driver. It recompiles invalid objects one at a time, which is useful when resource contention must be minimized or when the parallel workers cannot be safely spawned, such as on constrained development or test instances.
• PARALLEL_SLAVE — The internal worker routine invoked by the parallel execution path to perform the actual recompilation of objects distributed to each worker process.

No parameter lists are documented in the ETRM excerpt; callers should consult the Oracle Database PL/SQL Packages and Types Reference for exact signatures before use.

Tables Accessed

The ETRM metadata does not document any tables accessed through APPS synonyms, which is consistent with the nature of this package. UTL_RECOMP operates primarily against the data dictionary — including views such as DBA_OBJECTS to identify invalid objects and the underlying dependency metadata — rather than against application tables. No EBS application-level tables are read or written by this package.

Usage Notes

UTL_RECOMP is typically invoked from a privileged SQL*Plus or SQL Developer session connected as a DBA or as SYSDBA, most commonly after applying patches, running adpatch, or upgrading the database. EBS release 12.1.1 and 12.2.2 administrators rely on it to resolve invalid objects detected through ADADMIN or through queries against DBA_OBJECTS.

The package is referenced by several other SYS packages, including DBMS_UTILITY, DBMS_REGXDB, and DBMS_OBJECTS_APPS_UTILS, the latter being significant in the EBS context because it links recompilation activity to the Applications object model. This relationship means that EBS-aware utilities may invoke UTL_RECOMP internally on the administrator's behalf.

Because recompilation can be resource-intensive, administrators should generally prefer RECOMP_PARALLEL on production systems with multiple CPUs and reserve RECOMP_SERIAL for smaller or resource-constrained environments. Invocation requires elevated privileges, and running it during peak business hours is discouraged because recompilation affects shared library cache entries and can temporarily impact concurrent users.