Re: db_writer_processes tuning

Hello Nigel,
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

WTF?

2009/2/9 Milen Kulev <makulev@xxxxxxx <mailto: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: