The major use case for Oracle Database In-Memory is real-time applications that need a fast response between the application and the database directly without any latency.
Oracle Database In-Memory enhances performance for analytics and data warehousing, addressing large data volumes with real-time processing and advanced transaction capabilities. Its columnar storage accelerates analytic queries, with stability supporting deployment across diverse scales.


| Product | Mindshare (%) |
|---|---|
| Oracle Database In-Memory | 11.9% |
| SQLite | 14.9% |
| Firebird SQL | 12.9% |
| Other | 60.3% |
| Type | Title | Date | |
|---|---|---|---|
| Category | Embedded Database | Jun 23, 2026 | Download |
| Product | Reviews, tips, and advice from real users | Jun 23, 2026 | Download |
| Comparison | Oracle Database In-Memory vs SAP HANA | Jun 23, 2026 | Download |
| Comparison | Oracle Database In-Memory vs SQLite | Jun 23, 2026 | Download |
| Comparison | Oracle Database In-Memory vs Firebird SQL | Jun 23, 2026 | Download |
| Title | Rating | Mindshare | Recommending | |
|---|---|---|---|---|
| Teradata | 4.1 | N/A | 88% | 83 interviewsAdd to research |
| SQL Server | 4.2 | N/A | 93% | 274 interviewsAdd to research |
| Company Size | Count |
|---|---|
| Small Business | 6 |
| Midsize Enterprise | 4 |
| Large Enterprise | 19 |
| Company Size | Count |
|---|---|
| Small Business | 76 |
| Midsize Enterprise | 30 |
| Large Enterprise | 94 |
Oracle Database In-Memory provides an efficient platform for mixed-workload environments, optimizing performance and accelerating query processing. Its ability to handle OLAP queries without impacting latency-critical OLTP operations aids real-time data transfer, analytics, and reporting. Users across different industries implement it for business intelligence, data transactions, and decision-making, utilizing both on-premises and cloud platforms for applications such as banking and commerce. Despite its benefits, users cite needs for improved interface, better stability, and enhanced AI capabilities. Security, integration, and technical support remain critical considerations.
What are the key features of Oracle Database In-Memory?In industries like banking, Oracle Database In-Memory is pivotal for enhancing transaction processing and analytics, offering improved security and real-time data management. Businesses in commercial sectors leverage it for decision support, employing both on-premises and cloud solutions, facilitating seamless data operation and strategic advantage.
Shanghai Customs
| Author info | Rating | Review Summary |
|---|---|---|
| Technical Solution Architect at Vodafone | 4.5 | I've found Oracle Database In-Memory highly effective for real-time, high-volume data processing with minimal latency, though its UI could improve and setup is intricate; overall, it's stable, scalable, and serves my use case well. |
| Sr. Oracle Database Administrator at Shoukat Khanum Memorial Hospital | 4.0 | We recently began implementing Oracle Database In-Memory based on management's request. While setup faced network and data transfer challenges, ongoing use is stable, though I haven’t seen clear benefits or ROI yet. I rate it eight out of ten. |
| DB Architect / Consultant at Virtusa Global | 4.0 | The primary use of Oracle Database In-Memory is to enhance disk operation performance and speed up processing through memory. It features in-memory cache for real-time needs, though it could better support AI challenges like hallucination management. |
| Product Owner at Heineken | 4.5 | We use Oracle Database In-Memory for deploying commercial applications and secure data storage, valuing its dashboard and processing speed. However, it's pricier than Azure, and we face challenges with regional support from Oracle's team. |
| Senior System Analyst at Thakral | 4.5 | I use Oracle Database In-Memory mainly for core banking applications. Its Real Application Clusters enhance performance for thousands of users. The high cost and complex installation are drawbacks, but the ROI is approximately 80%, despite ongoing support costs. |
| Architect at LTIMindtree | 4.5 | I find Oracle Database In-Memory's outstanding performance, especially for airlines' batch processing, highly beneficial. While the dashboard needs refreshment and pricing/scalability could improve, my overall experience is positive. |
| Database Administrator at a government with 10,001+ employees | 4.5 | Oracle Database In-Memory significantly optimizes database performance by accelerating query processing, which enhances productivity. Its automated features meet our needs, though some manual intervention may be needed to fully realize benefits. We've achieved an 80% return on investment. |
| Senior Consultant at Tata Consultancy | 4.5 | Our company uses Oracle Database In-Memory as part of our banking solutions for real-time analytics and mixed workloads. While performance is valued, the appliance-based approach can be restrictive, and pricing could be improved to suit customer needs better. |
| IT Consultant at a computer software company with 1,001-5,000 employees | 5.0 | I use Oracle Database In-Memory for analytics and reporting, appreciating its backward compatibility. Transitioning from non-In-Memory takes time but avoids code changes. Reducing downtime would improve the process. Microsoft's scalability is inferior, and my deployment was cloud-based. |
| Sr Quality Engineer at Optum | 3.5 | We use Oracle Database In-Memory to create relational databases on both public and private clouds. It is simple and scalable, though it could benefit from incorporating AI-driven intelligent coding. We haven't used or considered other solutions. |

