PeerSpot user
Senior Analyst ( Senior Oracle DBA) at a tech services company with 10,001+ employees
Real User
We're able to add more users, and queries get executed very quickly for data warehousing compared to our previous solution.

What is most valuable?

  • Smart Flash Cache
  • Storage Index
  • Smart Scan
  • Hybrid Columnar Compression
  • Oracle ASM
  • Security with encryption
  • Oracle platinum support

How has it helped my organization?

We were using a normal RAC on a Linux server for online applications and Oracle on the same platform for data warehousing. After moving to Oracle Exadata, we were able to add more users, and queries get executed very quickly for data warehousing, around one quarter to half the time when compared to our previous solution under normal conditions.

What needs improvement?

  • Shared RAM for multiple instances
  • Hardware update in terms of storage
  • Ability to migrate a database to Exadata from a normal environment

For how long have I used the solution?

I've been using it for five years, including in my previous company.

Buyer's Guide
Oracle Exadata
April 2024
Learn what your peers think about Oracle Exadata. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,886 professionals have used our research since 2012.

What was my experience with deployment of the solution?

During migration, we approached transportable tablespace and Oracle database along with GoldenGate.

What do I think about the stability of the solution?

There have been no issues with stability.

What do I think about the scalability of the solution?

It's been able to scale for our needs.

How are customer service and support?

10/10 because we have Oracle Platinum Support.

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

Previously, we used SQL tuning, server tuning along with network tuning with huge storage and higher CPUs. It was a management decision, along with our recommendations, to move to Exadata.

How was the initial setup?

It was a complex setup because we were implementing the online application as well as data warehousing on the same machine. Lots of planning took place before moving to Exadata, and we did regression testing for each application on an Oracle provided Exadata machine. After verification from our application team and management, we verified our test results.

What about the implementation team?

We did it in-house with help from Oracle.

What's my experience with pricing, setup cost, and licensing?

It's too costly.

What other advice do I have?

I have seen, and it's my personal experience, that if your application runs on half a rack don't go for a full rack. After all, you can upgrade from half a rack to a full rack if needed, and there is no point to move directly onto a full rack.

Check with Oracle and do testing on the lower version rack first. Although sales people from Oracle will convince you to go for a higher version, which is not needed unless your design, architecture, and applications needed .

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

With regards to "Ability to migrate a database to Exadata from a normal environment" in Room for Improvement

What did you try? I found a simple CTAS worked just fine. The Transportable TS and GoldenGate were just too much trouble setting up. Going from AIX to Linux also was an issue with the Endian conversion.

As for shared RAM, what are you trying to achieve? Oracle 12 is likely what you are looking for.

See all 2 comments
it_user270906 - PeerSpot reviewer
Project Manager at a tech services company with 1,001-5,000 employees
Consultant
In addition to greater scalability, better reliability, and a smaller datacenter footprint, the intelligent features utilize the storage layer in a way we've found valuable.

What is most valuable?

The intelligent features have been built to utilize the storage layer in a much better way.

How has it helped my organization?

It's one of the most stable, high-performing products I've used.

What needs improvement?

More control for database admins is needed for storage indexes and pricing.

For how long have I used the solution?

I've used it for close to five years.

What was my experience with deployment of the solution?

No issues encountered.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

It's average.

Technical Support:

It's average.

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

We switched because we get better reliability and scalablity, as well as improved performance and a smaller footprint in the datacenter.

How was the initial setup?

It was straightforward.

What about the implementation team?

We implemented it in-house.

What was our ROI?

It's close to 40% in terms of cost saving.

What's my experience with pricing, setup cost, and licensing?

Oracle's pricing and licensing is always costly.

Which other solutions did I evaluate?

No issues encountered.

What other advice do I have?

If you are running Oracle databases, this is the best solution.

