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 :-(
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@xxxxxxxxx> 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@xxxxxxxxx> > To: oracle-l@xxxxxxxxxxxxx > 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