Try our new research platform with insights from 80,000+ expert users
reviewer2270901 - PeerSpot reviewer
Team Lead - Oracle Technologies at a financial services firm with 5,001-10,000 employees
Consultant
Top 20
Reliable platform with a straightforward setup process
Pros and Cons
  • "The solution's most valuable feature is its performance optimization within our hardware environment."
  • "The product could benefit from enhancements in its graphical user interface."

What is our primary use case?

Our primary use case for the solution is within our on-premises environment. We do not utilize cloud services and rely on local hardware for our operations.

What is most valuable?

The solution's most valuable feature is its performance optimization within our hardware environment. This capability enhances processing speed, which is crucial for our operations, although the improvements are more hardware-dependent.

What needs improvement?

The product could benefit from enhancements in its graphical user interface.

For how long have I used the solution?

I have been using Oracle Database In-Memory for approximately 25 to 30 years.

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

What do I think about the stability of the solution?

I rate the product stability an eight. 

What do I think about the scalability of the solution?

I rate the product scalability an eight out of ten. 

How was the initial setup?

The initial setup was relatively straightforward.

What about the implementation team?

Oracle's local support team efficiently managed the deployment process, ensuring a smooth implementation.

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

The platform's licensing cost needs improvement. 

Which other solutions did I evaluate?

We selected the product due to its stability, security features, and ability to handle replication with minimal downtime.

What other advice do I have?

The platform is reliable and effective within our setup. However, potential users should be aware of the high costs and evaluate whether the benefits justify the investment.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Oracle Database In-Memory
February 2025
Learn what your peers think about Oracle Database In-Memory. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,713 professionals have used our research since 2012.
Solution Architect at ixtel
MSP
Simple to implement, very fast, and easily scalable
Pros and Cons
  • "The solution is very fast."
  • "The solution is quite expensive."

What is our primary use case?

We primarily use the solution as a warehouse. In the front end we are using MicroStrategy, and we are using Oracle as a database.

What is most valuable?

The warehouse is the solution's most valuable aspect.

The solution is very fast.

What needs improvement?

I'm not sure about the improvements needed in the solution.

The solution is quite expensive.

For how long have I used the solution?

I've been using the solution for two years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

The solution is scalable. Almost everyone in the company uses the solution.

How are customer service and technical support?

The solution's technical support is good.

How was the initial setup?

I did not install it myself, but the database administration team did, and they found it simple. In one day they were able to administrate the data stack file.

What about the implementation team?

Our team handled the implementation.

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

Oracle is a costly product.

Which other solutions did I evaluate?

Choosing this solution was the choice of the database administrator. I didn't participate in the process, so I'm not sure what was used before of if other solutions were evaluated.

What other advice do I have?

We use the on-premises deployment model.

I'd advise others to look at the solution, but to be mindful as it is costly. Whether it is right for a company or not depends on the requirements. If they have the budget, they should go for Oracle. If they do not, I'd suggest they look at something open-source like MySQL or Oracle SQL.

I'd rate the solution nine out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
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
PeerSpot user
Owner - Consultant at a tech services company with 51-200 employees
Consultant
Combined with Exadata, it makes a solution that will deliver the best performance related to the volume of data.

What is most valuable?

Oracle has a lot of features embedded. In my opinion, Oracle In-Memory offers a lot of improvements in database performance specially for data warehouses and analytics workloads. Combined with Exadata, it makes a solution that will deliver the best performance related to the volume of data.

As I’m very involved in database security, I can tell say that Advanced Security Option and Database Vault are most valuable features for me because I can propose them to my customers to deliver the best security options for their databases.

How has it helped my organization?

Each time I've implemented the In-Memory option, the improvements have been on the performance side. This option offers a way to drastically reduce batch duration with a minimum of work because we only need to enable it on columns we choose, test batch performance, and that’s it. We can do this cycle of work less than 10 times and the job is completed.

What needs improvement?

They need to improve the Decision Support System with analytics workloads.

For how long have I used the solution?

I've used Oracle Database since 2001, and I officially used the In-Memory option since its general availability in June 2014. But, as I’ve been a beta tester for the Oracle version that delivered this option, I can say that I've used it since the beginning of 2014.

What was my experience with deployment of the solution?

There have been no issues deploying it.

What do I think about the stability of the solution?

The product is stable. Of course, at this level of software, there are always some bugs. But, each time I have had to implement it, the bugs weren’t very problematic and I've always found a patch or a workaround.

What do I think about the scalability of the solution?

It scales to the needs of my customers.

How are customer service and technical support?

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.

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

I tested the In-Memory equivalent in DB2 or SQL Server 2014, but they both have limitations in their uses. SAP HANA is one of the most concurrent of Oracle’s solution, but I have never used it.

How was the initial setup?

The deployment was very easy because we just have to set a volume of memory as the In-Memory area, and the enable In-Memory for specific columns. This part is longer, but for me, it’s more a tuning issue than a deployment issue. Deploying Oracle In-Memory is very easy and takes only a few minutes.

What other advice do I have?

Implementing Oracle In-Memory is very easy, but the tuning phase is mandatory to optimize it.

Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
PeerSpot user
it_user522219 - PeerSpot reviewer
IT Director at a manufacturing company with 1,001-5,000 employees
Real User
It scales really well.​​​

What is most valuable?

Performance. That's probably the number one.

When we use it for OLTP, which is the Online Transaction Processing, the response for the end-user is pretty fast, which is a good thing, especially if the user is looking at a website, the response time is really micro milliseconds as opposed to waiting a few seconds for that page to load.

How has it helped my organization?

I think it still goes back to the user benefiting the most out of this, it's basically a good customer experience, the product.

What needs improvement?

Nothing right now.

What do I think about the stability of the solution?

It is pretty stable.

What do I think about the scalability of the solution?

It scales really well.

We had to scale it along with the rest of the ecosystem, not just this in particular, but the infrastructure as well. We had to scale both of them.

How are customer service and technical support?

We had to involve them just because we ran into a couple of issues and they've been resolved in a timely manner. Pretty good.

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

No, we always needed something like this, and I've looked at Microsoft, they have a similar solution, I think they have something similar,

How was the initial setup?

It's pretty straight-forward. It's actually more of an inbuilt core functionality as opposed to have us to go through an implementation process.

Which other solutions did I evaluate?

We did evaluate a few other vendors, but again this wasn't a product on it's own. It's part of the bigger ecosystem. So the decisions are for other reasons.

What other advice do I have?

Try it out first. See if it meets your expectations and go from there.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521976 - PeerSpot reviewer
Sr Architect at a insurance company with 1,001-5,000 employees
Vendor
We meet our SLAs because of the performance and speed. I can call support anytime.

What is most valuable?

The most valuable features are the performance and speed.

How has it helped my organization?

The key thing for us is that we can meet our customer SLAs because of the performance and the response time we get.

The second thing is, personally, being a database person, I like Oracle Database In-Memory because of the backing of the support. If something goes wrong, I can call support anytime. That's one of the key reasons.

What needs improvement?

A lot of new technologies have been coming in to the market in recent years. For example, SPARC, and other analytics languages. Most of the legacy databases don’t have that good connections or connectors to those. It's still a challenge to efficiently use them. I don't know about small data, but we have large data. Especially, if you have a large data, then it's not very efficient. We don't have the tweaks to buffer it or stream it properly. Those are the kinds of things I think could be done.

What do I think about the stability of the solution?

Stability has been pretty OK. There have been some issues. Support was able to help us out with some configuration.

What do I think about the scalability of the solution?

It scales well for our needs.

How is customer service and technical support?

I've been an Oracle customer with different companies. I’ve worked with them for almost 10 years now. One of the key things that stands out for Oracle is the support, because I also work with other database vendors. That's the biggest differentiator. Even if I have some issue when I get up at 1 AM, I know I can call on support and I know I'll be able to get my problem solved.

Which other solutions did I evaluate?

We looked at other vendors before we started using this product, but because we were already an Oracle customer, using their database, it made sense to be in Oracle In-Memory.

What other advice do I have?

I suggest looking mostly at the interfaces; that is the key. Even if the performance is good, but the interfaces are not right, to the application or to the front end, that could be an issue.

We’re really happy with Oracle Database In-Memory.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521634 - PeerSpot reviewer
PeopleSoft Infrastructure & Operations Manager at City & County of San Francisco
Vendor
It is a stable, scalable solution that the vendor supports well if you pay for that support.

What is most valuable?

I cannot imagine IT today without Oracle databases. Oracle has basically delivered their data revolution with relational databases and their constant development and innovation going into the cloud.

What needs improvement?

They are coming up with more improvements than we actually want. If you ask most of the customers, they are happy with what they had 10 or 20 years back. The company has a need to make more money or beat the competition, so they constantly come up with these new features. They say these are cool features to have, but I don’t think they are needs. We don't need all the upgrades, practically speaking.

However, I am interested in the analytics of the data that is used for new research. Customers do need some of that information.

For how long have I used the solution?

I have used this solution for 15 or 16 years.

What do I think about the stability of the solution?

This is a very stable solution. You always have kinks with any solution, but they have awesome support, depending upon how much money you pay them. You need to have platinum service to get good support. Otherwise, you'll have to struggle a bit.

What do I think about the scalability of the solution?

The scalability is good, of course. Oracle is known for its scalability.

How is customer service and technical support?

We have different levels of support. What makes the difference is how persistent you are. If you demonstrate that you have a lot at stake, then you will get good support. If you are very casual, then you will get slack support. This is the case with anybody.

How was the initial setup?

The installations and upgrades are complex. It's a complicated, complex product, so you definitely need technology experts. You can’t just pick up anybody from the street, like a new graduate, to do this work. You definitely need inside help. You need expertise because this is complex technology. You're talking about Data Guard, which is a complex technology. You do need experts for help.

What other advice do I have?

We are going to be an Oracle shop for a long, long time.

When looking for a vendor, I look for expertise, how quickly they can roll out the product, and the cost of implementation.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user