Try our new research platform with insights from 80,000+ expert users
Anand-Shah - PeerSpot reviewer
Software Architect at Iskraemeco
Real User
Top 5Leaderboard
Has a valuable transaction feature and good technical support services
Pros and Cons
  • "It efficiently handles low-code data and supports read-and-write operations for clustering."
  • "The product could be more economical."

What is our primary use case?

We stream and exchange data with multiple partners and vendors using the product.

What is most valuable?

Oracle Database In-Memory has a valuable transaction feature. It efficiently handles low-code data and supports read-and-write operations for clustering.

What needs improvement?

The product could be more economical. It is much on the higher side than other databases. Additionally, they should include OLTP functionality.

For how long have I used the solution?

We have been using Oracle Database In-Memory for ten years.

Buyer's Guide
Oracle Database In-Memory
May 2025
Learn what your peers think about Oracle Database In-Memory. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
856,873 professionals have used our research since 2012.

What do I think about the stability of the solution?

It is a stable platform. I rate its stability a ten out of ten.

What do I think about the scalability of the solution?

There were 5000 Oracle Database In-Memory users in my previous company. I rate the product's scalability a ten out of ten.

How are customer service and support?

The technical support services are good.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup is easier for the cloud version. I rate the process a ten out of ten.

What's my experience with pricing, setup cost, and licensing?

The product is expensive. However, it provides quality features. There is room for improvement, considering other options. I rate the pricing a ten out of ten.

Which other solutions did I evaluate?

We evaluated different providers. We went to Oracle Database In-Memory for better transaction size and volume.

What other advice do I have?

I rate Oracle Database In-Memory a ten out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1859013 - PeerSpot reviewer
BI manager at a computer software company with 10,001+ employees
Real User
Top 20
Highly stable and manages database memory using various methods
Pros and Cons
  • "The solution's ROI is excellent."
  • "They should improve the solution's scalability for large databases."

What is our primary use case?

We use the solution for improving database reporting that previously took long hours.

What is most valuable?

The solution's most valuable feature is its ability to manage database memory using various methods.

What needs improvement?

They should improve the solution's scalability for large databases. Also, they should frequently update the on-premises version.

For how long have I used the solution?

We have been using the solution for two years.

What do I think about the stability of the solution?

The solution is highly stable. I rate its stability as a nine.

What do I think about the scalability of the solution?

It is a scalable solution. We have 2,000 customers and 35,000 end users of the solution. Also, we plan to increase the number of users.

How are customer service and support?

The solution's technical support team is responsive. But it could respond faster to complex issues.

How was the initial setup?

The solution's initial setup process is fast and easy. It takes less than an hour to complete. However, implementing and testing it in a different environment takes more time.

What about the implementation team?

The solution requires four executives for deployment and maintenance. We test the solution's new version in a lower environment for deployment. Later, we release it in our production environment.

What was our ROI?

The solution's ROI is excellent.

What other advice do I have?

I recommend the solution to others and rate it as a nine.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Buyer's Guide
Oracle Database In-Memory
May 2025
Learn what your peers think about Oracle Database In-Memory. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
856,873 professionals have used our research since 2012.
Amit Rajora - PeerSpot reviewer
Assistant Consultant at Tata Consultancy
Real User
Top 5
On-premises solution provides security for BFSIs and banking systems
Pros and Cons
  • "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."
  • "The query optimization and backup features should be added."

What is our primary use case?

We work as consultants, so we provide the solution to customers. It's deployed on-premises.

We write the queries using SQL Developer, and we do the synchronization.

We're using Oracle 10g and 11g.

What needs improvement?

The query optimization and backup features should be added.

For how long have I used the solution?

I've been using this solution for more than eight years.

What do I think about the stability of the solution?

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.

We do maintenance frequently. Every weekend, the admin team has to do some patches and some upgrade activity on the servers. So, maintenance is needed to stay up-to-date.

What do I think about the scalability of the solution?

Since we aren't using this as a SaaS, if we move to cloud, we can go for scalability easily. The on-premise solution is scalable. It's also good for cost reduction. If the client is looking for some cost reduction, it is not possible with the on-premise version, so it's better to go for SaaS or cloud.

What's my experience with pricing, setup cost, and licensing?

There are no costs in addition to the standard licensing fees.

What other advice do I have?

I would rate this solution 8 out of 10.

For someone with small architecture and a small volume of data, they can go for the cloud services. If they have a huge volume or some security perspective like BFSI data and a banking system, they should definitely go for the on-premise solution.

