Re: PARALLEL_MAX_SERVERS value

  • From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • To: exriscer@xxxxxxxxx
  • Date: Tue, 25 Oct 2011 08:39:33 -0500

The processes and sessions parameter also figure into this setting, but I
have always set this from somewhere between 2 and 4* the number of cpus.
The number they give looks way too large to me also.
On Tue, Oct 25, 2011 at 8:36 AM, LS Cheng <exriscer@xxxxxxxxx> wrote:

> 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
>
>
>


-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


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


Other related posts: