Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: CPUs and Oracle

RE: CPUs and Oracle

From: VIVEK_SHARMA <vivek_sharma_at_inf.com>
Date: Thu, 6 Jul 2000 15:37:42 +0530
Message-Id: <10550.111315@fatcity.com>


Rahul
ok
Oracle Corp suggests 1 db_writer per hard disk accessed

List Any OTHER parameters ?

> -----Original Message-----
> From: Rahul [SMTP:rahul_at_ratelindo.co.id]
> Sent: Thursday, July 06, 2000 12:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: CPUs and Oracle
>
> 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
> > also send the HELP command for other information (like subscribing).
> >
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> 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 - 05:07:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US