Re: Hyperthreading - Oracle license
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: Finn.Jorgensen@xxxxxxxxxxxxxxxxx
- Date: Fri, 11 Jan 2013 00:10:09 +0100
On 01/10/2013 11:09 PM, Jorgensen, Finn wrote:
> At my company on a Sun T5240 host which reports 128 CPU's due to extreme
> hyperthreading, I had to restrict CPU_COUNT otherwise running utlrp.sql as
> part of new database creation spawned so many parallel threads it brought the
> server to its knees.
>
Hi Finn,
you can manually adjust the degree of parallelism for utlrp:
@@utlprp.sql X
See ORA-04031 error when upgrading to 11.2.0.2 during utlrp.sql step [ID
1275067.1].
That said, for me, one of the first things to do after a fresh 11.2
install is adjust
the max_parallel_server processes, the default seems too hight.
Regards
Dimitre
--
//www.freelists.org/webpage/oracle-l
Other related posts:
