Try our new research platform with insights from 80,000+ expert users
Oracle Database In-Memory Logo

Oracle Database In-Memory pros and cons

Vendor: Oracle
4.4 out of 5
Badge Leader
648 followers
Start review

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Oracle Database In-Memory enhances performance for real-time analytics and mixed workloads by accelerating query processing and streamlining workflows.
It provides fast caching and improved performance by utilizing fewer CPUs, making it more consistent and faster than traditional databases.
The scalability is excellent, supporting large amounts of data with high efficiency.
The solution is highly valued for its performance optimization within hardware environments, offering a strong return on investment.
Its ability to bypass disk storage for faster memory operations is critical for fast transactions and analytics.

CONS

Oracle Database In-Memory is expensive and customers believe pricing could be more reasonable.
There is a lack of features to automatically load partitions, which requires manual scripting.
Technical support does not meet expectations and needs improvement.
The integration with other tools is insufficient and scalability for large databases could be enhanced.
Oracle Database In-Memory could improve its capabilities in generative AI and data replication features.
 

Oracle Database In-Memory Pros review quotes

Md Al-Amin - PeerSpot reviewer
Feb 9, 2024
The product offers high scalability.
MD
Dec 9, 2019
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.
JS
Oct 13, 2020
The application development is very user-friendly.
Learn what your peers think about Oracle Database In-Memory. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
845,406 professionals have used our research since 2012.
PY
Jul 10, 2023
I like Oracle because it is a backward-compatible solution.
Laksiri Bala - PeerSpot reviewer
Mar 26, 2025
The valuable features of Oracle Database In-Memory include its capability to bypass disk storage for faster memory operations, which is critical for transactions and analytics.
Jelena Bandic - PeerSpot reviewer
Oct 5, 2023
It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity.
RU
Sep 28, 2023
Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads.
Amit Rajora - PeerSpot reviewer
May 8, 2022
The on-premise version is stable. We have different teams and resources for the server side, for admin, and for development. We can easily take care of all the services and applications.
PS
Dec 14, 2022
The scalability is very good.
it_user1209981 - PeerSpot reviewer
Jan 19, 2020
The scalability of the solution is very good. It's able to support large amounts of data.
 

Oracle Database In-Memory Cons review quotes

Md Al-Amin - PeerSpot reviewer
Feb 9, 2024
The high cost of the product is an area of concern where improvements are required.
MD
Dec 9, 2019
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.
JS
Oct 13, 2020
The pricing could be improved. It would ideal if it was more reasonable.
Learn what your peers think about Oracle Database In-Memory. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
845,406 professionals have used our research since 2012.
PY
Jul 10, 2023
It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory.
Laksiri Bala - PeerSpot reviewer
Mar 26, 2025
Oracle Database In-Memory could improve by better supporting generative AI challenges, such as hallucination management.
Jelena Bandic - PeerSpot reviewer
Oct 5, 2023
We often have to find solutions on our own through the support site, so there's room for improvement in this regard.
RU
Sep 28, 2023
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.
Amit Rajora - PeerSpot reviewer
May 8, 2022
The query optimization and backup features should be added.
PS
Dec 14, 2022
The solution should move to the new way of writing software code with AI that is intelligent and learns.
it_user1209981 - PeerSpot reviewer
Jan 19, 2020
Technical support is below our expectations currently. It could be improved.