Re: db_writer_processes tuning
- From: Milen Kulev <makulev@xxxxxxx>
- To: nigel.cl.thomas@xxxxxxxxxxxxxx
- Date: Mon, 09 Feb 2009 16:59:52 +0100
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:
