We use the solution for analytical purposes because it makes it faster to analyze processes. In-Memory also helps with reporting. My first project using the solution was for the government, and we deployed the solution on the cloud.
I like Oracle because it is a backward-compatible solution. When I changed from an In-Memory database to a non-In-Memory database, all I had to do was configure and restart. I did not have to change the coding at all. But it takes a bit more time to transform from non-In-Memory into In-Memory when using a MySQL server.
It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory.
I've used Oracle Database In-Memory since 2019.
I rate Database In-Memory's stability an eight out of ten.
In-Memory's scalability is okay because it's focused on big databases. Scalability is a focus when used on a NoSQL database. When we use In-Memory in the Oracle database, which is an MDBMS, scalability is not a concern. The solution is only for enterprise-level customers.
I don't like tech support from Oracle. I've been with Oracle since 1992, and I've seen the quality of support decrease.
The initial setup is very simple, and that's why I like it. It's fairly transparent. There is nothing to change about the coding. The customer may not even realize an engine exists in the database except during downtime.
I rate the pricing a zero out of ten because Database In-Memory is too costly.
The best competitor for Oracle is Microsoft. But Microsoft is much harder than Oracle to scale.
After accessing the In-Memory database, we usually have some downtime. That's acceptable to me, but if they can eliminate that, it would be good. The downtime is needed now to change the allocated memory in Oracle. If you use a data block, the downtime lasts minutes.
Oracle provides Exadata for customers, and that's very good because usually another cloud is not provided to them.
I rate the solution a ten out of ten.
When I compare solutions like In-Memory to FOSS 3.0, FOSS 3.0 has more features. But if you add all those features to one person, they are incompatible. Compatibility is an important thing, but many people just skip it.