Re: db_writer_processes tuning
From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Mon, 9 Feb 2009 15:03:31 +0000
Message-ID: <53258cd50902090703s4b410536pb21b917db96b95da_at_mail.gmail.com>
Small thing:
Date: Mon, 9 Feb 2009 15:03:31 +0000
Message-ID: <53258cd50902090703s4b410536pb21b917db96b95da_at_mail.gmail.com>
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-lReceived on Mon Feb 09 2009 - 09:03:31 CST