Re: db_writer_processes tuning
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: makulev@xxxxxxx
- Date: Mon, 9 Feb 2009 14:03:32 -0200
mine does... that is:
two thousand eight hundred and seventy five dollars rounds up to four
dollars ^_^
hth
Alan Bort
Oracle Certified Professional
On Mon, Feb 9, 2009 at 1:59 PM, Milen Kulev <makulev@xxxxxxx> wrote:
> 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>
>>
>> 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
>>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
