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: excessive number of db writer

Re: excessive number of db writer

From: lale obradovic <cika.lale_at_googlemail.com>
Date: Sun, 10 Sep 2006 15:24:46 +0200
Message-ID: <547d26230609100624k34ea7ad1v779b2993b9d5d82c@mail.gmail.com>


Hi,

What did Oracle consultant told you as a reason for setting this hidden parameters?

Regards,

Lale

> On 9/6/06, amonte <ax.mount_at_gmail.com> wrote:
> >
> > Hi
> >
> > I have been suggested by some Oracle Consultant to set 20 Database
> > Writer in a 12 CPU HP-UX Server.
> >
> > Does anyone know what are the side effects of having excessive DBWR? I
> > detected a higher CPU usage (between, 1% to 2%) not sure if its due to the
> > number of Database Writer. Because when I increased the number of DBWR at
> > init.ora I also changed these parameters
> >
> > _row_cache_cursors = 60
> > _kgl_latch_count = 59
> > _kghdsidx_count = 4
> > statistics_level = basic
> >
> > again suugested by this guy.
> >
> > TIA
> >
> > Alex
> >
> >
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Sep 10 2006 - 08:24:46 CDT

Original text of this message

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