Re: db_writer_processes tuning

From: <TESTAJ3_at_nationwide.com>
Date: Mon, 9 Feb 2009 10:13:25 -0500
Message-ID: <OF98219794.0A8B5867-ON85257558.00539B45-85257558.0053A04B_at_lnotes-gw.ent.nwie.net>

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_at_googlemail.com> To:
makulev_at_gmx.net, ORACLE-L <oracle-l_at_freelists.org> Date:
02/09/2009 10:04 AM
Subject:
Re: db_writer_processes tuning
Sent by:
oracle-l-bounce_at_freelists.org

Small thing:

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

WTF? 2009/2/9 Milen Kulev <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 processes. I have used this setting (also with VxFS), and there were no problems.

HTH. MILEN

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 09 2009 - 09:13:25 CST