log_simultaneous_copies = 2 * cpu_count
should db_writers be set Equal to cpu_count for a Multi-Cpu machine ?
(db_writers exists in 7.3.4)
Also ANY Other Parameters that are CPU Related in 7.3.4 ?
List please advise
> -----Original Message-----
> From: Surya Rao [SMTP:surya.rao_at_reuters.com]
> Sent: Thursday, July 06, 2000 5:51 PM
> To: rahul_at_ratelindo.co.id
> Cc: oracledba_at_quickdoc.co.uk
> Subject: Re: CPUs and Oracle
> Sensitivity: Confidential
>
> This particular instance is on v7.3.2 and I can't find the
> DB_WRITERS parameter for this version.
>
> I guess if these are not adjusted, it will NOT be making use
> of the additional processor. Other than this, any impact if
> no parameter on Oracle is UNCHANGED?
>
>
> surya
> -------
>
> when the instance starts, oracle will automatically
> adjust the cpu_count parameter.
> you might need to adjust/increase the following. (i'm on 7.3.2, AIX)
>
> db_writers = no. of cpu's
> db_block_lru_latches = 2 * no of cpu's
> log_simultaneous_copies = ?
>
> Rahul
>
>
> > ----------
> > From: Surya Rao[SMTP:surya.rao_at_reuters.com]
> > Sent: Thursday, July 06, 2000 7:06 PM
> > To: oracledba_at_lazydba.com
> > Subject: CPUs and Oracle
> > Sensitivity: Confidential
> >
> > Hi List,
> >
> > We are going to add more CPUs into our server running Oracle.
> >
> > Anything we need to change in the Oracle config or parameters
> > to make it realise that new CPU has been added?
> >
> > Any other thing pertinent to multiple CPUs with regards to
> > Oracle, that I shd know about?
> >
> > Any insight into this will be appreciated
> >
> > surya
> > ------
> >
> > ----------------------------------------------------------------
> > Visit our Internet site at http://www.reuters.com
> >
> > Any views expressed in this message are those of the individual
> > sender, except where the sender specifically states them to be
> > the views of Reuters Ltd.
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
>
> -----------------------------------------------------------------
> Visit our Internet site at http://www.reuters.com
>
> Any views expressed in this message are those of the individual
> sender, except where the sender specifically states them to be
> the views of Reuters Ltd.
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
Received on Wed Jul 05 2000 - 23:45:39 CDT
