- Smart Flash Cache
- Storage Index
- Smart Scan
- Hybrid Columnar Compression
- Oracle ASM
- Security with encryption
- Oracle platinum support
We were using a normal RAC on a Linux server for online applications and Oracle on the same platform for data warehousing. After moving to Oracle Exadata, we were able to add more users, and queries get executed very quickly for data warehousing, around one quarter to half the time when compared to our previous solution under normal conditions.
I've been using it for five years, including in my previous company.
During migration, we approached transportable tablespace and Oracle database along with GoldenGate.
There have been no issues with stability.
It's been able to scale for our needs.
10/10 because we have Oracle Platinum Support.
Previously, we used SQL tuning, server tuning along with network tuning with huge storage and higher CPUs. It was a management decision, along with our recommendations, to move to Exadata.
It was a complex setup because we were implementing the online application as well as data warehousing on the same machine. Lots of planning took place before moving to Exadata, and we did regression testing for each application on an Oracle provided Exadata machine. After verification from our application team and management, we verified our test results.
We did it in-house with help from Oracle.
It's too costly.
I have seen, and it's my personal experience, that if your application runs on half a rack don't go for a full rack. After all, you can upgrade from half a rack to a full rack if needed, and there is no point to move directly onto a full rack.
Check with Oracle and do testing on the lower version rack first. Although sales people from Oracle will convince you to go for a higher version, which is not needed unless your design, architecture, and applications needed .