Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g
database in a multiprocessor environment.
At the end of the upgrade, you observe that the DBA executes the following script:
SQL> @utlrp.sql
What is the significance of executing this script?
A.
It performs parallel recompilation of only the stored PL/SQL code.
B.
It performs sequential recompilation of only the stored PL/SQL code.
C.
It performs parallel recompilation of any stored PL/SQL as well as Java code.
D.
It performs sequential recompilation of any stored PL/SQL as well as Java code.
Explanation:
Recompile invalid objects with utlrp.sql
Run the utlrp.sql script after creating or upgrading a database. This script recompiles all PL/SQL modules that may be in an INVALID state, including packages, procedures, types, and so on. This step is optional, but recommended so that the performance cost of recompilation is incurred during the installation rather than in the future.
Note:
There should be no other data definition language (DDL) statements running on the database while the script is running, and packages STANDARD and DBMS_STANDARD must be valid.
http://docs.oracle.com/cd/B16276_01/doc/server.102/b14196/install004.htm
Note:
Selecting Recompile invalid objects at the end of upgrade is equivalent to running the ORACLE_HOME/rdbms/admin/utlrp.sql script, which is used to recompile stored PL/SQL and Java code.