Disclosure: My company has a business relationship with this vendor other than being a customer: Platinum Partner
PeerSpot user
Buyer's Guide
Oracle Exadata
April 2024
Learn what your peers think about Oracle Exadata. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,886 professionals have used our research since 2012.
PeerSpot user
Presenter at a consultancy
Consultant
It's not "one size fits all"

Whoever is the "Oracle Support" that does the initial setup seems to think that one-size-fits-all is the solution to every application environment. Still seems to be the approach of the 1980s that if the menu comes up then the setup is complete. For all the money and hoopla it is a disappointment to have to struggle with memory issues when doing simple tasks like adding large number of partitions.

There should be an option at install time to deal with DW and OLTP environments. I dont think that the training provided for "Exadata Support" persons is adequate to make the configuration modifications. So the "user" of the Exadata is left to deal with a machine configuration suitable for "oranges" when it is really "apples" that are needed.

Update
Once again it all boils down to how much the organization wants to own the Exadata environment. Not taking a hands-on approach to monitoring and fine tuning based on "experience" is not making the best use of the resources. But there appears to be a trend towards "leaving everything vanilla".

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

I am not questioning the content and delivery of your training (cto6336)!. I am only questioning the observed outcomes from the Exadata training that I have experience with. If after the training, the "DBA" comes out with a fear and apprehension of doing anything other than compression to solve all known problems to mankind, then I think the training has failed. There have been many White Papers from non other than Oracle, which says things are different between a DW/BI and an OLTP environment. Also if there are partitions then there will be row movement. I am not sure if Exadata magically, if at all, deals with these when there is compression. Also if there is compression then there is a throughput penalty when we are doing migration from 10gR2 into Exadata. What happens when we have predefined tables with compression and we are trying to use transportable tablespaces. Do the predefined compressed tables remain on the target or will the whole thing fail? When we do data migration using simple CTAS having compression at the target will slow down the process. When there are only 6 hours of downtime available after which we have to resume data loading it becomes a crucial issue not to have anything take up more time.

The "fear and inability to think differently" after coming back from an Exadata Training ==> because Oracle Support will not allow it, is not the expected outcome from the course and neither is it going to make for the best deployment of Exadata expensive as it is.

Also to not even have the willingness (or perhaps in our case the knowledge) of making use to the Terabytes of ssd drives to put some high read tables is not what I would have expected from the Exadata training.

See all 2 comments
it_user701433 - PeerSpot reviewer
Senior Oracle RAC / Exadata Administrator at a tech services company with 1,001-5,000 employees
Consultant
Provides terrific performance and huge space savings in compressed backups.

What is most valuable?

Smart Scan, HCC Compression, Storage Indexes, Flash Cache, Flash Log and the two server types, i.e., High Performance and High Capacity are the most valuable features.

How has it helped my organization?

It provides terrific performance, huge space savings in compressed backups and lesser backup duration with parallelism.

What needs improvement?

Gathering various logs during the performance issues needs to improve.

For how long have I used the solution?

I have used this solution for six years.

What do I think about the stability of the solution?

Initially, we did experience stability issue but thereafter, it was well-stabilized.

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and technical support?

An excellent support is provided by Oracle, it is based on the support model paid for.

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

Previously, we were using the standard UNIX clustering servers. Performance and scalability are the reasons as to why we switched over to this solution.

How was the initial setup?

The vendor does the setup.

What other advice do I have?

This is a really good solution. Initially, query issues are expected but once stabilized, an amazing performance is expected.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user687189 - PeerSpot reviewer
Co-Founder/CTO/Chief Architect at a tech services company with 11-50 employees
Consultant
By going to Exadata platform, we forced the best practice to a single stack version.

What is most valuable?

The Exadata system is specifically optimized for database workloads. But
the key [Exadata specific] features that we leverage for our workloads is
Exadata Smart Scan, Smart Flash Cache, Hybrid Columnar Compression, and of
course all the 12c Oracle Database which are integrated with Exadata stack;
e.g, Multitenant/PDB.

