it_user452346 - PeerSpot reviewer
IT Manager with 501-1,000 employees
Video Review
MSP
We're looking forward to using it more to take our on-prem database backups to the cloud.

What is most valuable?

So from the database perspective, we usually are talking about three important things. So the obvious ones are the multitenancy in the pluggable databases. The second category, I would call it performance, making sure that we are getting the right value from the databases in terms of data access. And the third one is obviously the security. So, we are more interested in implementing solutions that, we are actually excited to see Oracle come in with release two with all the issues we have, from 11g and on. So, 12.1 is there, but we want to see what's coming up in 12c at release two, and we are really excited about multitenancy. The whole security aspect, and then the performance as such.

How has it helped my organization?

So from the cloud perspective, I think there are too many vendors out there. One of the things we are excited from the Oracle perspective is their ability to take us off of our backups, the database backup. Using that, they can take us to the cloud and we want to try that out, mostly on their test end, as of now. And once we see how the ROI is, and what kind of a performance we are getting and then also check on how the security is, then we might probably consider going a little bit deeper into low-level production applications, all the way into the business applications.

So right now we are evaluating their trial period with Oracle on migrating in their databases, and we are also excited to use some of their backup and recovery solutions, which basically, you take your database and you run your backups, right now it is running on your local disk, but then we are configuring that to go into the cloud. So one of the cool features we are using from Oracle is the RMAN. It takes a second set of channels, and just take it as a destination and that goes into the cloud. So we can restore it at the same time from either of the options, on-prem or from the cloud. So we are excited to see how that works, because that is something that Oracle has recently come up with.

What needs improvement?

So we want to see, obviously, besides Oracle databases, what other databases can be provisioned and integrated in the cloud. So if I have to have an application running off of a non-Oracle database, and I have an application and the database running in cloud, which is an Oracle, I want to see if I can integrate them through what kind of a web service, how can I transfer the data? How do I move my processes without having to come back into my on prem and then go back into the secondary cloud? So those are some of the integration points I'm looking at.

And the second important thing I'm looking at is, the overall governance. How Oracle can provide their cloud control and give use the ability to manage the on prem and the off prem cloud services, combined in a single view.

Which solution did I use previously and why did I switch?

So obviously we did an ROI analysis and a TCU. So, we have seen that the cost is definitely a factor. And security is more important, so that's why we did not press the button on the production yet. So we are piloting with the non-prod to see what kind of security we're going to get, what kind of threats are we going to be exposed to. And once we are satisfied, once we get our sign-off from the management, we might probably pull the trigger. But we are in the evaluation period.

Buyer's Guide
Oracle Database as a Service
April 2024
Learn what your peers think about Oracle Database as a Service. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,886 professionals have used our research since 2012.

What about the implementation team?

Onboarding: so the Database Cloud, the way we have seen is, so you have a cloud control and you go in and, based on your subscription, you actually get the environment. So once you get the environment, you generate the security keys to establish the network connectivity between the on prem to the public and once we have the provision done, then you can actually encrypt the data on the source side, and move them into the cloud through their cloud control utility. So that's how we migrate them. Now, we haven't done a lot of the big databases yet. So we are piloting on the small ones. So, so far, the pilot ones look good which are close to about 300 to 400 GB databases. But we want to see how that goes with couple of terabytes of databases.

Which other solutions did I evaluate?

Scalability is number one. Data transfer is number two. And security actually tops, on top of that. And the ability to move the workloads between on-prem and off-prem. So that's one of the big things you are looking at, and if we don't like things, and if you want to push back, and we want to come back to our on-prem, what options do we have? So, can we migrate easily from a public cloud to a private cloud and private cloud to an on-prem cloud, and vice-versa. So, having that ability is a big thing, because we don't want to invest in something where we go to the cloud but we don't know how to come back. So we don't want it to be a one-way street, we want to choose a product that can give us an opportunity to not only go into the cloud, but also in a worst-case scenario, come back out.

So initially we started with Amazon. We tested a little bit, but the security was a big thing for us and the way they handle security is a little different I don't necessarily say it is wrong or bad, it's just that I was not very comfortable having the keys being shared versus in Oracle, the security keys are owned by the customer which is us, as opposed to with the vendor, and that was a prime difference for us. And second thing was, Amazon cloud is more on the infrastructure provisioning and metered. They don't give a database as a service. They do have some options, but being an Oracle customer, we know what Oracle can provide, which is totally a value-add kind of a service, with a lot of different shaders, compared to the others like Amazon or Rackspace or a hundred different partners. But I think it's because we are very close with Oracle, we can see how they can give us those value add services.

