excessive number of db writer
- From: amonte <ax.mount@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 6 Sep 2006 10:39:51 +0200
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
Other related posts:
