Recompile Invalid Objects in the Database
After you install, patch, or upgrade a database, recompile invalid objects
on the CDB and PDBs using utlrp.sql
with the catcon
utility.
Oracle recommends that you use the catcon.pl
utility to run utlrp.sql
on
all containers in your container database (CDB). The utlrp.sql
script recompiles invalid objects. Run the script
immediately after installation, to ensure that users do not encounter invalid
objects.
Note:
If you upgraded using the AutoUpgrade utility, then AutoUpgrade automatically takes care of this task during the upgrade. You do not need to perform this task.
Expect a time delay for the serial recompilation of PDBs to complete. Depending on the number of PDBs that you are upgrading, the recompilation can extend significantly beyond the time required for the upgrade scripts to complete.
The utlrp.sql
script automatically
recompiles invalid objects in either serial or parallel recompilation, based on both
the number of invalid objects, and on the number of CPUs available. CPUs are
calculated using the number of CPUs (cpu_count)
multiplied by the number of threads for each CPU (parallel_threads_per_cpu). On Oracle Real Application Clusters
(Oracle RAC), this number is added across all Oracle RAC nodes.
Related Topics
Parent topic: Recommended Postinstallation Tasks