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