What is most valuable?
The most valuable feature is the integration of the various components that make the performance soar. More specifically the presence of storage indexes along with the Exadata Storage Server software, which delivers process offloading, allows us to deliver better performance without indexes--saving space and CPU. This innovative feature is not something we would be able to replicate with other solutions. In addition, we consider the features smart scan, smart flashcache, smart flash log and hybrid columnar compression very useful.
How has it helped my organization?
Prior to Exadata, we were relying on daily ETLs from multiple source systems to load data into base tables, then we prepared a summary and materialized views from the base to data marts which were eventually exposed to the end users. This process used to take 18 hours. So, the data was always at least 18 hours late, and occasionally later, if the ETLs failed. This caused two issues: first, most managers simply were not able to make quick decisions because the data was stale and second, for most important functions, the users got the data from our OLTP system which taxed that system's capacity.
After Exadata, we observed three immediate benefits:
- The ETLs finish in 3 hours (down from 18), making the data fresh and enabling the managers to make quick decisions. Campaigns used to take days but take a few hours now
- Users no longer go to the OLTP system, reducing the impact there and saving us from upgrades
- There is no need to build summaries; so some of the data is available almost immediately, allowing most decisions to be taken on near-realtime data which was impossible pre-Exadata
What needs improvement?
There are three possible enhancements:
- Build a stronger, more responsive support team.
- Add a RAID-5 like storage layout for customers to save space with the full understanding that performance will be less (which could be fine for non-prod systems).
- Add storage level replication without the use of Data Guard, which is quite useful in case of organizations that rely on that technology for their Disaster Recovery effort.
For how long have I used the solution?
What was my experience with deployment of the solution?
Yes; mostly due to the database version being different. We were upgrading from 10g to Exadata which ran 11g; so there were some issues we had to overcome; but those were expected. Quite honestly, our deployment was smooth in Exadata itself due to our deep understanding of the technology. Without it, I am not sure if it would have been that smooth.
What do I think about the stability of the solution?
Yes; the initial versions had a lot of firmware issues that caused the cells to reboot, which caused the ASM software to rebalance the diskgroups. It mostly occurred in the X2 system. The X4 system has been quite stable. However, it's important to point out that Oracle generally releases firmware updates quite fast to remove any stability issues. We encountered them because we didn't apply these due to our internal reasons.
What do I think about the scalability of the solution?
No; scalability has been pretty awesome.
How are customer service and technical support?
It leaves a lot to be desired. It has improved; but still a lot to go. I rate it 6 on a 10 point scale. Technical Support
I gave an overall rating of 9 to Exadata X4 due to the quality of support personnel during installation and after sales events. That is going up but still leaves something to be desired.
Which solution did I use previously and why did I switch?
We used Oracle database on HPUX. We switched because it was impossible to deliver performance without additional indexes. Indexes took up space and slowed down data insertion performance. Exadata solved these by enhancing performance without the need for indexes.
How was the initial setup?
Oracle sends professional installers for installation and deployment. So it was fairly simple. However, as I mentioned earlier, we do have a deep technical expertise base so it worked in our favor. Without that expertise, I can't be sure if would not have been complex.
What about the implementation team?
We implemented everything with our in house team.
Which other solutions did I evaluate?
Yes, we did evaluate Teradata, Netezza and Greenplum.
What other advice do I have?
First and foremost, develop or hire a deep technical talent base inhouse, even if it's just one person. The technical role is called Database Machine Administrator (DMA). Planning is winning half the battle. There are tiny little things that makes a big difference. For instance, how to decide whether to keep the indexes you have--it's not something you can outsource. Second, get the installation checklist (detailed) from Oracle and establish SLAs for each item meticulously along with the hand off details. Third, if you don't have it, consider Oracle Enterprise Manager Grid Control to manage the Exadata system. Fourth, decide to use Oracle Platinum Support (free for Exadata) from day one. Finally, get ready to be wowed.
The innovative use of all the technologies integrated so creatively and functionally that it provides an immense performance boost impossible to attain with do it yourself systems. For instance the secret sauce is Exadata Storage Server (ESS) software, which is unique to Exadata, can't be replicated even with other massively parallel systems.