Try our new research platform with insights from 80,000+ expert users

Oracle Database In-Memory pros and cons

Vendor: Oracle

4.4 out of 5

32 reviews
100% willing to recommend

Pros & Cons summary

Oracle Database In-Memory offers fast caching and performance, enhancing real-time analytics and transactions with fewer CPU needs, high scalability, and low latency crucial for sectors like risk management. Although costly, it lacks advanced query optimization, automatic partition management, and integration with other tools. It bypasses disk storage, optimizing hardware performance, yet technical support and scalability for large databases require improvement, along with minimizing downtime during data transfers.

Buyer's Guide

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

Prominent pros & cons

PROS

Oracle Database In-Memory accelerates query processing, which speeds up operations and enhances productivity.

It efficiently handles low-code data and supports fast read-and-write operations with high scalability.

Oracle Database In-Memory integrates with various data sources, facilitating seamless data processing.

Valuable features include bypassing disk storage for faster memory operations, crucial for transactions and analytics.

Oracle Database In-Memory offers excellent performance optimization within hardware environments, maximizing ROI.

CONS

Oracle Database In-Memory is considered expensive and many users suggest pricing improvements to make it more reasonable.

Users express the need for automated features to load and monitor partitions in-memory, reducing reliance on scripts and schedules.

Technical support is below expectations and could be improved, with some users needing to find solutions independently through the support site.

Greater integration with other tools and systems is desired to enhance Oracle Database In-Memory’s functionality.

Users have noted the lack of scalability for large databases and suggest improvements in this area.

Oracle Database In-Memory Pros review quotes

Senior System Analyst at Thakral

Feb 9, 2024

The product offers high scalability.

Read full review

MD

Mohammad Dastpak

Database Administrator at a energy/utilities company

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

Oracle ACE, DBA at Goodus,inc

Oct 13, 2020

The application development is very user-friendly.

Read full review

Oracle Database In-Memory

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: August 2025.

865,295 professionals have used our research since 2012.

PY

PramudyaYanuanto

IT Consultant at a computer software company with 1,001-5,000 employees

Jul 10, 2023

I like Oracle because it is a backward-compatible solution.

Read full review

DB Architect / Consultant at Virtusa Global

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

Database Administrator at a government with 10,001+ employees

Oct 5, 2023

It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity.

Read full review

RU

Ravi Upadhyayula

Senior Consultant at Tata Consultancy

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

Assistant Consultant at Tata Consultancy

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

Priyank Shrivastava

Sr Quality Engineer at Optum

Dec 14, 2022

The scalability is very good.

Read full review

Technical Leader at European Commission

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

Senior System Analyst at Thakral

Feb 9, 2024

The high cost of the product is an area of concern where improvements are required.

Read full review

MD

Mohammad Dastpak

Database Administrator at a energy/utilities company

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

Oracle ACE, DBA at Goodus,inc

Oct 13, 2020

The pricing could be improved. It would ideal if it was more reasonable.

Read full review

Oracle Database In-Memory

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: August 2025.

865,295 professionals have used our research since 2012.

PY

PramudyaYanuanto

IT Consultant at a computer software company with 1,001-5,000 employees

Jul 10, 2023

It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory.

Read full review

DB Architect / Consultant at Virtusa Global

Mar 26, 2025

Oracle Database In-Memory could improve by better supporting generative AI challenges, such as hallucination management.

Read full review

Database Administrator at a government with 10,001+ employees

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

Ravi Upadhyayula

Senior Consultant at Tata Consultancy

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

Assistant Consultant at Tata Consultancy

May 8, 2022

The query optimization and backup features should be added.

Read full review

PS

Priyank Shrivastava

Sr Quality Engineer at Optum

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

Technical Leader at European Commission

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

SQL Server vs Oracle Database In-Memory

Teradata vs Oracle Database In-Memory

MySQL vs Oracle Database In-Memory

SAP HANA vs Oracle Database In-Memory

MariaDB vs Oracle Database In-Memory

IBM Db2 Database vs Oracle Database In-Memory

SQLite vs Oracle Database In-Memory

LocalDB vs Oracle Database In-Memory

IBM Informix vs Oracle Database In-Memory

SAP IQ vs Oracle Database In-Memory

Tibero vs Oracle Database In-Memory

SAP Adaptive Server Enterprise vs Oracle Database In-Memory

DuckDB vs Oracle Database In-Memory

Exasol Data Warehouse vs Oracle Database In-Memory

Apache Derby vs Oracle Database In-Memory

See all alternatives

Product Categories

Product Categories

Embedded Database

Relational Databases Tools

Popular Comparisons

Popular Comparisons

SQL Server vs Oracle Database In-Memory

Teradata vs Oracle Database In-Memory

MySQL vs Oracle Database In-Memory

SAP HANA vs Oracle Database In-Memory

MariaDB vs Oracle Database In-Memory

IBM Db2 Database vs Oracle Database In-Memory

SQLite vs Oracle Database In-Memory

LocalDB vs Oracle Database In-Memory

IBM Informix vs Oracle Database In-Memory

SAP IQ vs Oracle Database In-Memory

Tibero vs Oracle Database In-Memory

SAP Adaptive Server Enterprise vs Oracle Database In-Memory

DuckDB vs Oracle Database In-Memory

Exasol Data Warehouse vs Oracle Database In-Memory

Apache Derby vs Oracle Database In-Memory

See all alternatives

Related questions

26

What would be the best application SQL optimizer over the WAN?

6

When evaluating Embedded Database Software, what aspect do you think is the most important to look for?

40

What exactly can one do with embedded Oracle Database?

11

Why is Embedded Database Software important for companies?