Re: PARALLEL_MAX_SERVERS value

  • From: LS Cheng <exriscer@xxxxxxxxx>
  • To: Sidney Chen <huanshengchen@xxxxxxxxx>
  • Date: Tue, 25 Oct 2011 15:36:10 +0200

Hi
I am not seekings the *best* setting, rather some generic guidelines or
official WP

But CPUx10 es definitely too many because IMHO a CPU, either thread or core
should not handle more than 4 requests, 10 is a lot! But why Oracle suggest
10? To be honest I never read PARALLEL_MAX_SERVERS definition because I have
always set this parameter using my experience.

Simulate a load scenario sounds very good in a perfect world where budget
and resources are not a problem but in the real world who does it for all
the applications? I then real world how can get the real load for a new
application?

Regards

--
LSC


On Tue, Oct 25, 2011 at 3:10 PM, Sidney Chen <huanshengchen@xxxxxxxxx>wrote:

> Instead of seeking for the *best* setting, it will better to prove it. to
> simulate a typical loading in a testing env, try with different degree and
> pick up the one suited for you, that's according the loading, the capacity
> of your CPU and Memory.
>
> --
> Regards
> Sidney Chen
>
>
>


--
//www.freelists.org/webpage/oracle-l


Other related posts: