Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: catcpu and parallel compiles

RE: catcpu and parallel compiles

From: Yasin Baskan <>
Date: Fri, 3 Jun 2005 17:33:31 +0300
Message-ID: <083667B535F3464CA0DD0D1DAFA4E376062B6A25@camexc1.kfs.local>

Utlrp.sql calls utlrcmp.sql first. In utlrcmp.sql it creates the package utl_recomp, this is the package used in compiling invalid objects. You can call it like this to compile in parallel:

execute utl_recomp.recomp_parallel(4);

In utlrcmp.sql it gives related info abaout the parallel compilation:

Rem Parallel recompilation can exploit multiple CPUs to reduce the time
Rem taken to recompile invalid objects. The degree of parallelism is
Rem specified by the first argument to utl_recomp.recomp_parallel().

Rem      In general, a parallelism setting of one thread per available
Rem      CPU provides a good initial setting.
Rem      However, please note that the process of recompiling an invalid
Rem      object writes a significant amount of data to system tables and
Rem      fairly I/O intensive. A slow disk system may be a significant
Rem      bottleneck and limit speedups available from a higher degree of
Rem      parallelism.

-----Original Message-----
[] On Behalf Of Jeffrey Beckstrom Sent: Friday, June 03, 2005 5:22 PM
Subject: catcpu and parallel compiles

Looking at installing a 9.2 patch which runs catcpu. At the end, it runs utlrp. There is a comment in the catcpu script about being able to change the value passed to utlrp so that parallel compiles can be done.

I thought utlrp only did serial compiles?

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113


Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel=
 ve Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu=
 mesaj, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz=
 ve para karsiligi satilamaz; mesajin yetkili alicisi veya alicisina=
 iletmekten sorumlu kisi degilseniz, mesaj icerigini ya da eklerini=
 kopyalamayiniz, yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji=
 gonderen kisiyi derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde=
 ya da eklerinde yer alan bilgilerin dogrulugu, butunlugu ve guncelligi=
 Bankamiz tarafindan garanti edilmemektedir ve bilinen viruslere karsi=
 kontrolleri yapilmis olarak yollanan mesajin sisteminizde yaratabilecegi=
 zararlardan Bankamiz sorumlu tutulamaz.

This message and the files attached to it are under the privacy liability=
 in accordance with the Banking Law and confidential to the use of the=
 individual or entity to whom they are addressed. This message cannot be=
 copied, disclosed or sold monetary consideration for any purpose. If you=
 are not the intended recipient of this message, you should not copy,=
 distribute, disclose or forward the information that exists in the content=
 and in the attachments of this message; please notify the sender=
 immediately and delete all copies of this message. Our Bank does not=
 warrant the accuracy, integrity and currency of the information=
 transmitted with this message. This message has been detected for all=
 known computer viruses thence our Bank is not liable for the occurrence of=
 any system corruption caused by this message
Received on Fri Jun 03 2005 - 10:38:15 CDT

Original text of this message