Re: init parameters when you have multiple processors

The ones that spring to mind are DB_WRITER_PROCESSES or DB_IO_SLAVES and DB_BLOCK_LRU_LATCHES. Basically if you have spare CPU and IO capacity you can use the extra CPU's to manage more simultaneous IO. However if you are actually tuning a production system I'd recommend identifying your bottle necks and tuning appropriately as messing with these parameters could make things worse not better.

Kind Regards

Fraser McCallum
MVP Oracle
www.brainbench.com

"DBAdjour" <databaseguy90_at_hotmail.com> wrote in message news:tVrZ7.21493$LQ1.7484078_at_news2.nash1.tn.home.com...
> 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 - 19:19:07 CST