The major use case for Oracle Database In-Memory is real-time applications that need a fast response between the application and the database directly without any latency.
The biggest benefit of Oracle Database In-Memory is dealing with a huge amount of information without any latency for our response time.
I assess the benefits of automatic in-memory population for prioritizing data as very nice features, and it is very easy to configure. The result most of the time runs without any issues.
The benefits of data compression in Oracle Database In-Memory are great because we are using data, and it saves a lot regarding sizing.
I do not have any comment related to the improvement of the solution; for sure, it needs improvement, but for my use cases, it is very sufficient, and I think for the biggest companies, it needs a very powerful infrastructure.
The area where improvement is required the most in the product is the UI.
The problem with the UI is that it is not complex for understanding, but it needs some training to know what each button does, how it works, and the many variables needed.
I have been working with Oracle Database In-Memory for more than ten years.
I confirm that Oracle Database In-Memory is stable, which means there are no glitches or issues.
Oracle Database In-Memory is quite a scalable product.
The technical support from Oracle is very good.
Positive
The installation and deployment of Oracle Database In-Memory are not straightforward; it has a lot of configurations, but it is not hard to learn. If you are doing it a lot of times, you will learn how to avoid many complications during the installation. However, I am not able to say it is complicated; it is not complicated, but it is not easy either.
The biggest challenge I may face when installing it is managing a lot of configurations.
I do not have any other product that does the same as Oracle Database In-Memory; however, I have worked with other vendors like PostgreSQL, MongoDB, and DB2, but I am not using other databases or in-memory database solutions.
As a service provider, my overall experience with Oracle Database In-Memory is rated at nine points out of ten.
The first thing I should remember when advising people who are looking to use Oracle Database In-Memory is to know the amount of data that needs to be processed, as Oracle Database In-Memory can process a huge number of data and support a huge number of transactions in seconds or milliseconds. If you do not need it, do not use it.
I rate my overall review experience at eight points out of ten.
We are working on Oracle Database In-Memory and Oracle Database Vault. We have implemented this.
In our organization, we have a development team with different in-house applications, and they build scripts and other things that we deploy. They recently gave us the requirement to use Oracle Database In-Memory, so we recently started implementing it.
I cannot provide information regarding the best features of Oracle Database In-Memory.
We receive requirements about the features they need with Oracle Database In-Memory, or they ask us to research and provide solutions. We determine if it's better to use a new feature of Oracle or if it can be accomplished using existing features in the database we are using.
I currently don't know how Oracle Database In-Memory has benefited my organization. We recently received this query from our high management to use this In-Memory function, so we are currently in progress to use this new feature.
We faced challenges with our database which is around seven to nine TB in size. It was very difficult to move data from on-site to cloud in one attempt at the start, because we didn't have sufficient bandwidth to copy the data files to the cloud.
We have recently deployed our database on cloud with Oracle Database In-Memory. We have a single standby on cloud. On contingency occasions, we switch over to cloud and use it for four to five months.
I rate the technical support of Oracle an eight or nine out of ten.
Positive
It took days to implement Oracle Database In-Memory because we have a size of seven to eight TB. We didn't have a good quality connection, so it took additional time.
We used chunk and transportable tablespaces. When we established a better connection, we used Data Guard. We built the Data Guard on the cloud side and started with the RMAN duplicate.
We have a group of five people involved in the process of implementing Oracle Database In-Memory. One is my senior, and I work with my two juniors.
I do not see any return on investment or any cost reductions after implementing it.
The pricing for Oracle Database In-Memory is more affordable.
I am not using Oracle Database's Dual-Format Architecture yet.
I am not using Oracle Database In-Memory compression technologies yet.
I rate Oracle Database In-Memory eight out of ten.