If we go for any BFSI or some banking or card solution, we can easily see that most of the companies are working with the on-premise solution only. They aren't considering the cloud solution to be secure. In terms of security, they are going for the on-premise version because everything is in their hands only.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
GM & CTO (In charge) at CCBL
Real User
Top 20
Helps to handle fast transactions with low latency
Pros and Cons
  • "We use the tool for real-time data transfer for risk management purposes. In a trading system, conversions happen fast. We use the product to handle fast transactions with low latency."
  • "I would like Oracle Database In-Memory to include a data replication feature."

What is our primary use case?

We use the tool for real-time data transfer for risk management purposes. In a trading system, conversions happen fast. We use the product to handle fast transactions with low latency. 

What needs improvement?

I would like Oracle Database In-Memory to include a data replication feature. 

For how long have I used the solution?

I have been working with the solution since 2005. 

What do I think about the stability of the solution?

Oracle Database In-Memory is very stable. 

What do I think about the scalability of the solution?

I would rate the product's scalability a nine out of ten. 

How was the initial setup?

Oracle Database In-Memory's setup takes six months to complete. You need 10-15 resources to handle the deployment of the whole system. 

What's my experience with pricing, setup cost, and licensing?

Oracle Database In-Memory is expensive. 

What other advice do I have?

I would rate the solution a ten out of ten. If you do not have high-frequency transactions, then Oracle Database In-Memory is not for you. You would require Oracle Database In-Memory for mission critical high-frequency transactions. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Paresh-Nayak - PeerSpot reviewer
Enterprise Data Architect at Link Group (LNK), Digital Solutions
Real User
Fast, reliable solution that zeroes data loss
Pros and Cons
  • "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."
  • "Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."

What is our primary use case?

I mainly use this solution for business analytics and intelligence.

What is most valuable?

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. Another valuable feature is that we can zero data loss with this solution because there is no data loss when there is a loss of power or the RAM crashes, as with traditional databases.

What needs improvement?

In the next release, Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster.

For how long have I used the solution?

I've been using Database In-Memory for two to three years.

What do I think about the stability of the solution?

Database In-Memory is reliable, performs very well, and requires very little maintenance.

What do I think about the scalability of the solution?

This solution is easy to scale.

How are customer service and support?

Oracle's technical support is very good.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup was simple.

What about the implementation team?

We used an in-house team along with some documentation and help from Oracle's website.

What's my experience with pricing, setup cost, and licensing?

Database In-Memory is priced a bit higher than its competitors like Microsoft. The Enterprise edition has no additional costs, the in-memory features come included.

What other advice do I have?

I would rate Database In-Memory nine out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Oracle ACE, DBA at Goodus,inc
Real User
User friendly with a good interface but very expensive
Pros and Cons
  • "The application development is very user-friendly."
  • "The pricing could be improved. It would ideal if it was more reasonable."

What is our primary use case?

We primarily use the solution as an email database.

What is most valuable?

Overall, it's a very good solution.

The application development is very user-friendly. 

The SQL is great in Oracle. If you use other databases, you often have to find another syntax and develop in other languages.

The user interface is great.

What needs improvement?

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

The design isn't that great. It's kind-of buggy and doesn't seem to cater to the Korean market.

There seems to be issues relating to migration. It's difficult to migrate off of it if you need to.

For how long have I used the solution?

I've probably been using the solution for about a decade. It's been about ten years now.

What do I think about the stability of the solution?

The stability has caused us some issues. We've dealt with bugs in the past. It's not flawless.

What do I think about the scalability of the solution?

The scalability is pretty decent. We've had clients that have scaled in the past, however, they didn't use Oracle to do so. That said, I believe it scales.

How are customer service and technical support?

We don't have contract-level technical support. In the past, we've used MOS support at oracle.com. It was just for a service request. They utilize more of an open-source system and it relies on open-source technical knowledge. It would be more helpful if Oracle could directly answer our queries. However, that's just not the case.

Which solution did I use previously and why did I switch?

We've found another similar solution called Ignite that we are looking at implementing.

How was the initial setup?

The initial setup is pretty straightforward. It's nearly always a cloud environment, which makes things fairly easy. Everything is already set up for the most part. Companies that want to utilize In-Memory just need to work with the existing cloud infrastructure.

What's my experience with pricing, setup cost, and licensing?

The product is quite expensive. Organizations should be prepared for a rather high price tag. Our clients may end up moving to an open-source option to lower costs.

What other advice do I have?

We're Oracle partners. We've been partners with Oracle for a long time.

Our IT department first changed from on-premises to cloud. Our clients seem to like a hybrid deployment model. Now they are considering looking for other solutions that may not be as expensive or may even be open-source.

