RE: catcpu and parallel compiles
- From: "Yasin Baskan" <yasbs@xxxxxxxxxxxxxx>
- To: <JBECKSTROM@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracledba@xxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Fri, 3 Jun 2005 17:33:31 +0300
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 PARALLELISM AND PERFORMANCE
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
Rem However, please note that the process of recompiling an invalid
Rem object writes a significant amount of data to system tables and
is
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-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeffrey Beckstrom
Sent: Friday, June 03, 2005 5:22 PM
To: oracle-l@xxxxxxxxxxxxx; oracle-db-l@xxxxxxxxxxxxxxxxxxxx;
ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx;
oracle-rdbms@xxxxxxxxxxxxxxx
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.
=0D
I thought utlrp only did serial compiles?
=0D
=0D
=0D
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
//www.freelists.org/webpage/oracle-l
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