We use Oracle Database In-Memory to deploy applications for commercial purposes, store data securely, and ensure efficient data processing.
Oracle Database In-Memory has improved data storage and processing efficiency, which is crucial for handling large amounts of data in our products and commerce operations.
We find the dashboard and the speed of data processing very valuable in Oracle Database In-Memory.
Oracle Database In-Memory is more expensive than Azure, and the support from the Oracle team is not very good, especially since they do not have a support team in our region.
We have been using Oracle Database In-Memory for about five to seven years.
Oracle Database In-Memory is very stable. I would rate its stability as nine out of ten.
Oracle Database In-Memory is highly scalable. I would rate its scalability as nine.
Oracle's support is not satisfactory. They do not have a support team in our region, making it difficult to get timely assistance.
Neutral
We used a third-party company to implement the Oracle Database in memory.
Oracle Database In-Memory is very expensive. Additionally, there are extra costs for some features.
I highly recommend Oracle Database In-Memory to other companies.

I use the solution as it is a major part of my applications. My core banking systems are Oracle-based, mostly. The analytics part of the core banking systems is also Oracle-based.
The most valuable features of the solution stem from Oracle Real Application Clusters. Oracle Real Application Clusters help our company deal with the missing two-node or three-node clusters. The product helps divide the workload into three nodes, which increases the performance of the tool for more than 5,000 to 7,000 users, who are simultaneously connected to the database. Oracle Real Application Clusters gives users multiple nodes, which helps balance the use of load.
The high cost of the product is an area of concern where improvements are required.
The installation process of the product is not straightforward, making it an area where improvements are required. If I get freshers to install the product, they may face hassles. There is a need to have an expert person to install the product. DB2 is a solution that anyone can install.
I have been using Oracle Database In-Memory for seventeen years.
Stability-wise, I rate the solution a nine out of ten.
The product offers high scalability. There is a huge cost involved if I need to scale up.
Around 10 people in my company use the product.
The product is regularly used in my company and can be considered as the heart of the operations.
There is no need to increase the usage of the product because we mainly use the tool in our company to support the application. The people on my team can administer the database.
Firstly, a user should prepare the operating system for installation, and then we have to copy the software to install the product. When dealing with scenarios related to Oracle Real Application Clusters, users need to add nodes and storage. The setup process is a little bit complex compared to DB2. The setup process of Oracle Database In-Memory takes around five to six hours to install Oracle Real Application Clusters, if everything is okay, apart from which the other processes will take a day.
The solution is deployed on an on-premises model. The cloud-based solution is available for testing and development, and it need not be installed in your environment. A user just needs to do a few clicks and select the database, after which it automatically gets installed in the cloud. Only in the on-premises version of the product, there is a need to do some work in the tool.
Support from a consultant is always good because sometimes the company's in-house teams forget what the recommendations are and other things when it comes to the product. Consultants can give users an idea of what needs to be done for the betterment of the performance of the product.
In terms of ROI, I don't get to see returns after ten or eleven years since I have to keep paying the support cost attached to the license of the product. From a business and performance perspective, the product's ROI is good. I can say that the product offers an 80 percent ROI.
The cost of the product is high.
There is a need to make a yearly payment towards the licensing costs, after which there is any to pay towards the support cost attached to the solution.
I have not evaluated other products against Oracle Database In-Memory.
The solution improves the data analytics processes as it helps to meet the requirements of a database. To meet the recommendation of the company to have an Oracle-based product, we use Oracle Database In-Memory. The resources in our organization are mostly Oracle-based products. For bigger environments, I prefer Oracle because it allows me to have access to trained resources in the market. Due to the aforementioned aspects, Oracle works for me.
The tool supports our organization's OLAP and OLTP workloads. My organization is a bank with 900 branches, and all of them are connected simultaneously. Considering the aforementioned scenario, most of the user activities were through the database. Large user bases are supported by Oracle and are much better than DB2.
The columnar data storage format of the product is not used in our company's system. The inbuilt capability of the product was used in our company with regards to the storage part, but for the software part, my company does not use columnar data storage format.
In most cases, a database is required by the application. It is not me who personally but the applications that require a database. In general, database requirements come from the application, and for such scenarios, I recommend others to go with Oracle as other databases may not be good enough, especially if the applications require only databases from Oracle. If the applications require DB2, then users should opt for DB2. My recommendation cannot be considered as a valid one, especially if we consider the requirements that may vary for applications. If there is a need to support terabytes of data, the database from Oracle is useful. The performance capability of Oracle is much better than DB2.
The In-Memory Advisor is helpful, especially after the installation processes are done and the operation part is running. If any performance issues arise, the In-Memory Advisor helps users to find out the information as to what is the root cause of the problem and to explain what should be done.
Whenever there is only a single node, my company faces a lot of password issues since there are many users. The company has to scale up to two nodes. The load balancing aspect is managed with the help of two nodes, so it is easily scalable. Though the steps are a bit complex, the product is very much scalable. The performance had increased by almost 200 percent when my company had added the second node.
I rate the overall tool a nine out of ten.
I am using Oracle Database In-Memory while working with airlines. The application is outstanding in batch processing at the airport.
I find the performance features of Oracle Database In-Memory to be most beneficial. The system's performance is in milliseconds which is impressive. The dual format architecture impacts our data processing positively. I also see a financial benefit as the system performs efficiently. These features improve our operational efficiency.
The dashboard requires some refreshment or configuration improvements. Also, the pricing could be addressed.
I have been using Oracle Database In-Memory for approximately two years.
I rate the stability of Oracle Database In-Memory as nine out of ten, indicating it is quite stable.
I rate scalability as seven out of ten. There is room for improvement in terms of scalability.
I rate customer service and support as nine out of ten. They are quite good.
Positive
I switched from Oracle Enterprise to Oracle Database In-Memory due to performance reasons.
Our DBAs handled the deployment. It wasn't complex, so I assume the initial setup was manageable.
There is a team of four to five DBAs involved in maintenance.
The deployment was carried out by one engineer.
I rate the product nine out of ten overall.