What other advice do I have?

So the Database Cloud on Oracle right now, I think it's there, but there is some room to grow. So I wouldn't give them 10 yet. I would hold on to that. Probably eight would be a better option. But I want to see the growth in terms of, not only on the vertical side, I want to see the horizontal growth, in terms of how they can leverage, as I said earlier, integrating with other systems. So, if they can grow both horizontally and vertically, then probably I can give them a 10. But at this time, they are not there yet.

So I would say, anybody who wants to get into the cloud, evaluate your options. Check out your dev and test environments first. Check out your backup as a service, because it's very easy. You just have to set your targets and push your database backups. So try with those two first, and see the difference, and compare that with your other vendors. And see what kind of a response latency you're getting from the cloud. And make the call. I mean, that's what I did, and it was clear.

Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer: We're partners.
PeerSpot user
KopanoRamaphoi - PeerSpot reviewer
Consultant at Rpc Data
Real User
Top 10
Scalable with good analysis and diagnosis functionality
Pros and Cons
  • "If the solution is installed in your environment correctly, you are not going to have any issues whatsoever. It's problem-free."
  • "One of the things that I have noticed is that there are some services that will give you a hard time during implementation if you are looking at the documentation of Oracle. Sometimes the documentation information is quite limited. It's an aspect of the solution they could improve."

What is our primary use case?

We can use the product for so many things. For example, we can use it for integrating with different services, and as a middleware, using it to access the Oracle forms. I've used it with things like Enterprise Manager Cloud Control or Enterprise Manager.

What is most valuable?

Since I work as a database administrator, I like the way Oracle has Oracle database information. So it's quite easy for me to rectify issues pertaining to Oracle Database. Oracle has managed to allocate tools that can be used to analyze the problems when they arise. 

They've done tremendous work in terms of analysis and diagnosis. It's quite easy to use the database, provided you have managed to install it according to your Oracle standard. 

The solution has been very stable over the years.

We've found the solution to be quite scalable.

If the solution is installed in your environment correctly, you are not going to have any issues whatsoever. It's problem-free.

What needs improvement?

We've been very happy with the solution. I can't recall any missing features. It works well once it is installed correctly. If you install it incorrectly in your environment, you may run into issues.

One of the things that I have noticed is that there are some services that will give you a hard time during implementation if you are looking at the documentation of Oracle. Sometimes the documentation information is quite limited. It's an aspect of the solution they could improve.

For how long have I used the solution?

I've been using the solution for quite some time now. We've roughly been in production for more than five years now.

What do I think about the stability of the solution?

The solution is very, very stable. It doesn't crash or freeze. It's not buggy or glitchy. It's reliable and offers good performance.

What do I think about the scalability of the solution?

The solution is highly scalable. I did try both Autonomous Database and Data Warehouse on the cloud. On the cloud, there isn't much. You need to work a lot on the data side where ever you want, how you want your data to be presented. Things like BI are going to present your data. 

We support a huge number of users. The number of users Oracle can handle is amazing.

How are customer service and technical support?

Oracle technical support has always been very good. We have no complaints. They are helpful and responsive and we are satisfied with the level of support they provide to us.

If you have an Oracle Support Account, you shouldn't run into any issues at all.

How was the initial setup?

There really isn't an installation process for the solution. It's on the cloud.

What's my experience with pricing, setup cost, and licensing?

I don't directly deal with payments or licensing and therefore cannot directly speak to overall costs or licensing agreements. 

What other advice do I have?

We're just a customer and end-user and we help clients that are also using Oracle.

We're using an older version of the solution.

As an IT company, we provide services to different companies. Right now we are working on a project which is running on an older version, 11G. It's a government institute. However, we support a huge number of users.

I always recommend Oracle for my clients, to those who are interested in engaging technologies. I always encourage others to also take certification courses. Oracle has had free courses for the cloud, and I really advise those interested in the solution to get in on one.

In general, I would rate the solution at a nine out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Oracle Database as a Service
April 2024
Learn what your peers think about Oracle Database as a Service. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,886 professionals have used our research since 2012.
IT Project Manager at a comms service provider with 10,001+ employees
Real User
Top 5Leaderboard
An easy to use solution that helped us with our applications
Pros and Cons
  • "It is very easy to use."
  • "It is very hard to support Oracle Database."

What is our primary use case?

My primary use cases for Database as a Service are to create databases, tables, store procedures, and queries.

What is most valuable?

The solution's most valuable feature is the help it gives to our applications. It is very easy to use.

What needs improvement?

It is very hard to support Oracle Database.

