Re: init parameters when you have multiple processors

thanks,

What tuning parameters should I check into ( besides parallel query stuff )

dba djour
"Fraser McCallum" <fmcc_at_NOSPAModbaguru.com> wrote in message news:_NrZ7.73143$Q66.267630_at_NewsReader...
> There are no specific parameters you need to set for an Oracle install on
a
> multiple CPU machine. An Oracle install is multiple CPU aware on an OS
that
> can use more than one CPU and will configure itself accordingly when
> started. What you are probably thinking of is that certain tuning related
> parameters if changed should be done so with consideration of the number
of
> CPU's.
>
> Kind Regards
>
> Fraser McCallum
> MVP Oracle
> www.brainbench.com
>
> "DumbassDBA" <databaseguy90_at_hotmail.com> wrote in message
> news:mmrZ7.21200$LQ1.7451743_at_news2.nash1.tn.home.com...
> > Are there any init parameters that should be set when you have multiple
> > processors?
> > I have only had one processor on NT until recently and now I have 4 on
NT
> > and 4 on a HP UX11 64bit Oracle instance.
> > Seems like there were some parameters I was supposed to set ( spin_count
> > sounds familiar) but I don't see any such parameters in the
documentation.
> > At least not that I have found.
> >
> > I am new to Unix too. Sort of had this dumped on me. Oracle seems much
the
> > same but the operating system is different. I know there must be some os
> > parameters I should set too but I will read up on that next.
> >
> > thanks for any help.
> >
> > dum ole dba
> >
> >
>
>
Received on Fri Jan 04 2002 - 18:37:45 CST