2016-05-31T10:27:00Z

What needs improvement with Oracle Database as a Service?

Julia Miller - PeerSpot reviewer
  • 0
  • 36
PeerSpot user
33

33 Answers

Goce Starkovski - PeerSpot reviewer
Real User
Top 10
2023-09-25T14:15:25Z
Sep 25, 2023

The installation process requires improvement as it can be quite complex. Simplifying the procedure would certainly be beneficial. There is room for enhancing the administration tools, possibly by providing better separation of functions.

Search for a product comparison
ES
Real User
Top 20
2023-09-22T09:22:00Z
Sep 22, 2023

The solution’s price could be reduced.

Roberto Huaman - PeerSpot reviewer
Real User
Top 10
2023-05-11T18:15:00Z
May 11, 2023

It's a very expensive product. So, the pricing needs to be improved. Big data use cases involving analytics, especially advanced analytics like machine learning, I need to improve in Oracle.

SW
Real User
Top 5Leaderboard
2023-04-21T08:54:58Z
Apr 21, 2023

There is room for improvement in the speed of the data migration process.

Vipul Saxena - PeerSpot reviewer
Real User
Top 5
2023-03-10T08:49:18Z
Mar 10, 2023

One area for improvement would be the ability to connect to Excel directly from the database. Currently, I am unable to do this with Oracle Database as a Service, whereas I am able to do so with SQL Server. I would like to see Oracle Database as a Service offer a similar service to what SQL Server provides in terms of connecting Excel to the database. In the next release, I would like to see a feature that allows for easy transfer of data from MySQL to other databases, such as SQL Server. Having this capability would provide developers with more flexibility in their coding.

Brian Imambaks - PeerSpot reviewer
Real User
Top 5
2023-03-09T22:00:44Z
Mar 9, 2023

The area in this solution that could be improved is that currently, it's difficult to do the setup. You need to do all kinds of command lines to get it set up. If that setup becomes easier and easily manageable, that would be great. In the next release, I'd like to see a simpler connection between Oracle and other databases like SQL, MySQL, or a DB tool. I'd also like to see a simpler way to pull data from those external databases. This would add value to Oracle in my opinion.

Learn what your peers think about Oracle Database as a Service. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
763,955 professionals have used our research since 2012.
CS
Real User
Top 5
2023-03-09T21:58:26Z
Mar 9, 2023

They should add more integration to the solution.

Guruprasad Gonjare - PeerSpot reviewer
Real User
Top 5
2023-03-09T21:58:00Z
Mar 9, 2023

I would like to see improvements in the license cost. The solution is subscription-based for PaaS services. You need to buy your own authorized license.

ET
Real User
Top 5
2023-02-20T09:41:52Z
Feb 20, 2023

I'm a rookie at the moment. I still need to learn the solution. It's hard to discuss what is needed when you are still learning. For many companies, the standard version is not enough. They need to move to the enterprise version. However, there is a large price jump between the two. A company needs to have skilled people on its team in order to really take advantage of the solution. I'm not sure about the ADF lifecycle.

Csaba Molnar - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-02-16T10:19:00Z
Feb 16, 2023

I would like the tool to improve the setup because it is complex.

Daniel_Nemethy - PeerSpot reviewer
Real User
Top 5
2023-02-13T20:29:00Z
Feb 13, 2023

I would like to improve the stability of the Oracle database.

BaidyTHIONGANE - PeerSpot reviewer
Real User
Top 5
2023-02-13T20:28:19Z
Feb 13, 2023

The solution's pricing could be less expensive.

DZ
Real User
Top 5
2023-01-25T16:43:25Z
Jan 25, 2023

Oracle Database as a Service is a good product but costly. The licensing costs for it should be reduced because it's expensive. The license fee for Oracle Database is more costly than my product license.

Ayman Sayed - PeerSpot reviewer
Real User
Top 20
2023-01-06T14:33:34Z
Jan 6, 2023

Debugging this solution is challenging.

Uriel Juárez - PeerSpot reviewer
Real User
Top 10
2023-01-05T20:23:41Z
Jan 5, 2023

