Oracle Database In-Memory Reviews

We are developers and integrators that produce software and solutions for our customers. We have a variety of customers in different industries and we have a local platform where we develop solutions based on Oracle or SQL Server. I'm the company CEO.

Security is the most valuable feature. 

The solution would be better if we could use modeling rather than coding, which is the only option currently available. I'd also like to see more integration with other tools. 

The solution is stable. 

The solution is scalable. 

We had some technical issues last year and we emailed the company with questions. We never received a response, unfortunately. We eventually found the solution online but never received a response from the company. We are based in Iran so maybe there are some limitations in that respect. 

As with any solution, the initial stage can be complex, but after a while, it becomes easy. Relative to other solutions, the setup is not complex. 

The solution is very expensive. 

The solution provides a good environment and it's a product we trust.

I rate this solution eight out of 10. 

The most valuable aspects of this solution are:

• Fast caching
• Improved database performance

They should lower the price. My customers think that it's too expensive. 

We have been using it for the last two to three years. 

It requires a lot of resources, man power, and DB power, to make it stable.

It is scalable. 

The initial setup is complex. They want to achieve what Oracle is offering. Oracle offers everything under one umbrella inn one offering. Whereas if I go for PostgreSQL I have to buy a small component separately from a third-party vendor.

I would recommend In-Memory because it is a robust and scalable RDBMS. We are able to achieve high availability.

I would rate it a nine out of ten. 

They should improve the licensing cost.

The stability of the platform is the most valuable feature. The solution can support large amounts of data once the architecture is in place.

The solution could benefit from AI improvements.

Technical support could be improved.

The usability of the solution could be better. They should make it easier in terms of system administration and for getting examples of statistics from the databases. An interface or dashboard for statistics would be better. Right now, we're using cloud controls to do that, but it's not good enough.

I've used this solution for the past five months and was an Oracle Database administrator from 2000 to 2005.

The database is very stable.

The scalability of the solution is very good. It's able to support large amounts of data.

Technical support is below our expectations currently. It could be improved.

The solution was already in place when I began to work for the company. I don't know if they previously used a different solution or not.

We have ULA agreements with commission in place with Oracle. The pricing is okay for now.

We use the on-premises deployment model in the virtualization environment.

I'd rate the solution eight out of ten. If technical support was better and usability was improved, I'd rate it higher. It's the best solution on the market right now, but it's more for big data. For us, it's the best solution we can get for our specific needs.

We primarily use the solution as a warehouse. In the front end we are using MicroStrategy, and we are using Oracle as a database.

The warehouse is the solution's most valuable aspect.

The solution is very fast.

I'm not sure about the improvements needed in the solution.

The solution is quite expensive.

I've been using the solution for two years.

The solution is stable.

The solution is scalable. Almost everyone in the company uses the solution.

The solution's technical support is good.

I did not install it myself, but the database administration team did, and they found it simple. In one day they were able to administrate the data stack file.

Our team handled the implementation.

Oracle is a costly product.

Choosing this solution was the choice of the database administrator. I didn't participate in the process, so I'm not sure what was used before of if other solutions were evaluated.

We use the on-premises deployment model.

I'd advise others to look at the solution, but to be mindful as it is costly. Whether it is right for a company or not depends on the requirements. If they have the budget, they should go for Oracle. If they do not, I'd suggest they look at something open-source like MySQL or Oracle SQL.

I'd rate the solution nine out of ten.

We are using Oracle Database In-Memory as an indirect approach to improving response times. In mixed-workload environments, we use the In-Memory column store to support OLAP-type queries without harming the latency-critical OLTP operations the systems "earn money with". This was successful for many customers throughout 12.2 and 18c.

It helps to build successful mixed-workload environments. Thus, for smaller setups, it's enough to have one database setup, not two, and it saves one interface in between.

In recent versions, Oracle implemented storing the In-Memory column store contents in the database, to resurrect the IMCS quicker and in a repeatable way.

One very nice side-effect is the in-memory index. If this would be developed a bit more into being configurable, users could use it as a kind of in-memory partitioning. That opens a big field of possible use cases.

Very stable.

In my experience, it scales quite well. Unfortunately, decent scale-out with RAC only works in Exadata, since Oracle relies on RDMA which is only available for InfiniBand.

