We performed a comparison between Oracle Database and Oracle Database In-Memory based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."One of the most valuable aspects of Oracle Database is the maturity of the solution."
"It's extremely easy to use and the performance is great."
"The solution has an endless capacity."
"The most valuable feature of Oracle Database is all the functionalities. When we write a code we sometimes have to create an explicit functionality to process the data that we want. At times we find that there is already existing functionality in data created by Oracle itself, it is helpful."
"The solution is definitely very good for our consultancy on payroll and human resource."
"I love the performance tuning feature of Oracle Database because it provides hints and indexing, which are very valuable. Some of its other valuable features are its rack, record key vaults, and backup compression."
"I like the query part and the optimization of the query to get the data. I also like its speedy recovery and stability. In the security part, the loss of data is minimal for any crashes that could happen. First of all, it might not occur, or if it happens, the recovery of the data is smoother than others."
"The solution is very easy to use in general."
"The scalability is very good."
"The solution's ROI is excellent."
"We can integrate it with any data sources as well."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"The product offers high scalability."
"I like Oracle because it is a backward-compatible solution."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"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."
"Oracle Database could be improved by adding more automation."
"The main issue with Oracle is the maintenance required."
"As of now, Oracle is branded to Oracle only, the option of migrating to other databases is not available."
"We don't really find that any features are lacking."
"Its security is good, but it could be more secure."
"The licensing model is complicated and could be improved."
"Even if you have backup discs and never use Data Guard, you still have to pay for a license for it."
"The licensing could be cheaper and clearer."
"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."
"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."
"Oracle Database In-Memory appliance-based solutions can be restrictive for some applications, as they may require more flexibility in the database design to be tuned and sized to the customer's needs."
"The platform’s pricing needs improvement."
"Technical support is below our expectations currently. It could be improved."
"We often have to find solutions on our own through the support site, so there's room for improvement in this regard."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"The high cost of the product is an area of concern where improvements are required."
Oracle Database is ranked 2nd in Relational Databases Tools with 278 reviews while Oracle Database In-Memory is ranked 8th in Relational Databases Tools with 27 reviews. Oracle Database is rated 8.6, while Oracle Database In-Memory is rated 8.8. The top reviewer of Oracle Database writes "Supports a large volume of transactions compared to other databases". On the other hand, the top reviewer of Oracle Database In-Memory writes "User friendly with great scalability but needs to move toward intelligent AI". Oracle Database is most compared with SAP HANA, SQL Server, MariaDB, IBM Db2 Database and Amazon Aurora, whereas Oracle Database In-Memory is most compared with SAP HANA, Progress OpenEdge RDBMS, IBM Db2 Database, SQL Server and MariaDB. See our Oracle Database vs. Oracle Database In-Memory report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.