Recompiling All Invalid Objects
Oracle recommends that you run the utlrp.sql
script after you install, patch, or upgrade a database, to identify and recompile invalid objects.
The
utlrp.sql
script recompiles all invalid objects. Run the script immediately after installation, to ensure that users do not encounter invalid objects.
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.
Parent topic: Required Postinstallation Tasks