The performance.
Director, IT at a tech services company with 1,001-5,000 employees
It makes it possible to deliver high performance Oracle OBIEE applications. It needs to be changed to be a true appliance so you don’t have to manage individual components inside it.
What is most valuable?
How has it helped my organization?
It makes it possible to deliver high performance Oracle OBIEE applications to our customers.
What needs improvement?
They need to reduce the cost. It needs to be a true appliance so you don’t have to manage individual components inside it. It needs to provide a better maintenance process, which means no downtime, and true rolling upgrade.
For how long have I used the solution?
We used Oracle Exadata from 2010 to 2015.
Buyer's Guide
Oracle Exadata
November 2024
Learn what your peers think about Oracle Exadata. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
What was my experience with deployment of the solution?
I have deployed OEM 11g and 12c in High availability mode and was not too complicated to implement. I have not tried HA with 13c. However, installation for all the releases have been fine.
What do I think about the stability of the solution?
We've experienced no issues with performance.
What do I think about the scalability of the solution?
We had some challenges on scalability. That time the only choice we had was to upgrade to a full rack from a ½ rack. However the newer version of Oracle Exadata has flexibility to upgrade. It can add database servers or storage servers not require to add ¼ or ½ racks.
How are customer service and support?
6/10 - not because of people, but technology and architecture. A few times we had issue to completely fail a drive before we can replace it.
Which solution did I use previously and why did I switch?
We had been using Oracle RAC on EMC disk array with Dell servers until the performance cannot really meet Oracle OBIEE application and some data warehouse applications’ performance requirement. We did look at Netezza and Datallegro, but they didn’t run the SQL that compatible with Oracle. By then Oracle Exadata seemed the only logical option for us. We also had a business reason to purchase Oracle Exadata at that time.
How was the initial setup?
The initial setup was pretty smooth and straightforward.
What about the implementation team?
We had Oracle team to setup the device.
What other advice do I have?
The device performed very well, but the biggest challenge for us was the maintenance. Any firmware, code or OS upgrade took long time, which requires a downtime window. The rolling upgrade would even take longer so we never tried it. I heard that the new version of Exadata should be improved in this area, but we have moved off Oracle Exadata platform. The DR is another challenge since ideally you would want have to a Exadata at DR site, which in most cases is cost-inhibitive. I would say that make sure you can do rolling upgrade for minimizing the downtime, and find a cost effective DR solution especially if you use HCC (Hybrid Columnar Compression).
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Presenter at a consultancy
v1 and v2 on Linux: Its large memory capability and parallelism potential has given a big boost
On a scale from 1-5 (1=worst, 5=best), how would you rate this product overall compared to similar products?
- 4, Have not used anything similar but our environment is mainly OLTP so we have to figure out how to take advantage of the normal 11gR2 features and make the optimal use of the Exadata structure and storage cells.
For how long have you used this product?
- 15 months
Which features of this product are most valuable to you?
- Parallelism
- Memory
- Storage Cell “intervention” for query performance
- If we can modify all of our code to use /*+ APPEND */ or /*+ APPEND_VALUES */ then the compression would be significant. Seems to be a “version 1.0” for OLTP centric applications. On the other hand we also need to rethink the database, application architecture and deployment.
Have been finding that in some situations with partitioned tables ignoring the local index (partition key) and doing a full table scan is a lot faster! For example
select /*+ parallel(t1,8) */
column_x
from partition_table t1
where partition_key_column >= trunc(sysdate-30)
and partion_key_column <= trunc(sysdate-1)
and other things
performs poorly (effectively hours!) and the execution plan show the use of the index associated with the partition_key_column.
adding the hint full(t1) gets the result back in less than 10 seconds
Can you give an example of how this product has improved the way your organization functions?
- We have a lot of documents to index and search. Exadata, with its large memory capability and parallelism potential has given a big boost, (300+%) to indexing throughput. We can see a potential for User Query performance improvements but this needs a “re-factoring” (re-write??) of the code.
What areas of this product have room for improvement?
- No built-in feature seems to be present for not allowing the CPU to become overwhelmed and crash the system. Oracle does (or should know!) how much CPU and RAM is necessary for the product to work. Why not just reserve this “minimum” capacity?
Did you encounter any issues with deployment, stability or scalability?
- Spurious shutdowns, snapshots stop working.
Did you previously use a different solution and if so, why did you switch?
- The physics of the old system could not be improved. “Out-of-the-Box” solution and probably more important a controlled and managed upgrades by the Vendor.
Did you implement through a vendor team or an in-house one? If through a vendor team, how would you rate their level of expertise?
- Combination
What advice would you give to others looking into implementing this product?
- If you cannot consolidate into a single database you are effectively spending a lot of money to get no further ahead.
I am beginning to wonder if Exadata X5 will be the end of the road and for seriously challenged Data quantity the shift towards the newer Big Data Appliance. There are also the new advanced analytic functions in the SQL in 12c.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Oracle Exadata
November 2024
Learn what your peers think about Oracle Exadata. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
Oracle Database Specialist at a comms service provider with 1,001-5,000 employees
With this solution, our data warehouse was consolidated on a single database with improved capability and performance.
What is most valuable?
SmartScan and Cell Offloading, which can drastically reduce I/O from queries, improving response time.
How has it helped my organization?
My company's data warehouse was consolidated on a single database with improved capability and performance. Maintenance tasks and jobs start to execute much faster on the new environment. Now our company is acquiring a new hardware to support our SAS application.
What needs improvement?
Massive updates statements should not disable HCC.
For how long have I used the solution?
I've used it for over two years.
What do I think about the stability of the solution?
When the workload increases on the cells, Cell Offloading may not happen.
What do I think about the scalability of the solution?
No issues encountered.
How are customer service and technical support?
Customer Service:
8/10.
Technical Support:8/10.
Which solution did I use previously and why did I switch?
No previous solution was used.
What about the implementation team?
The setup is conducted by Oracle, which is a requirement.
What was our ROI?
We've not measured it.
What's my experience with pricing, setup cost, and licensing?
It can simplify your IT environment, reducing the costs with maintenance operations if you have the Platinum offering.
Which other solutions did I evaluate?
We looked at Fusion I/O, but Exadata Storage was so much faster.
What other advice do I have?
It really fit our mixed environment and it is totally directed to DW/DSS environment, as most of the heavy queries would be performed on the storage server.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user259683Oracle Database Specialist at a comms service provider with 1,001-5,000 employees
Vendor
Sorry for the lat answer, we have 3 Exadata Machines one X2-2 Quarter Rack, one X4-2 Half Rack and one X5-2 Elastic Rack (4 DB nodes and 8 Storage Nodes).
Thanks.
Infrastructure Principal Director at a tech services company with 10,001+ employees
The fully converged approach of engineered systems certainly saves a lot of effort.
What is most valuable?
One of the less well appreciated features of engineered systems in general, and Exadata in particular, is the speed with which a customer can get up and running. Having all components, both hardware and software, fully configured, tested, and optimised on delivery is a major customer win.
To fully appreciate this you have to consider the alternative, which is traditionally a best of breed approach, and how long this takes customers, and the effort involved in wiring everything and ensuring full interoperability between both the hardware and software components. Having experienced the issues with this approach many times in the past, the fully converged approach of engineered systems certainly saves a lot of effort.
How has it helped my organization?
In addition to the enhanced speed of operational readiness, the other major, but less well appreciated benefit, is one of standardisation. Many large organisations have a wide and varied oracle database, both in terms of hardware and software. A big advantage I have seen is standardisation onto the one hardware platform and a minimal number of software versions. This has improved operational effectiveness.
What needs improvement?
Several barriers to entry have been overcome with the latest X5 generation, in particular moving to more flexible sizing (elastic configurations) allows customers to choose the exact fit of compute and storage resources they require.
For how long have I used the solution?
I've used this product for nearly 4 years now. I've used all versions of Exadata from V2, all the way up to X5. This covers 5 generations of enhancements.
What was my experience with deployment of the solution?
Issues encountered tend to business process problems or people problems. The issues tend not to be technical.
What do I think about the stability of the solution?
In the earlier days of the V2 generation, and with customers pushing the then limited memory and cpu sizings available, stability was not at the levels encountered today.
With properly sized memory parameters and with the later generations of the Exadata software, stability is excellent.
What do I think about the scalability of the solution?
Have worked on expanding racks with multi-generation racks, the promise of start small and grow over time is delivered fairly effortlessly.
How are customer service and technical support?
Technical support can be patchy, particularly a couple of years back, the number of support personnel with exadata skills was perhaps not at the level it could have been. That being said, I have continually been impressed with the field engineers. I have encountered some who's dedication and commitment to fixing issues went way above what I would have expected.
Which solution did I use previously and why did I switch?
Storage growth, and the possibility of utilising HCC to drive this down was a large driver for switching.
How was the initial setup?
The initial setup and deployment of an Exadata rack is straightforward it has been well engineered to be a very quick initial setup.
What other advice do I have?
The best advice is to scope upfront. Do a proper sizing exercise, get some outside assistance if you need it to get the sizing correct. If you are looking at a large deployment, consider piloting first, as you don't want to have a large amount of kit landing and then spend a long time on the migration.
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.
Dev Lead PeopleSoft FIN at a religious institution with 1,001-5,000 employees
I like the storage cell because of the amount of RAM and memory. It doesn't transfer as much data out as other systems do.
What is most valuable?
I like its reliability. I like the storage cell because of the amount of RAM and memory. It has the ability to do a lot of things, so that it doesn't transfer as much data out as other systems do.
How has it helped my organization?
Once we went to Exadata, we started doing statistics on a weekly basis. Between the two of them, things have stabilized quite a bit; didn't need as much tuning, and so it required less DBA time to do that. DBAs were freed up to do other work.
What needs improvement?
We have a 2X. Because I don't know what the 6X does, I don't know what additional features I’d like to see them include in future releases.
What do I think about the stability of the solution?
It's very stable and very reliable.
What do I think about the scalability of the solution?
I work with the PeopleSoft systems on the databases and it's doing just fine. I don't have to scale out.
How are customer service and technical support?
I don't believe we’ve had to use technical support. We had a little bit of help at the beginning to get everything installed; after that, it just ran.
Which solution did I use previously and why did I switch?
Someone in the upper management decided to spend some money, and we had the machines; he said use them.
How was the initial setup?
I was allowed to help with some of the initial setup. Most of it was handled by the DBA core team; what I did was give some ideas on how we ought to do some things.
What other advice do I have?
What size of database are you working with? What kind of reliability and stability do you need? Is the cost worth what they would get out of the stability.
I like the Oracle database. I find Oracle as a whole has a very stable database. As far as the Exadata is concerned, as I’ve mentioned, I didn't have a choice in the matter. Nonetheless, if given my druthers, I would stick with it because it is reliable, even though it is kind of expensive.
My rating reflects its reliability. If I was rating it just on cost, I would rate it much lower.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
DBA at a religious institution with 51-200 employees
Everything goes into one machine. Google searches help me more than Oracle support.
What is most valuable?
A valuable feature is that everything goes into one machine; Oracle and the applications, so that is a big advantage.
Sometimes, I don't see any difference between Linux servers and the Oracle ones.
What needs improvement?
We have only used this product for 3 years so I cannot say what exactly needs improvement.
See my Technical Support answer below.
For how long have I used the solution?
I have been using this product for about 3 years.
What do I think about the stability of the solution?
It is stable. Sometimes we need to do patching and they take the system down. For example, we did patching a couple of weeks ago and they took the system down. They said it's the OS patching although they did not inform us beforehand. They just went ahead and did it.
That's one thing about Exadata: Sometimes when there are errors, they have do the patching. We cannot just do it ourselves.
What do I think about the scalability of the solution?
The product is scalable.
In my management, I have no say as what to buy. I'm just doing the work. They keep buying it, so we have to keep supporting it.
How is customer service and technical support?
The technical support is terrible. When I search on Google, I get more answers than from the Oracle support team. For example, when we reach out to Oracle and claim something is not working like we cannot get OEM to connect from the Exadata machine. I simply searched on Google and found the answer. The Oracle support team could not find the solution for 3-4 weeks. Finally, I searched on Google and I found the answer in less than 1 hour. The issue was that 1 of the files had no permission for OEM to connect. That's it. Google is good. I can search anything on Google, not Oracle support.
How was the initial setup?
As a DBA, we usually use it for the database upgrade which is straightforward. For the OS upgrade, it's mainly up to the Oracle support and the platform support to carry out the upgrade. We don't do it. We're even afraid to install any third-party/ other vendor's application on it, as it may be harmful.
What other advice do I have?
One thing that's good is that everything is into one machine; the database and the application that we are using. Oracle cannot blame the third-party vendor. It's an OEM problem, so Oracle itself needs to support this product. That's the only advantage that I see. Oracle loves to blame somebody else for their issues. That’s why I am not keen on this product.
I use a lot of Linux servers and they all do the same thing.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Lead Performance Engineer at a tech company with 10,001+ employees
Because of the built-in flash, IO latency is drastically reduced.
What is most valuable?
The most valuable feature of the overall system is the way it is engineered. It basically gives you the best performance. The most important thing that you will see in the database, especially an Oracle database, is the latency because of IO. Because of the built-in flash, the latency is really reduced quite drastically.
We do see very good performance, at least 30% better performance in our overall response time when we use Exadata.
What needs improvement?
It's very specialized hardware. It really meets very critical needs, but it is very expensive. When I was working for another company, which was a mid-sized company, they did not even consider Exadata just because of cost. Making it more cost effective might help them.
Other than that, from a technical point of view, I can't think of any area with room for improvement.
For how long have I used the solution?
I have been using it for one year.
What do I think about the stability of the solution?
I believe it's a stable solution because we haven't seen any issues, so far.
What do I think about the scalability of the solution?
It is scalable, given the way you can add more and more Exadata to your configuration, but it gets expensive. However, I'm not the right person to comment on whether it provides enough value for the money.
How is customer service and technical support?
I don't know too much about their support because I'm not the person who directly interacts with Oracle support on any issues. Nonetheless, one thing I learned is, for any maintenance, we have to call an Oracle technician. That's in our contract and that gets expensive. For small and mid-sized companies, that might be a factor they might want to consider.
What other advice do I have?
If they are really looking for performance, and performance is the only thing that matters to them, while having a very stable system, this product is engineered within Oracle, who knows their database more than anyone else. A combination of hardware and software from the same vendor, it is specifically designed for Oracle Database, so I definitely recommend it, if it meets all their other cost and other requirements.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Database Development Leader at a tech company with 10,001+ employees
It aptly addresses the problems of database consolidation. No more arguments about running mixed workloads together.
Valuable Features
The following features of Exadata are the most valuable to me:
- Cell offloading
- Smart Scan
- Flash Cache
- Infiniband Fabric
- IO Resource Manager
- Hybrid Columnar Compression
- Storage Indexes
Improvements to My Organization
The Exadata database machine is a perfect solution to cater to the needs of large data warehouses. It aptly addresses the problems of database consolidation and marks an end to the argument of running mixed workloads together. With Exadata, we were not only able to consolidate our large data warehouses in a single machine, but we also stabilized the peak workloads. The throughput issues simply vanished with the features like Flash Cache and Infiniband Network Fabric.
On the operational fronts, Exadata streamlines the tasks and responsibilities in a distinctive manner across the levels of an enterprise IT structure. Solution architects act as machine administrators and make sure that the machine is being used in optimal way. At the same time, database administrators, being the familiar heads, don't find much change in roles. Overall, Exadata justifies the total cost of ownership (TCO) by balancing the capital and operational expenses - thereby achieving a higher ROI.
Room for Improvement
Starting from Exadata X5, virtualization is supported. The feature, though, for some reason, is not much talked about. If Oracle starts promoting OVM and VMWare on Exadata through white papers and case studies, I'm sure it will enable new IT setups in practice. For instance, virtualization support can enable ETL nodes to be resident with Exadata.
Use of Solution
I have been using this solution since 2012 (four years).
Deployment Issues
I did not encounter any issues with deployment.
Stability Issues
I did not encounter any stability issues.
Scalability Issues
I did not encounter any scalability issues either.
Customer Service and Technical Support
Customer Service:
I rate customer service 8/10.
Technical Support:I rate it 8/10. My experience with Oracle Support has been moderate. Many times, I find support engineers working on an SR seem to be in a hurry to change the status to 'customer working'. In the past, I've asked them to understand the issue over a call (rather than adding updates) and then suggest the solution.
Implementation Team
A vendor team with good expertise implemented the solution.
Other Advice
Find the appropriate workload for the machine. Looking at the data sheet, Exadata is a beast meant to solve bigger problems. You will not be able to gauge its benefits with nuggets of data.
Disclosure: My company has a business relationship with this vendor other than being a customer: I used to work for the vendor
Buyer's Guide
Download our free Oracle Exadata Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 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
Yellowbrick Data Warehouse
IBM Integrated Analytics System
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?
Have been finding that in some situations with partitioned tables ignoring the local index (partition key) and doing a full table scan is a lot faster! For example
select /*+ parallel(t1,8) */
column_x
from partition_table t1
where partition_key_column >= trunc(sysdate-30)
and partion_key_column <= trunc(sysdate-1)
and other things
/
performs poorly (effectively hours!) and the execution plan show the use of the index associated with the partition_key_column.
adding the hint full(t1) gets the result back in less than 10 seconds