The primary purpose of Oracle Database In-Memory is to optimize database performance. It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity.
The automated aspect of this solution is highly valuable, and its current effective performance meets our needs satisfactorily.
While it has the potential for significant benefits, it seems that some manual intervention or guidance may be necessary for it to fully realize its advantages. We haven't fully experienced its complete benefits yet.
I have been working with it for three years.
It's extremely stable, and I'm optimistic that it will remain open and adaptable in the future. I would rate it nine out of ten.
It offers excellent scalability capabilities, especially for organizations with several thousand users. It follows a centralized architecture rather than a distributed one.
I would rate technical support at a seven because we've encountered instances where certain aspects weren't explained clearly. We often have to find solutions on our own through the support site, so there's room for improvement in this regard.
Neutral
It can work entirely automatically, but it's not currently realizing its full potential in terms of performance.
Similar to other databases we currently have, the deployment time depends on the database size. Typically, it takes just a couple of hours. First, we determine the hardware specifications, create the database, and then proceed with data import. This process typically involves around three individuals.
We experienced an 80% return on investment.
It's quite costly and it comes with a fixed price. It is not a good fit for smaller businesses.
I would recommend this solution to larger companies that have specific requirements and can benefit from it. It's a highly effective product.
Our company has the whole banking solutions. As part of the banking solutions, we offer the bank solution. The underlying infrastructure is Oracle Database In-Memory.
Some customers look for other ERP or CRM solutions. Our application team offers these solutions. We use Oracle Database In-Memory for all of our databases.
Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads.
Oracle Database In-Memory appliance-based solutions can be restrictive for some applications, as they may require more flexibility in the database design to be tuned and sized to the customer's needs. Likewise, the solution’s pricing could be improved.
I have used Oracle Database In-Memory as a reseller for 10-12 years. I'm part of the solution team providing both in memory and the databases. We are using the latest version of the solution.
The product is stable. I rate the solution's stability a nine out of ten.
We can cater the solution to every type of business. I rate the solution's scalability an eight-point four out of ten.
Sometimes, getting the proper perspective on the solution is challenging. The product doesn't have any issues, but fine-tuning can be done. We need to change those parameters and other things. These changes may already be in our repository of solutions, but sometimes, it can be challenging to find them.
Neutral
I rate the initial setup an eight out of ten, where one is complex, and ten is easy.
The solution's pricing is high. I rate the solution's pricing an eight out of ten, where one is cheap and ten is expensive.
Overall, I rate the solution a nine out of ten.
We use the solution for analytical purposes because it makes it faster to analyze processes. In-Memory also helps with reporting. My first project using the solution was for the government, and we deployed the solution on the cloud.
I like Oracle because it is a backward-compatible solution. When I changed from an In-Memory database to a non-In-Memory database, all I had to do was configure and restart. I did not have to change the coding at all. But it takes a bit more time to transform from non-In-Memory into In-Memory when using a MySQL server.
It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory.
I rate Database In-Memory's stability an eight out of ten.
In-Memory's scalability is okay because it's focused on big databases. Scalability is a focus when used on a NoSQL database. When we use In-Memory in the Oracle database, which is an MDBMS, scalability is not a concern. The solution is only for enterprise-level customers.
I don't like tech support from Oracle. I've been with Oracle since 1992, and I've seen the quality of support decrease.
The initial setup is very simple, and that's why I like it. It's fairly transparent. There is nothing to change about the coding. The customer may not even realize an engine exists in the database except during downtime.
I rate the pricing a zero out of ten because Database In-Memory is too costly.
The best competitor for Oracle is Microsoft. But Microsoft is much harder than Oracle to scale.
After accessing the In-Memory database, we usually have some downtime. That's acceptable to me, but if they can eliminate that, it would be good. The downtime is needed now to change the allocated memory in Oracle. If you use a data block, the downtime lasts minutes.
Oracle provides Exadata for customers, and that's very good because usually another cloud is not provided to them.
I rate the solution a ten out of ten.
When I compare solutions like In-Memory to FOSS 3.0, FOSS 3.0 has more features. But if you add all those features to one person, they are incompatible. Compatibility is an important thing, but many people just skip it.
Our company uses the solution to create relational databases. We use both public and private clouds.
The solution has a simplicity that makes it very easy to use.
The scalability is very good.
The solution should move to the new way of writing software code with AI that is intelligent and learns.
I have been using the solution for 15 years.
The solution is very scalable and that is the feature we like most.
I rate scalability a nine out of ten.
The technical support could be improved. I don't recall specifics, but know that I expect more from them.
Sometimes, support doesn't understand the environment of a business so they give irrelevant solutions. That is the biggest problem with support.
I rate support a seven out of ten.
Neutral
The setup is pretty straightforward and easy so I rate setup a nine out of ten.
We implemented the solution in-house and it did not take long to deploy.
The pricing is pretty good so I rate it an eight out of ten.
Before choosing the solution, evaluate the on-premises, public, and private cloud environments. Speak with a representative about what environment best meets your needs.
In the public cloud arena, Azure and AWS also offer good products that compete with the solution.
I rate the solution a seven because there are better public cloud options.