Oracle recommends that you run the
utlrp.sql script after you install, patch, or upgrade a database, to identify and recompile invalid objects.
utlrp.sqlscript recompiles all invalid objects. Run the script immediately after installation, to ensure that users do not encounter invalid objects.
- Start SQL*Plus:
sqlplus "/ AS SYSDBA"
- Run the
Oracle_homeis the Oracle home path:
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.