Oracle Database In-Memory Overview

Oracle Database In-Memory is the #2 ranked solution in our list of top Embedded Database Software. It is most often compared to SAP HANA: Oracle Database In-Memory vs SAP HANA

What is Oracle Database In-Memory?

Oracle Database In-Memory transparently accelerates analytics by orders of magnitude while simultaneously speeding up mixed-workload OLTP. With Oracle Database In-Memory, users get immediate answers to business questions that previously took hours.

Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality, or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with any existing Oracle Database compatible application is as easy as flipping a switch - no application changes are required. Oracle Database In-Memory is fully integrated with the Oracle Database’s renowned scale-up, scale-out, storage tiering, availability, and security technologies making it the most industrialstrength offering on the market.

The ability to easily perform real-time data analysis together with real-time transaction processing on all existing applications enables organizations to transform into Real-Time Enterprises that quickly make data-driven decisions, respond instantly to customer demands, and continuously optimize all key processes.

For more information on Oracle Database In-Memory, visit

Oracle Database In-Memory Buyer's Guide

Download the Oracle Database In-Memory Buyer's Guide including reviews and more. Updated: January 2021

Oracle Database In-Memory Customers
Shanghai Customs
Oracle Database In-Memory Video

Oracle Database In-Memory Reviews

Filter by:
Filter Reviews
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
Filter Unavailable
Filter Unavailable
Order by:
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Showingreviews based on the current filters. Reset all filters
Mohammad Dastpak
Database Administrator at a energy/utilities company
Real User
Top 5Leaderboard
Dec 11, 2019
Easy to deploy and has good performance

What is our primary use case?

My solution has a big database with terabytes of data and we use Database In-Memory for a lot of our data. Normally, we partition it and create big tables, but we can use In-Memory for data that we use every day or every hour. We put some partitions in In-Memory from some tables and we use that. It normally has good performance.

Pros and Cons

  • "Normally, every database server uses hard disks. In-Memory has a feature, apart from their database, which is very good. When we start our server, all your data needs loading memory. We can use that. It's a very good feature. I think they added this feature in 2019. We can mount memory in the partition, create partitions in there, and create table space from that spot to share. It's a really good feature. We use it a lot."
  • "We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature."

What other advice do I have?

Oracle is the best database, but I love open-source software. Oracle always has the first original features for three or four years and we use them because they are stable and we can buy in a large scale and use it for our office. It has no problems. I think Oracle is ten out of ten. About Oracle Database In-Memory, in particular, I would rate it as eight out of ten. It's a new feature. I think it's improved from the last version three years ago. Oracle's new features and data are very useful for us for storing data, loading it, etc. Oracle features based on processes are good. In Oracle, we…
JongGun Shin
Oracle ACE, DBA at Goodus,inc
Real User
Top 20
Oct 13, 2020
User friendly with a good interface but very expensive

What is our primary use case?

We primarily use the solution as an email database.

Pros and Cons

  • "The application development is very user-friendly."
  • "The pricing could be improved. It would ideal if it was more reasonable."

What other advice do I have?

We're Oracle partners. We've been partners with Oracle for a long time. Our IT department first changed from on-premises to cloud. Our clients seem to like a hybrid deployment model. Now they are considering looking for other solutions that may not be as expensive or may even be open-source. I'm not really a database expert. My understanding is that some customers want to make a product from the portal website using the In-Memory DB. Others tend to want to migrate from an Oracle In-Memory database to another email database. It's difficult when users want to migrate off of Oracle or simply to…
Find out what your peers are saying about Oracle Database In-Memory vs. SAP HANA and other solutions. Updated: January 2021.
455,536 professionals have used our research since 2012.
Martin Klier
Senior Database Consultant at Performing Databases
Top 5Leaderboard
Aug 8, 2019
It helps to build successful mixed-workload environments

What is our primary use case?

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.

What other advice do I have?

It is always worth testing or running a proof of concept to check its value.
Paulo Martins
Technical Leader at European Commission
Real User
Top 5Leaderboard
Jan 20, 2020
Has the ability to support large amounts of data once the architecture is in place

Pros and Cons

  • "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."

What other advice do I have?

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.
Solution Architect at ixtel
Top 5Leaderboard
Dec 23, 2019
Simple to implement, very fast, and easily scalable

What is our primary use case?

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

Pros and Cons

  • "The solution is very fast."
  • "The solution is quite expensive."

What other advice do I have?

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.
Paresh Nayak
Oracle Cloud Infra Architect at Sterlite Technologies Ltd
Real User
Top 5Leaderboard
Apr 8, 2020
Has improved database performance and has fast caching

What is most valuable?

The most valuable aspects of this solution are: Fast caching Improved database performance

What needs improvement?

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

For how long have I used the solution?

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

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

It is scalable. 

How was the initial setup?

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. …