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

Oracle Database In-Memory enhances performance by accelerating real-time analytics and supporting mixed workloads, efficiently handling large data with high scalability. It offers reduced CPU needs by loading data to memory and ensures data protection. Although users value its fast transactions and low latency, they also note high costs, manual partition management, insufficient tool integration, and technical support deficiencies. Appliance-based solutions and downtime during data transfers further limit flexibility and scalability.

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.
It accelerates query processing, improving operations and workflow efficiency.
The application supports large data scalability effectively.
Improved performance and fast caching within any hardware environment is notable.
Oracle Database In-Memory handles fast transactions with low latency for real-time data transfer.

CONS

Oracle Database In-Memory is considered expensive, leading to customer dissatisfaction regarding its pricing.
There is a lack of automatic features for loading the last partitions in In-Memory, requiring manual scripts and schedules.
Technical support does not meet expectations, with users needing to rely on self-service solutions through the support site.
Improvement is needed in Oracle's query optimization and backup features.
Oracle Database In-Memory does not sufficiently integrate with other tools, and scalability for large databases needs enhancement.
 

Oracle Database In-Memory Pros review quotes

Md Al-Amin - PeerSpot reviewer
Feb 9, 2024
The product offers high scalability.
Read full review
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.
Read full review
JS
Oct 13, 2020
The application development is very user-friendly.
Read full review
Buyer's Guide
Oracle Database In-Memory
March 2025
Free Report: Oracle Database In-Memory Reviews and More
Learn what your peers think about Oracle Database In-Memory. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
DOWNLOAD NOW
842,466 professionals have used our research since 2012.
PY
Jul 10, 2023
I like Oracle because it is a backward-compatible solution.
Read full review
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.
Read full review
Jelena Bandic - PeerSpot reviewer
Oct 5, 2023
It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity.
Read full review
RU
Sep 28, 2023
Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads.
Read full review
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.
Read full review
PS
Dec 14, 2022
The scalability is very good.
Read full review
it_user1209981 - PeerSpot reviewer
Jan 19, 2020
The scalability of the solution is very good. It's able to support large amounts of data.
Read full review
Show 10 more reviews (out of 21)
 

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.
Read full review
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.
Read full review
JS
Oct 13, 2020
The pricing could be improved. It would ideal if it was more reasonable.
Read full review
Buyer's Guide
Oracle Database In-Memory
March 2025
Free Report: Oracle Database In-Memory Reviews and More
Learn what your peers think about Oracle Database In-Memory. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
DOWNLOAD NOW
842,466 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.
Read full review
Laksiri Bala - PeerSpot reviewer
Mar 26, 2025
Oracle Database In-Memory could improve by better supporting generative AI challenges, such as hallucination management.
Read full review
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.
Read full review
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.
Read full review
Amit Rajora - PeerSpot reviewer
May 8, 2022
The query optimization and backup features should be added.
Read full review
PS
Dec 14, 2022
The solution should move to the new way of writing software code with AI that is intelligent and learns.
Read full review
it_user1209981 - PeerSpot reviewer
Jan 19, 2020
Technical support is below our expectations currently. It could be improved.
Read full review
Show 10 more reviews (out of 21)

Product Categories

Product Categories
Embedded Database
Relational Databases Tools

Popular Comparisons

Popular Comparisons
SAP HANA vs Oracle Database In-Memory Logo
SAP HANA vs Oracle Database In-Memory
IBM Informix vs Oracle Database In-Memory Logo
IBM Informix vs Oracle Database In-Memory
DuckDB vs Oracle Database In-Memory Logo
DuckDB vs Oracle Database In-Memory
Progress OpenEdge RDBMS vs Oracle Database In-Memory Logo
Progress OpenEdge RDBMS vs Oracle Database In-Memory
Druid vs Oracle Database In-Memory Logo
Druid vs Oracle Database In-Memory
InterSystems Caché vs Oracle Database In-Memory Logo
InterSystems Caché vs Oracle Database In-Memory
See all alternatives

Product Categories

Product Categories
Embedded Database
Relational Databases Tools

Popular Comparisons

Popular Comparisons
SAP HANA vs Oracle Database In-Memory Logo
SAP HANA vs Oracle Database In-Memory
IBM Informix vs Oracle Database In-Memory Logo
IBM Informix vs Oracle Database In-Memory
DuckDB vs Oracle Database In-Memory Logo
DuckDB vs Oracle Database In-Memory
Progress OpenEdge RDBMS vs Oracle Database In-Memory Logo
Progress OpenEdge RDBMS vs Oracle Database In-Memory
Druid vs Oracle Database In-Memory Logo
Druid vs Oracle Database In-Memory
InterSystems Caché vs Oracle Database In-Memory Logo
InterSystems Caché vs Oracle Database In-Memory
See all alternatives
Related questions
  • 7
What would be the best application SQL optimizer over the WAN?
  • 1
When evaluating Embedded Database Software, what aspect do you think is the most important to look for?
  • 45
What exactly can one do with embedded Oracle Database?
  • 3
Why is Embedded Database Software important for companies?