Oracle Database In-Memory Room for Improvement

PS
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 »
Jelena Bandic - PeerSpot reviewer
Database Administrator at a government with 10,001+ employees

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 »
Yossi Belitasky - PeerSpot reviewer
BI manager at Clarivate Analytics

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
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.

View full review »
Md Al-Amin - PeerSpot reviewer
Senior System Analyst at Thakral

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.

View full review »
PY
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 »
Amit Rajora - PeerSpot reviewer
Assistant Consultant at Tata Consultancy

The query optimization and backup features should be added.

View full review »
Anand-Shah - PeerSpot reviewer
Software Architect at Iskraemeco

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
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
GM & CTO (In charge) at CCBL

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

View full review »
it_user521652 - PeerSpot reviewer
Senior Oracle Consultant at a retailer with 1,001-5,000 employees

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 »
Paresh-Nayak - PeerSpot reviewer
Enterprise Data Architect at Link Group (LNK), Digital Solutions

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 »
it_user452352 - PeerSpot reviewer
Strategic Solutions Architect at OnX Enterprise Solutions

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
Solution Architect at ixtel

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

The solution is quite expensive.

View full review »
it_user522219 - PeerSpot reviewer
IT Director at a manufacturing company with 1,001-5,000 employees

Nothing right now.

View full review »
it_user521976 - PeerSpot reviewer
Sr Architect at a insurance company with 1,001-5,000 employees

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
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 »
it_user436422 - PeerSpot reviewer
Owner - Consultant at a tech services company with 51-200 employees

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

View full review »
JS
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 »
it_user521634 - PeerSpot reviewer
PeopleSoft Infrastructure & Operations Manager at City & County of San Francisco

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
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. 

View full review »
it_user1209981 - PeerSpot reviewer
Technical Leader at European Commission

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 »
it_user522027 - PeerSpot reviewer
Project Director at a university with 1,001-5,000 employees

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.

View full review »
PN
Oracle Cloud Infra Architect at Sterlite Technologies Ltd

They should lower the price. My customers think that it's too expensive. 

View full review »
it_user119625 - PeerSpot reviewer
Director at a tech vendor with 10,001+ employees

We are waiting for new features in the next release.

View full review »
it_user436134 - PeerSpot reviewer
Database Consultant at a financial services firm with 1,001-5,000 employees

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.