"It depends". If you get a good support engineer, it is a dream. 

But, most times, it is not, unfortunately.

No, since there was no other solution offering in-memory without changing the SQL syntax.

We grew into it during beta and initial releases, so I can't answer this.

We do implementations ourselves, so I can't answer this.

If you can save setting up an additional interface and a second DB server, investment should return immediately.

The setup cost is not a big factor, but the engineer should have decent experience with Oracle's In-Memory system.

License cost is a factor; the benefit has to be carefully evaluated.

We tried several ways to offload OLAP queries from the database, especially using a second DB system.

We evaluated this product throughout the beta1 and beta2 phase.

It is always worth testing or running a proof of concept to check its value.

Oracle has a lot of features embedded. In my opinion, Oracle In-Memory offers a lot of improvements in database performance specially for data warehouses and analytics workloads. Combined with Exadata, it makes a solution that will deliver the best performance related to the volume of data.

As I’m very involved in database security, I can tell say that Advanced Security Option and Database Vault are most valuable features for me because I can propose them to my customers to deliver the best security options for their databases.

Each time I've implemented the In-Memory option, the improvements have been on the performance side. This option offers a way to drastically reduce batch duration with a minimum of work because we only need to enable it on columns we choose, test batch performance, and that’s it. We can do this cycle of work less than 10 times and the job is completed.

They need to improve the Decision Support System with analytics workloads.

I've used Oracle Database since 2001, and I officially used the In-Memory option since its general availability in June 2014. But, as I’ve been a beta tester for the Oracle version that delivered this option, I can say that I've used it since the beginning of 2014.

There have been no issues deploying it.

The product is stable. Of course, at this level of software, there are always some bugs. But, each time I have had to implement it, the bugs weren’t very problematic and I've always found a patch or a workaround.

It scales to the needs of my customers.

Technical support is useful with the My Oracle Support website. But when I have to open a service request, I have to find a solution on my own because technical support usually doesn't understand my problem or they always ask for the same logs, same questions, and I ultimately waste my time.

I tested the In-Memory equivalent in DB2 or SQL Server 2014, but they both have limitations in their uses. SAP HANA is one of the most concurrent of Oracle’s solution, but I have never used it.

The deployment was very easy because we just have to set a volume of memory as the In-Memory area, and the enable In-Memory for specific columns. This part is longer, but for me, it’s more a tuning issue than a deployment issue. Deploying Oracle In-Memory is very easy and takes only a few minutes.

Implementing Oracle In-Memory is very easy, but the tuning phase is mandatory to optimize it.

Performance. That's probably the number one.

When we use it for OLTP, which is the Online Transaction Processing, the response for the end-user is pretty fast, which is a good thing, especially if the user is looking at a website, the response time is really micro milliseconds as opposed to waiting a few seconds for that page to load.

I think it still goes back to the user benefiting the most out of this, it's basically a good customer experience, the product.

Nothing right now.

It is pretty stable.

It scales really well.

We had to scale it along with the rest of the ecosystem, not just this in particular, but the infrastructure as well. We had to scale both of them.

We had to involve them just because we ran into a couple of issues and they've been resolved in a timely manner. Pretty good.

No, we always needed something like this, and I've looked at Microsoft, they have a similar solution, I think they have something similar,

It's pretty straight-forward. It's actually more of an inbuilt core functionality as opposed to have us to go through an implementation process.

We did evaluate a few other vendors, but again this wasn't a product on it's own. It's part of the bigger ecosystem. So the decisions are for other reasons.

Try it out first. See if it meets your expectations and go from there.

The most valuable features are its real time performance and consistency.

We are not using it for our internal systems, but rather for our customer solutions. We can provide a high standard with this solution to our customers by using such products.

We are waiting for new features in the next release.

Stability is very good.

Scalability is also very good.

Technical support from Oracle is fantastic. We have been working with Oracle very closely and we are very satisfied with their performance.

We had started to use this solution from the beginning. We haven't switched from another solution. When selecting a vendor, we want someone who has a long term road map. This demonstrates sustainability.

The initial setup was not complex. It was no problem at all and it was straightforward.

We haven't used other vendors. We have a long relationship with Oracle and we have had a good experience with them in the past.

I recommend using this solution, just as we are using it.