No more typing reviews! Try our Samantha, our new voice AI agent.

Oracle Database In-Memory pros and cons

Vendor: Oracle

4.4 out of 5

33 reviews
100% willing to recommend

Pros & Cons summary

Oracle Database In-Memory offers backward compatibility and high scalability, optimizing performance with query acceleration and real-time analytics. Its advanced memory operations enhance transaction efficiency and reduce CPU needs. Data compression aids resource management in cloud setups. While effective, it faces challenges with high costs, insufficient support, and limited database design flexibility. Improving query optimization and reducing downtime in format transitions would enhance its usability for diverse environments.

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 offers backward compatibility and high scalability, making it suitable for diverse environments and large datasets.

The performance optimization within hardware environments enhances productivity by accelerating query processing, thus improving workflow efficiency.

Oracle Database In-Memory efficiently handles real-time analytics and low-code data while supporting read-and-write operations for clustering, crucial for fast transactions with low latency.

Its capability to bypass disk storage for faster memory operations is critical for transactions and analytics, providing faster and more consistent database performance with fewer CPU requirements.

Data compression features save significant storage space, benefiting overall system resource management and efficiency, particularly in cloud deployments with single standby and contingency operations.

CONS

Oracle Database In-Memory could benefit from reduced downtime when transitioning from non-In-Memory formats.

Users find the platform to be expensive with a need for more economical pricing and licensing options.

Technical support is often insufficient and could be improved for better usability.

There is a need for improved flexibility in database design to suit diverse user requirements.

Improved query optimization and backup features are essential for enhanced functionality.

Oracle Database In-Memory Pros review quotes

Owner - Consultant at a tech services company with 51-200 employees

Aug 1, 2017

Combined with Exadata, it makes a solution that will deliver the best performance related to the volume of data.

Read full review

Database Consultant at a financial services firm with 1,001-5,000 employees

May 5, 2016

The most valuable feature of Database In-Memory is that it's really fast.

Read full review

Strategic Solutions Architect at OnX Enterprise Solutions

May 31, 2016

Database In-Memory, to me, is the most compelling reason to go to Oracle 12c, release 1.

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: March 2026.

885,311 professionals have used our research since 2012.

PeopleSoft Infrastructure & Operations Manager at City & County of San Francisco

Jan 10, 2017

I cannot imagine IT today without Oracle databases.

Read full review

Senior Oracle Consultant at a retailer with 1,001-5,000 employees

Apr 4, 2017

After we started using the in-memory product, we saw really dramatic figures.

Read full review

Sr Architect at a insurance company with 1,001-5,000 employees

Dec 4, 2016

I've been an Oracle customer with different companies, and one of the key things that stands out for Oracle is the support, because I also work with other database vendors and that's the biggest differentiator.

Read full review

Project Director at a university with 1,001-5,000 employees

Nov 28, 2016

The Oracle database is easier to program and manage, and is secure.

Read full review

MK

Senior Database Consultant at Performing Databases

Aug 8, 2019

We are using Oracle Database In-Memory as an indirect approach to improving response times, and 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.

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

SG

Solution Architect at ixtel

Dec 23, 2019

The solution is very fast.

Read full review

Show 10 more reviews (out of 30)

Oracle Database In-Memory Cons review quotes

Owner - Consultant at a tech services company with 51-200 employees

Aug 1, 2017

Technical support is useful with the My Oracle Support website. But when I have to open a service request, I have to find a solution on my own because technical support usually doesn't understand my problem or they always ask for the same logs, same questions, and I ultimately waste my time.

Read full review

Database Consultant at a financial services firm with 1,001-5,000 employees

May 5, 2016

It's good and it functions, but it's not the easiest add-on to Database to work with.

Read full review

Strategic Solutions Architect at OnX Enterprise Solutions

May 31, 2016

Multitenant, to be honest, is a little adolescent at this point.

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: March 2026.

885,311 professionals have used our research since 2012.

PeopleSoft Infrastructure & Operations Manager at City & County of San Francisco

Jan 10, 2017

You need to have platinum service to get good support. Otherwise, you'll have to struggle a bit.

Read full review

Senior Oracle Consultant at a retailer with 1,001-5,000 employees

Apr 4, 2017

For some reason, the stats optimizer doesn't work well. We had to disable some of the Oracle’s new features that are not quite mature.

Read full review

Sr Architect at a insurance company with 1,001-5,000 employees

Dec 4, 2016

Especially, if you have large data, then it's not very efficient.

Read full review

Project Director at a university with 1,001-5,000 employees

Nov 28, 2016

Additionally, once we put data into Oracle, it's very hard to move it out to another solution, so we have to stay with Oracle.

Read full review

MK

Senior Database Consultant at Performing Databases

Aug 8, 2019

"It depends". If you get a good support engineer, it is a dream. But, most times, it is not, unfortunately.

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

SG

Solution Architect at ixtel

Dec 23, 2019

The solution is quite expensive.

Read full review

Show 10 more reviews (out of 30)

Product Categories

Product Categories

Embedded Database

Relational Databases Tools

Popular Comparisons

Popular Comparisons

Teradata vs Oracle Database In-Memory

SQL Server vs Oracle Database In-Memory

MySQL vs Oracle Database In-Memory

Oracle Database 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

CockroachDB vs Oracle Database In-Memory

SQLite vs Oracle Database In-Memory

SAP IQ vs Oracle Database In-Memory

IBM Informix vs Oracle Database In-Memory

LocalDB vs Oracle Database In-Memory

Tibero vs Oracle Database In-Memory

Oracle Berkeley DB vs Oracle Database In-Memory

Exasol Data Warehouse vs Oracle Database In-Memory

See all alternatives

Product Categories

Product Categories

Embedded Database

Relational Databases Tools

Popular Comparisons

Popular Comparisons

Teradata vs Oracle Database In-Memory

SQL Server vs Oracle Database In-Memory

MySQL vs Oracle Database In-Memory

Oracle Database 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

CockroachDB vs Oracle Database In-Memory

SQLite vs Oracle Database In-Memory

SAP IQ vs Oracle Database In-Memory

IBM Informix vs Oracle Database In-Memory

LocalDB vs Oracle Database In-Memory

Tibero vs Oracle Database In-Memory

Oracle Berkeley DB vs Oracle Database In-Memory

Exasol Data Warehouse vs Oracle Database In-Memory

See all alternatives

Related questions

108

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

18

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

55

What exactly can one do with embedded Oracle Database?

29

Why is Embedded Database Software important for companies?