Re: excessive number of db writer

Anand do you know what side effects can excessive DBWR cause?

I dont know because I cant find anything which tells you the side effects :-(

On 9/6/06, Anand Rao <panandrao_at_gmail.com> wrote:
>
> 20 DB Writers is way too high.
>
> what kind of an application is this? Even for a
> 'write-only-will-not-select-any-data' application, 20 is high questionable.
>
> normally, you don't need to dab around with those parameters. why did they
> need to be changed?
>
> sorry, but your Oracle consultant has got it wrong.
>
> cheers
> anand
>
>
>
> On 06/09/06, K Gopalakrishnan < kaygopal_at_yahoo.com> wrote:
> >
> > Alex,
> >
> > Did you get an explanation for those suggestions? It would be
> > difficult for us to comment on those changes without any additional
> > details..
> >
> > However, However,However, 20 DBWriters are certainly high for your
> > configuration ;)
> >
> > Have a nice day !!
> > ------------------------------------------------------------
> > Best Regards,
> > K Gopalakrishnan,
> > Co-Author: Oracle Wait Interface: Oracle Press 2004.
> > http://www.amazon.com/gp/product/007222729X/
> >
> > Coming Soon: Oracle RAC Handbook, Oracle Press 2006
> > http://www.amazon.com/gp/product/007146509X/
> >
> > ----- Original Message ----
> > From: amonte <ax.mount_at_gmail.com>
> > To: oracle-l_at_freelists.org
> > Sent: Wednesday, September 6, 2006 1:39:51 AM
> > Subject: excessive number of db writer
> >
> > 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
> >
> >
> >
>
>
> --
> All I need to make a comedy is a park, a policeman and a pretty girl -
> Charlie Chaplin
>

--
http://www.freelists.org/webpage/oracle-l