Re: db_writer_processes tuning
Date: Mon, 09 Feb 2009 16:59:52 +0100
it is definitely rounding error (2,875 -> 4 ;) ). It is really pitty that my emplyer dowsn't round up my salary int this way ;)
Anyway, the databases are running pretty well even with 4 DB writer processes.
Best Regards. Milen
Nigel Thomas wrote:
> Small thing:
> (16 + 7)/8 = 3, not 4
> 2009/2/9 Milen Kulev <makulev_at_gmx.net <mailto:makulev_at_gmx.net>>
> 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
> I have used this setting (also with VxFS), and there were no problems.
> HTH. MILEN