How has it helped my organization?

We have consolidated a large portion of our disparate database deployments
from across the enterprise onto the Exadata. This has saved us and our
customers Capex and datacenter floor space. But more importantly, it's
forced us to rationalize and standardize on a specific software stack. For
example, earlier we had eight or nine different versions of Oracle Grid
Infrastructure and Oracle Database. By going to Exadata platform, we forced
the best practice to a single stack version.

What needs improvement?

The key areas of improvements are better documentation, Exadata hardware
stack monitoring, and improved awareness (self-tuning) application/SQL for
Exadata. For monitoring, most of the admins had difficultly with the OEM
Exadata Plugin, and thus we wrote our own monitoring. In addition, most
customers have custom network configurations, these don’t always fit into
the Exadata “out-of-box” supportability. Oracle ACS had to work
particularly closely with Network team to resolve firewall, port-forwarding,
DNS name resolution issues, etc.

What do I think about the stability of the solution?

We have had issues with storage cells failing and rebooting, but with proper
configuration and redundancy decisions (upfront) we barely noticed the
event. Nevertheless, when we had component failures it was difficult to
diagnose and triage.

What do I think about the scalability of the solution?

No, this is one issue we didn’t encounter. We decided on the appropriate
Exadata configuration and we deployed and consolidated. Moreover, Exadata
has Elastic configurations as well. Nevertheless, there are some internal
areas where the admins need to set and rationalize perception. Some SQL
is poorly written and even Exadata can’t fix that. The perception is that
Exadata is a single “red” pill to cure bad code, that’s just not the case.

How are customer service and technical support?

Oracle Exadata Tech Support has been great. We had many issues with Oracle
ACS and Platinum Support; specifically around the areas of scheduling
patching and upgrades. For these reasons, we ended building that skillset
in house.

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

We had disparate configurations, ranging from IBM AIX P-series, HP systems,
and older Solaris systems. We began our consolidation approach and
standardized on the Exadata for our Oracle Database 11.2 and above systems.

How was the initial setup?

The initial setup required a lot of planning from all stack parties. All
features and configuration need to be discussed upfront. However, with
detail planning, the execution and deployment, via “OneCommand” process, was fairly straightforward.

What's my experience with pricing, setup cost, and licensing?

This is where the Exadata hangup occurs. Not only are users paying for
Oracle EE and options such as RAC, and most of the must-have features such
as Advanced Compression, and Partitioning; but also the Exadata Storage
software. Add in the Support costs for all that storage. However, Oracle doesoffer “capacity on-demand” options, which do mollify the compute
licenses (not storage licenses) to an extent.

Which other solutions did I evaluate?

Yes, we looked at Hyper-Converged Systems and UCS compute with
All-Flash-Arrays. And we did buy those systems for specific applications
that didn’t fit the Exadata solution.

What other advice do I have?

Understand pricing and cost of skillset acquisition. In addition, define the
organizational layout for supporting the Exadata, since Exadata is a
“converged and engineered system” per se.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521853 - PeerSpot reviewer
Database Administrator at Qualys
Vendor
If there are any patches or other updates, everything is combined as a single patch. We had lots of storage issues and disk failures.

What is most valuable?

I like mainly the performance. Also, we have enabled RAC clusters. That's one of the main things, as well as high availability. The performance and high availability are really awesome.

How has it helped my organization?

The main benefit is that everything is powered by Oracle; the whole box, hardware, software, and storage. So we have the flexibility of going to one vendor directly instead of going to multiple vendors if we had any issues. If we have a storage issue, we go to them. If we have a database issue, we go to them. And if there are any patches or other updates, everything is combined as a single patch. We can apply it and it's easy to apply with a single command and easy to coordinate and support.

What needs improvement?

In the current version we're using, we had lots of storage issues, disk failures, etc. We think in the future, we'd like to see that reduced. That will reduce the cost and everything for the client.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

We had an issue where we had to increase the storage and we got the new cells from Oracle. Then we scaled outward.

How are customer service and technical support?

We have used technical support many times. Most of time it's okay, but sometimes there's a delay in the response. Then we have to escalate and get it done.

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

We didn’t have any previous solution. We had different vendors, like a storage vendor, and the DB software was from Oracle. As a security company, we want to maintain our compliance by applying the latest patches. That's why we chose this engineered system: so that we have a single vendor we can contact easily.

How was the initial setup?

For setup, we had a consultant come in. They trained us initially and helped us with the set up. Then, after that, we started working on everything.

What's my experience with pricing, setup cost, and licensing?

It's very costly.

What other advice do I have?

I would suggest going with the product, but again it depends on the application, the budgeting and all that. The budget for the application depends on how critical the application is. If it's really critical and revenue generating, then I'll recommend going with this product. But if it is not so critical, then I'll recommend going with something is less costly.

Mainly, we already had experience with the Oracle database and that's why we chose this one.

Technical support is one of the things we look for in a vendor, because any issue we get we want to get a response as soon as possible. We also consider the stability of the product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user406893 - PeerSpot reviewer
PL/SQL Developer at a marketing services firm with 1,001-5,000 employees
Vendor
Exadata is fast, but things are different. There was a significant learning curve involved in getting it to run our heavy-duty reports.

Valuable Features:

It's a fast solution, though it does take some work to ensure that queries are offloading using bloom filters, etc.

Improvements to My Organization:

It replaced a legacy database (SAND) and was part of a major overhaul. It didn't change the way the company worked per se, but it did force the creation of an Exadata compatible reporting framework, and it was that framework which enabled a leaner rewrite of the existing reports and provided a basis for new ones.

Room for Improvement:

As soon as your joins get complicated, things start to go wrong. You lose much of the offloading and start spilling into temp space. We were reporting on billions of rows and it was a constant problem so a custom reporting framework had to be created. Parallel queries need to be carefully managed and the DBAs need to be right on top of the resource manager, as if you aren't managed properly as a user, you can end up waiting behind others. 

Deployment Issues:

We've had no issues with deployment.

Stability Issues:

We've had no issues with stability.

Scalability Issues:

We've had no issues with scalability.

ROI:

There was quite a learning curve despite knowing that "things are different" with Exadata.

Cost and Licensing Advice:

I do know it's eye-wateringly expensive and that we struggled to get it to do what we wanted it to do.

Other Advice:

I'd be interested to see how the run times stack up against Hadoop or similar - but once you've spent the money, there's no going back!.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user1011 - PeerSpot reviewer
Manager of Data Center at a insurance company with 51-200 employees
Vendor
Good for Data Warehousing and OLTP Applications

Valuable Features:

• Exadata provides great improvement in terms of read/write response time. The response time is approximately 10x the performance of a regular disk. • Tuning is automatic. • SQL operations run faster, because large I/O operations are replaced by group operations. • Ideal for data warehousing since it supports bulk load operations. • Good storage capacity

Room for Improvement:

• Licensing is per CPU and relatively expensive. • It is specifically designed for data warehouse and OLTP platforms; so, it is not cost effective when investing in it for low data transactions. • The hardware runs only Oracle Software Exadata is a proprietary system from Oracle, that combines both hardware and software requirements for data warehousing and OLTP applications. Oracle utilizes the improvement in disk technology, to produce one of the best machines, ideal not only for data warehousing, but good for private cloud.

Other Advice:

Smart Scan , Smart Flash, storage Index, Hybrid Columnar Compression, Resource Manager and Smart Scan of Data mining Model Scoring technologies are the features that places Exadata machine ahead of similar products. If you are looking for a data warehouse machine with large storage capacity, high performance, and manageability, Exadata is the best suite. But, you have to mentally prepare yourself for the fact that Exadata hardware only runs oracle software.
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: April 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.