Re: db_writer_processes tuning

From: Milen Kulev <makulev_at_gmx.net>
Date: Mon, 09 Feb 2009 16:59:52 +0100
Message-ID: <499052F8.4030806_at_gmx.net>

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_at_gmx.net <mailto: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:59:52 CST