Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Presenter at a consultancy
Consultant
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.
PeerSpot user
it_user3309 - PeerSpot reviewer
it_user3309Presenter at a consultancy
Consultant

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

See all 3 comments
PeerSpot user
Oracle Database Specialist at a comms service provider with 1,001-5,000 employees
Vendor
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.
PeerSpot user
it_user259683 - PeerSpot reviewer
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.

See all 2 comments
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.
it_user242436 - PeerSpot reviewer
Infrastructure Principal Director at a tech services company with 10,001+ employees
Real User
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.
PeerSpot user
it_user521775 - PeerSpot reviewer
Dev Lead PeopleSoft FIN at a religious institution with 1,001-5,000 employees
Vendor
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.
PeerSpot user
it_user522213 - PeerSpot reviewer
DBA at a religious institution with 51-200 employees
Vendor
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.
PeerSpot user
it_user521874 - PeerSpot reviewer
Lead Performance Engineer at a tech company with 10,001+ employees
Real User
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.
PeerSpot user
PeerSpot user
Database Development Leader at a tech company with 10,001+ employees
Real User
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
PeerSpot user
it_user521901 - PeerSpot reviewer
Head Of Section Of DB Ms Support And Deployment at Sportmaster
Consultant
Provides scalability and high performance; our business solutions run more quickly

What is most valuable?

Scalability and high performance, real high performance.

How has it helped my organization?

The most basic business solutions run more quickly.

What needs improvement?

I don't know. We've only just started using it. It's a new solution for us.

What do I think about the stability of the solution?

It's stable.

What do I think about the scalability of the solution?

We can extend the data without any trouble, just put something new in and go on. That's great. There's no problem of that kind with this solution, for us.

How are customer service and technical support?

Good quality support.

Which solution did I use previously and why did I switch?

We just switched from another older version of Exadata to the newest one.

How was the initial setup?

It's complex. We integrated an existing solution to Exadata.

Which other solutions did I evaluate?

Our short list was HP and IBM. We went with Oracle because we needed a unified solution like Exadata. No one else could provide a solution with this performance, for us.

What other advice do I have?

When looking at vendors to work with we look for good, fast implementation of the solution, reliable support, and lower cost.

It's a good solution for a data warehhouse, analytics, etc. It's just a good, reliable solution.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer'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 Warehouse
Buyer's Guide
Download our free Oracle Exadata Report and get advice and tips from experienced pros sharing their opinions.