Re: exadata write performance problems

Hi Mladen

We will be enabling writeback flash cache, with that we should minimize the write performance problem. Just that to get that enabled there are still a few months to go!

Thanks

On Fri, Feb 15, 2019 at 11:47 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Hi!
>
> Exadata is a data warehouse machine. Its main feature are Bloom filters
> which eliminate the unnecessary blocks during the physical scan and
> don't force the database to do the elimination in its SGA. However, the
> writing speed of Oracle Exadata leaves a lot to be desired. If you need
> a huge concurrent write, my advice would be to use a modern all flash
> array like NetApp all flash, EMC Xtrem_IO or Pure. In other words,
> Exadata shines at querying, not at writing.
>
> Regards
>
> On 2/12/19 4:15 PM, Ls Cheng wrote:
> > Hi
> >
> > IHAC who has 1/8 Exadata x6-2 with High Capacity Disks is having heavy
> > performance problems whenever some massive DML operation kicks in,
> > since this is a 1/8 configuration the IOPS supporting write operation
> > is not high, roughly 1200 IOPS. I am seeing as high as 4000 Physical
> > Writes Per Sec in peak time. When this happens the user session starts
> > suffering because they are blocked by enq: KO - fast object checkpoint
> > which is blocked by "control file parallel write" by CKPT. So the idea
> > is aliviate CKPT. This is from hist ash
> >
> >
> >
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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