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@xxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
