utlrp.sql script after you install, patch, or upgrade a database, to identify, and recompile invalid objects.
utlrp.sqlscript recompiles all invalid objects, including packages, procedures, and types. Run the script immediately after installation, to ensure that users do not encounter invalid objects.
- Log in as an Administrator user, or as the Oracle Home user.
- Start SQL*Plus and log in as a SYSDBA user:
- Click Start.
- Select Programs (or All Programs).
- Select Oracle - HOME_NAME.
- Select Application Development.
- Select SQL*Plus.
- Run the
utlrp.sqlscript, where Oracle_home is the Oracle home path:
utlrp.sql script automatically recompiles invalid objects in either serial or parallel recompilation, based on 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.