Oracle Database as a Service could improve by having ETL for larger data.

SL
Real User
Top 20
2022-11-28T22:24:29Z
Nov 28, 2022

Oracle Database as a Service could improve the provisioning. You have to recreate on-premise hardware environments in the cloud, it was not very intuitive.

OT
Real User
Top 10
2022-11-17T20:11:00Z
Nov 17, 2022

There is room for improvement in PL/SQL. It is not user-friendly and it is hard to understand.

YA
Real User
Top 5
2022-10-27T10:19:43Z
Oct 27, 2022

The solution can be improved by reducing the pricing, making the deployment less complex, and increasing security.

LM
Real User
Top 5Leaderboard
2022-10-05T16:52:00Z
Oct 5, 2022

It is very hard to support Oracle Database.

GauravBatra - PeerSpot reviewer
Real User
Top 10
2022-09-13T13:50:46Z
Sep 13, 2022

In such a heavy product, there's always some level of improvement needed. On the cloud services, they need to improve some console-level items, including the logging of the databases on the console level.

Ahmad Hida - PeerSpot reviewer
Real User
Top 5
2022-08-08T12:42:53Z
Aug 8, 2022

The price of Oracle Database as a Service could be better.

WilmerRodriguez - PeerSpot reviewer
Reseller
Top 5
2022-08-02T18:53:00Z
Aug 2, 2022

The solution needs more certifications for other products and applications because migration to the cloud is difficult without them. The solution currently uses GoldenGate for disaster recovery plans and I'd like the option for a different database such as SQL Server, MySQL, or MariaDB.

OO
Reseller
2022-07-21T20:46:00Z
Jul 21, 2022

The solution uses a large amount of CPU space, which could be improved. We would also like to see a reduction in the licensing costs for using this solution, as it is quite costly.

SA
Real User
Top 10
2022-05-29T12:52:00Z
May 29, 2022

Earlier, the interface was continuously changing. Features you used would be moved somewhere else, so it was a little challenging to navigate, but now I think it's stable.

Guillermo Peña - PeerSpot reviewer
Real User
Top 20
2022-04-25T09:34:42Z
Apr 25, 2022

Although we do not need to set up our own indexes, because the solution internally improves the queries, when we migrate to a different instance, the internal machine learning is lost. The solution doesn't provide an option for migrating the index optimization to another instance.

MV
Reseller
2020-08-02T08:16:44Z
Aug 2, 2020

The licensing model is complicated and should be simplified. There are different prices that depend on hardware and other factors.

ST
Real User
2019-10-23T05:52:00Z
Oct 23, 2019

The improvements we require are mostly regarding the documentation and compatibility with other systems or with other non-Oracle technologies. Documentation is difficult to find. Since we're experienced with Oracle technology, we have also found many errors in it. Not everything is 100% accurate. The solution should add functionalities, like database system functions, to speed up the query processing type. Any sort of functions or commands that would give you a faster result would be a welcome improvement. Microsoft Azure, for example, has some building functionalities to fetch big chunks of data and in a very fast way. I haven't seen a similar feature from Oracle.

AA
Real User
2019-09-08T09:50:00Z
Sep 8, 2019

I don't believe that any product is a perfect solution. I believe that each product has some minor disadvantage about which customers need to be able ready to work with or workaround. It may not be the fault of the product but lack of compatibility, the preferences of the user or lack of knowledge of existing features. I think these can all be the case in not maximizing what Oracle already has. Because of my preference for and knowledge of Toad and the way I work with Oracle, I am not up to date on all of the tools included in this product. But I think if we have all of the features needed as developers already in the product, Oracle will be much better. For example, something very important for all developers that could already be available now in Oracle products is weighting the data. This is a very important technical concern for data centers. The code that developers use is built up in some instructions, so I need to understand how each instruction is executed and how the current state of the code or data application is affecting the transactions. I found that this type of analysis was difficult in Oracle itself, so I used another product — like Toad — that would give me the ability to debug all the code instruction by instruction to really understand what is going on. It's quite an important feature. If it is available in Oracle now it is not very good or well described. This is a problem that needs a solution. If it is already there and the vendor does not know about it or understand it, I think there is a big issue. The difference is that to get the most out of the technology, the developers really need to know about the new features and how to find and use them. This is something about Oracle that I think is not very good. Along with that idea, I think that Oracle might do a little bit improve their interface as it is not very user-friendly and I have heard other developers say similar things. I didn't use myself because it would not help me as much or as quickly as other products to develop functions and to develop other features like reporting. I would have to learn a whole different way.

