Re: exadata write performance problems

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