217.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.
Answer: C
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/install.112/e47798/postcfg.htm#NTDBI2798
|
PL/SQL |
|
Recompiles all existing PL/SQL modules that were previously in an |
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 packagesSTANDARD
and DBMS_STANDARD
must be valid.-
Start SQL*Plus:
DRIVE_LETTER:> sqlplus /nolog -
Connect to the database with the
SYS
account:SQL> CONNECT SYS AS SYSDBAEnter password:SYS_password -
Start the database (if necessary):
SQL> STARTUP -
Run the
utlrp.sql
script, which by default is located inORACLE_HOME
dbmsadminutlrp.sql
. For example:SQL> @? dbmsadminutlrp.sql