Re: excessive number of db writer

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 6 Sep 2006 02:05:02 -0700 (PDT)
Message-ID: <20060906090502.33810.qmail@web57004.mail.re3.yahoo.com>

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

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 Wed Sep 06 2006 - 04:05:02 CDT