认真就输

SQL> select * from v$version;

BANNER

——————————————————————————–

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

PL/SQL Release 11.2.0.4.0 – Production

CORE    11.2.0.4.0      Production

TNS for Linux: Version 11.2.0.4.0 – Production

NLSRTL Version 11.2.0.4.0 – Production

[oracle@orcl9i admin]$ tail -10 utlrp.sql

Rem ===========================================================================

Rem BEGIN utlrp.sql

Rem ===========================================================================

@@utlprp.sql 0

Rem ===========================================================================

Rem END utlrp.sql

Rem ===========================================================================

其实这里的0就是控制并行的方式

0 – 基于CPU_COUNT参数设置并行度.

1 – 以串行方式编译对象,一次编译一个.

N – 以N个并行度进行编译.

下面我们在看看ultprp.sql脚本中有如下的内容

这里我们也可以直接修改并行度

   This script automatically chooses serial or parallel recompilation

   based on the number of CPUs available (parameter cpu_count) multiplied

   by the number of threads per CPU (parameter parallel_threads_per_cpu).

   On RAC, this number is added across all RAC nodes.

DECLARE

   threads pls_integer := &&1;

BEGIN

   utl_recomp.recomp_parallel(threads);

END;

/

另外我们还可以修改utl_recomp.recomp_serial();来实现