OM
Consultant
2019-08-11T06:26:00Z
Aug 11, 2019

The direct scaling is a feature that has room for improvement. I would like to see virtual management machines that can scale storage well with zero downtime. The backup option and patching would then be much easier to do. I would also like to implement CDI with Database as a Service. There is also room for improvement with regards to scalability and availability. The maintenance is also an issue. When Oracle does maintenance, you need to be prepared because everything will be down.

ME
Real User
Top 10
2019-07-28T07:34:00Z
Jul 28, 2019

When we troubleshoot, there are many tools that we need to use. One example is having to look at the system logs. The troubleshooting process should be improved so that we can resolve errors faster. Oracle demands a lot of memory and you need to have a strong machine. In the next release, I would like to see a framework for memory management.

Ahmad Hida - PeerSpot reviewer
Real User
Top 5
2019-07-18T11:31:00Z
Jul 18, 2019

Some of the technical features could be improved. They have a problem with some of the object types. I think this is one of the issues which is needed to be improved. If they could implement a managing tool that is better than the one they have now, that would be an improvement.

it_user622242 - PeerSpot reviewer
Real User
2018-05-15T06:35:00Z
May 15, 2018

I would like to see a better dashboard for the storage. It need to be more complete overall. At the moment, it is basic.

RN
Real User
2016-05-31T10:27:00Z
May 31, 2016

Features that people want the most are already there. One of them is Oracle In-Memory which allows you to put things in a columnar data store in memory with Oracle's 12c (12.1.0.2+). You could have an in-memory database. You could have columnar data, which is compressed and in-memory (in the in-memory column store) or if you're doing transactional data, it's in the buffer cache (memory) so it's very fast to do that transactions. It's a different memory area altogether. When I look at the cloud, you'll need In-Memory more, because you're going to be dealing with larger volumes of data. The second feature that helps is multi-tenancy; Oracle already has this as of 12c Release 1. It is the ability to clone and move things around and maybe do an exchange partition (PDB - Pluggable Database) with one of your vendors or one of your customers out there (given security needs are met). Non-PDBs (or not using multi-tenancy is being deprecated). Leveraging and testing new features of 12.2 is also beneficial. Oracle 18c will be beneficial with Snapshot Carousel, PDB switchover, In-Memory External Tables and Polymorphic Tables. I think the way that Oracle and other vendors can move people quicker to the cloud is by educating people on the capabilities of the cloud and some of the benefits of the cloud. I think as customers and vendors out there and partners of Oracle look at providing solutions for the cloud, I think people will be more likely to go there, but what I think right now is the biggest hesitancy is there are a lot of other cloud providers don't have any of the features Oracle has. Oracle must let people know that if you have on-site Exadata, now you can have Exadata in the cloud. Easy to move. You've got a lot of data you want to archive? You can move it to a slower, larger server or a faster, smaller server depending on what you want to do. Just the capabilities that they have in-house or in the cloud. Some cost more than others, so effective planning is one big key to success. The cloud is gaining momentum, but the key to success is evaluating it fully and using appropriately.

Oracle Database Cloud Service combines the power of Oracle Database, with the unique capabilities of the Oracle Cloud. The service provides a secure, automated data management platform that leverages on demand Oracle Cloud Infrastructure services via a simple web based user interface and RESTful API. Oracle Database Cloud Service provides elastic database services for development, test, and production environments of custom and packaged online transaction processing (OLTP), data warehousing,...
Download Oracle Database as a Service ReportRead more