For how long have I used the solution?

I have been using Oracle Database as a Service for four years.

What do I think about the stability of the solution?

Oracle Database is very stable.

What do I think about the scalability of the solution?

The solution is scalable. We have approximately 20 users.

How are customer service and support?

Customer service and support with Oracle is good. I would rate the service they provide a five out of five.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

Prior to using Oracle Database as a Service, we were using MySequence. We chose to switch solutions due to the cost.

How was the initial setup?

The initial setup of Oracle Database was neither easy nor complex, it depends on the experience of the individual implementing the solution. If you are experienced, it is not hard.

What about the implementation team?

We implemented the solution in-house.

What's my experience with pricing, setup cost, and licensing?

Oracle Database is less expensive than the previous solution we used.

What other advice do I have?

Depending on the company, I would recommend Oracle Database. Overall, I would rate the solution a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Database Administrator at Contemi
Real User
Top 5
Outstanding security and performance in this stable solution
Pros and Cons
  • "I would rate this solution as an eight out of ten because the stability and performance are good and the solution does not need to be maintained a lot."
  • "There is room for improvement in PL/SQL. It is not user-friendly and it is hard to understand."

What is most valuable?

The security and performance of this solution are outstanding. 

What needs improvement?

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

For how long have I used the solution?

I have been working with this solution for about 10 years. 

What do I think about the stability of the solution?

The solution is very stable. 

What do I think about the scalability of the solution?

I haven't had many opportunities to work with the scalability features. I don't have much experience in this area.

How was the initial setup?

The setup, installation, and configuration are maybe a little bit complex the first time. Of course, when you've done it several times, you become familiar with it, so for me, it is not too complex. 

What's my experience with pricing, setup cost, and licensing?

The solution is expensive. 

What other advice do I have?

I would rate this solution as an eight out of ten because the stability and performance are good and the solution does not need to be maintained a lot. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
PeerSpot user
Production Systems Engineer at Enwe
Real User
Top 10
Easy to use, scales quickly, and has good support available
Pros and Cons
  • "When we want more information on something that we are using, it is easy to find related topics on the internet."
  • "In the next release, I would like to see a framework for memory management."

What is our primary use case?

We use this solution for multiple databases.

I have written Oracle scripts for operational databases and uploading databases.

Our environment includes a Red Hat server with two storage devices for high availability. 

How has it helped my organization?

I have been able to assist people with technical support remotely.

What is most valuable?

This solution is very stable, easy to use, and scales quickly. When we want more information on something that we are using, it is easy to find related topics on the internet.

We use the automated system for creating tables.

The security system is very good.

What needs improvement?

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.

For how long have I used the solution?

We have been using this solution for one year.

What do I think about the stability of the solution?

Oracle databases are stable. It is a very dependable application.

What do I think about the scalability of the solution?

Oracle has many strong features and tools. There are many options and possibilities.

How are customer service and technical support?

Technical support for this solution is good.

Which solution did I use previously and why did I switch?

I have used MySQL and Microsoft SQL Server, and there is no comparison to Oracle. 

How was the initial setup?

I simply followed the instructions on the Oracle website.

The deployment took several months because we have a complex architecture with six thousand servers.

What other advice do I have?

I don't use the management features because I don't work with the GUI. I prefer to use the command line.

Oracle is a very good solution that I would recommend. It is strong software with good support and documentation available.

I would rate this solution an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user432795 - PeerSpot reviewer
Managing Director at CarajanDB
Vendor
Data Guard is best DR solution but licensing is a nightmare
Pros and Cons
  • "Not only does it provide a mature, reliable solution for DR. It also helps if application owners need to look into data which is a couple of hours old, using Flashback Database on the standby database."
  • "Data Guard is the best solution for Disaster Recovery."
  • "My favorite option – Multitenant – should be available for some pluggable databases in all editions, without any fee."
  • "An 8GB download for software is far too big. Nowadays it should be possible to simply use RPM packages on Linux/Unix."

How has it helped my organization?

Not only does it provide a mature, reliable solution for DR. It also helps if application owners need to look into data which is a couple of hours old, using Flashback Database on the standby database.

What is most valuable?

Data Guard, because it’s the best solution for Disaster Recovery.

What needs improvement?

The licensing is a nightmare. Tons of options which need to be licensed individually, and no real offering for VMware or other Hypervisors.

And my favorite option – Multitenant – should be available for some pluggable databases in all editions without any fee.

What do I think about the stability of the solution?

No stability issues at all.

What do I think about the scalability of the solution?

RAC is not a real scalability solution, so instead of scaling out I prefer to scale up.

