db_writers can be more than the number of cpu's ...
if the system is write intensive, some dba's suggest
2 db_writers PER datafile..
> ----------
> From: VIVEK_SHARMA[SMTP:vivek_sharma_at_inf.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, July 06, 2000 1:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: CPUs and Oracle
>
>
> 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
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> --
> Author: VIVEK_SHARMA
> INET: vivek_sharma_at_inf.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Jul 06 2000 - 00:43:29 CDT
