Performance Impact using a Shared Exadata vs Dedicated Exadata
Hello,
We are using Oracle Analytics Cloud version (OAC v5.8) that connects to cloud to build visualizations. It connects to cloud via Oracle Autonomous Data Warehouse (ADW with Oracle v19), deployed on a Shared Exadata Infrastructure.
Our dataset is in terms of about 8.5 million records as of today and this increases on a daily basis (there is an addition of about 50K records daily). As a business requirement we fetch all of this data in the datasource (in cloud) via ADW and show visualizations in OAC.
Since this is huge data we do have latency issues. Although, we have used various measures and addressed this issue to a certain extent, we still have latency issues (sluggish loading of charts) at times.