Re: excessive number of db writer

  • From: "Anand Rao" <panandrao@xxxxxxxxx>
  • To: ax.mount@xxxxxxxxx
  • Date: Wed, 6 Sep 2006 14:41:36 +0530

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006