Oracle Database In-Memory Room for Improvement
PS
Priyank Shrivastava
Sr Quality Engineer at Optum
The solution should move to the new way of writing software code with AI that is intelligent and learns.
View full review »While it has the potential for significant benefits, it seems that some manual intervention or guidance may be necessary for it to fully realize its advantages. We haven't fully experienced its complete benefits yet.
View full review »They should improve the solution's scalability for large databases. Also, they should frequently update the on-premises version.
View full review »Buyer's Guide
Embedded Database
March 2024
Find out what your peers are saying about Oracle, SAP, Progress Software and others in Embedded Database. Updated: March 2024.
765,386 professionals have used our research since 2012.
RU
Ravi Upadhyayula
Senior Consultant at Tata Consultancy
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. Likewise, the solution’s pricing could be improved.
The high cost of the product is an area of concern where improvements are required.
The installation process of the product is not straightforward, making it an area where improvements are required. If I get freshers to install the product, they may face hassles. There is a need to have an expert person to install the product. DB2 is a solution that anyone can install.
PY
PramudyaYanuanto
IT Consultant at a computer software company with 1,001-5,000 employees
It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory.
View full review »The query optimization and backup features should be added.
The product could be more economical. It is much on the higher side than other databases. Additionally, they should include OLTP functionality.
View full review »MK
Martin Klier
Senior Database Consultant at Performing Databases
One very nice side-effect is the in-memory index. If this would be developed a bit more into being configurable, users could use it as a kind of in-memory partitioning. That opens a big field of possible use cases.
View full review »IH
Imam HOSSAIN
GM & CTO (In charge) at CCBL
I would like Oracle Database In-Memory to include a data replication feature.
View full review »For some reason, the stats optimizer doesn't work well. We actually disabled some of these features, such as the optimizer adaptive features. On the fly, the optimizer actually changes the explained plan, and that feature is really not working fine. We had to disable that.
The plans were actually not stable when we enabled it, so we had to disable it. We had to lock the stats on some of the master tables, because the plan instability is the actual problem. We don't want the plan instability, and we saw that quite often. We had to disable some of the Oracle’s new features that are not quite mature. That’s one of the problems that we have seen.
View full review »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.
View full review »The In-Memory database features are probably going to double in capacity and in power in the upcoming release; also, with pluggable and container databases. They're going to become much more flexible. Most of this is already public knowledge. I'm just not discussing details at this point.
The one feature that I'd like to see more emphasis on is security because as we move towards the Oracle Public Cloud, it's here already. The biggest concern and we heard this in many of the talks here at Collaborate 16 this week, but also among my clients and customers is, is it secure. That's an excellent question and the answer is it absolutely is. It's absolutely secure because you can't not encrypt. You must encrypt your data when it's placed inside the Oracle Public Cloud. Now the wonderful thing about that is that you hold the private key; the private key part of the private key infrastructure and public key infrastructure, so there is no way that a government agency, for example, could come to you and go, "I want all this data." All that they would get would be the encrypted files. That may not necessarily be true in other cloud implementations. I'll leave it at that.
View full review »SG
SumitGadgilwar
Solution Architect at ixtel
I'm not sure about the improvements needed in the solution.
The solution is quite expensive.
View full review »Nothing right now.
View full review »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.
View full review »MD
Mohammad Dastpak
Database Administrator at a energy/utilities company
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.
View full review »They need to improve the Decision Support System with analytics workloads.
View full review »JS
JongGun Shin
Oracle ACE, DBA at Goodus,inc
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.
View full review »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.
View full review »NT
Nima Taheri
CEO & Board member at Barsa Novin Ray
The solution would be better if we could use modeling rather than coding, which is the only option currently available. I'd also like to see more integration with other tools.
The solution could benefit from AI improvements.
Technical support could be improved.
The usability of the solution could be better. They should make it easier in terms of system administration and for getting examples of statistics from the databases. An interface or dashboard for statistics would be better. Right now, we're using cloud controls to do that, but it's not good enough.
View full review »Oracle is a large company that is constantly purchasing other companies to add functionality. I think that if I want a new feature, Oracle will not listen to just me. They are marketing to a large market and not just myself.
Oracle occupies the main space in the database market. Additionally, once we put data into Oracle, it's very hard to move it out to another solution, so we have to stay with Oracle. Also, while Oracle is expensive and MySQL is free, MySQL is more difficult to use.
PN
Paresh Nayak
Oracle Cloud Infra Architect at Sterlite Technologies Ltd
They should lower the price. My customers think that it's too expensive.
View full review »We are waiting for new features in the next release.
View full review »It's good and it functions, but it's not the easiest add-on to Database to work with. It's still new, so hopefully it'll be improved in later versions.
View full review »Buyer's Guide
Embedded Database
March 2024
Find out what your peers are saying about Oracle, SAP, Progress Software and others in Embedded Database. Updated: March 2024.
765,386 professionals have used our research since 2012.