Re: db_writer_processes tuning
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: nigel.cl.thomas@xxxxxxxxxxxxxx
- Date: Mon, 9 Feb 2009 10:13:25 -0500
Oracle bug, mathematical rounding :)
joe
_______________________________________
Joe Testa, Oracle Certified Professional
Senior Consultant
Data Engineering and Administration
Nationwide Investments
(Work) 614-677-1668
(Cell) 614-312-6715
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.
From:
Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx>
To:
makulev@xxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date:
02/09/2009 10:04 AM
Subject:
Re: db_writer_processes tuning
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx
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:
