Oracle OCP 1Z0 053 Q217(Upgrade Recompile)

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

實際上，指令碼內容：

呼叫了utlprp.sql
@@utlprp.sql 0

utlprp.sql中存在以下呼叫：

DECLARE
   threads pls_integer := &&1;
BEGIN
   utl_recomp.recomp_parallel(threads);
END;
/

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2072902/，如需轉載，請註明出處，否則將追究法律責任。