What is the significance of executing this script?

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in amultiprocessor 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?

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in amultiprocessor 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



Leave a Reply 0

Your email address will not be published. Required fields are marked *