I primarily use Exadata to handle the databases of critical applications.
Department Unified Communication Head at Mana
Good data management
Pros and Cons
- "Exadata's best features are its performance during redo logging and the elasticity of the database handling."
- "Exadata would be improved with single dashboard visibility."
What is our primary use case?
What is most valuable?
Exadata's best features are its performance during redo logging and the elasticity of the database handling.
What needs improvement?
Exadata would be improved with single dashboard visibility.
For how long have I used the solution?
I've been working with Exadata for six to seven years.
Buyer's Guide
Oracle Exadata
December 2024
Learn what your peers think about Oracle Exadata. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
What do I think about the stability of the solution?
Exadata is stable.
What do I think about the scalability of the solution?
Exadata is scalable.
How was the initial setup?
The initial installation took around a week.
What other advice do I have?
I would recommend Exadata to other users for its database management and would rate it eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
BI & Analytics Manager at a insurance company with 1,001-5,000 employees
Useful data processing, minimal maintenance, and simple deployment
Pros and Cons
- "The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain."
- "Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly."
What is our primary use case?
Oracle Exadata is used to keep our data, which is related to the company. It collects it from the source system and stores it in the enterprise data warehouse platform. For storing the data itself and serving the data on a different platform for the company.
What is most valuable?
The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain.
The solution only requires one person for maintenance and support in an average-sized insurance company.
What needs improvement?
Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly.
In a future release, I would like to have new analytical capabilities.
For how long have I used the solution?
I have been using Oracle Exadata for more than eight years.
What do I think about the stability of the solution?
The stability of Oracle Exadata is good.
What do I think about the scalability of the solution?
Oracle Exadata is scalable.
We have data engineers and data scientists using this platform, and in my team, there are 25 of them, and all of them are using this platform.
How are customer service and support?
We request a heath check for issues from the support and we have a deal with them to support us.
I rate the support from Oracle Exadata a three out of five.
How was the initial setup?
Oracle Exadata's initial setup is easy. Installing the solution on our system in the data center takes less than one day.
I would rate the initial setup of Oracle Exadata a four out of five.
What about the implementation team?
We did the implementation using our team and a third-party company.
What's my experience with pricing, setup cost, and licensing?
There is an annual license to use this solution. The solution is expensive.
I rate the price of Oracle Exadata a three out of five.
What other advice do I have?
I would recommend this solution to others.
I rate Oracle Exadata an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Oracle Exadata
December 2024
Learn what your peers think about Oracle Exadata. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Chief Technology Officer at Triana Business Solutions Lda
Enables us to run with more performance cores with less CPU to attend all the database demands
Pros and Cons
- "It has improved the performance, now we run with more performance cores with less CPU to attend all the database demands. Reducing Time to Market, increase our ability to face the competition with speed and low cost."
- "I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination."
What is our primary use case?
I was running an ERP system on Rackmount machines with critical databases on it. There is no way to scale-in and very expensive to scale-out as the system is growing countrywide. Replication between sites and branches not guaranteed. Also, the EOL of this infrastructure drives this huge change, and to avoid huge change management on the application point of view and the need to maintain the same database technology it was the biggest challenge that I ever faced during this times, moving from Version 9 to 11g and now to 19c.
How has it helped my organization?
It has improved the performance, now we run with more performance cores with less CPU to attend all the database demands. Reducing Time to Market, increase our ability to face the competition with speed and low cost. We improved the database availability while ensuring business continuity implementing efficient replication between main and DR site, so we decreased from one downtime in two months to zero downtime a year. So we can sleep as we are confident that data replication is running without any constraints. Multi-tenancy is one feature that can be used to guarantee the investment on this infra.
What is most valuable?
Business Continuity is the most valuable feature. The replication between the site via Data Guard is performing without any constraints, the agility to make tests of switchover, and back following disaster recovery procedure. The performance using this machine to providing database service is as easy as next to next database administrations. We can run AWR data collection for performance evaluation and problem-solving without any production performance constraints. Using Database partitioning and Cache Memory in each storage cell boost all we need as a database machine. The easy administration gives us time for training, improve our business understanding, and care about our competitors. Also, the container Database (CDB/PDB) together with other technologies (like Micro Services) can very improve the company core business.
What needs improvement?
The Oracle Support. I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination. Increase the FDP in the Southern Africa region can boost quality and competition on support service also increase product selling on these countries.
For how long have I used the solution?
I have been using Oracle Exadata for bout nine years.
What do I think about the stability of the solution?
This machine are equipped with new edge of fault tolerance technologies ensuring business continuity. All servers have dual power supply and the hard drives are reliable. Following the Oracle procedure to assembly this hardware in your datacenter with clean power is one thing that guarantees the stability. Of course, a support contract must be signed off between client and oracle to predict all possible disruption on time.
What do I think about the scalability of the solution?
There are many models of this engineering system, starting from X2 in 2011 to the last version X8M, you can choose a quarter, half and full, depending on your workload and budget. Starting with the quarter size you can scale it by adding more servers and storage until Full version or adding another box.
How are customer service and technical support?
Every implementation is unique. I have been working with Oracle since 2005 and have not had issues regarding technical support. But Oracle must audit their implementation partners regularly to avoid major problems like a bad quality implementation that make clients raise a call.
How was the initial setup?
The initial setup is not so complex as it is done by Oracle Experts and is validated by the senior engineers.
What about the implementation team?
We implemented it through the vendor team. I worked with a very skilled personal, like project managers, ACS Support Leaders and technicians that have very experience in deploying this kind of systems
What was our ROI?
Using this infrastructure for a database as a service or Oracle Cloud at Customer/Service can be a good approx. to increase your ROI.
What's my experience with pricing, setup cost, and licensing?
Going to EXADATA is not good advice for non-profit companies, like government institutions, all though this is a very safe infrastructure to guarantee security and availability for a long period. The OPEX must be well prepared for a period that can have all the return of the investment. Using EXADATA as a database as a Service (Multi-tenancy) can be an alternative to good ROI.
Which other solutions did I evaluate?
We also evaluated Postgress.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Software Engineer at a retailer with 10,001+ employees
We tuned so much code by using all the techniques and it is working fantastically.
What is most valuable?
- Oracle OEM
- Analytic functions and Window functions
- Parallelism
- Hints to the optimizer
- Gather statistics
- Extended Statistics
How has it helped my organization?
We tuned so much code recently by using all the techniques above and it is working fantastic.
What needs improvement?
The Oracle tuning advisor could have been available to Developers so that they can send the advises to DBA's.
For how long have I used the solution?
2 years
What was my experience with deployment of the solution?
Nnope. It is usually we forget to mention the Schema names before the deployment and it fails when DBA's runs with Super user.
What do I think about the stability of the solution?
Some time in Last junuary we had an issue with when we upgrade the database and the queries are started running very slow and we have changed the way of running statistics with Oracle recommendations and it started running fine.
What do I think about the scalability of the solution?
Nope not yet but we might have plans to move it to Cloud. we are not really sure. We have our own data center and we never had any problems with Scalability
How are customer service and technical support?
Customer Service:
It is good and sometimes we don't get exact recommendations even though we give all details but it was satisfactory.
Technical Support:it is good they are knowledgable enough to answer our questions.
Which solution did I use previously and why did I switch?
We never used any other solutions before and we are only using Oracle form the beginning.
How was the initial setup?
Nope. it was quite easy.
What about the implementation team?
We have implemented through PWC. but it was pretty stable.
What was our ROI?
More performance techniques and latest updates that we are really existed about.
What's my experience with pricing, setup cost, and licensing?
Pricing is fine because we are seeing an excellent results. we could have get the same things for lower prices but the Oracle service is really good.
Which other solutions did I evaluate?
Yes. 1. Performance, 2. Scalability 3. Cost
What other advice do I have?
Oracle solutions are excellent and evolves according to the customer needs. Whenever there is a bug we recommend to the customers directly so that they are aware of whats going on rather they find out them selves. This helps service improvement as well customer relations hips.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Director at a financial services firm with 1,001-5,000 employees
Single appliance with no additional tooling required for deployment. The need for additional licenses for core Oracle products is an area for improvement.
What is most valuable?
Performance with use of storage compute.
How has it helped my organization?
Single appliance with no additional tooling required for deployment reduces overall maintenance and cost of ownership.
What needs improvement?
Cost, need for additional licenses for core Oracle products.
For how long have I used the solution?
Two years.
What was my experience with deployment of the solution?
Yes, Cisco switch is not a standard within our company. Need to deploy with Oracle switch, after initial validation and setup, un-plug all network, replace the Cisco switch, and recable. This is time consuming and should not be required if Oracle would simply put in a different Cisco switch.
What do I think about the stability of the solution?
No.
What do I think about the scalability of the solution?
Yes, memory limitations, 756gb limits the performance of databases.
How are customer service and technical support?
Customer Service:
Platinum support services supplied with the Exadata is worthless.
Technical Support:If I have an application down, we do not call oracle support as their response times to get a qualified engineer on the phone take 4+ hours. We solve problems ourselves.
Which solution did I use previously and why did I switch?
ODA and standalone.
Scalability and consolidation.
How was the initial setup?
See the switch issue mentioned above.
What about the implementation team?
Implemented in-house with the assistance of Technologent.
What was our ROI?
Negative.
What's my experience with pricing, setup cost, and licensing?
Total ROI should include the HW and all the associated SW licenses required. With an EXA, the cost to implement is prohibitive when also performing replication as you have to procure two of these very expensive boxes.
Which other solutions did I evaluate?
ODAs.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Founder and President at Viscosity North America
A single consulting resource can patch/upgrade the entire stack because patching and maintenance has become reliable and simplified.
What is most valuable?
My top 4 most important features of Exadata are:
1. Smart Scan, the ability to offload intensive SQL workloads to the storage servers. Queries are offloaded to the storage layer and only the result sets of relevant data are returned to the database server thus significantly improving performance.
2. Exadata Hybrid Columnar Compression, where we can compress data from 10x to 50x. Deploying databases on the Exadata can significantly reduce the amount of storage that is needed.
3. Exadata Smart Flash Cache automatically moves data between DRAM, flash and spinning SAS or SATA disks to provide best performance.
4. Virtualization is a new feature introduced to the X5-2 family. Now Oracle’s Database Machine can be catered to large enterprise mission critical databases and can house smaller databases that need isolation and now even application servers together with the database. We can connect data intensive applications to the database over low-latency, high throughput infiniband.
How has it helped my organization?
We are able to provide a complete solution to our customers from data center installation/configuration, firmware upgrades, ILOM upgrades, OS patching/upgrades, cluster patching/upgrades and database patching/upgrades. We can upgrade the entire stack in a single evening with minimal outage. Depending on the customer’s tolerance for downtime, we can either perform the patching or upgrade in a rolling fashion.
Patching and upgrade services have proven to be a value-add differentiator for SMB and mid-market customers where resources and budgets are often limited. A single consulting resource can patch/upgrade the entire Exadata stack because patching and maintenance has become reliable and simplified.
What needs improvement?
For the initial instantiation process, the Oracle Exadata Deployment Assistant (OEDA) could have better error checking and pre-check validation as you navigate through the tool. When executing the OneCommand utility, generated logs are decent but the logs are not detailed enough to pinpoint to where the error occurred in the stack. Oracle can do a better job with error isolation. After the OneCommand, other one-off commands have to happen (i.e. we have to login to the infiniband and cisco switch). Ideally, OEM could be leveraged to configure the remaining components of the Exadata after the OneCommand. The idea would be to reduce the number of people required to support the stack. If we leverage OEM, we can leverage a single resource that minimally understands the stack to support the workflow.
For how long have I used the solution?
I've been using Exadata since V2 in 2009.
What was my experience with deployment of the solution?
For new DBA's trying to understand the Exadata infrastructure, they struggle initially trying to understand all the components between ILOM, ASR, and OEM (what they manage, what they support, and what problem area that they detect) and which does what since they are overlapping. Consolidation management across the Exadata is another common issue on the Exadata. OEM is good at managing individual targets but not so great yet on identifying culprits across environments with heavily consolidated databases. When you look at the compute wholistically, it is difficult to identify what database is consuming most CPU and most I/O resources. Doing any kind of showback is difficult to do across instances.
What do I think about the stability of the solution?
I only see stability issues with Exadata when I see too much consolidation, and/or the Exadata is not sized properly. Often the customer tries to throw everything and anything on the Exadata, by over-parallelizing OLTP/batch processes without any resource management across any databases.
What do I think about the scalability of the solution?
With the Exadata, if I see an issue with scalability, it is typically goes back to being a sizing issue. The real question I have to ask is: did you get the right Exadata configuration for your database(s). If your Exadata configuration is sized properly, you should not have scalability issues.
If you let every database see every CPU on the Exadata compute node, you can potentially run into scalability issues. Customers who do not take advantage of database resource manager or IO Resource Manager (IORM) often run into performance issues in a consolidated environment. Likewise, if a customer tries to over-parallelize their application code, it can cause scalability issues. We tend to see more issues with improper management of parallel execution on the Exadata because it is perceived as something you can throw anything at.
How are customer service and technical support?
Customer Service:
The Exadata stack is well known and has become a standard platform with Oracle customers; thus, triage to resolution has become much more streamlined. When you create a service ticket with Oracle Support, time to resolution is significantly reduced. On another note, Oracle Field Support engineers are remarkable. They have been quick to respond, flexible, knowledgeable, and willing to work with our schedule.
Technical Support:Oracle Support Engineers are outstanding but you have to know how to navigate the system. Oracle Support provides all the technical support for the Exadata including the database software, OS, and hardware. Not knowing how to navigate through Oracle’s support structure and escalation policies can leave you feeling stranded by the vendor. Logging a support ticket with any component of the Exadata is no different than logging a support ticket for a database issue. You need to know how to raise a severity for a service ticket and how to escalate a support issue with the duty manager when production issues occur. Having a seasoned DMA (database machine administrator) is crucial to a successful Exadata deployment.
Having said that, often with Exadata customers, they can create a service ticket with the wrong Oracle Support group. This can cause confusion and elongated response times at early stages of the Exadata deployment as the service ticket gets routed to different teams within Oracle Support.
Which solution did I use previously and why did I switch?
Lot of our customers come from best of breed technologies (UCS/Dell/HP, EMC/Hitachi) to choosing Exadata. Typically, our customers choose Exadata for pure performance in IOPs, throughput, and low latency for their database workloads; however, we have seen a trend of customers choose the Exadata platform because they are short staffed, have high rates of attrition, and thus, have inability to support the hardware and software technologies.
How was the initial setup?
The initial setup is straightforward with the Exadata X5-2. We have to re-image the factory Exadata and leverage OneCommand for configuring the compute and storage nodes.
What about the implementation team?
A lot of the initial setup is configured by the Oracle ACS (Advanced Customer Support) organization; however, Viscosity is a certified Exadata implementation specialist and often perform the initial installation and configuration at the customer data center. By the time the customer receives a fully configured Exadata, they are ready to deploy databases as a RAC or non-RAC database.
What was our ROI?
For our customers, we are able to significantly reduce both CapEx and OpEx for customers for 3-5 years TCO. We are able to:
- Accelerate implementation to meet the functionality demand from the business users
- Deliver quick implementations to meet the market demands
- Lower implementation costs
What's my experience with pricing, setup cost, and licensing?
Setup costs for the Exadata varies from customer to customer and depends on database size, number of databases, and number of applications. For our most recent customer in Dallas Texas, the cost rolled up to approximately 800k for 2 X Quarter racks, which include storage cell software, and 25k for setup services. To determine day-to-day cost, we estimated the cost to average about 7k per month for both QTR racks.
Which other solutions did I evaluate?
A lot of our customers typically look at two other options. We have seen customers perform side-by-side evaluations by building their own high performance system with EMC/Pure Storage/Violin All Flash Array and UCS/HP/Dell blades or perform comparisons with a converged system such as VCE‘s Vblock. Customers typically ask for a proof-of-concept demo and run performance benchmarks with their own database and application to see the immediate impact and value-add for their organization. Our last 3 customers have compared Exadata with the Vblock.
What other advice do I have?
For new customers who are about to embark on the Exadata journey, they should consult with a vendor specializing in Exadata implementations for the first set of database migrations and technical direction. Customers should also do the proper sizing exercises either with Oracle or with the Exadata Specialty niche vendor to buy the suitable Exadata configuration what will suit their business needs for the next several years.
When purchasing Exadata, they should also look into purchasing either the ZFS Storage Appliance (ZFSSA) or the Zero Data Loss Recovery Appliance (ZDLRA) to offload their backups to leveraging Infiniband technology for maximum throughput.
OEM CC 12c provides a comprehensive monitoring and management of the Exadata platform. Not only can OEM monitor and maintain at the hardware level for compute, storage and network but also at the OS, cluster and database level. OEM Cloud Control can monitor all components of the Exadata.
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer: We are an Oracle Gold Partner, reseller, and certified implementation specialist for Exadata. We are also authors of the Exadata Expert Handbook (http://www.amazon.com/Oracle-Exadata-Experts-Handbook-Farooq/dp/0321992601/ref=sr_1_1?ie=UTF8&qid=1432846914&sr=8-1&keywords=expert+exadata+handbook) and Oracle ACE Directors.
BI Expert with 1,001-5,000 employees
Fast processing for a pretty penny.
Oracle’s Exadata is a self-contained database appliance. Traditional database architecture would have a server that contained the CPU, memory and enough hard drive space to house the Operating System connected through a network to an array of hard drives for all other storage. Scalability was achieved through adding additional database servers and creating a cluster, and expanding the back end array. This traditional architecture resulted in poorer performance in read and write intensive applications such as Data Warehousing due to bottlenecks in the storage array.
Database appliances combine the processing with the storage achieving exponentially faster performance by having onboard dedicated storage and software to manage the distribution of data across that storage.
The pros of Exadata are:
• Hardware is easy to deploy
• The system is faster than comparable data models on traditional architecture
• Oracle 11g holds the record for the fastest OLTP. http://www.tpc.org/tpcc/results/tpcc_perf_results.asp
• Scalability is easy – just add additional nodes or Oracle’s storage expansion rack
• Integration with a Oracle product line that has a lot of depth
The cons of Exadata:
• Performance on some queries may dramatically change for the worst and need extensive tuning
• The optimizer is not well understood by anyone (including Oracle support) which leads to the first con
• The storage management software, while has gotten better since the 1st generation of the product, has a tendency to be buggy
• Requires a lot of administration by DBAs.
• 1st generation Exadatas on the HP hardware are crap.
• They are expensive – both licensing and hardware and not all of the database software is included in the Exadata price. Single full rack database machine and storage with full support is around 1.5 million (doesn’t include the year over year licensing). http://www.oracle.com/us/corporate/pricing/exadata-pricelist-070598.pdf
The main thing to point out with this hardware is that it is purpose built. While Oracle might market it as the single database appliance to end all, it is still not a best practice to combined mixed workloads (OLTP/OLAP) into the same physical or logical architecture. Performance to an extent in OLAP is still driven by having an appropriate and performing data model. Hardware will only provide so much of a boost and is still driven by the logical design of the database.
I would recommend Exadata if you are moving from an Oracle legacy system. If you are looking to move from another vendor, then the process is going to be rather difficult in getting it to work on Oracle. If you are building from the ground up, then it depends on the budget you have to work with.
Main competitors of the Exadata – PureSystems by IBM (FNA Netezza), Teradata, EMC’s Greenplum.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Partner at Tsp Teknoloji Danışmanlık A.Ş.
Performs well with large databases and provides excellent data transformation features
Pros and Cons
- "The tool performs well with a large database."
- "The analytics features must be improved."
What is our primary use case?
We work on data warehouses and data marts.
What is most valuable?
The tool performs well with a large database. It is easy to integrate the tool with other ELT solutions. The performance and data transformation are excellent. We recommend it to our clients. The tool has good storage technologies.
What needs improvement?
The product must make more investments in object storage technologies. Six to seven years ago, the product had an SQL-based analytics feature that did not work well. The vendor must consider investing in it. The analytics features must be improved.
For how long have I used the solution?
I have been using the solution for more than ten years.
What do I think about the stability of the solution?
Oracle Exadata is a robust product.
What do I think about the scalability of the solution?
We must pay more money if we need more storage. I rate the product’s scalability a ten out of ten. The tool is suitable for enterprises and SMBs.
What's my experience with pricing, setup cost, and licensing?
I rate the tool’s pricing a three out of ten. The solution is expensive.
Which other solutions did I evaluate?
Teradata is a competitor. If we use Teradata, we must use their data warehouse model.
What other advice do I have?
I will recommend the tool to others. Overall, I rate the product a nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Last updated: May 18, 2024
Flag as inappropriateBuyer's Guide
Download our free Oracle Exadata Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
Product Categories
Data WarehousePopular Comparisons
Snowflake
Teradata
Vertica
VMware Tanzu Data Solutions
Apache Hadoop
SAP BW4HANA
IBM Netezza Performance Server
Oracle Database Appliance
IBM Db2 Warehouse
SAP IQ
Microsoft Parallel Data Warehouse
Oracle Big Data Appliance
IBM Integrated Analytics System
Yellowbrick Data Warehouse
Silk Platform
Buyer's Guide
Download our free Oracle Exadata Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
- Is VxrRail a good alternative to an Oracle environment?
- Looking for advice on how to migrate from Oracle Exadata to VMware Tanzu Greenplum
- Which solution do you prefer: Oracle Exadata or Snowflake?
- What are the main differences between Oracle Exadata and Teradata?
- Which solution is better for setting up a data lake: Apache Hadoop or Oracle Exadata?
- Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
- When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
- At what point does a business typically invest in building a data warehouse?
- Is a data warehouse the best option to consolidate data into one location?
I agree, just go with Exadata. Exadata made it really easy for us to implement data warehousing projects.