Re: Running utlrp creates too many Pnnn processes

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Sat, 20 Dec 2008 19:42:15 -0500
Message-ID: <74f79c6b0812201642n60621725m775b3c72c060d64e@mail.gmail.com>


Maureen,

Are you on a T5220 or T5240 or something like that by any chance with highly threaded CPU's? These servers have many problems related to CPU_COUNT being set high. We have a T5240 with 128 virtual CPU's and ran into many different issues related to memory and this parameter. I have also run into your exact problem on a T5220 with 64 virtual CPU's.

Anyway we have so many of these servers now I finally opened a SR with Oracle and asked what the implications of lowering the CPU_COUNT parameter was (because Oracle says NOT to touch this parameter) and the answer was that it's fine to lower the parameter. This will solve many of your problems. Just set it to 32 or 16 or whatever works for you.

Finn

On Thu, Dec 18, 2008 at 4:53 PM, Maureen English <sxmte_at_email.alaska.edu>wrote:

>
> The cpu_count parameter is 64. It is one of the parameters used to
> calculate the value of the parallel_max_servers parameter. The value
> - Maureen
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Dec 20 2008 - 18:42:15 CST

Original text of this message