Oracle Exadata: Best for Analytics and OLTP
September 17, 2019

Oracle Exadata: Best for Analytics and OLTP

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Exadata Database Machine

We are using Oracle Exadata Database Machine for all of our Oracle databases which includes Supply Chain, Order Management, Finance, Integration, etc. Exadata improved all database performance. It has been most beneficial to our warehouse operations. We used to have a lot of IO issues, and to troubleshoot them, our DBA has to spend 3-4 hours daily. Now, IO is no longer the issue.

For all other processes like RMAN backups, export/import and data loads, we saw a lot of improvements.
  • Sparse clone helps us to quickly provision the dev/ test databases in less than 30 minutes and also saves storage.
  • Compression features in Exadata greatly helped us to save storage and improve performance.
  • Redundancy at every level in Exadata keeps our Oracle databases always up.
  • Platinum patching support is not as good as we expect.
  • Improved database response time greatly helped the supply chain process.
  • We save time on database refreshes using sparse clone, and developers/testers can get a copy of the database very quickly.
Best for both analytics and OLTP loads. Redundancy at every level makes it highly available. Patching process is being simplified over time, making it easier with less downtime. Good to consolidate lots of databases in a single Exadata rack which makes the management of databases easy. Very large databases are well supported.