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.
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