How are customer service and technical support?

Very poor.

Which solution did I use previously and why did I switch?

I have always used Oracle Database.

How was the initial setup?

Back in the early 90s, set up was difficult. But now, it’s straightforward using the graphical interfaces. But there is indeed room for improvement. An 8GB download for software is far too big. Nowadays it should be possible to simply use RPM packages on Linux/Unix.

What's my experience with pricing, setup cost, and licensing?

There should be a standard way to license the database in a virtual environment (e.g. VMware) and there should be a low-end version (like Standard Edition One) again.

What other advice do I have?

Before starting to look for the high-end solution (Enterprise Edition) you should consider using Standard Edition Two. There is a great chance that it will be sufficient, and gaps can be filled with third-party products like Dbvisit Standby for Distaster Recovery.

Disclosure: My company has a business relationship with this vendor other than being a customer: Oracle Gold Partner.
PeerSpot user
Senior BackEnd .net at a wholesaler/distributor with 1,001-5,000 employees
Real User
Solution helps our clients migrate databases quickly to the cloud
Pros and Cons
  • "My impression of the scalability of Oracle Database as a Service is very high."
  • "The initial setup is complex. This is not a really easy solution. It is very large, so it's hard to install, but it's not impossible."

What is our primary use case?

Our clients have a variety of use cases for this solution. It can be used at gas stations and supermarkets. 

What is most valuable?

Clients come to us with huge on-prem databases. Because of the size of the databases, it can be difficult to grow to cloud. Thanks to Oracle Database as a Service, we can help these clients migrate quickly. 

Oracle solutions give our clients visibility.

What needs improvement?

No company is perfect, but Oracle does need to improve their support. They need to really focus on the customer experience, et cetera. 

I would also like to see them improve the Oracle Database Interface for distributor businesses.

For how long have I used the solution?

I have a year of experience with Oracle Database as a Service. 

What do I think about the stability of the solution?

My impression of the stability of this solution is also very high.

What do I think about the scalability of the solution?

My impression of the scalability of Oracle Database as a Service is very high.

How are customer service and technical support?

I think that Oracle's technical support could improve. When they understand what the problem is, they are fast and solve it quickly, but it is difficult to get to that point with them. Sometimes communication is strained by the fact that we're always talking to different tech support specialists. Maybe the solution would be a sort of segmentation of their tech support team by departments. They do have some good people, but it takes some time to find them because you have to go through their call center. 

How was the initial setup?

The initial setup is complex. This is not a really easy solution. It is very large, so it's hard to install, but it's not impossible.

Which other solutions did I evaluate?

For our clients, Microsoft is an alternative. Microsoft is cheaper, faster and has better support than Oracle.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
PeerSpot user
CTO at a tech services company with 51-200 employees
Real User
Reduced the number of traditional storage/server architecture

What is most valuable?

  • Resource elasticity
  • Rapid provisioning
  • Automated centralized management of all DBs
  • Measured services, etc.

How has it helped my organization?

  • Technically, apart from the cost reduction, it reduces the administration overheads.
  • Scale-up and scale-down resources, as per the demand to ensure the major business, do not impact performance issues.

What needs improvement?

  • Reduce the licensing cost further.
  • Stronger security

For how long have I used the solution?

Over one year now.

What was my experience with deployment of the solution?

Challenges faced when migrating the on-premise database to cloud, especially VLDBs.

What do I think about the stability of the solution?

Mostly with the internet availability and speed. Nothing really with the stability of the DBaaS.

What do I think about the scalability of the solution?

Not anything we have come across.

How are customer service and technical support?

Customer Service:

Satisfactory.

Technical Support:

Satisfactory.

Which solution did I use previously and why did I switch?

Most of the DEV/UAT/TEST were on-premises, which moved to the cloud with consolidation.

How was the initial setup?

There were technical challenges configuring the connectivity, moving the data, etc.

What about the implementation team?

Installation was through a vendor.

What was our ROI?

Reduced the number of traditional storage/server architecture. More productivity and quick provisioning of the database helped moving the application to production quickly.

What's my experience with pricing, setup cost, and licensing?

Oracle licensing is expensive compared to other competitors, such as AWS and MS Azure.

Which other solutions did I evaluate?

Yes. AWS and MS Azure.

What other advice do I have?

Any DEV/UAT/TEST environments are really candidates to go for cloud and ensure you fully utilize the flexibility of cloud technologies.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Oracle Database as a Service Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Database as a Service
Buyer's Guide
Download our free Oracle Database as a Service Report and get advice and tips from experienced pros sharing their opinions.