Re: excessive number of db writer

  • From: "lale obradovic" <cika.lale@xxxxxxxxxxxxxx>
  • To: ax.mount@xxxxxxxxx
  • Date: Sun, 10 Sep 2006 15:24:46 +0200

Hi,

What did Oracle consultant told you as a reason for setting this hidden
parameters?

Regards,

Lale


On 9/6/06, amonte <ax.mount@xxxxxxxxx> wrote:
>
> 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: