Re: DBWR config

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 25 Aug 2020 16:04:50 -0400
Message-ID: <ac60ff209faefff7e63ed344aaf1116bf523be38.camel_at_gmail.com>



I would suggest a bit of HW tuning. Add a 512GB NVME drive and use it as flash cache. After that, put your most frequently used tables in the flash cache and your DBWR will be much faster. You will only need more DB writers if you're experiencing free buffer waits. Nobody, not even Kevin Closson, can help you predict your workload without testing. On Tue, 2020-08-25 at 12:44 -0500, Ram Raman wrote:
> List,
> I am considering configuring DBWRs for our new system. I came across
> this online: https://kevinclosson.net/category/dbwr-performance/
> Does the advice hold true today given the blog is a bit dated? We
> are planning on hosting a multi TB warehouse on Linux.
>
> Thanks
> Ram
> --
>
>
>

-- 
Mladen Gogala

Database Consultant

Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 25 2020 - 22:04:50 CEST

Original text of this message