Re: db_writer_processes tuning

  • From: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx>
  • To: makulev@xxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 9 Feb 2009 15:03:31 +0000

Small thing:

(16 + 7)/8 = 3, not 4

WTF?

2009/2/9 Milen Kulev <makulev@xxxxxxx>

>  Hello Vladimir,
> as fas as know, according to Oracle the optimal count of DB writer
> processes is
> "(CPU_COUNT+7)/8". For 16 CPUs that would give you 4 DB Writer processes.
> I have used this setting (also with VxFS), and there were no problems.
>
> HTH. MILEN
>
>

Other related posts: