We used to work on business intelligence projects, so we really enjoyed the service-like performance. It's been great.
The business intelligence is very good.
We have found that the analytics environment is excellent.
Download the Oracle Exadata Buyer's Guide including reviews and more. Updated: November 2022
Oracle Exadata allows enterprises to run any Oracle Database workload with the highest performance, scale, availability, and security on fully compatible cloud and on-premises infrastructure. Exadata uses a scale-out design with unique optimizations that include persistent memory, SQL query offload, and built-in resource management to optimize performance for OLTP, analytics, machine learning, and mixed workloads running in consolidated environments. By running hundreds or thousands of optimized Autonomous Database and Exadata Database instances on Exadata Cloud or Cloud@Customer infrastructure, customers are able to minimize their infrastructure, reduce management, improve developer productivity, and lower total costs by up to 40%, as described in Wikibon’s analysis (PDF).
The main benefit of Exadata is its speed. It hosts operating systems, CPU memory, and hard drives. It runs all types of databases, including online transaction systems, processors, and data warehouses, while remedying the poor performances of older databases.
Oracle Exadata features a simple and fast database storage system that protects and backs up your critical data. It accelerates data warehouse performance for faster access to business information and data. It is the ideal database solution for companies looking to build up their infrastructure from scratch.
Oracle Exadata Database Machine Key Benefits
Accelerate database processing: Exadata Storage Server implements a unique, highly efficient database-optimized storage infrastructure that enables Exadata’s unparalleled performance without any of the bottlenecks that traditional storage experiences. Each storage server contains CPU processors that are used to offload database processing. The CPUs in the storage servers do not replace database CPUs, but work alongside them to accelerate database workloads.
Reviews from Real Users
Oracle Exadata stands out among its competitors for a number of reasons. Two major ones are its robust performance and its wide variety of database features that make it a comprehensive database solution.
Adriano S., an IT system integrator at a financial services firm, writes, "Oracle Exadata's performance is one of its best features. We are very satisfied with it. The previous equipment used to make a payment for all the government employees used to take at least two days for some of the transactions. Now, it will take hours to make the same amount of payments. Another thing is the flexibility to organize all our databases. We can use it with new features that come with this version of Oracle 19c, which is the container database. With container databases, we can work with many databases, organized, and segregated, and still access the functions and management, the things that most of the technical people like to have in place."
Paulo X., a sales manager at LTA-RH Informatica, notes, "Regarding features, there are so many that we can offer to customers. When we sell Exadata Cloud, there are many options to choose from, especially when it comes to enterprise database options. In my experience, the main features that are appreciated are various ones like GPS and the assortment of security options."
PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
We used to work on business intelligence projects, so we really enjoyed the service-like performance. It's been great.
The business intelligence is very good.
We have found that the analytics environment is excellent.
We've discovered that the solution is quite a complex product, which can make it difficult to sell. Snowflake, for example, is simpler and therefore an easy sell.
The customization can sometimes be difficult to achieve.
We've been working with the solution for a very long time. It's been more than 15 years personally and at least 15 years at this company, so it's been well over a decade at this point.
We don't deal with bugs or glitches and the product doesn't crash or freeze. The only real issues we come across are related to customization. It's quite stable. We haven't had problems.
We have about 100 people using the product currently.
Our clients are quite sizeable companies.
I've never used technical support and therefore can't really comment on their responsiveness or level of knowledge. I have an internal team that assists with troubleshooting as necessary.
As a consultancy, we work with a variety of products. This includes Oracle and Snowflake, for example.
We are an integrator of the solution. Our clients are sizeable companies, and there are several providers involved in different projects with Exadata. We're not the only administrators.
I personally haven't handled an installation. We're mostly focused on projects related to BI and analytics. Someone else handles the setup and we just use the product or have our clients use it. I don't have a sense of whether the implementation is difficult or complex or how long deployments take.
We are a consultancy. We are partners with Oracle, with Snowflake, and with other vendors, software vendors.
We work in different deployment models with our customers. We try to fit our customers' needs. It depends on the customer and the project in terms of which deployment model we'll recommend or use.
Overall, I would rate the solution a nine out of ten. It's very good. We've had a great experience using it over the years.
Database Consolidation and Performance is best on this platform. It is tailor made to run the oracle database and hence the defaults on this device force you to choose oracle best practices. No more moaning by your storage admin that he wants to carve out the luns ,that he doesn't understand ASM stripe and Mirror Everything S.A.M.E and that he knows better what's good for the oracle database.Even the old x 2-2 can run version 18c of the database.
Ability to patch with no downtime and the ability to ensure all the prerequisites are satisfied without manual intervention saves time and effort and makes systems we deploy for our clients more secure. Licensing costs too are less for Oracle linux and for clients moving to the oracle cloud it is included in the price of the subscription. with the new Exadata cloud @customer offering there are even more ways to get the benefits of Exadata without lareg capital expenditure.
Ksplice, Prevalidated Oracle RPMS , the testing done with Oracle database and weblogic and the UEK kernel have made Oracle linux systems best for running large oracle databases and other packaged applications.Exadata's IORM and DBRM make it a great consolidation platform. its smartscan feature and flash cache are unparallelled in providing performance.
The new exadata x8-2m has even higher speed roce 100GBps connectivity.
we do have a little trepidation with systemd as it does have a learning curve . Also changing to a binary logging format for us feels like retrograde motion , but sadly almost all linux varients have moved in this direction.
Over nine years across multiple versions.
We have encountered several predictive disk failures, but we never lost data because the machine detected the issue before the actual failure and alerted us and Oracle to dispatch a spare through ASR.
No issues at all except when the code we were working with was not scalable (procedural PL/SQL and cursors). In fact, the RAC worked very well and we saw near-linear scale-up, and the license costs were dramatically less than a conventional solution.
We have had great customer service. We had almost no issues with the machine as such except for some predictive hard disk failures and the machine never had a problem due to the redundancy, so there was zero downtime for any of the hard disk faults.
Majority of the cases we have had good support. We had a few small hiccups with ASR Auto Update as it twice lost configuration. However, we have since disabled that function and do the ASR updating manually after taking a backup. As this feature is not essential to the actual running of the machine, it never caused us any major issue.
The initial setup was pretty straightforward. We had undergone training so we knew what was required and hence there were no surprises. There was participation from the vendor team also.
It was a vendor team who did the bare bones setup and then we did the actual deployment and migrations in-house. Our team is very seasoned. The vendor team was quite good and we had no issues with installation and initial configuration.
As we have the capability and specialization to do the software implementation in house we worked collaboratively with the vendor team for the same. Vendor team was very knowledgeable.
We have realized a lot of tangible and intangible benefits from the machine. It would be difficult to put a dollar figure to it because the machine allows for things that simply cannot be done without it. So in that way, we can safely say that the machine paid for itself within the first 12 months.
There are many new options available now, including IaaS and CoD. I would advise others to engage a third-party expert to ensure that they get the best deal. I did note that Oracle does tend to internally oversize things especially if they want to fill up a budget, and hence third-party oversight is essential.
For us, we work with all vendors and every vendor has its good and bad qualities. We use all solutions and hence we know when to recommend the Exadata machine.
I would always consider this solution when I want an integrated scalable best-of-breed solution for enterprise class Oracle database deployment. I have seen so much inter-vendor finger-pointing during SevOne outages to ever want to wander back into that uncharted wilderness.
As we are a service provider for the government our job is to stabilize the database layer. We need to make sure all our data is secure. That's why we like to work with a robust environment like Exadata to make sure that our response time and our reliability are good.
Oracle Exadata's performance is one of its best features. We very satisfied with it. The previous equipment used to make a payment for all the government employees used to take at least two days for some of the transactions. Now, it will take hours to make the same amount of payments. Another thing is the flexibility to organize all of our databases. We can use it with new features that come with this version of Oracle 19c, which is the container database. With container databases, we can work with many databases, organized and segregated, and still access the functions and management, the things that most of the technical people like to have in place.
Regarding the technical side of the machine itself, I don't see much that needs improvement. In terms of the kind of service and support that most of the clients need, it is huge investments. I would like to emphasize that the clients that use these technologies from Oracle must be well supported by the Oracle company. This is one thing that I would like to address. They could have better support.
Additionally, the price for the Exadata is quite high. This is one thing that Oracle must think about. You can find the same features and the same performance that Oracle provides in other kinds of technology. So it depends on the client. If you want to use an Oracle engineered system, then you know that you have to pay.
Otherwise, you'll need to buy more for performance, replications, and the availability of these kinds of things. But you don't want to pay a lot. You have another option that Oracle support calls Oracle ODA. With ODA, you don't have to use machines, but you have the same kind of features and key performances. However, you may have reduced options for scalability with these kinds of Oracle solutions compared to the engineering system like Exadata. After buying these, you have the support that you need to maintain all these environments. This is what I want to address.
I will mention security. I know that there is a feature for security, but it is not included in the first purchase of this solution. That means if you need to increase the security, you need to buy the security feature which doesn't come by default on these solutions. As you may know, there are a lot of security problems all over the world with this kind of environment. Based on the fact that we are serving the government, we need to have security issues solved from the beginning and take care of security immediately. It would be better if Oracle could have some solutions that would bring us the confidence with their security at the outset. That's one thing I would like to address.
I'm not saying that there is no security on this machine. There is good security on the version of Oracle which is running on these machines, it's very nice. But I'm saying this because I know that Oracle can do more than that and bring the substation to the clients.
I have been using Oracle Exadata since 2010.
Even with the old machines, we didn't have any constraints with the stability. There were some problems regarding the hardware that you must change because they are getting holes and they fail more frequently. When the life cycle goes, it's the end. But on the other side, this machine is very stable.
Since we have had these machines in production, we haven't had any downtime. Over the last two years, we had a lot of downtime with the old machines because they were very old and did not have enough performance to solve the demands of the database. But we don't have any constraints about the stability with these new machines.
The strategy of the company was not to pay a lot, because we don't have much money. So we began with the scalability approach. We bought enough resources to sustain the demands of all our clients.
If the demands increase, we can also increase the resources and close off the cabinets. We can scale this machine anytime that we need. We can go until the version that they allowed for scalability. Then, if you need to maintain this technology, you can scale out and have two machines working together side by side.
This is a database machine. We have a system that hosts more than 20,000 citizens. So most of the time we have more than 3,000 transactions per day. As a service company for the government, every database resource is on this machine. We have at least three or four databases running on this machine and we have many applications that are running through this machine as well, so it serves all the countries.
The first line of maintenance is done by my team, including day to day operation. Support from Oracle is for things which are beyond our knowledge of database administration. Most of the time, the maintenance is done by us. But there is a point you must understand regarding the hardware maintenance. We are not allowed to do hardware maintenance, this belongs exclusively to the Oracle Team. The Oracle Team must be the one that does the hardware maintenance on these machines. Of course, we have a partner here in Mozambique who represents Oracle. This company is the one that is the second line of support. If they find something, they can escalate it to Oracle or they can solve it themselves.
When we started the company, we thought about the responsibilities that the company would have attending to all the requests from the government and that we would need to go to robot technology. We thought in 2002 to go directly to work with the Oracle database. So Oracle database was the first database technology we decided to use as our strategic plan for the stability of the company.
At that time, we start working with the small machines and after two or three years, we realized that there are a lot of scalability problems with those kinds of machines and stability issues with this kind of hardware. So that's why we we had lots of downtime and we spent lots of time correcting these kinds of problems instead of thinking about growing the business. So we moved these small machines to a bigger one in 2010. That's all extra data with the X-2 version, but these kinds of machines are getting old and they are out of order now. We cannot buy the spare parts or anything else we need. So we decided to keep using all of the technology, but moved from that environment to a new machine with a better performance.
This has seen better performance. That's why we are still working with only one technology, Oracle.
For Oracle Exadata, there are two main profiles that you have to take care of. One is the installation itself, like assembling the machines, which need some kind of expertise. The other is the installation of the software and creating the database, which need other kinds of equipment. From our perspective, our main goal within all of this is not about these two profiles. It's about the database engineering. Because we are coming from using an old machine, which is running an old version of Oracle, you will need to properly create not only the environment to host the database, you will also need to migrate from an old version of Oracle, like 11g, to 19c. This is another challenge that we have during implementation of these projects.
I can say that from acquisition it took at least, but not more than, five months to implement.
At acquisition we need to design the tenders and the rules of the company. The tender goes out, then it is published, then we evaluate all the tenders, then someone must win the tender. All this takes a lot of times. Then you go to the implementation phase. We did a workshop to design the solution. It took at least three weeks. Then it starts implementing the infrastructure. Migrating the database is another point because one database can take at least two days. That's the situation. But start to finish takes five months.
We did the assembling and installing of all these with the support of Oracle ACS, which is a very nice team that gives personal support for us. It was very good working with them. The other thing is the migrating itself. Migrating depends on each company because not all the companies have the same database architecture or the same data. That's why at the migration stage, 60% of the intervention of migrating from the old version of Oracle to the new version was done by my team. But the Oracle STS support was with us the whole time.
I would of course recommend Oracle Exadata to other people who are looking into implementing such solutions. They need to know what happens with this solution, what can be done with it, because as the government we cannot give out that information because it's not allowed. But, I would recommend it if a company wants to use these solutions, wants to have stability with their equipment, with their applications, and with their systems. If a company wants to be competitive in the market and have a good name, reputation and everything else, I think using Oracle, with the Oracle Exadata machine, is the best way to achieve that.
On a scale of one to ten, I can give Oracle Exadata a 9.
We have two primary use cases for Exadata. The first is for a financial services company, which is an online bank. We use this product for all of their transaction processing. In their locale, they have a lot of transactions related to the automotive industry.
The most valuable feature is the time to solution.
The standard deviation that comes with it is helpful.
We appreciate the operational standards, which includes patching at least two times per year. This keeps it secure and up to date.
There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements. In my experience, rather than being handled by flash memory, it is being done using the hard drive. This slows it down a lot in certain cases. The reason this happens is that Temp IO often has a lower priority when compared to transactional operations such as Write Vault, Redo Vault, and Commit. This means that it can never get enough "attention" to be placed in flash memory.
The entry-level pricing is too high for the smaller shops.
Some additional built-in automation would be helpful. Some automation already exists in the software deployment process, but different components are handled differently, so more automation would be an improvement.
We have been using Oracle Exadata for about nine years, since 2011.
Stability-wise, I would rate this product close to ten out of ten.
Oracle Exadata is very scalable.
When one of our customers such as a bank employs one or more Exadata machines to handle database work, it means that the whole bank could be using it.
The technical support from Oracle is pretty good. It could be better at times but for the most part, they are knowledgeable.
The initial setup always comes with some complexity because it needs a lot from the customer to prepare the site, network, firewalls, and the rest. The deployment is always complex.
Preparing for deployment can take a couple of months, again depending on the requirements. There are standard things that have to take place, such as allocating space in the data center and making sure that the power, cabling, and switches are there. Once everything is in place, the software installation will take two or three days.
My team handles the deployment for our customers.
The licensing is the same as it is with other Oracle products, which depends on how many CPU cores are activated. In addition to that, there are storage licenses that are needed. All things considered, the price of this product is fairly high, as is always the case with Oracle.
This is a product that I can recommend, although there needs to be a clear understanding of the use cases because Exadata doesn't come cheap. There is the requisition cost, the cost of support, costs for maintenance, and none of that is cheap. As long as there is a solid reason why Exadata is needed in the organization, I would definitely recommend it.
My suggestion for anybody who is implementing this solution is geared towards the in-house DBAs as opposed to customers in general. DBAs tend to handle Exadata the way they would any Oracle database, which is not the way to do it. Many of them have been working with Oracle databases for their entire career, and often, training on Exadata is necessary to get it working properly.
I would rate this solution a nine out of ten.
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.
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.
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.
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.
I have been using Oracle Exadata for bout nine years.
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.
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.
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.
The initial setup is not so complex as it is done by Oracle Experts and is validated by the senior engineers.
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
Using this infrastructure for a database as a service or Oracle Cloud at Customer/Service can be a good approx. to increase your ROI.
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.
We also evaluated Postgress.
The primary use case is for maintaining contextual databases. In other words, it is for our online applications and services.
The most valuable part of the product is performance enhancement.
We still have to migrate to the latest version of Exadata, which we plan to do later this year or in the next year. Because of that, I am not sure we have anything that we would need to have added. I would need to consult our DBAs after we have migrated. They might find some issue that they would like addressed. But off the top of my head and because we are not on the newest version, it is not right to say the product needs something when it might already be there or has been updated.
Exadata is practically a perfect solution for us as it stands. Because we are pretty satisfied with it, we have not rushed into the upgrade. I am not sure that we are fully utilizing the options that are currently on the table. For our contextual databases, it is the best option and we do not have any really an issue with it that needs improvement.
We also need the product for other purposes. For analytics, we use Identity Two and we also need Microsoft Escrow Server for certain tasks. We accept some minor issues that I could identify if I discuss that with our DBAs. I do not think anything bothers us that much that we would need improvements. Of course, the price is the price, so it could always be less expensive. Maybe there are other considerations from the marketing side, but I do not deal with that.
There are some issues with accounting where we really can not calculate return-on-investment. Exadata pays some fees for you so there is simplified billing, but that separates us from some evaluation of usage. Maybe Oracle could offer a solution for resolving that. Maybe a calculator or separate report that could help customers to find this data somehow. More clarity on this usage might affect how you estimate the workload of the storage and could really make clear what you get in return on using the product for the month.
We migrated from Identity two on to Exadata sometime between five and six years ago.
It is stable like other Oracle products.
It is scalable.
We developed some software for migration. The previous database was on the mainframe server and it was quite a nice product. We have a lot of experience, both with Oracle Exadata, with other databases, and other systems that we also use. We work with many solutions and we use what we think is best for a particular task. Contextual databases work especially well with Exadata.
It is not really clear how to calculate the ROI for Exadata. Because you need to do the calculations for yourself, you need to know the license modeling pretty well. Even then, it is not very clear how much it costs for Exadata performance, CPU, and other additions. You really can not calculate these points when Exadata pays for you. Oracle could help customers to find out the actual numbers and help with calculations for ROI.
If you compare an Oracle database on your system to buying into Exadata, which is an engineering system consisting of hardware, then, of course, it is more expensive. On the other hand, it gives you some possibilities to experience better performance than you would have if you would run Oracle on your servers. When you scale it up, it means that you actually get this additional hardware for free. You need to pay more for the license instead. This is one of the cost differences that is not very clear how to calculate. It is hard to tell how long it takes for one product or the other to become a cost advantage.
There are some extra costs for hardware and for everything else if you upgrade to have better performance. At that point, the system uses not just the standard license, but also the storage shares. This can be quite significant when doing larger implementations. So the clarity of the cost models is something that could probably use some improvement from the Oracle side.
It is quite difficult really to compare and evaluate all the solutions available. The market is pretty mature. We have to just make a shortlist of possible solutions from whatever products and solutions we are looking at and go from there. It is not realistic to do an in-depth analysis of everything.
A lot of solutions that are more oriented toward network monitoring are now rebranded. The markets itself was previously called anomaly detection systems. Sometimes it is not quite clear which of the solutions really have additional capabilities that can make a difference without really studying them in-depth. We obviously looked at some extra products to contemplate and compare, and we continue to. But, for now, what we see and what we decided is where we will be staying. I am not sure that any product really offers a significant upgrade that is worth migrating for.
Darktrace is a step ahead in some ways but, in this area, it is really difficult to assess clearly because there is a lot of the marketing fog. It is sometimes quite difficult to get to the facts about the advantages. It also may not be worth migrating when the product you are using will develop the same or similar capabilities.
On a scale from one to ten where one is the worst and ten is the best, I would rate Oracle Exadata highly. If you compare it to other engineering databases, I would rate it a nine.
Practically perfect from my point-of-view.
We are using Oracle Exadata as a warehouse for historical reporting to provide the historical data that can be utilized by Power BI for reporting.
This solution meets all of my expectations.
The performance of the data is the most important part. It's quite good, and the security features are also quite good.
The management monitoring tools are quite important and an area that needs some improvement. The monitoring or consoles that are available should be available across the platform, and not only seen when logging onto the server.
The availability of the monitoring should be responsive and available all of the time.
I am planning to switch from Oracle Exadata to one of Microsoft's solutions, such as Synapse Analytics, to improve the performance.
We have our Power BI and other parts in the cloud.
The Exadata, being on-premises, creates problems at times because of the gateway.
I recommend that Oracle come up with connectors that can be utilized by Oracle Exadata to convert the data that we have in Oracle to MySQL. We can extend the reach of Exadata to other toolsets.
I have been working with Oracle Exadata for three years.
It's stable and I have not experienced any issues.
This solution is scalable.
I have been working with Oracle support for the last 15 years. I have no issues with support.
The initial setup was done by my infrastructure team and I don't think that they found any difficulty in it. They are knowledgeable in Oracle, so they didn't have any problems.
We are okay with the licensing, as it's not much. Oracle is always costly but it's fine.
The ecosystem that we have in our company is majorly Microsoft-based. When I refer to power BI or other integrated tools, they are by Microsoft.
I would certainly recommend using Oracle. They have their cloud applications and I would say that it is not a good idea to go with an on-premises deployment. My suggestion is that people go with OCI instead.
I would rate this solution an eight out of ten.
My primary job on Exadata is working with the Oracle engineer whenever a customer makes a patching request. We engage with the Oracle engineer regarding Exadata patching in a quarterly manner, around every three months. I collaborate and communicate with our customers daily regarding these activities on Exadata.
On our customer side, we deploy Exadata X7 and Exadata X5. We work on our customer's side with Exadata patching on Exa 5 and Exa 7, and with an Oracle Enterprise Manager regarding monitoring purposes.
Their monitoring tool is available in the Exadata environment where you can easily monitor all things in the Exa tech support and if there is any issue present in Exa, you can easily fix it.
We are willing to migrate our customers to Exadata X8 since this is a new version of Oracle Exadata.
Their Smart Scan is a very capable feature with a great data retrieval rate.
It would be good if Exadata made some new features available regarding data retrieval and speed capacity functions.
I have been using Oracle Exadata for one and a half years.
Exadata is also a very stable environment. Their Smart Scan feature is great for every banking environment and financial institutions willing to implement it.
It is a very scalable environment.
Our customers are very satisfied regarding Exadata because when we raise a call with Oracle regarding any issue their response is very prompt, within 5 minutes. And an engineer is available for working on the issue.
The initial setup was very easy and took two to four hours working on it because this is an engineer system. So the Oracle engineer and the ACS team worked on it and on the on-premises database to migrate to Oracle Exadata.
In our current situation it is not bad, it's a very capable and very comprehensive solution.
On a scale of one to ten I rate Exadata a ten!
All business Oracle databases were spread across many DB servers and different platforms. We consolidated all of our databases onto a single Exadata box to ensure that they were running on the same platform and have greater coordination and integration between the databases. Also, we gained performance without much change in the database code, as well as saved a greater amount of space by applying the compression feature.
We experienced a significant performance improvement without changing the code, simply utilizing Oracle Exadata standard smart features including Smart Scan, Smart Flash Cache, and Storage Indexes.
We saved a great amount of storage by applying different levels of HCC and removing ninety percent of the indexes. This is a powerful and extremely stable system with IB network speed.
Most of the Exadata features are enabled by default, without the need for configuration. For example, the smart features include Smart Scan, Smart Flash Cache, Storage Indexes, and IB 40GB.
Compression is a great feature, where one can really save a lot of storage.
Oracle has introduced Machine Learning (ML), Artificial Intelligence (AI), and autonomous features for automatic database tuning. The new addition of X8M has come with a direct memory read future to deliver amazing performance for all sorts of OLTP and analytics workloads. This should benefit the Exa community.
General perception from many customers is the cost and maintenance of exadata database machine. Although Oracle recently introduced low cost storage and automated many features, still the cost and maintenance is a concern. Oracle should provide free of cost the Exadata software on the box to have more customers.
We have been using this solution for more than eight years.
Every component in the Oracle Exadata database is redundant. Hence, it provides HA for every layer.
This solution offers the flexibility to add more servers, storage servers, or a combination of both.
Oracle support service needs more improvement.
We haven't used Engineered Systems for Oracle database platforms, though, we were on various platforms that were difficult to manage and maintain.
The bare metal setup is done by Oracle professionals and managed by them. Though, customers can manage this on their own, depending on the skill set of their team.
Our implementation was done on-site, through the vendor.
We realize ROI through higher throughput, high availability, and business continuity.
Exadata is an expensive tool, but, considering the ROI, it's worth going for the solution.
We compared other market players of Engineered systems. However, Oracle Exadata features are unmatched by other players in the market.
Oracle is coming out with many advanced hardware additions and software solutions to make this product the world's best database machine.
We are service providers and provide this solution to our customers. We deploy the on-prem deployment model.
The most valuable feature is that you have the same familiar environment of an Oracle database but with the additional performance you get from this architecture.
There is no room for improvement because everything that they could solve, they have. It has good storage optimization, hardware actualization, and internal communication network. They made improvements in whatever they could.
The problem with the Oracle Exadata is that it is a dead-end of technology. The supplier's market is dying, so they have no future. For analytical purposes, companies are now using analytical databases. So they're using databases like MPP, multi-parallel processing databases, things like Greenplum, and Teradata. Exadata has no future. It is going into history. Five years ago, it was top technology. Now, they don't have a future.
It's too expensive per terabyte. It's complex and hard to expand.
Scalability is really tough because it's scalable as much as an appliance is scalable. If you want to scale it, you need to add an appliance itself. You can buy one-eighth of a rack, one-quarter, one-half of rack. If you still want to extend capacity, you need to buy another module that is another eighth or quarter or half and you need to install it into a rack. It's quite complex. This is one of the reasons why appliances are not that popular anymore because modern databases are on hardware and you just put on another server, another node. It's quite expensive, compared to the commodity hardware.
The initial setup is quite complex because it's an appliance. It's a big box with all the processing power and storage that you need to order and get installed. It's pretty complex.
You need to do the installation which is done by Oracle. It's not just software, it's an appliance. When customers want to buy it, I need to order it. They want it a lot faster and it's actually quite expensive. If Oracle or Oracle partners have this appliance in stock it can be quick but if it's ordered through a manufacturer it can be lengthy.
I would rate it an eight out of ten.
It provides efficient runtime processing.
Hybrid columnar compression.
Try to diminish the logging service.
My primary use case is for EIMS (Enterprise Information Management Systems). We run this in the night time, and every day in the morning. Then the reports are readily available, so there is zero failure.
This improves the way our organization functions because it is on X86 machines. The X86 machines and also because the internal fiber channels are internally integrated, but while you want to have it in the network because integrating with the network, that is the external network(the tape drives and all). Those things are really cumbersome.
The reports are always readily available. The backup solution that is the data file system is available for a 30 day insert. There is really no other software solution that gives us the same quality backup and restoration like this.
We have had issues with system restoration. If there is a system fail, the internal drives are useless. We need Exadata to integrate with that one, and to restore it back. But there should be something in place in case of system failure. One of the systems should have the facilities to troubleshoot from the other nodes to this note remotely. Or, even if not remotely, just to troubleshoot at least among the thrusters.
There is no system collectively. Let us say this system failed; do we have any disks? Total disks, let's just say 100 disks. Five disks are failed. 100 disk measuring is not data top. If mirroring is that, like we can HRCMR. Let's say IBM CRM are CTC shadow image, REMC like that, the storage level they are giving the facilities inserted data mirroring, so immediately we can bring the DR. But internally, the Exadata doesn't have such features. Maybe they can think through that mirroring of collective system. Insert automatic measuring. If we have a collective recovery, let's say system-to-system, that DR solution, though they are giving a data guard, we have to set it up into the second system and the Data guard is a software solution. There is a really high skill required for a DBA to bring up the database. So a non-skilled person, like the storage engineer, can bring up for shadow images. HRCMI, HRCMR, like that. But in the case of Oracle, you must be really specialized to to bring up the data guard.
In addition, they should insert automatic measuring. AM is, let's say, one table fail. Okay, you can recover it. Or one disk failed, then they can troubleshoot it. But automatic recovery, fine, but if we have a collective recovery, let's say system-to-system, that DR solution, though they are giving a data guard. We have to set it up into the second system and the Data guard is a software solution. There is a really high skill required for a DBA to bring up the database. For a non-skilled person, like the storage engineer can bring up for shadow images. HRCMI, HRCMR, like that. But in case of Oracle, you need to be really specialized to to bring up the data guard.
It is really super-stable.
The scale is somewhat limited. The existing axis can only have four blades. So, there are limitations. The storage is around 200TB to 400TB, which is not infinite storage.
The technical support team are real professionals. I admire their technical skills and supports. Their supports are really admirable.
We had very complex situation, actually, with our Exadata migrations. Due to the shortage of our manpower, one of our engineers and one and also Oracle did migrations. During the migration phase, they have a lot of discussion and talks and deviation. But, they had someone help us migrate excellently. Because we have a data that's set up and also because it is not one-to-one relationships. End-to-end relationships, we had it over there. Database level, not table level. Database level, we have physical data within some other machine. The secondary data will be here. The data guard will be inside the Exadata, and the Exadata itself have the data guards and it's really nurtured relationships further, but some start up guys also have come back to the preparatory work center.
All in all, in Oracle, you need a skill set for implementation. I don't say it is difficult, but you need a skill set for it.
When considering a product, I make sure that I have:
The price is very high. But, it is worth it.
Extreme Bare metal Performance for the business to scale up as per the heterogeneous database loads
Our business cycle has benefited greatly with Exadata as our as operational efficiency has improved by 200%.
Also, our business analytics platform performance has improved by 300%.
There were no stability issues.
We've had no issues scaling it for our needs.
oracle customer service is the best in the industry.
Technical support for Exadata is the best in the industry.
Traditional Oracle RAC to Oracle Exadata RAC due to have scalable and robust database consolidated platform for upcoming release 12.2, which has ability to consolidate multi character set with in single container and heterogeneous data guard support.
It was a bit complex to fit in with our business requirements initially, but post implementation it was great. and will work as most stable and scalable database ever run on Linux with various complex work loads.
We implemented it in-house and advisor for major global exadata deployments
Oracle need to reduce the licensing cost to get more market penetration and offer as Open Financing Option.
Yes with SAP HANA and other relevant platform for Analytics
I would truly recommend this to all SMEs and Big Enterprises for consolidating databases with a unified next-generation platform.
Scalability and high performance, real high performance.
The most basic business solutions run more quickly.
I don't know. We've only just started using it. It's a new solution for us.
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.
Good quality support.
We just switched from another older version of Exadata to the newest one.
It's complex. We integrated an existing solution to Exadata.
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.
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.
This is an engineered system by Oracle. It provides very fast communication between the storage and database. A lot of data processing is done at the storage level.
This makes the queries and processing much faster than before; reports can run within minutes rather than hours.
Cost is very high. It needs to be made affordable to grab more customer base. A lot of the technical enhancements are being made by Oracle regularly. Now, it is available on the cloud also.
If you deploy a normal server setup with SAN or direct disks, the cost is very low. Exadata machine is supplied by Oracle and hardware also maintained by Oracle. They charge as per their standards and pricing. Its quite costly in that regard.
I have used this solution for five years, since about the time it was launched.
There were no stability issues.
There were no scalability issues. In fact, scalability is one of its prime features, it is very flexible.
The technical support is, as usual, good from Oracle.
Earlier, we used SAN and the traditional servers. That was also good and time-tested for decades. This is all together a new concept.
It was a normal Oracle database setup.
The price and license costs are high as compared to the normal database setup. It depends on the client's requirements and size of the databases. Clients/ buyers have to take the call.
No other options were available in this category at that time or even now.
You should evaluate your requirements and budget.
Exadata storage is very fast and it gives really good performance. Sometimes people buy a good server with a lot of CPU, pay a lot of money, but they have very poor storage performance and then they don't get enough performance from their system.
Exadata really gives good storage performance and our business applications run very fast.
It's perfect. I don't know what to improve in Exadata.
More than five years.
Very stable. In the last five years there was was just one occasion of downtime because one cell went down and because we had low free disk space. It was a little problem but it was solved.
I don't think it's so scalable because Exadata is a box. You can't do anything with this. It's a box, use it, that's all.
Support is much better for Exadata than for other products. Very fast response and sometimes much faster than for other systems.
Sometimes if we have a bug on another database, we duplicate the database on Exadata, repeat the bug and they make a patch much faster.
We didn't set it up, Oracle set up Exadata. It's not permitted to set up Exadata by yourself. They bring it to you. It's ready for use.
I totally recommend buying Exadata. It's very good product. I haven't ever seen anything better than Exadata for Oracle Database.
Excavation is purely for the storage of the data warehouses. It does what it needs to do. It performs. We have an active-passive DR. We tested it, it works. We can switch datacenters within reasonable time and go completely live in another data center on the technology we have.
We bought the whole stack, so we have extra discs. We have one month to show that an application doesn't work. We found out that installing and running the software on Oracle, was better than on the other platforms we used before.
Off the top of my head I can't think of anything.
A year and a half to two years.
In my eyes, it is going to meet the company's needs moving forward.
We have some very good internal guys who handle most of the issues. Actually, we haven't had many issues at all.
No vendor is reliable. We say there's a difference between proven in PowerPoint and proven in practice. We always find out in practice if it really works.
Personally, what I like to see is somebody who understands the business. What I see is that a lot of vendors are mainly focused on technology and not on the business functions you want to build. I believe that technology can be bought while the intellectual property is in the business services that you deliver to an organization. That's what I look for.
The fact that it's an engineered system. It's a database in a box, storage, the networking, the compute engines. All of it's in one nice neat package. My DBAs like administering it. My application owners like its reliability on the back end.
Our ability to scale heavy workloads and our ability to consolidate lighter workloads and reduce our sprawl through the data sector.
Price. Extremely expensive. Maintenance is about industry average. They've got a pretty good upgrade roadmap. But it's been an expensive ride for us, but also a necessary one.
Very stable. No major issues. No downtime that was a result of bugs or some kind of defect in the platform.
It has scaled well.
As a member of IT management with business units breathing down our neck, when there is an issue we always feel the support can be faster but I don't get a lot of complaints. It's good support. Like everything, it could be faster. We'd want to be faster.
It was straightforward for us because we used an integrator partner to put it all in for us, and then our administrators stepped in and took over.
We're constantly looking at other products. We went with Exadata because we needed some muscle on the back end for an ERP implementation. We've been through Exadata first-generation, and right now we're putting in X6s. We've had X2s, X3s, X4s, and we're actually installing X6s right now as we lifecycle through.
It's a great investment for the large enterprise. I think with Exadata in the cloud, that's coming, that we're starting to look at - and they're obviously trying to push here at the conference - I think it'll open itself up to a lot of other customers that probably wouldn't have gone with such an expensive on-premise solution. We're excited about that, too.
I would definitely recommend it to any colleagues.
It enables us to consolidate, that's one thing. We have consolidated five databases into one box, so that definitely a cost-savings there. We migrated from ODS to X5-2, so that is one thing.
The second thing of course are the extra features like the storage indexes. In short, the main feature that we take advantage of is the intelligence within the storage which makes it no longer a "dumb storage" server. That is another main thing.
We did some PoC tests with our own data, and we were really getting 10x using Hybrid Columnar Compression, unique to Exadata, so some cost savings there.
Those are the things. Performance has gotten better, less footprint, and consolidation.
Including the migration, it's around a little more than a year now.
It has been pretty stable. We haven't seen many issues. Yes, we have hit some bugs, but otherwise it's pretty stable. It's a lot of mature boxes now. It's, again, an X5-2; it's mature enough.
We have a half rack now. If we at all feel like we need more compute, we can definitely add on more racks. So scalability, definitely a yes.
It is excellent. In our organization, my team did the first migration, so it was all new to everyone. From the installation team to internal support teams, and my team which is the application DBAs, which really worked on the migration. Checking stuff and letting us know if there were any changes to be made; for all of those, even with the migration, we got excellent support.
That was part of the agreement between the parties, that they would help us with the first migration.
We were using ODS.
Personally, my requirements when looking for in a vendor: Definitely one is they have to be leading in that technology in the industry. The vendor should also make me want to use the latest proven technologies, we cannot take chances with that. Whichever is the case, whatever we are using a product for, that particular product has to be the industry best. That is one thing.
Another thing is definitely that it needs to be a known partner like Oracle. They know the people we know, so that gives comfort that, middle of the night, if you have an issue, you can call this person. In short, proven support.
They just have a lot of products, and they work well together.
I think it's free. That's one more thing.
I think it's better than the VMware from that perspective. I think it has improved quite a bit in the last 12 months. They're still lagging behind, but I like the new features they're introducing. I think that's why I'm one of the applicants for the product.
My organization is supposed to integrate Oracle products with our line of products too, so it doesn't really improve, but I think it's a synergy between the two companies, to be able to bring in the products from two companies and make it a better solution. I think there's a lot of synergy between the two for that.
Yes. Backup recovery, snapshot technology integrated with the hardware array, DR solutions, more of migrating VMs between different ones.
It would be nice to have a single click button to, say, migrate my VMware VM into the Oracle VM, or vice-versa. That is not available right now, and even the procedures there is really complicated, time-consuming.
Those are a lot of things we talk about with the Oracle VM engineers. They said they're short of resources, they can only prioritize certain things. I'm still hoping that they'll come out soon.
It is. Especially the new version, 3.4.
I have not been playing with the scalability, but I know they can scale pretty high. Especially I know they use it within their own MiniCluster product, and a lot of their appliances. I have no doubt it can scale.
Yes, I have actually. Kind of hit and miss.
It depends, I guess, on the support engineer really. I think I got more misses than hits.
No. It's just my focus of work. I'm supposed to work on Oracle products and their VM solutions, Oracle VM.
I do use the VirtualBox, but that's not enterprise grade, I don't think. Customers in an enterprise environment would not deploy VirtualBox for productions, but they would go with the normal VM for that.
The documentation is clear. The time to implement is really short. You put the CD in there, and you just kind of follow the prompts and you're done pretty much. I like that aspect of it.
If I were a customer and I had to choose, honestly there's only two other solutions out there, either VMware or Oracle VM. I think Hyper-V is too narrow-focused, so it would be out of my choices.
Again, if I wanted to choose between the two, if I'm not already a VMware customer, I would definitely go Oracle VM, especially when I run Oracle products already. Oracle databases, or middleware stuff.
I think it's just given me a better customer experience, one vendor to go to for support, one vendor to get patches. I believe that they can offer better integrations in the future. At least that's what I'm hoping for.
They have to look at their existing infrastructure, what they have, and what makes sense.
If they already have a big presence of VMware, it won't make sense to start with Oracle VM products. If they are just starting out, and want to test the waters and see what features, I would definitely recommend Oracle VM first. It does offer a lot of features that VMware does, with the right parts.
Performance and storage is good.
Reduces cycle time for batch processing.
I would like to see better application performance.
We have been using this for six months.
There were no real deployment issues.
There were no stability issues so far.
There were no scalability issues so far.
Customer service is excellent.Technical Support:
Technical service is excellent.
We did not use a solution previous to this one.
The setup was straightforward, but porting applications to Exadata was complex.
We implemented through Oracle.
Our ROI was $500K savings.
These are on the high side.
We were really impressed with the performance of the applications.
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.
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.
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.
It's very stable and very reliable.
I work with the PeopleSoft systems on the databases and it's doing just fine. I don't have to scale out.
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.
Someone in the upper management decided to spend some money, and we had the machines; he said use them.
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 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.
Smart scan and smart indices are the most valuable features.
It improved the query performance.
I would like to see improvement in retail store response times.
We have been using this solution for three years.
There were deployment issues, but the dev team fixed them.
There were no issues with stability.
There were no issues with scalability.
I would give customer service a rating of 7/10.Technical Support:
I would give technical support a rating of 7/10.
We did not use a previous solution.
The installation was straightforward with Oracle support.
We implemented with Oracle.
The solution offloads the storage. This gives us great performance without impacting the CPU.
We have improved the average response time between 36% and 85%, depending on the database after migrating to Exadata.
We have been using this for 18 months.
There were no deployment issues. However, the process of configuring with OEDA requires a lot of information beforehand.
We only had a few stability issues with unexpected reboots.
Customer service is very good.Technical Support:
Technical support is very good.
Exadata has great value. The storage CPUs do not count on the Oracle Database licenses.
If you are acquiring a larger configuration, I would advise you to consider getting two smaller ones, so you can:
Maybe you should not license every Oracle product if you do not need them on every database.
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.
It provides terrific performance, huge space savings in compressed backups and lesser backup duration with parallelism.
Gathering various logs during the performance issues needs to improve.
I have used this solution for six years.
Initially, we did experience stability issue but thereafter, it was well-stabilized.
There were no scalability issues.
An excellent support is provided by Oracle, it is based on the support model paid for.
Previously, we were using the standard UNIX clustering servers. Performance and scalability are the reasons as to why we switched over to this solution.
The vendor does the setup.
This is a really good solution. Initially, query issues are expected but once stabilized, an amazing performance is expected.
Stability and performance.
Provides data analytics and helps with warehouse needs. It helps analyze network performance.
I would like to see improvement in terms of upgrades.
There were deployment issues with the upgrade process. There was conflicting documentation and varying responses from Oracle support.
There were stability issues during upgrades.
There were no scalability issues.
I would give customer support a rating of 5/10. The FEs are usually good and proactive.Technical Support:
Technical support varies wildly.
We used a plain database before this.
We needed Oracle support for all of the setup steps.
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;
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
Database consolidation driving hardware and licensing cost reduction.
Complexity comes from patching the whole stack (firmware to database). If you have subscribed to a platinum support contract, Oracle will do it for you.
No, the whole stack is stable.
No, it scaled linearly as claimed by Oracle pre sales.
The Exadata support team is good, they will never let you down.
Exadata comes pre configured, just need to create your databases and load your data.
Public price is high, as usual with Oracle. You need to make a deal with Oracle sales.
You should carefully plan your Gridisk/ASM disk layout, One big +DATA and +RECO, or one by database. Also think about your ORACLE_HOME: just one or many? Having several Oracle_Home gives you flexibility in patching (you can stop only one database) but increase DBA works, several Oracle_Home to be patched.
The fact that we can consolidate all our databases into a single box is a cool feature. The extreme performance of Exadata is something that was worth paying for. Exadata performs at least 5-10 times faster than databases on conventional storage.
Previously, we were always facing performance related issues for the hundreds of internal applications running on our databases. That part has reduced quite dramatically. Seldom, if ever, do we encounter performance bottlenecks.
We did not see the volume of compression claimed by Oracle (10x-50x) on a table that had completely unique data. The table itself was about 140 GBs in size and we hardly got a compression of around 10%. We had elaborate discussions with Oracle about this, but we were not entirely convinced by the explanations provided by Oracle. This is something that needs to be looked into.
We have been using this product since December of 2013.
We did not encounter any issues of stability on Exadata.
There were no problems with scalability at all.
I would rate technical support as very good. We always received excellent technical support whenever we required it.
We were using an HPE solution, but as we were outgrowing our storage requirements, we explored other alternatives. Exadata seemed a very logical choice for consolidating all our databases in one place.
The setup was straightforward as Oracle was involved in the setup from the very outset. We did not face any issues during the setup.
My advice would be to have a licensing expert with you to study and analyze the licensing policy before you commit to the investment. There are a whole lot of technicalities in the fine print that may not always be apparent to the non-initiated.
We evaluated EMC Storage and Greenplum.
My advice would be to go with Exadata. It is definitely worth the investment.
Exadata storage cell offloading software is the most valuable feature.
With Exadata database migration we saw a 50x performance gain.
I have been using Exadata for eight years.
We have not experienced many issues with stability, except with some cell node bugs.
We didn’t have scalability issues.
They have an extremely great Oracle team.
Traditional RAC to optimize all-in-one appliance hardware, database, software, network, storage.
Setup was straightforward.
Oracle should offer free cell node licensing to encourage current RAC clients to switch.
We explored Teradata, Cisco and EMC appliances.
Negotiate with Oracle for licensing and consolidation of licensing.
Speed and stability.
Payroll used to take two and a half days. It now takes one or two hours.
The Oracle support team needs to understand the product better than the customers do.
We have been using this solution for one and a half years.
We had no deployment issues.
We had minor stability issues.
We had no scalability issues.
Customer service was OK.Technical Support:
Technical support was OK.
We switched due to our corporate growth and our performance needs.
The setup was straightforward.
We did the implementation in-house.
We evaluated EMC and SSD storage arrays.
We tuned so much code recently by using all the techniques above and it is working fantastic.
The Oracle tuning advisor could have been available to Developers so that they can send the advises to DBA's.
Nnope. It is usually we forget to mention the Schema names before the deployment and it fails when DBA's runs with Super user.
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.
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
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.
We never used any other solutions before and we are only using Oracle form the beginning.
Nope. it was quite easy.
We have implemented through PWC. but it was pretty stable.
More performance techniques and latest updates that we are really existed about.
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.
Yes. 1. Performance, 2. Scalability 3. Cost
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.
Storage Base Indexes, Caging and Hybrid Column Compression.
Put all the List of Value tables on Flash Storage for fast Reading in Oracle ERP, Performance Improved.
eAM, Inventory, Financial and Procurement and HR
7 out of 10Technical Support:
7 out of 10
IBM AIX P5
Saved 48 CPU licensing after consolidation on Oracle Exa-data
Little bit high, but it is worth it.
Capacity Planning is Key
Best Solution for Oracle Databases
The most valuable feature of the solution is that it is durable. It is a highly relevant option with extreme performance. The extreme performance is one of the key features when you're using Exadata. There are known points that you need to take care of, simply "beware of update".!
I'm currently writing a data warehouse on Exadata. Before this solution, we were aiming for this to be completed by 8 a.m., when our ETLs would finish. With the help of Exadata's special features, this was reduced to 3 a.m.
This solution allows us to bring more data within the same time period. It provides us with more subject areas that provide more reports to our users. Our ETL times reduced to 65%, then to 50%.
I would like to see more database features and maybe more archiving features, because we need to do data archiving. I would like to see additional database memory.
My first implementation was in 2009 and still using.
There's nothing bad to say about Exadata. It's stable, durable, and always up and running. My DBAs do online patches and online backup.
This product is scalable. We first started with the quarter rack, and then we expanded to the full rack.
Previous to this solution, we were using a normal Oracle RAC service. We were just waiting for this product to come out.
The installation is easy because it comes out-of-the-box and you just start using it.
We had already chosen Exadata, so we didn't compare this solution with many other products.
Get the database on Oracle first. If you are in an Oracle stack, it would be much better to use the Oracle products. If you are driving a Ferrari, you wouldn’t put a Mercedes engine in it. If you are writing a query, you cannot rely on other brands.
I'm an architect, so when I look for a product, I look for performance.
Stability, high ROI and low TCO. Plus performance, of course. Being able to compress the data, especially in big size databases, has been extremely useful as HCC can deliver quite high compression rates. The business benefits of OES are as many as the pure technical benefits/features.
Exadata with the In-Memory option is several levels about SAP HANA.
In the past, Infrastructure units were mostly organized in teams like the Database team, the Storage team, the Backup team, the Unix team, the Monitoring team, etc. Now, with Exadata, they have become sort of obsolete. Only one unit is needed for administering the whole stack, which means a lot of savings on IT level.
The Initial investment price could use improvement. It is often the stumbling block. Many organizations have limited or small budgets for the initial investment. This has somehow changed with X5 when the entire Exadata configuration no longer needs to be licensed when using OracleVM.
I've used this solution since 2008. For the past 4 years, Exadata and more broadly speaking, Oracle Engineered Systems, are occupying almost all my working time so my exposure to the product is as much as one can get. My review answers also include my experiences with other Oracle products, including Oracle SuperCluster T5-8 and Zero Data Loss Recovery Appliance X5.
Only during the first month or so of new generation Exadata machines, when the initial scripts have not been properly modified to reflect the new generation machine. Often, when proper sizing isn't done in advance, or even worse when sizing hasn't been done at all, the load can been too much for the servers. This is however an extreme case and has nothing to done with the Exadata frames.
No. Their stability, in fact, is the main benefit from Exadata. When Exadata is in production, what clients tend to agree upon is that stability is of paramount importance. Several clients have had absolutely no downtime after deployment. Downtime nowadays for most enterprises, to put it simply, is money. Not to mention the image and the reputation. This is so hard to be included in pre-TCO studies as estimating such losses is rather difficult. The stability that Exadata brings solves this major issue entirely.
No. It is quite simple to extend the configurations if needed, more databases can easily be added. With Exadata less memory is needed so we see clients running even close to 100 databases on a small 1/8th frame. With large databases, clients can sometimes run out of storage, but additional storage can easily be added with the help of storage expansion racks.
The Platinum support has been useful to most of the clients. It helps IT organization eliminate the internal need to spend time and efforts on patching and monitoring the Exadata boxes. It allows them to concentrate on other tasks.Technical Support:
Sometimes it takes too long time to get help with technical issues. At times, clients get frustrated with being asked the same questions multiple times. I would rate the Oracle technical support as good.
In the past, the complexity of building your own database environment was a long and tedious process. From deciding on the hardware and the operating system, to installation, patching, creating and configuring the database... It took such a long time that the benefits of the Exadata appliance are more than obvious nowadays. In a make-it-all-yourself solution, identifying the problems took a long time, and sometimes issues were never identified. The all-by-one-vendor approach has its benefits. Put all your eggs in one basket and watch that basket, is what I would say.
It depends on who does the initial setup. The process is definitely straightforward and not that complex at all. For example, the Accenture Enkitec Group is strongly specialized in these types of setups.
The Accenture Enkitec Group, with 450+ implementation, is by far the leading team in performing such tasks. There is a separate team within AEG specialized in patching and configuring Oracle Engineered Systems.
It varies from client to client depending on several factors but it is almost always when the cut-even period is approx. 12-18 months after the initial investment. The TCO of OES is much lower than similar systems like VCE’s Vblock, HP’s Converged system, and IBM’s PureFlex system, Teradata, etc.
The TCO of the Exadata Cloud Service is even better than the one of on-premise!
There is no single answer to this question. It varies from client to client depending on the size of the systems included in the setup.
IBM POWER, SAP HANA, VCE Vblock and Teradata.
If a company is looking into Oracle Engineered Systems, I would suggest first that a health check is performed on the current system, in addition to making a PoC on the (new) systems under consideration.
In the history of Oracle Corporation, there seldom has been a product so successful, complete and flawless. Client satisfaction is extremely high and stability of systems using Exadata is close to infinite availability.
We have implemented Oracle EBS on Exadata several times. We mostly used Exadata as the data layer. The most significant gain was in the area of performance. Performance increased significantly both for OLTP and batch works.
In addition to the performance increase, we saw a significant decrease in IT operations, because the necessity of SQL tunning is decreased, the total work that is spent on administration operations decreased, and so on.
Another significant gain was the efficiency of the administration. In Exadata environments, one database machine admin (or DBA team) could manage not only the database, but storage (cells) and the OS as well.
As the Exadata is hardened by Oracle and it is the most important one among the system in the engineered systems group of Oracle, we haven't seen any big Exadata specific problems that could not be solved, yet. The latest Exadata machine is generation 6 (X-6) so there is a current knowledge base.
Product specific documentation is satisfactory, but the interoperability documents should be improved. For example, there should be a step-by-step installation document for installing EBS on Exadata. Similarly, the documentation should be revised and Exadata specific notes should be added where necessary. We saw this need while installing EBS 12.2 database tier on Exadata. The document was written for the subject “Installing EBS 12.2 on Linux X86-64 (Exadata fits this category)". However; the OS RPMs that the document instructs to install, were not not present even in the latest Exadata. However, as Oracle says, Exadata has all the RPMs and they are up-to-date, so we were confused. We created several SRs, and even today it is not certain. We installed the RPMs specified in the document into Exadata. This was okay, but they may not even be necessary at all.
Certification should also be improved. Today, Oracle doesn't certify applications with engineered systems. We just check the RDBMS and OS certification to decide whether our application's database is cerfied with Exadata. This is actually enough for most of the cases. However, certifying specific data layers of certain applications (like EBS's database tier) on Exadata and adding some notes and recommendations (especially for performance) and restrictions (where necessary) can be a good move.
I have used this since 2011.
We have not had any stability issues.
We have not had any scalability issues. Oracle Real Application Clusters on Extended Distance Clusters is not supported with Exadata. So, basically, it is not supported to build RAC extended clusters on multiple Exadata machines. The good news is that RAC extended clusters will probably be supported with Exadata in Oracle Database 12.2 (12CR2). It is not certain yet, but it is expected, so we will see.
Actually, a consulting company (Oracle Partner) giving the technical support of this product, we didn't encounter any problems by getting advanced support by Oracle and we didn't get any unrecoverable problems while implementing what we learnt from the user guides and Oracle support documents.
The technical support of Exadata is quite good (if it is given by the IT professionals who know what they are doing).
Our customers were using conventional converged infrastructures and standalone servers. The reason they switched can be explained with the following list of items:
Setup is straightforward. You just fill out a deployment form that Oracle sends you. By filling out this deployment form, you actually give all the necessary inputs for the deployment (such as IP addresses, host names, NTP server IP addresses, DNS server names, etc.)
Most of the time, Oracle field engineers, who are well-trained for deploying Exadata, do the setup on-site. After the initial setup, any experienced admin who knows Oracle RAC and Oracle RDBMS, can go further to provision databases (create databases, do performance related configurations and so on) on Exadata or they can even further migrate databases to Exacta.
After the first setup, Oracle still answers your questions and supports you to make sure that deployment meets the customer requirements.
I recommend a proper sizing. A proper sizing makes you decide how big (1/8,1/4 etc) your Exadata should be. In the sizing phase, you can also decide whether to license all cores, or reduce the number cores using capacity-on-demand features of Exadata, as well. This has a direct impact on licensing.
In general, our customers are generally interested in Exadata. But, there are cases where the power of Exadata is just too much. Especially when the databases are not so big and when the transaction counts are low.
From an Oracle perspective, our customers also evaluate the Oracle Database Appliance (ODA). The decision is made according to the needs. If ODA is not enough for the customer’s needs, they consider Exadata.
I recommend others to define their needs and the things they expect from Exadata. I strongly recommend doing a PoC to ensure that Exadata meets their expectations.
Of course, reviewing the Exadata related documents and real life stories will give a better idea about the tasks that are done for implementing an Exadata environment and the tasks that are done to get the most benefit from Exadata.
Workload offloading to the cell layer : Exadata is Oracle's engineered system which SW and HW are compatible and contains many layers (compute nodes – networking – storage or cells), so compute nodes receives request or transactions then offload their processing to the cell through InfiniBand switches and this storage or cells contains high speed flash memory and Exadata driver software that has many features that provide high performance.
High availability of each component and everything is redundant: as I mentioned before Exadata conations many layers each one of them is redundant for example at least there are two clustered compute nodes contains databases homes, instances, binaries...etc. these clustered nodes are active/active, so if one of the go down the work will continue so this is High availability and redundancy for compute nodes layer, this similar to InfiniBand Switches and storage failure groups.
Smart scan feature and the flash memory: it is part of Exadata driver software which is preinstalled on cells storage which provides the compute node with the required selected data or rows only not the whole tables as normal ASM, so filtering is done at the level cell by using the flash memory.
I have used it for three years.
Some steps failed during the deployment by using one command utility to do all deployment steps by one command; so, we divided the deployment steps, then solved each issue separately until we successfully finished the development.
We have not encountered any stability issues; it is a stable box.
Until now, we did not scale.
Customer service is 7/10.Technical Support:
Technical support is 6/10.
We previously used normal HW, then moved to VMware, then moved to Exadata to get good performance and consolidated platform for DBs.
The initial setup is clear but you have to be careful while filling out the OEDA (Oracle Exadata Deployment Assistant) tool as it will generate an XML file that contains all of the required configurations for everything, like networks, storage, clusters, etc.. This file will be used during the initial setup.
We implemented it through the vendor; I rate their level of expertise about 7/10.
At first glance, it is expensive because it contains many HW and SW components and provides high availability, as you have to buy licenses for DB, RAC, packs, and Exadata drivers SW per disk. But, if you are going to use it in a consolidated way for all Oracle databases, I think the price will be reasonable, as you have many DBs. There are many sizes for Exadata, so you have to choose the suitable one for your organization according to proper sizing. For licensing, the minimum license number is 8 cores, which are available for Exadata X5-2 and X6-2.
Before choosing this product, we also evaluated HPE HW including flash memory and SSD disks, but it was more expensive at that time.
The team should be familiar with RAC; some HW and network knowledge. The team should understand the new Exadata SW related to the cell layer.
Consider the COD feature to pay as you go. Integrating Exadata with Oracle Cloud Enterprise Manager gives you the power of monitoring and managing the box. You can also enable the notification mailer through EM or cell.
Performance with use of storage compute.
Single appliance with no additional tooling required for deployment reduces overall maintenance and cost of ownership.
Cost, need for additional licenses for core Oracle products.
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.
Yes, memory limitations, 756gb limits the performance of databases.
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.
ODA and standalone.
Scalability and consolidation.
See the switch issue mentioned above.
Implemented in-house with the assistance of Technologent.
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.
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.
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.
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.
It is stable.
We had an issue where we had to increase the storage and we got the new cells from Oracle. Then we scaled outward.
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.
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.
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.
It's very costly.
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.
Exadata has been very great for us in terms of database consolidation. We have been using Exadata because we have been upgrading our technology every single year. In the past, we were using a Sun server and managing that as an active-passive cluster.
There have been initiatives to convert the databases to Oracle RAC; so when Exadata came out, they didn't really have to do much of anything. The grid infrastructure and everything came built in with all the best practices.
One of the advantages we found was that we didn't really need to be the first ones to be hit by a bug. If any of our customers comes across a bug, we already had a patch ready for it.
We have the platinum service for the database. That comes in handy in terms of high availability.
With all of this, the storage and the compute nodes were built together so they have more knowledge of Oracle-related queries: whether it is a redo or an IO; or it's coming from an undo space or from a DML. All these kinds of things come in really handy for us in terms of making our database perform really well.
These are some of the advantages I think we got out of Exadata.
The high availability of the database improved a lot. Our customers who are using it seem to be very happy with the response times. We also have a hot standby in case you need to migrate or do an upgrade. Overall, the company itself was very happy after migrating to Exadata.
The mix and match of hardware is always a problem. If you start with a product here and you want to migrate it two years later, you don't get the same version of the hardware. It's always different when you mix and match hardware. For example, if one compute node is X3-2, another two compute nodes are X5-2, and the storage node is different, I think it's going to get complicated. I don't know how to resolve it.
It would be nice if there was a way that you could swap everything over to upgrade all the hardware to one piece where it matches everything, and have an automatic hardware upgrade available. This way, you could keep everything on the same hardware solution. I don't know if that is possible.
Their support needs improvement. Also, the model in which they operate with a complex architecture in terms of upgrading the hardware pieces and expansion of RACs. Even the storage is licensed, which is a bigger question mark.
Any mission can go wrong. Exadata is no exception to this. Of course, we had software bugs; it's Oracle. You can expect a lot of back and forth with the new versions of it. We had lots of stability issues in the beginning. One of the major issues was the Write Back Flash Cache. By default, the storage nodes come with write-through. That's not very good for your OLE DB because it's not going to hit your flash. It's going to directly hit your hard disk. That's not going to give you good performance. The implementation team did not do a good job knowing that it's an OLE DB. They did not enable the Write Back Flash Cache.
The first few databases that we migrated went really well; but when we migrated more databases, it started failing. We had a big problem. We had to enable the Write Back Flash Cache to restabilize it.
Of course, the storage nodes have multiple bugs in them. Constantly upgrading it is a pain because while we do have high availability, not all the patches are done in a rolling fashion. Some of them force you to do non-rolling patches, specifically the OJVM patches.
Those are some of the pain points that I can see with Exadata.
So far, we don't have a big problem with scaling because we are happy with two node clusters. When we really need to expand, then we will need to cross that bridge when we come to it.
It's always a pain working with the Oracle support team. I say this because not all tickets get resolved immediately. It can take many days. Sometimes it takes a week. This can also include the weekend. During the weekend, the support team is thin. I need to follow up many times and call their managers. We have to scream at them to get back to us.
It's always a little bit difficult dealing with Oracle support compared to other vendors. They are a bigger organization. It does become a little complicated with such a big organization. With other vendors, you can call and resolve things properly and easily. I think there are a lot of process-oriented delays when it comes to Oracle. That’s built in as part of dealing with a bigger organization.
Because the ticket is not handled by a single engineer, sometimes the other engineer needs to digest it first. For example, a person in the US could start to help us, and then hand it over to someone in the UK. When that persons gets on board, he takes some time to digest the previous engineer’s explanation, recommendations, and diagnosis of the problem. If it continues to be handed over, and if it goes on for days, each engineer needs to go through the entire history of the ticket. That is a pain.
In such cases, it is always better to stick with a particular engineer and to a certain time zone. This means that the solution will be delayed. It depends on how soon you want to get it resolved. You might want your account manager to put pressure on the support team.
I am hoping for smoother operations and coordination in the future.
The initial setup depends on the technical team. The ACS team at Oracle can help, but it depends on which engineer you get on board. If the engineer is new on the team, doesn’t completely understand it, and is simply following instructions according to a script, there is every possibility that it could go wrong, if we don’t have a core team at our end verifying each step.
It is very important that you be prepared, and that you know every single change that goes into it end-to-end, including the monitoring and enabling the ASR service if you are going to use the platinum service.
A combination of pure flash storage and T4-4 servers are also extremely good in terms of latency times. It matches your TPS (transactions per second). Oracle had a little bit of an edge in terms of the best practices. Also, it's easier to debug and give us a solution because they can replicate the same issue in their environment. These are some of the slight advantages that Oracle Exadata has in terms of providing a solution more efficiently and quickly.
We always believed that Oracle is a leader in improving technology. We always believe in their solutions. Oracle Exadata is a great product without a doubt. Our gut now says why not go like we wanted and migrate to Oracle RAC. We didn’t want to spend time to put everything together, the network, the storage, and so on. Why reinvent the wheel when every best practice is already there? The "gotcha" is that if you increase the number of cores, you must be prepared to pay for the license.
Those are things that we weren't initially aware of, but then it all came handy to us when we need to go with engineered systems. That's why our upgrade part on our infrastructure upgrade and Oracle engineered system are on the same plane, so we just used it.
Exadata is not for everybody. Initially, it was designed for data warehousing. It's not for OLTP data. They improved it to OLTP, and then you could consolidate and mix and match. For all the patches, be aware whether you really want to go with it and expand it. Use all due diligence in checking whether this engineered system is the right solution for you . You need to work with it and test it yourself to make sure that it is for you. There might be a better product for you other than Exadata.
If you do want to go with Exadata, you should consult with someone outside of Oracle to help you and verify whether this is a good solution for you. Do not decide based on marketing material or gimmicks.
It's about consolidation of my infrastructure, scalability, high performance, and availability. These are the main factors that led me to choose this solution, as well as the cost. Exadata saves on my storage costs. All our costs were reduced significantly, and that was the reason why we went back to Exadata.
On the improvement side, they’re pretty much good. With the latest version, X6-2, we have enhanced the storage capacity. It was 4 TB each disk, now it’s 8 TB each disk; essentially same size appliance with more storage space. That request has been heard and we're able to mitigate that. Increased storage was one thing and they have definitely done better on the IO of flash storage. They implemented that; pretty much good stuff.
We have not had any major problems with stability.
From time to time, we scale capacity up and out. In system engineering terms, we can scale up to limit. The kind of features we just set it up, I've been able to fit my requirements into that.
We have Oracle’s Platinum support, which has been pretty good. However, the people are not always knowledgeable. I always rely on my best contacts in Oracle to get the right support. Even though we have Platinum Support, my last delay was my contacts in Oracle.
Initial setup was very much straightforward. Not as much manpower is required as we used to need. Before, if you wanted to manage a server, you had to have a server administrator, the storage administrator, and a DBA administrator. Now all three functions are combined into one person. A data administrator can perform the role of storage administrator, your host administrator, platform administrator, as well as database administrator. It's like several persons reduced to one.
I would definitely recommend this product if cost is not a factor. The implementation costs are, frankly, higher, but your return on investment over a period of time is less. If you're looking for that, then I would definitely advise to go for this product.
For me, the most valuable feature is the fact that it’s an integrated system of software and hardware together.
We see cost saving due to the reduced footprint in the data center and improved performance.
There has been great improvement from the X2 to the X6 versions. There is a lot of improvement every time. CPU power is always doubled every time and memory power is doubled, so they are on the right track.
Monitoring might be a good option for improvement.
The solution is very stable.
We have had no issues with scalability.
We have opened tickets with Oracle technical support and so far, no problems.
We looked at a custom-built solution.
The scale of the product is the most valuable feature. We use it for data warehouse and for that, we need to process a whole bunch of data faster. That is one of the features that we use this product most.
We use it for bringing data from all the different systems into it and then process it there. It is relatively faster. I always want the fastest speed, but despite all the claims made, it is fast. This product meets our scale and volume requirements.
It has enabled us to implement business intelligence. That is the most important function that we are using it for. It has helped us line-up. Earlier, we used to take close to 24 hours in some cases. Now, it's a matter of a couple of hours.
They can make it faster and more scalable. Currently, it is not. Actually, we carried out a benchmark against another company's product. Oracle took about 14 hours and that company's product took only thirty minutes. It is like a day and night difference.
It's pretty stable.
This product does not scale like we want it to.
There is another company that we use for this purpose and it does a much better job.
It's pretty good. I don't have any problems in that area.
We were not using any other solution prior to this. The reason why we chose this product is because we had already invested in Oracle and they had this to offer, so we continued with it.
If we needed to use it for batch requirements like before, it is still one of the best solutions. But, right now with the needs that we have, it isn't enough. If you are looking for batch processing, this solution is the way to go. However, if you are looking to do what we do, which not many companies do, then it is not suitable. We are into the internet business and we process trillions of records in a day all over the world. So, probably it is not for us. But for most of the companies, it is suitable. In my previous company, we had this solution.
Actually, the product rating all depends on the timing. Initially when it was bought, at the time, there was no other solution like this. At that time, I would have rated it higher. However, with our current requirements we need to be able to process billions of records in almost real-time, which this database doesn't meet.
Oracle products are pretty stable. They are leaders in database. As we looked into data warehouse products, they are the natural choice. We did not want to bring something new.
The number one feature is the speed; it's InfiniBand. We're serving almost 3.2 million people; it's an eligibility system. We add on 80 TB of data that needs to be churned and processed. Previously, we used Sun Solaris, and then we moved to a Windows platform. It was really bad. We started the load on Tuesday, and sometime around noon on Wednesday it finished. Sometimes, it would crash. Right now, it all finishes within 4.5-5 hours. If it starts at 6 o’clock, it’s done by 9 o’clock. That is one big advantage we see.
The standard Oracle things that we have, such as compression, are also valuable.
Now, all of our development to pre-production – everything – is in one single rack, which is easier for us to do. Production is on another full rack. That's what we use it for.
Pretty much whatever we need from the database side, it is there. There are specific things from the application side. I do not have a list; they do have a list of what you can't see from the database side. Pretty much what we are looking for is part of the 12c that is coming out. Most developers are used to Microsoft .NET and SQL Server. We are all cutting out Oracle, so there is a shift within the developer's mind; how am I going to use it; starting from the modeling to how to use it; key items; for example, I need to have a temporary table to create a gdd; there's an identity column in SQL that automatically fills in, and it used to have triggers.
The 12c is coming. There are some good features coming that I'm looking for. At a conference earlier this year, I was part of the session on what is new in 12c. I'm really excited about that.
We're doing real-time analytics, so one other thing is whether NoSQL is the best fit or not. We need to evaluate that, which we have not done yet. Pretty much, we are thinking that we have Exadata, so we want to use that product.
I have been using it for 3.5-4 years.
It is absolutely a stable solution. After we moved to Exadata, the stability has been good. Number one is, we used to go through Microsoft patching every month. With Exadata and Linux, we only have to do the firmware once per quarter. We try to coordinate that with quarterly Oracle patches. It isn’t really required; we only do it because we are behind two firewalls. We don't have to apply all the patches.
It is absolutely scalable. We have five enterprise applications of our own. They're all public-facing systems. Going back to the performance, on any given day, anywhere between 5,000-8,000 internal people use it, and we do have a public-facing system. People apply for benefits, and it's entirely public, so they can use it. Compared to our previous system, if you look at the performance metrics, some of them show almost 30-40% improvement. Some of the batches are almost 70% improvement.
If you look at the backend side – logical export backups, RMANs, and disaster recovery; all of those things – there is a tremendous increase.
Technical support is pretty good. There are certain areas specific to the enterprise application where we might not be getting Oracle support. But for Oracle products, it is pretty good.
We brought Oracle in to set it up, so it still is with Oracle. We didn't go through the entire setup process because Oracle was part of it. Oracle itself did it, so it was pretty easy for us. Again, one good thing is, we don't have to really worry about the patching, OS levels, and other stuff. It is pretty easy for us.
There are still a few issues that we are working on, but from a performance point of view, ease of use, scalability and reliability, plus we took a performance option for the storage – we were at capacity, so now we are good with the capacity, too – overall, I feel like everybody is happy with the product.
When I am looking at vendors like Oracle, the primary criteria will be the support. When you go through an issue, we need an immediate solution; it’s a 24/7 application. We don't anticipate anything. For example, something like, when we were going through a patching, and suddenly I found an issue. I didn’t see it in my lower environments, and now my production is impacted. We created a severity one ticket. How soon? And can I trust it? That's number one.
There may be some custom solutions we may be looking at, but it's not part of the product. Depending on what type of solution it is, we might need additional support and also training. I think Oracle is growing. I've been using Oracle since 1991, so I know how much it grew outside the database. Training is one of the biggest issues that we are having. We moved from a Windows platform to a Linux platform. Also, how to manage the entire thing; Enterprise Manager completely changed. One is self-learning, another one is vendor-provided, low-cost training. Those are the things we are looking for.
On top of that, you can say there are certain things that can benefit us; there is a new release coming out. If they can provide another training session, like, "Hey, this worried us, and here are the documents." Something like that would really help our DBAs to be at the cutting edge, rather than they themselves having to explore. Those are all things.
Usually, the I/O operation is a more intensive and costly one. In any transaction processing, the I/O is a more expensive operation due to storage and better performance. That's where most of the latency and time would be spent in overall flow. Exadata has an additional service and computing power at the storage level as well which reduces this latency. Usually it's available only on the high-end machines.
Exadata as a platform is a complete solution, where you have CPU memory with an additional server and inter-cell storage. That's the beauty of Exadata; IOPS and good overall latency and that's why we like it. We use it for the transaction processing, especially for production.
In terms of improvement, related to other products when we were running down the physical servers, we ran into some issues. We are always on the latest stack so at this point of time we are self-sufficient. Once we deployed Exadata, we never had to look back, at least in recent times.
One improvement would be the limitation on the storage. For example, when we buy with a double or triple CN, it comes with some storage. Once we reach that point, we don't have any other option. This was in the old version. We don't know how it is improved in the current version; maybe there is a way to optimize it and we can have additional storage allocated. In the earlier versions, we didn't have this possibility and we need to upgrade to a later version of Exadata to get more storage.
I have used this product for more than 4 or 5 years.
It's a stable solution but it comes with a price. You get performance and there is a cost associated with the performance. The Exadata tool is best when you can afford. You get best quality, in terms of the overall product features.
It depends on each case, your use and the company. For us, it is scalable and working for our use.
For me, what we have right now is scalable and it is serving our purpose.
They have a dedicated team exclusively for Exadata. Whenever we ran into some issues with the tool, they nailed it down. The support was good in Oracle because this is a prestigious product from Oracle. They have their support model.
The most valuable feature is the flash cache. Let's say you have brought it in at the application level. You don't want to change your code. You take the object, you put it in the flash, and it runs fast.
The biggest benefit for organization is the performance. That's it. That's the endgame. We want to satisfy the client. When they click, they get it fast, and that's it.
Also, the fact that it reduces your IO because the storage and the server, everything's in the same box, makes it easier and faster.
It is stable.
Well, they give you a box. We haven't come to a case where we need to add more servers or nodes to it. For the moment, what we have is what we're using and it's doing what it's supposed to do.
Our main issue is the CPU; they can't cope with what we want. The application is CPU-bound. They have to find a way, talk to Intel, design something, so it's fast, so it can provide more CPU, more bang for the buck. It's expensive.
It depends on what the ticket is about. It's easy to open a ticket. Now, to get solution on this ticket, that's a different story because they start asking for all the logs. You give them the logs, and they still want more logs; all this time, the problem is not resolved. That’s not particular to the Exadata platform; it's a general Oracle issue. It can be an arduous process.
Also, when you open the ticket, you don't get a senior guy right away; you get a junior person. You have to complain, and say, "Guys I know what I'm talking about, move it.", before they go to the next level. Then, you get who you want. That's another issue, but they have been there for many years. They need to improve their technical support.
If you know what you’re doing, initial setup is no big deal.
We also evaluated Superdome. We decided to go with the Oracle product because we are an Oracle shop. Oracle has intelligence on what it's doing. It integrates really well.
The main thing I would tell people is, whoever is going to maintain it has to know what he's doing. When you spend your money and you don't have the good people, you don't get your money back. It's a waste of money. You have to know who you are putting on it, so they can give everything back to you. Otherwise, it's a good product.
It's a good product. It's stable.
Offloading is the most valuable feature of Exadata.
It integrates well with our other products.
There are little things that need fine tuning, such as storage.
It’s also missing some features that you would expect from a data warehousing tool, such as snapshots.
It is stable.
It scales well for our needs.
Technical support is good.
We also looked at Teradata, but Exadata is perfect.
Definitely take some courses on Clusterware, ASM, Real Application Clusters; those kinds of courses, advanced courses.
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.
We have only used this product for 3 years so I cannot say what exactly needs improvement.
See my Technical Support answer below.
I have been using this product for about 3 years.
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.
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.
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.
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.
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.
The most valuable feature is the fact that it's an engineered system. It's a database in a box, storage, the networking, the compute engines. All of it's in one nice, neat package. My DBAs like administering it. My application owners like its reliability on the back end.
The benefits we see are our ability to scale heavy workloads, and our ability to consolidate lighter workloads and reduce our sprawl through the data center.
Price: It’s extremely expensive. Maintenance is about industry average. I think they've got a pretty good upgrade road map. It's been an expensive ride for us but a necessary one.
It is very stable; no major issues; no down time that was a result of bugs or some kind of defect in the platform.
It has scaled well to your needs.
As a member of IT management with business units breathing down our neck when there is an issue or something like that, we always feel the support can be faster but I don't get a lot of complaints. It's good support. Like everything, it could be faster. We'd want it to be faster.
Initial setup was straightforward for us because we used an integrator partner to put it all in for us, and then our administrators step in and take over.
We're constantly looking at other products.
We ultimately chose Exadata because we needed some muscle on the back end for an ERP implementation. We've been through Exadata first generation, and right now we're putting in X6s. We've had X2s, X3s, X4s, and we're actually installing X6s right now as we lifecycle through.
It's a great investment for the large enterprise. I think with Exadata in the cloud that's coming, that we're starting to look at and they are obviously trying to push at conferences, I think it'll open itself up to a lot of other customers that probably wouldn't have gone with such an expensive on-premise solution. We're excited about that, too. I would definitely recommend it to any colleagues.
We're very happy with it.
Fast performance and tons of storage that we can have to put a lot of databases under the Exadata Server are the most valuable features in this product.
For us, speed is the most important factor. For our SLAs, we need to maintain the performance. Thus, performance is one of the main criteria for our applications and that plays a major role.
Performance is what we always tend to work on and it could still be improved. For example, if we get Echo Calls then the performance also shoots up.
We have recently moved over to Exadata. Currently, we have not experienced any stability issues
We are still moving. So far it is satisfactory, although we are not getting our work locked under.
We did look at other products but Oracle has its way of marketing. We had IBM as the other competitor, but I don't know whether they have any product equal to Exadata.
Go for it if cost is not a factor. It's been good; so far we have not experienced any issues.
The best features are its robustness, stability, and performance.
Actually, I'm using the old version. The latest version is already out with all a lot of new features; so what I’m looking for is already there in that. Once we start using the new one, then we can come to know what additions we can put in.
It seems very stable.
Scalability is good.
Technical support is awesome. Oracle is our technical support; so when we need it, they are there.
Initial setup is complex. You need Oracle technical support to do your initial setup.
I would certainly say if you're looking for something scalable or diverse, this is the solution.
The most valuable feature is supposed to be speed. I like the consolidation with the memory, the SSD and the InfiniBand, and the algorithms that they use internally to take different paths through for the database traffic. All of those features are why we went with it.
We've just started to convert over and the performance out of it was not as much as we had expected. We're seeing only, probably, one-third faster than where we were at. I don't know if we'll get the benefit that we had anticipated out of it.
I think their platinum support needs to be improved. It's very difficult after you've got the product in-house. They’ve got great service up until you get the product. Then, you get the product, and trying to find someone to help you with configuration or setup, or even just opening up an SR, was not there.
With patching, it takes 6-8 weeks to get it onto their schedule, in order to get something patched. Then, it's rush, rush, rush at the very end. It's a big mystery as to what exactly are they doing. That's the biggest problem that we've had.
We have not had any down time. We've run into bugs, which we had not anticipated. When we upgraded software, depending on the version, if you're not with the current patch release, you have huge problems. You can't even run. We can't even run our application right now because we ran into a patch problem.
For as far as we've gotten with it, it has scaled to our needs; so far so good.
Before choosing this product, I did not evaluate other options. This was a CIO decision and we went with Exadata.
You want to get everything set up before it comes in the door. While you still have that sales support with you, you want to get all of your additional support, because you have to be added in for the platinum support area. Get all of that set up before you get your product in.
It's not as good as we expected, but it's definitely better than what I've seen with other companies.
The most valuable feature is definitely the storage offload; the fact that, as you're executing your SQL, it's segregated out to a storage device, and the database itself doesn't have to take that overhead. We've noticed a huge improvement in execution.
It has definitely improved my organization, because it's an engineered solution. It's not pieces and parts from different vendors. Having the one-vendor solution that's fully supported by Oracle, it doesn't require us to have the number of staff that it used to in a more distributed environment. We've definitely got some efficiencies from a staffing model because of it.
I'd like to see them improve more of the reporting capabilities of Enterprise Manager for the Exadata plug-in.
It's definitely been stable for us; over a four-year period, we had zero outages. It's been rock solid.
We’ve had experience scaling it. We started out originally with an X2, the second release of Exadata. A year ago, we expanded that with the new X5. We were able to take our existing procurement and expand it with newer hardware too.
We definitely have noticed that technical support has gone down, unfortunately. The quality of support; it takes a lot longer to get tickets resolved than it did four years ago, when we first bought the Exadata. We're an engineered systems customer. That's supposed to have more platinum-level support model to it. We have not experienced that recently.
It was end of life for our previous hardware. We had to buy something. The Exadata just seemed to be a better solution.
Initial setup was very simple, actually. Getting all of the right network information was really the critical path for it, but once that was done, the actual install and configuration was very simple.
The replacement hardware was ironically Sun. Because Oracle procured Sun, they just became our natural progression.
When I’m choosing a vendor to work with, I look at the reliability of the actual hardware solution itself and then also the support. Even though tech support has not been very good for us, our Oracle reps have stayed with us and want us to be successful. They help us try and navigate the Oracle waters.
Know what versions of hardware are out there, for any type of an engineered solution. Understand where there might not be redundancy in the solution, to know if that's going to meet your needs or not.
I have not given it a perfect rating because I probably wouldn't give anyone a perfect rating. It's met all of our expectations.
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.
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.
I have been using it for one year.
I believe it's a stable solution because we haven't seen any issues, so far.
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.
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.
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.
The most valuable features are the high columnar compression and the flash cache. Basically, the whole I/O subsystem is valuable, but those two features are really big for us.
I have been using it for close to five years.
It is very stable. We were on X2; that was not as stable. There were some battery issues with some of the flash cache cards. We're on X5 and X4 now and that's much better; many more IOPS, so that's been great.
It is scalable, very much so. It will absolutely meet the company's needs going forward.
The support for troubleshooting issues is OK; it's fine.
The support for patching – we have Platinum Support – is probably one of the worst I have ever experienced in my career. We've been trying to upgrade to the latest version of 11g R2 and we haven't done it. The last few times we've tried to do it, they were supposed to be able to upgrade without downtime, but the last two or three times, we've had downtime. We have very little trust in Platinum Support to do the upgrades.
Previously, we just used regular Oracle databases on standard hardware. Now, most of our products are on their own silo databases. Now, we're pushing them all to a single Exadata, using Exadata solutions.
We actually contracted the initial setup out, as part of Oracle Platinum Support. We also have another third-party company that did more of the operations on it. When my team finally got to it, everything was set up. It's really a matter of deploying our application on there and then tuning it to be more Exadata specific; not a whole lot. Anything will run on it, but we take advantage of the high columnar compression and the flash cache storage.
As far as cost goes, it's really expensive. The huge price tag on it is the only reason why I have not given it a perfect rating.
If you have the money, spend it; if it makes sense, obviously. If you're really I/O bound, it's a great solution; I/O bound from performance to storage. With the high columnar compression, we're getting close to 10X compression.
When I’m selecting a vendor such as Oracle to work with, I look for one with a good reputation and is reliable. Reputation comes on as willingness to work with you. I consider the features that are offered; is what they're offering now going to scale, obviously? Is what they're offering now going to still be supported in the future? There are compatibility issues and similar items. For example, with Exadata, I'd hate to be the one of only three companies on Exadata in the world and five years from now, nobody remembers what Exadata is.
One of its most valuable features is the ease of managing infrastructure as a whole; software and hardware coming together in one place to manage all the architecture, networking, hardware, software, storage, etc.
Every year, there is definitely some incremental improvement; faster storage, more compute nodes, better networking, etc. At some point, regarding the whole computation model, instead of just having more and more CPUs, the core itself probably needs to get smarter. Instead of saying, “Oh, it's 16 cores. Now, it's 32. Now, it's 64.”, I would like to see the 16 cores able to do smarter work. That's what I think. I can see it's kind of heading that way, so we might get some improvement in that space.
I have been using it for a little bit over three years.
It's stable. We haven't had any, what I would call Sev 1-type, issues that have caused us a problem with Exadata.
It is a scalable solution. I think it's going to meet the company's needs moving forward, without problems.
Between 1 and 10, technical support is 7 or 8. Time to time, we do run into some issues, here and there, where it takes us a little while to get through, to make sure that engineers understand what's going on. For the most part, we don't have any major hiccups, I guess. Sometimes, the issue is finding the right person, getting to the right person to have that conversation. Once you have that then it's fine, but getting to it takes a little bit of time.
We previously just had commodity servers that we replaced with Exadata for the ease of convenience.
The initial infrastructure setup is straightforward because it is delivered in a box. It's all pre-configured for the most part. Again, I think it boils down to how each company does it after it's deployed at their site. That's where it gets a little bit challenging and that's where you have to put a little bit of effort in to make sure you lay it down right.
I would definitely recommend Exadata to someone in a similar job role as myself at a similar-sized company, but I would also them to understand the need of what they’re trying to do and not necessarily go to Exadata just because it's nice. They need to spend time on what they want to get out of it. Yes, it's a nicely engineered system but they also need to evaluate cost versus benefit. It's not cheap, I can tell you that.
Its most valuable feature is the smart scan functionality. It allows for the queries to work faster. It offloads the stuff to the cell server, so it provides better performance.
I like the consolidation of all the components in one feature. I like the fact that it's very specialized and you can go ahead and utilize it, out of the box. It is intuitively different than a normal database solution; you have to actually design for it. For example, you get rid of indexes instead of creating them. It's a little different; you really need to get up to speed on what the functionality is in order to optimize it. There are a few different things that you can use, such as compression; you can use all kinds of different features that it has.
A lot of the extra features they're adding are wonderful, but they're always putting a price on it, for example, the in-memory thing. For certain things, such as Exadata, we're going to stay with on-premises because of regulations. It feels like for anything new, it's almost like they want another license fee; that's the down side.
Maybe they could make the licensing not so bad. If you're already buying something that costs a quarter of a million dollars up to a half a million dollars, maybe they could throw in some extra bang for the buck, some freebies.
It is hardware; things break. It does have some redundancy in it, you will see a performance hit at certain periods of time, but I do like the fact that it does have a lot of failover.
The scalability is a little bit difficult, actually. A lot of people advertise it as being easy, but what happens is: when you have a previous version and you want to scale that version, they're already into a new version. It's almost better just to buy the new X6 instead of trying to expand your X3. If you want to do scalability, you have to do it immediately within a year; you can't wait.
Actually, level one support is OK. It's no different than what most DBAs themselves can handle. Right now, we have a challenge with some wrong results on Exadata, and it's taking a number of weeks; we have clients that are very upset. I would say technical support is a mix. It depends on how difficult the question is, and if it was encountered before. If it was encountered before, really fast. If not, you have to go to development and it can take a while.
We did not previously use a different solution. It's a data warehousing product. I know you can use it for online transaction processing, but it's perfectly wonderful for data warehousing. It has a tremendous increase in performance; it's like night and day. We still have some people that are on old systems that we're moving and it's like night and day. You can put really lousy code on it and make that code run good. I'm not saying the code was lousy; I'm just saying that Exadata handles the code differently. If you know how to optimize it, you have to optimize it, though. If you try to put the old code on, don't make your indexes invisible and don't understand how it works, you can actually cause a degradation in performance. You need someone on staff or Oracle help with the understanding of what the differences are, so that you can really make it work for you.
I have a huge background in UNIX hardware, networking and database. For me, it was extremely straightforward. For someone who has just one job function, for example, just a DBA, it would be very challenging. I work with some people for whom it is extremely challenging because they don't have the other aspects; they only understand database and that's a problem if you want to work in Exadata.
In the past, we were looking at EMC solutions; the flash, the different disks and so on. It still wasn't able or capable to function the way that the Exadata does. That's why Exadata won out, but Exadata could probably improve itself by using some of that state-of-the-art flash in the product more. They could even improve on the design by using more up-to-date disks and technologies, that are out there now.
When I’m selecting a vendor such as Oracle the most important criteria for me are reputation, stability, performance; that kind of criteria.
If a friend asked me about Exadata, I would encourage them to go with it.
It is fast and integrated. It combines hardware with the software that we use from Oracle. It's a complete stack, not only for the hardware but the full implementation and delivery, so it’s really good for IT.
We have seen performance and reliability benefits. It's also beneficial from a cost perspective.
We are using it now predominantly as a hardware stack managed by our company. We would love to see it more as a service; a database-as-a-service offering.
It is very stable; no stability issues.
No problems with scalability.
The SRs that we raise are not always resolved in a timely fashion. Often I'm unhappy.
At this moment in time, it is pretty much a straightforward, almost-manual installation. We're looking for some automation around it.
We also looked at other organizations or vendors, as well. We also looked at the database appliance from Oracle.
We decided to go with the Exadata product because of the size of our company.
The Nike one: Just do it.
It provides performance for our highly critical applications.
They seem to be doing real well with keeping up on the performance and everything, especially what I have seen with the new chipset that is being offered. I can't really think of anything that they are not doing that they should be doing.
It can be difficult to patch and maintain because there are so many databases running on it.
We have been using Exadata for about five years.
We have had no down time with it, but it can be difficult to patch and maintain because there are so many databases running on it.
It is an absolutely scalable solution.
The support is very good.
I'm not involved in operations that much, but from what I understand, they get back to us; they always find the right person.
Oracle comes in and does the initial setup.
I recommend it for highly critical, performance-sensitive applications. You have to do a TCO on it because it is a fairly expensive solution. There has to be a cost-benefit analysis done on that.
Oracle Exadata provides very good performance and reliability. It's a highly reliable system and provides maximum performance.
The business outcomes are much faster; end users are very happy so they can focus on their day-to-day work rather than waiting for the computer, the response from the system. In many customer cases, reports that used to take 10-12 hours get completed in 1-2 hours, a massive reduction. A business cycle that used to take about 3-5 days to turn around can be turned around in 1 day, so that's where we optimize our business utilization; much more efficiency.
A major concern from customers is that it's very costly, but if they think about the total cost of ownership over 3-5 years, I think the total cost attests to the business readiness and it doesn't come out to be very costly.
Exadata is pretty stable. There are built-in high-availability features. For example, every component – including the power supply, the fan, the CPU, and the memory – is redundant; you're buying a highly available system.
It absolutely scales to our customers’ needs. You can start with a two-node configuration, and you can go as high as eight racks, I believe, connected together with eight nodes, so you can scale up to 64. That number might have changed recently. You can scale it very well.
Technical support is fantastic. Oracle supports Exadata customers as the top tier, and you get support when you need it. Oracle has separate Exadata support. Once you buy Exadata, you go to that dedicated team and the turnaround is very, very good.
Initial setup is complicated and you need to engage Oracle to do that. Obviously, nobody else can do that. It's complicated, but it's a part of the process.
It's a very good product. I think if you have a business use and can justify the cost, go and buy it. You'll never regret it.
The system is engineered to run both databases and enterprise applications unlike other engineered systems, which are either tailored only for databases or only for applications. The ability to consolidate all of the databases is a big plus.
The SuperCluster provides best of both worlds – Oracle Exadata functionality along with virtualization at the firmware and the OS kernel layers.
On the Exadata side the features most valuable are – Hybrid Columnar Compression (HCC) for both Data Warehouse and OLTP workloads, Storage Indexes for Smart Scan, ability to use Flash Cache for DB storage, and more.
With SuperCluster and Exadata, all of the servers and storage are integrated within the same rack. This reduces the configuration and setup time, increases performance, and makes maintenance and patching easy. We are able to consolidate all of the databases and application stack on a single SuperCluster with Exadata.
In the area of Solaris zone-level virtualization, it would be good to have memory capping as a tool for memory management. Currently for 11g databases running on Exadata with smart scan against hybrid columnar compressed (HCC), tables could result in errors. It would be nice to have a patch rather than the current solution of upgrading the databases to 12c.
Currently, we have a Half-Rack SuperCluster with 2 SPARC T5-8 Compute Nodes and 4 Exadata Storage Servers. Current version of Exadata is 18.104.22.168.3. The compute nodes are running Solaris 11.2 with Oracle11g 22.214.171.124 databases. We've been using it for close to three years.
We had few issues while deploying DB zones. This virtualization has to be carried out differently when compared to DB LDOM virtualization.
There have been no major problems so far with stability.
There have been no major problems so far with scalability.
Overall it has been good so far.Technical Support:
Overall it has been good so far. In the case of engineered systems like SuperCluster/Exadata, the patching has to go through the support team and there is definitely room for improvements in this area.
Previously, we had multiple servers both with and without physical partitioning. The storage for all of the servers had to be zoned to a SAN. The servers and the storage previously were from different vendors and we had to integrate those. Other product offerings were evaluated, but with all of those we had to explicitly integrate the compute, storage, and networking components. In addition, we could not get the benefits of database optimizations with Exadata and have to pay the penalty for virtualization overhead and network traffic between compute and storage layers.
There is a certain degree of complexity with respect to the initial design of the Exadata storage cell disks and grid disks to meet the customer’s application needs. This especially true when migrating from an existing setup. Care has to be taken with regard to the initial domain configurations since this will determine the LDOM and zone-level virtualization. The Exadata disks have to be exposed to both the DB LDOMS and DB Zones.
The initial setup was from the vendor team (for any engineered systems from Oracle). But later we had to continue the setup to cater to our application and business needs. Prior to the implementation, all of the IP allocations are to be completed for the three layers – Client/Public network, InfiniBand private network, and the Management network.
At this time, I do not have the actual numbers but would rate the ROI is pretty good.
In the long run one can consolidate the various DB related licenses. The number of cores required to run the DBs and applications is much lower on a SuperCluster with Exadata, thereby leading to fewer licenses and reduced cost. Since the entire stack is owned by one vendor (in this case Oracle) the core factor for licensing is 0.5 leading to fewer licenses for the software components.
The SuperCluster in addition to Exadata storage also comes with ZFS storage cluster. Since the compute nodes, storage and networking components are fully integrated with InfiniBand I/O fabric this provides very high performance between various components. Also, it has built-in hardware encryption to provide data security.
The following features of Exadata are the most valuable to me:
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.
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.
I have been using this solution since 2012 (four years).
I did not encounter any issues with deployment.
I did not encounter any stability issues.
I did not encounter any scalability issues either.
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.
A vendor team with good expertise implemented the solution.
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.
Oracle Engineered Systems are the best solution for Oracle and non-Oracle applications: hardware and software are combined together to ensure high availability and maximum performance. Oracle Exadata contains all the advantages of standard Oracle Database, but on top of that there are exclusive features such as IORM (IO Resource Manager) and HCC (Hybrid Columnar Compression). IORM (in combination with Database Resource Manager (DBRM)) permits you to isolate I/O requests to avoid I/O saturation. HCC provides different levels of compression to reduce space allocation and to decrease I/O.
Oracle Exadata and Oracle Exalogic are standard-based. Customers can easily migrate their existing applications based on Oracle Database and Oracle WebLogic: they can take advantages of Engineered Systems with minimal effort during the migration process. Customers can benefit from high performance without modifying Java or SQL code and they can decide to use specific features after migrating to Exadata/Exalogic. Also, Engineered Systems can be used to consolidate complex environments: for example, our customer was able to decommission about 20 blades, using a single 1/8 Exalogic x4-2. Finally, Exadata and Exalogic simplifies patching/upgrading process, unifying firmware upgrades, ILOM upgrades, OS patching, Database/WebLogic upgrade/patching in one "single-vendor" activity.
We installed the first Exadata in 2011.
The most critical issue was due to a bug with SDP (Sockets Direct Protocol): after connecting Exalogic and Exadata to the same Infiniband fabric and after enabling SDP listeners on Exadata compute nodes, we faced unexpected and random crashes of database hosts. Fortunately, we discovered that SDP caused the reboot, so we disabled it. We permanently resolved the issue with the latest firmware of Exadata, and after that we can take advantage in terms of performance, of SDP protocol.
We used to perform upgrades of Exadata from quarter to half in order to increase CPU/storage capacity. When Exadata hardware is too old (for example, if you want to upgrade from Exadata X3-2 quarter to half, adding x6-2 hardware), you should evaluate the possibility of installing a new Exadata and using Oracle Data Guard to move Oracle Databases.
There was no solution in place previously.
Using Exadata and Exalogic, you can get the best performance optimizing the number of CPUs, saving costs on software licensing. Also, if you consolidate your environment using Engineered Systems, you can save money on hardware (storage/compute capacity).
No other options were looked at.
As best practice, before starting the installation you should have a look at the Oracle Documentation. Oracle provides a "Getting Started Guide" to get up-to-date checklists to verify requirements (for example IP addresses, name syntax, etc.) and to be sure your infrastructure is ready for the installation. Also, we recommend to install Oracle Enterprise Manager as a monitoring solution: it is fully integrated with Oracle Exadata and Oracle Exalogic, you can monitor hardware (compute nodes, switches, ILKOM etc.) and software (operating system, Database, WebLogic, business applications etc.).
The place where I've used it are mainly on the data warehouses with larger implementations, and having everything in one enclosure is really a lot nicer. Having the disk, all the memory, and all the networking, makes not just the implementation easier, but as you're running it, a lot simpler to administer. Because we're asking it to handle everything, it's a simple solution to administer and support. It also has plugins that makes it easier to monitor.
Definitely having the ability to have one machine do everything has been the biggest improvement for us organizationally. From the administration side, it helps. If one or two admins can handle it, they don't have to go all over the place to, such as to the storage team, the network team, or anywhere else because they can do a lot of things internally. Definitely, we've seen cost, time, and HR savings with several implementations.
Sometimes pricing can be a bit of an issue, especially if customers don't know exactly what they're getting. Maybe they've gone through the whole process and they didn't get the right size or the right amount. I've worked with several customers who had implementations that were too small and then had to upgrade, as well with others who were overpowered with their implementations.
The deployments have been issue-free.
We haven't really had any stability issues. The experiences we have had were when there have been hardware failures, but a Oracle took care of that pretty quickly. Our customer had databases and memory modules die and everything kept running. With the failures we've seen, it's stayed very consistent on the ones we've done.
If it's done with the right specs in mind, it seems to scale pretty well. We haven't really had any scalability issues.
Exadata is pretty much set up when it ships. Afterwards, you just have to copy data over and it's ready to go. So the setup is fairly easy and straightforward.
Definitely do a POC on it. Work closely with Oracle Professional Services to help you with the right configurations.
Some of the features which are specific to Exadata, like histories, offloading and accurate processing. One of the customers we work with had mostly thousands of batch jobs, which used to take, 30 to 40 hours, with the Exadata, and re-architecturing some of those solutions on the Exadata, moving them. It turned out to be running in one hour, or less than one hour. It's a huge, huge performance gain. And in the end, the company realized the return on the investment they have made into Exadata.
Some of the key benefits with our customers moving to the Exadata, they can get it consolidated, all the databases into one platform, one environment. And other advantages, you get a lot of the new features out of the box of the Exadata itself. We don't have to shelve around a lot of different parts of the machines, the networking component, the storage components, you know, all together, one into one machine, into the Exadata. It's a huge, huge advantage for the customers, right? They don't have to look into the history, they don't have to look into the database machines, you know, networking part of it all income passes in one machine. And Oracle has engineered it specifically for the purpose of data. Optimized the database solutions. So once you move it, you get the benefits of your query optimization, your history optimization, your machine data with computer optimization. Everything is blended into one machine.
The key features with the Exadata is offloading the query processing, some of them, at the storage level. That's where Oracle has to make it smarter. I think it's already smarter, the Exadata storage. I can't think of a specific feature that can put in, but that's where I think there's room for more improvement.
Adaptability is a little bit challenging for the customer because of the licensing and the pricing. That's where I think they can make a big difference.
It's a product which Oracle has built with scalability in mind. You can have Exadata hooked up with another Exadata. You have a really high bandwidth network, they call it Infiniband. So you can extend it horizontally as much as you want. So there's a huge, huge opportunity to upscale it and Exadata itself comes in two different flavors, like quarter rack, half rack, full rack. So you can choose and pick, based on your need of the scalability and the future need of how your workload and other things are going to be in future.
You've got to have some basic understanding of networking, storage, some kind of background in the database. That's where it makes it very easy for you to step in and do the initial set up of configurations. Of course, there are certain sorts of specific tools and utility from Oracle which you have to be aware, you have to talk to Oracle very proactively. Make sure you know all the requirements, you need to do the initial setups. You are aligned with the people in Oracle and you plan it. You know, planning is the key, and if you have those basic understanding of storage, database, the networking, those things. It really makes it easy for you to step it into the initial setup planning.
I think it comes to pricing. I know a lot of people don't have the better understanding of the licensing and other things. That's where it effectively comes, in the initial logistics of dealing and getting it.
I think it's a great solution for all the existing Oracle clients and if they really want to move ahead with the next generation of the Oracle Database, that's the solution to go for. Consolidate everything, move ahead with this. You get a better performance, you get better management, you get less people to manage the things, the room of errors are really less because you have specialized people, less people, and it's very valuable.
Rating: so I'll say that in terms of the rating it will fall in 8 to 9. In terms of the ease of maintenance, you have all the tools and everything Oracle provides. So you don't have to poke around and see what's where, if somebody should come, so where you have to go. If we're really good, you know the Exadata, you know what you're looking for, you talk to Oracle, get those tools, do it. In terms of the performance, you don't have to waste your night, day and night. It's a lot things come built in with the Exadata itself in terms of the price.
It's pretty simple in my opinion. It's called out the box, and it's called support. Sometimes with the engineered systems based on the support agreement that you have with the vendor, sometimes you hear about problems with your system from them rather than your applications experiencing some issues, and you're having to log a support ticket with Oracle. I think that's huge.
The thing that attracts them to the two products but mainly the Exadata is the storage technology is revolutionary whether it's the only solution of that flavor on the market or not, I'm not familiar with. It's the storage solution, it's the speed, and it's the high availability. If somebody wants 5 or 6 9s worth of availability, a very good place for them to be is with one of Oracles engineered system solutions.
As is always the case with Oracle, when some late-breaking fancy technology gets under their radar, self-invented or perhaps something that they're picking up that they'd like to compete with from another vendor, they're all over it. I can't specifically think of anything myself. Outside I guess of speed and maybe the other two things I could think of are speed and speed, but I'm not suggesting that speed is an enhancement because there's anything wrong with the speed of the system now, but of course we always like to do things in four nanoseconds rather than seven.
I think I would probably give it a capital S. People here peripherally hear about informational stuff that may be going on in the cluster, but as far as catastrophic events that may happen with the cluster, a lot of them in some way, shape or form are not far from self-healing. I think that's a huge advantage of an engineered system.
If you buy a quarter rack, you feel like you need more computing power, you upgrade to a half rack. You go to a 3/4 or a full rack. It's basically I guess we used to call it plug and play except a lot of us found it in the olden days, it was plug and pray. I think they've got that one licked to the max.
Sometimes it's them calling us on behalf of one of our clients, but I would find that once one figures out the best way to work with their support organization in general, but their engineered systems support organization in particular, I can't think anything outside of a world class organization. I would admit that I don't have a lot, if any, experience with the competition, but I don't feel like I need any experience with the competition because of the way they do support those two products.
A lot of the times it ends up being complaints from the user community, and difficulty with strategic activities that the system performs. If you're running a commercial off the shelf application against these engineered system, sometimes it's a little more complex to work with a third party vendor, to speed things up. Mainly it's complaints from the user community. You and I both know that if something takes four seconds all the time and takes seven seconds some of the time, all the people are going to remember is the seven seconds.
I haven't done it on a hands-on basis, but I believe that what I mentioned at the beginning about out of the box is just that. Oracle from my recollection first tried to venture into some form of engineered system in the '90s with HP. It was a red box that you basically took out of the carton and plugged in. I think that's pretty much close to what once you brought it onto the network, exactly what you're going to do with their systems, so I thinks it's plug and play.
Choosing a vendor: obviously cost, high availability, and the strength of the rack technology. It's a corner of the Oracle technology that basically not exactly gets reinvented, but the new features and the new ways of going about to do things and the capabilities of failover and all that is a huge concentration as the product matures, not that it is immature. I think that's a primary reason that people might consider looking at this. There's absolutely no doubt, it's not far from an upgrade basically being done on the fly. There's so many things that can be done online. The plague of course of the '90s and the early-2000s was downtime.
Rating: I'd call it about a 12 out of 10. Of course you have to be able to afford the box. You have to be able to afford the configuration that you're going to be getting into. It's cost-effective for a lot of organizations, but I would rate the technology very high. Some of the specialized mechanisms that Oracle has put in place, especially with respect to Exadata and the late-breaking version of Exadata in particular.
As I said before, I'm not intimately or even somewhat peripherally familiar with the competition, but these guys know what they're doing, and my experience has been in the past that if Oracle ever plays catch-up in a technology spectrum with the competition, watch out. We all know that it's now cheap. It's affordable for a lot of organizations. If cost is going to be something, it's going to ultimately drive an organization's buy or no buy decision. The benefit after the money is spent and an ongoing outflow of cash to the vendor, if it makes business sense for somebody, I don't think they can be in a better place.
Make sure it's the right solution. Make sure that you do indeed need their real application cluster solution, which we affectionately call rack. Make sure it's right for you. It sounds corny, and it's sounds like a cliché, but it applied when I got started in IT in the 1800s, and it still applies. If it's cost-effective, go for it.
It makes it possible to deliver high performance Oracle OBIEE applications to our customers.
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.
We used Oracle Exadata from 2010 to 2015.
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.
We've experienced no issues with performance.
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.
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.
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.
The initial setup was pretty smooth and straightforward.
We had Oracle team to setup the device.
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).
The most valuable feature is definitely the performance. However, it's also a platform for both performance and consolidation. Once you start leveraging Exadata with Database In-Memory and Multitenant, you've got a really solid platform for database enterprise computing.
If you have server footprint reduction or consolidation as a requirement, then you can consolidate several databases and configurations onto one platform. Combine that with performance, it becomes a great avenue for cost reduction in terms of OpEx and CapEx. Exadata cannot be one-dimensional solution, performance, consolidation, and scalability must be part of the overall solution.
I think Oracle Enterprise Manager has come a long way with monitoring and managing Exadata, but getting the patching down would go a long way. I think the patching is still lacking quite a bit. If we can get the patching and upgrade in place, that would make a huge impact in overall supportability. I realize there is new OEM functionality recently introduced to support this, but it needs to be flushed out and tested.
It's been great. The stability has really, really improved a lot over the last couple of years.
It's been fantastic. With all the additional flash, with the faster CPUs, the faster disks, it's really come a long ways. The introduction of the X6 is also going to be an interesting avenue.
Tech support has been really good. That goes a long way because you have some comfort, stability in the fact that you've got somebody that you can lean on. You don't always have those skill sets. Since we're a services company, we do have those skill sets in that area, but most customers may not have that.
These guys are very well versed in the technology. They understand not only the storage software part of it, but the database as well as the hardware aspect of it -end to end. The most surprising aspect of Exadata is really the support.
It is quite difficult, but again since we're a services company, we're pretty well versed in it. We actually help customers do that end-to-end. Not only do we help bring Exadata in, we help do the installation and configuration and migration to the Exadata, as well as sustainability for future.
It takes a lot of planning depending on your downtime for conversion, depending where [platform] you're coming from. All those things play a big part in what tools you use and how you use them.
It is an expensive stack, so there's those things to keep in mind. The upside is that once you've bought into the technology, you have to embrace it , if that's the direction you want to go.
It is really good for what it's supposed to do. It's a great technology for Oracle-based solutions. There's pluses and minuses in everything. Any time you get an engineered system like that, you have to be geared for organizational [boundary] changes. Understand how the technology is supposed to work, how it's going to change the way you do your day-to-day business.
The most valuable feature would be Smart Scan because it gives us the ability to perform a large amount of processing on the storage side, cutting down on I/O tremendously. That's one of the big features that really drew us into jumping on Exadata.
We also like having the ability to have a lot of flash storage where a lot of our data can be in-memory, which speeds up transactions and processing.
As with any organization, before we embark on anything, we have to look at the ROI as well as the ability of a particular tool. Exadata helps us to consolidate and manage our databases as one with much faster processing. This, of course, is the key in speeding up our ability to do work and provide customer service. We're a mutual fund company, so speed is really key in providing satisfactory customer service. Exadata really gives us the key factors from an IT perspective, which are performance and availability.
There's a lot with Exadata that can be done on a black-box level which depends entirely on what the vendor is able to do for you, which is good from a certain perspective. But we hope, as this technology matures, Oracle allows customers to have a little more hands-on customization of some certain elements to better suit their environments. So we're looking forward to the ability to do greater customizations to suit our business needs.
Deployment wasn't difficult and we had no issues with it. Oracle had a bad rap in the past with customers who had bigger systems. They didn't provide them with enough assistance in order to assimilate new products and tools. But now, they've done a pretty good job of creating a very thorough cookbook, which has helped a lot with issues they we and my peers at other companies have had. Some of the issues was in the way we set up our enterprises which made it difficult to bring in and assimilate new products, but Oracle has lately done a good job of smoothing that out.
Exadata has been a very stable product once configured properly. We've had no issues with instability.
It's scaled to our needs.
We have premier-level technical support, so we have a pretty good relationship with them.
I would describe the initial setup as being of medium complexity. We're a financial insurance company, so we always want to put in a lot of rigor, in terms of security and compliance. At times, it's not our own fault, but it's our devices, but at the same time, the price of being exploited is bigger than what it takes to ensure security and compliance. The issue has been really more of the rigor that we put in ourselves, and finding a way to allow those new products and solutions to work as they were expected through our hardening that we've done on our environment.
We want to stay at the front of the cutting edge, and we evaluate and realize that the benefit, the return on investment that Exadata brings for a company of our magnitude and size, is tremendous. We've exploited Exadata, and it's performed very well for us.
The performance of Smart Scan, Storage Indexes, etc., and the High Availability features are all valuable to us.
We have a complete HA environment with two Exadata machines across two datacenters. We've able to use Data Guard to perform switchovers, perform maintenance, and do other tasks with little or no downtime at all.
The Lifecycle Management over the whole stack could be improved over what it already provides. The rolling upgrade feature on the database itself should be improved. It needs some Java updates as well as there is too much downtime related to Java issues.
I've been using the platform for five years, and my customer is now buying Exadata X5-2.
We didn't have an issue with deployment.
While we have am MAA environment, it is absolutely robust. We've had no issues with any instability.
There have been no issues scaling it for our needs.
Oracle Support Services should be improved. The customer has seen more and more discussions within the Oracle Support Groups indicating that support has done more and more finger-pointing, which doesn't help the customer to fix problems.Technical Support:
5/10 - They have a lot to improve upon.
There was no solution previously in place.
The initial setup was complex, but it was well planned by Oracle ACS.
We implemented it between Oracle ACS and an in-house team.
The pricing and licensing is really complex and you need to have a very detailed plan.
The customer looked at a Hitachi solution.
Start with a good POC and then make the decision.
Because of Exadata Systems, we were able to consolidate all the applications databases into one, e.g, Oracle EBS, Siebel, Hyperion etc.
Exadata Linux systems have Intel CPUs inside. I would suggest that if Oracle could work together with Intel to have some more intelligence at the CPU level, then there would be nothing like it.
I've been using it since June 2013.
We didn't have any deployment issues.
After three to four months we may need to perform a rolling reboot of the DB/storage servers.
I would say it's the best solution in terms of scalability.
We used both EMC Storage and IBM Servers.
The setup was simple, however, the database migration was a bit challenging, but there was no show stopper anywhere.
We are a vendor TCS (Tata Consultancy Services) and have as a customer the Taj Group of Hotels (IHCL), where we deployed and implemented Exadata Systems.
It's almost 100%.
Go for it if you are looking for consolidation/scalability.
The High Availability and rolling upgrade features are the most important for us. They help us achieve zero downtime and increased performance.
The biggest advantage to our implementation of Exadata is that because it's an Oracle-engineered system, our database administrations don't have to worry about performance tuning. It's already optimally tuned and, when compared to other systems, it's really provided us with better performance.
We've had no issues with deployment.
It is brand new for us, and we are slowly getting other databases into it. So far, it's good, but we are not using 100% of them, so we still have to learn a lot.
It has the best scalability of all our Oracle products.
We've created a lot of cases, so we're in touch with Oracle support frequently. The service is consistent across all our Oracle products because they're located in one place.
We previously used IBM InfoSphere Warehouse.
The initial setup was straightforward.
Oracle provided us with an on-site consultant to perform the installation.
We also looked at Microsoft SQL. We chose Exadata as we have other Oracle products, including Database.
If you are buying Exadata, be sure to go with the latest version.
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.
I've been using it for five years, including in my previous company.
During migration, we approached transportable tablespace and Oracle database along with GoldenGate.
There have been no issues with stability.
It's been able to scale for our needs.
10/10 because we have Oracle Platinum Support.
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.
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.
We did it in-house with help from Oracle.
It's too costly.
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 .
It's a fast solution, though it does take some work to ensure that queries are offloading using bloom filters, etc.
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.
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.
We've had no issues with deployment.
We've had no issues with stability.
We've had no issues with scalability.
There was quite a learning curve despite knowing that "things are different" with Exadata.
I do know it's eye-wateringly expensive and that we struggled to get it to do what we wanted it to do.
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!.
Most, if not all of the time, a database workload is a disk I/O-bound, not CPU nor memory. The most time spent in a database operation is reading a data block from or writing a data block to physical disks. This is true for any type of workloads -- small or large block read and write, sequential or random access. The Exadata technology minimizes this bottleneck by utilizing
There are several scenarios in which this technology can help. Most package (COTS) software are not designed, and therefore are not optimized, for a specific database platform, e.g. Oracle. Performance starts becoming a problem when the database size and workload (e.g. transaction rate) are high. Even if you, as a customer, have reached out to vendor support, chances are they are not going to customize their code just for one database platform, Oracle. They may help you to do small tuning here and there, but without optimizing the application code, the result is limited. Exadata comes as a quick fix in this situation. Oracle Exadata will sweep the problem under the carpet.
Secondly, most applications have a mixed-workload, not purely OLTP and not purely batch/reporting. Unfortunately in many aspects, database tuning for the fastest response (as in OLTP workload) and for the highest throughput (as in reporting/DSS workload) are a contradiction. Again, Oracle Exadata can be a quick fix by minimizing the number of I/O on a fast and high-throughput storage network. It helps on any kind of workloads.
With its value proposition, Exadata is being used to run mission-critical, 24x7 applications. Unfortunately, not all hardware in the Exadata rack are hot-swappable (such as memory, processor and battery maintenance in older models), and therefore business application downtime may be required for those hardware replacements.
Infiniband cabling work may need a complete downtime as well, for example, when we need to connect multiple racks.
I have been working with Exadata, since its X2 generation about five years ago. Since then, I have worked with its X3, X4 and, currently, the latest X5 generation. Each generation comes in three models based on the number of sockets in each of database server, -2 (for example X5-2) and -8 (for example X4-8). I have not had a chance to work with the X5-8 model, which was released less than five months ago. However, there is no fundamental difference from the previous generation X4-8, other than more processing power and memory due to newer hardware.
As in any technology deployment, software bugs and misconfiguration are possible. I have dealt with a few bugs and misconfigurations that have caused application downtime in the past.
We have no issues with its stability.
You should start with a small footprint (for example, a quarter-rack Exadata) and then grow to a full-rack or even multi-rack Exadata. The only challenge is that by the time you need to expand, the Exadata generation may have evolved (every one to two years, so far). You may end up with a full-rack of Exadata that contains multiple generations, each with a different CPU, memory, and disk capacity. This may not be a big problem, but you have to come up with a strategy to distribute the workload.
Oracle Exadata comes with Platinum Support, which is a premium support and includes regular (quarterly) patching/version upgrade activity and fault monitoring. I think this is a right approach by Oracle. As an engineered system, there is a lot of version compatibility between firmwares, operating systems, and softwares that must be taken care of for a patching and image upgrade. This definitely would be a huge responsibility if customers had to deal with this.
What everyone needs to understand is that Exadata is a database consolidation platform, and is not designed as a virtualization platform. Therefore, there are security considerations if you plan to use Exadata to host multiple applications that require certain levels of segregation at the network, storage, and operating system levels.
What makes Exadata different than competitors is that it is not designed only for a specific application (as in SAP HANA), and is not only for a certain type of workload (as in Teradata).
It is called an engineered system, but there are options that Oracle offers to its customers. Customers need to complete a configuration generator tool called Oracle Exadata Deployment Assistant (OEDA). Based on the selection made on the tool, configuration file is generated and this will be a 'binding contract' between customers and field engineers who will do the initial setup. The problem is that it is the customer's responsibility to make the right options and some of them are not easy to understand. I suggest the customer not to hesitate to get assistance from Oracle Pre-sales and to go through each of possible options in detail and to understand all consequences.
Initial setup is always done by an Oracle field engineer, up to creation of an empty database. Infrastructure cabling and data center power are usually done by contractors. From the support standpoint, Exadata is just the same Oracle database servers and Linux/Solaris servers.
The solution is relatively easy and fast to deploy. It typically takes less than three weeks from hardware delivery to having functional database servers with a built-in high-availability feature. Most importantly, it delivers an excellent Oracle database performance for any type of workload (OLTP or batch/OLAP). I have seen from 3x to 10x performance improvement for various workloads compared to previous versions. The reason I didn't give a perfect 10 rating is because some hardware are not hot-swappable, such as battery (for older models), memory and processor. While as a matter of fact, this is an important feature of a platform for an enterprise mission-critical application.
What often is confusing for many is the support model of Exadata. Many think Exadata is a black box or appliance that will be supported entirely by Oracle. It is not an appliance or a black box. It is just a bunch of regular Oracle database servers and Linux (or Solaris) servers as storage servers. It needs DBAs and system administrators to take care of it and work with vendor support in case of incidents or patching.
There are several features I've found valuable, including Exadata Hybrid Columnar Compression, Exadata Smart Scan Technology, and Smart Flash Cache.
We have dramatically improved performance for the batch jobs, after we moved from the traditional Oracle 11G databases to the new Exadata servers.
Performance has improved several-fold and moving (consolidating many small databases from smaller Linux/Unix servers into Exadata cluster) has resulted in lower production support cost and effort for BAU DBAs.
There were some minor problems moving databases to Exadata, but it was more a problem with the internal processes with my current employer.
We've used it since August 2015.
We've not had many issues with deployment, except for the minor issues involving moving databases.
No problems, we have not had any unplanned down-time or performance issues.
We've had no problems with scalability.
Oracle was pretty good in original install and database clusters build, and was pretty helpful in all the requests and questions we posted to them.Technical Support:
I would say technical support is very good. I have extensive working relationships with the Oracle consultants who were deploying the Exadata clusters at Worksafe. We have not had any really major issues with our Exadata clusters so far.
Yes, I have worked as DBAs on traditional Oracle RDBMS versions 9I, 10G and 11G. My previous employer has deployed large DW database into Exadata with great success. Also, Worksafe has decided to move/consolidate many smaller servers/databases into large Exadata clusters. My opinion is that in both cases business users are pretty happy with the database performance and stability on Exadata servers so far.
Initial set-up was a bit complex, but everything was resolved pretty quickly.
Original implementation was done by Oracle, and I would rate the consultant competence as very high.
I was not involved with pricing and licensing.
I was not involved in any before evaluation process.
Exadata is very solid and robust machine, with great performance. Highly recommended for companies (who can afford it).
The extreme performance and data compression that comes straight out of the box.
With Exadata, everything is simply better optimized, and our organization has been leveraging the fact that it can now manage larger volumes of data much more easily than it could previously. For example, we almost never hear our internal or external customers complain about performance issues these days. Performance problems were a recurring problem for us in the past.
X5 supports virtualization, but I think the performance on virtualization is not all that great. I have heard it from a customer, though I admit I haven't tested it out myself.
We have been using this for about three months.
No issues encountered.
No issues encountered.
We find X5 to be very scalable.
We have always had excellent customer service.Technical Support:
We were convinced that with Exadata we would be able to consolidate our databases, have a serious performance boost, and leave a smaller footprint on the Data Center.
There were some complexities because a lot of departments were involved, and there were some communication gaps, but generally speaking, it went smoothly.
It was done in-house, but with help from Oracle.
Your TCO and Operational expenses will definitely go down with Exadata.
No, we were pretty much decided on Exadata from the outset.
This product actually does what it promises to - it gives extreme performance on your data set.
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?
- 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) */
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?
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.
The intelligent features have been built to utilize the storage layer in a much better way.
It's one of the most stable, high-performing products I've used.
More control for database admins is needed for storage indexes and pricing.
I've used it for close to five years.
No issues encountered.
No issues encountered.
No issues encountered.
It's average.Technical Support:
We switched because we get better reliability and scalablity, as well as improved performance and a smaller footprint in the datacenter.
It was straightforward.
We implemented it in-house.
It's close to 40% in terms of cost saving.
Oracle's pricing and licensing is always costly.
No issues encountered.
If you are running Oracle databases, this is the best solution.
SmartScan and Cell Offloading, which can drastically reduce I/O from queries, improving response time.
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.
Massive updates statements should not disable HCC.
I've used it for over two years.
When the workload increases on the cells, Cell Offloading may not happen.
No issues encountered.
No previous solution was used.
The setup is conducted by Oracle, which is a requirement.
We've not measured it.
It can simplify your IT environment, reducing the costs with maintenance operations if you have the Platinum offering.
We looked at Fusion I/O, but Exadata Storage was so much faster.
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.
The ASR needs to be improved.
I've used it for three years, from 2012 to 2015.
No issues encountered.
No issues encountered.
Oracle support provided the necessary information to scale the system.
It's good, 8/10.Technical Support:
In the past we used traditional RAC database architecture. We switched because this type of solution has many drawbacks, and Exadata is the best system for Oracle databases.
It was straightforward using the OneCommand tool that is designed for Exadata deployment.
We used an ACS engineer (advanced customer service) and the field delivery engineer did the implementation.
It is little bit expensive compared to other solutions, but very useful. You just pay for one license which covers all the components within Exadata.
It is a new level of server designed for Oracle database software, so you cannot find any other options with Exadata storage software.
If you have OLT and are working 24/7 on an Oracle database, Exadata is the best solution for you. Before implementing this product you need to define your requirements clearly as this will help you to avoid future issues.
There are so many it’s hard to just name a few but -
Many diverse applications were migrated to the Exadata platform that had either performance or stability issues. All have had very reliable and performance since.
Their hardware engineers can’t be beat. They are the best people I have ever worked with and parts are installed very quickly and efficiently. They’re very easy to work with, schedule jobs with, and get things done. Also, they are very proactive as well.
Most of my suggestions for Exadata itself have been addressed in X5. Oracle keeps improving the reliability and adding more hot swappable parts for the hardware and software.
The only improvements left are not with the product itself but with MOS support, ASR and patching. For MOS software support, there are some very talented people there, but not enough of them. They need more software engineers with in depth training on how to use the ASR system and the jump gate.
When the jump gate is updated or patched, it seems to take a bit to get things working properly again so patching and ASRs can be done. Platinum patching continues to improve but it is not a hands off solution.There is quite a bit of manual effort involved with each patch cycle to co-ordinate the patching. With some of the patching there, is downtime, and most of it is rolling but there are a few cases where you do need have downtime.
Since v1, almost six years.
Just the normal software bugs, nothing major. In fact considering the complexity, there are very few bugs at hardware/software level. The ASR system with the jump gate was more problematic than the Exadata setup.
No, very stable and reliable. On one quarter-rack we have 27 databases running, which astounds me every time I patch and do maintenance.
We have added more memory and additional storage arrays, and adding more memory is very easy, while adding a storage array takes some time, but it is not as complicated as I expected. We will be expanding our local file system soon not sure how complex this will be. Adding ZFS is fairly straightforward and has become easier since I first did it three years ago.
My hardware support is beyond compare. The MOS software support is good but there are just too few experienced people.
AIX, and we switched partly due to a hardware refresh, and partly due to performance, and the growth of some of the applications.
Documents are very clear, and there were many software and hardware engineers available to provide assistance and guidance along the way. The most difficult piece was the ASR system set up with the jump gate, password vault and set up in OEM. The other difficulty was the network, and some of that was due to my lack of experience in that area.
We had one application that went down constantly and since we moved to the Exadata there have been few issues outages and incidents.Huge performance gains as well.
Really evaluate your needs from a hardware and software end. Buy what you will need for between three and five years down the line, in terms of storage and memory. Buy products either before Oracle’s fiscal year end (May) or Open World. You can bundle all of your Oracle products into one agreement to get the best discounts. Try to get training and some consulting time into the agreement.Some companies leverage the partner or beta programs. I did one such beta test and was glad I did because I made improvements.
We had tried other storage and hardware options but nothing really got us performance we needed for some of our applications. We migrated applications from AIX to Linux VM and Exadata. The most critical or resource intensive applications go to Exadata.
There is a learning curve to this product and it is complex at the hardware, network and software levels. Train all your staff, not just the database administrations as the network and UNIX admns have to get familiar with the components. Exadata classes are available and the DBAs should know RAC and services well.
The starter databases are a template for new databases. Run ExaChks weekly, and set up OEM to monitor Exadata, but spend time to make sure you do it correctly. If you have a large Exadata foot print look at ZFS for backups and evaluate if you have the staff to support it. If not make sure you partner with the correct consultants.
Oracle does provide Platinum patching services but that has to be managed. Read about the product and really evaluate how to use it properly. Talk to other customers and join Exadata groups. Do a proof of concept, so see if there is a sandbox to try out. And probably the best hint is that MOS has an Exadata best practice guide - follow it as best you can. Granted there are some things you have to do for vendor products. But the more you can get out of these the better off you will be for patching, MOS etc.
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.
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.
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.
I've been using Exadata since V2 in 2009.
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.
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.
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.
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.
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.
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.
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.
For our customers, we are able to significantly reduce both CapEx and OpEx for customers for 3-5 years TCO. We are able to:
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.
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.
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.
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.
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.
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.
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.
Issues encountered tend to business process problems or people problems. The issues tend not to be technical.
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.
Have worked on expanding racks with multi-generation racks, the promise of start small and grow over time is delivered fairly effortlessly.
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.
Storage growth, and the possibility of utilising HCC to drive this down was a large driver for switching.
The initial setup and deployment of an Exadata rack is straightforward it has been well engineered to be a very quick initial setup.
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.
The most valuable feature is the integration of the various components that make the performance soar. More specifically the presence of storage indexes along with the Exadata Storage Server software, which delivers process offloading, allows us to deliver better performance without indexes--saving space and CPU. This innovative feature is not something we would be able to replicate with other solutions. In addition, we consider the features smart scan, smart flashcache, smart flash log and hybrid columnar compression very useful.
Prior to Exadata, we were relying on daily ETLs from multiple source systems to load data into base tables, then we prepared a summary and materialized views from the base to data marts which were eventually exposed to the end users. This process used to take 18 hours. So, the data was always at least 18 hours late, and occasionally later, if the ETLs failed. This caused two issues: first, most managers simply were not able to make quick decisions because the data was stale and second, for most important functions, the users got the data from our OLTP system which taxed that system's capacity.
After Exadata, we observed three immediate benefits:
There are three possible enhancements:
I've used it for 4 years
Yes; mostly due to the database version being different. We were upgrading from 10g to Exadata which ran 11g; so there were some issues we had to overcome; but those were expected. Quite honestly, our deployment was smooth in Exadata itself due to our deep understanding of the technology. Without it, I am not sure if it would have been that smooth.
Yes; the initial versions had a lot of firmware issues that caused the cells to reboot, which caused the ASM software to rebalance the diskgroups. It mostly occurred in the X2 system. The X4 system has been quite stable. However, it's important to point out that Oracle generally releases firmware updates quite fast to remove any stability issues. We encountered them because we didn't apply these due to our internal reasons.
No; scalability has been pretty awesome.
It leaves a lot to be desired. It has improved; but still a lot to go. I rate it 6 on a 10 point scale.Technical Support:
I gave an overall rating of 9 to Exadata X4 due to the quality of support personnel during installation and after sales events. That is going up but still leaves something to be desired.
We used Oracle database on HPUX. We switched because it was impossible to deliver performance without additional indexes. Indexes took up space and slowed down data insertion performance. Exadata solved these by enhancing performance without the need for indexes.
Oracle sends professional installers for installation and deployment. So it was fairly simple. However, as I mentioned earlier, we do have a deep technical expertise base so it worked in our favor. Without that expertise, I can't be sure if would not have been complex.
We implemented everything with our in house team.
Yes, we did evaluate Teradata, Netezza and Greenplum.
First and foremost, develop or hire a deep technical talent base inhouse, even if it's just one person. The technical role is called Database Machine Administrator (DMA). Planning is winning half the battle. There are tiny little things that makes a big difference. For instance, how to decide whether to keep the indexes you have--it's not something you can outsource. Second, get the installation checklist (detailed) from Oracle and establish SLAs for each item meticulously along with the hand off details. Third, if you don't have it, consider Oracle Enterprise Manager Grid Control to manage the Exadata system. Fourth, decide to use Oracle Platinum Support (free for Exadata) from day one. Finally, get ready to be wowed.
The innovative use of all the technologies integrated so creatively and functionally that it provides an immense performance boost impossible to attain with do it yourself systems. For instance the secret sauce is Exadata Storage Server (ESS) software, which is unique to Exadata, can't be replicated even with other massively parallel systems.
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.
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".
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.