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

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

MD
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.
SG
Solution Architect at ixtel
Dec 23, 2019
The solution is very fast.
it_user1209981 - PeerSpot reviewer
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.
Learn what your peers think about Oracle Database In-Memory. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
880,315 professionals have used our research since 2012.
PN
Oracle Cloud Infra Architect at Sterlite Technologies Ltd
Apr 5, 2020
The most valuable aspects of this solution are the fast caching and improved performance to the database
JS
Oracle ACE, DBA at Goodus,inc
Oct 13, 2020
The application development is very user-friendly.
Paresh-Nayak - PeerSpot reviewer
Enterprise Data Architect at Link Group (LNK), Digital Solutions
Apr 27, 2022
The most valuable feature is that Database-In-Memory is more consistent and faster than traditional databases as it requires fewer CPUs to process instructions.
Amit Rajora - PeerSpot reviewer
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.
NT
CEO & Board member at Barsa Novin Ray
May 19, 2022
Security is the most valuable feature.
PS
Sr Quality Engineer at Optum
Dec 14, 2022
The scalability is very good.
YB
BI manager at Clarivate
Mar 30, 2023
The solution's ROI is excellent.
 

Oracle Database In-Memory Cons review quotes

MD
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.
SG
Solution Architect at ixtel
Dec 23, 2019
The solution is quite expensive.
it_user1209981 - PeerSpot reviewer
Technical Leader at European Commission
Jan 19, 2020
Technical support is below our expectations currently. It could be improved.
Learn what your peers think about Oracle Database In-Memory. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
880,315 professionals have used our research since 2012.
PN
Oracle Cloud Infra Architect at Sterlite Technologies Ltd
Apr 5, 2020
They should lower the price. My customers think that it's too expensive.
JS
Oracle ACE, DBA at Goodus,inc
Oct 13, 2020
The pricing could be improved. It would ideal if it was more reasonable.
Paresh-Nayak - PeerSpot reviewer
Enterprise Data Architect at Link Group (LNK), Digital Solutions
Apr 27, 2022
Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster.
Amit Rajora - PeerSpot reviewer
Assistant Consultant at Tata Consultancy
May 8, 2022
The query optimization and backup features should be added.
NT
CEO & Board member at Barsa Novin Ray
May 19, 2022
Lacks sufficient integration with other tools.
PS
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.
YB
BI manager at Clarivate
Mar 30, 2023
They should improve the solution's scalability for large databases.