I'm not really a database expert. My understanding is that some customers want to make a product from the portal website using the In-Memory DB. Others tend to want to migrate from an Oracle In-Memory database to another email database. It's difficult when users want to migrate off of Oracle or simply to another Oracle solution. They tend to run into a lot of issues. Personally, this solution wouldn't be my top choice, as it makes things difficult.

There are a lot of alternative email database solutions. I'd just advise other companies to take a look at the options to see which would work best for their use case.

That said, while we migrated to another solution, it's still a pretty good tool, and issues just seem to arise if you are migrating. 

Overall, I'd rate the solution seven out of ten. If the pricing was more reasonable, and the migration was easier, I'd rate it higher. 

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Database Administrator at a energy/utilities company
Real User
Easy to deploy and has good performance
Pros and Cons
  • "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."
  • "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."

What is our primary use case?

My solution has a big database with terabytes of data and we use Database In-Memory for a lot of our data. Normally, we partition it and create big tables, but we can use In-Memory for data that we use every day or every hour. We put some partitions in In-Memory from some tables and we use that. It normally has good performance.

What is most valuable?

Normally, every database server uses hard disks. In-Memory has a feature, apart from its 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 tablespace from that spot to share. It's a really good feature. We use it a lot.

What needs improvement?

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 the last partitions on the table. We always need to create a script and make a schedule that can load the last partition 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.

For how long have I used the solution?

I have been using this version for about four months.

What do I think about the stability of the solution?

We have used this feature for four months and it's stable. I used to load one terabyte of data in my memory servers each time. I think it worked okay. I don't have any problem for now.

How are customer service and technical support?

I live in Iran. Iran is sanctioned by the US government so Oracle can't provide any services to us. I study on my own. I use Oracle documentation and watch YouTube videos. I don't have any company to support us.

How was the initial setup?

It is very easy to deploy. I always work in Linux, Oracle Linux. If you want to work from the GNOME GUI, it's really simple. You must state a parameter in Linux and then use their installer. Click next, next, next, then finish. It's simple. In Oracle 80 and 90, we have an installation system in a common UI. It's very simple. You must have the prerequisites and after that, install RPM in just one comment. Check your configuration and set up the database. It's simple.

Deployment in the GUI version, if you want to use that, is I think 14 to 20 minutes. In the command line, it would take 10 to 15 minutes. I can't remember exactly, but something close to that.

What other advice do I have?

Oracle is the best database, but I love open-source software. Oracle always has the first original features for three or four years and we use them because they are stable and we can buy in a large scale and use it for our office. It has no problems. I think Oracle is ten out of ten.

About Oracle Database In-Memory, in particular, I would rate it as eight out of ten. It's a new feature. I think it's improved from the last version three years ago.

Oracle's new features and data are very useful for us for storing data, loading it, etc. Oracle features based on processes are good. In Oracle, we just have four functions based on data types, but in post-production, we have more than ten functions. That is very useful for us. We'll add more functions and features like index and categorization based on data type, output, and large data. That would be very useful.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Independent Consultant at Unaikui
Real User
Top 5Leaderboard
Has a simple setup process and efficient features for columnar storage
Pros and Cons
  • "We can integrate it with any data sources as well."
  • "The platform’s pricing needs improvement."

What is our primary use case?

We use Oracle Database In-Memory for reporting and analytics.

What is most valuable?

The platform's most valuable features are query response time, columnar storage, and data cube setup.

What needs improvement?

The platform’s pricing needs improvement.

What do I think about the stability of the solution?

The platform is stable. I rate the stability a nine out of ten.

What do I think about the scalability of the solution?

We have more than 50 Oracle Database In-Memory users in our organization. While occasional usage may increase, the technical infrastructure effectively manages these fluctuations. It demonstrates negligible impact on performance, even with incremental user growth. I rate the scalability a nine out of ten.

How are customer service and support?

We have received technical support for reported bugs, and the team promptly releases patches.

Which solution did I use previously and why did I switch?

Earlier, we utilized the Oracle Database Appliance for data warehousing purposes. Additionally, we relied on SQL databases, particularly older versions managed by Oracle as well as the old SAP DB. However, we transitioned to Oracle Database In-Memory to address the specific needs of our environment, particularly in scenarios where we needed to report data across distributed sites efficiently.

How was the initial setup?

The initial setup process is simple.

What other advice do I have?

The platform provides the best performance in terms of database analytics. It efficiently serves as a data lake. We can integrate it with any data sources as well.

I recommend it to others and rate it a ten out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free Oracle Database In-Memory Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2025
Buyer's Guide
Download our free Oracle Database In-Memory Report and get advice and tips from experienced pros sharing their opinions.