Raghuraman Sundararajan - PeerSpot reviewer
Senior Manager III at a financial services firm with 10,001+ employees
Real User
Top 5
Has good performance, replication, and active data
Pros and Cons
  • "I like the tool’s database services. I like the system’s performance, replication, active data, etc. which are all good."
  • "The solution provides the same type of RDBMS engine for all use cases. They need to provide different products that will be suitable for all use cases. The solution does not support the documentation of databases."

What is our primary use case?

We use the tool to store data.

How has it helped my organization?

All our payment engines run on databases which are the heart of our entire ecosystem.

What is most valuable?

I like the tool’s database services. I like the system’s performance, replication, active data, etc. which are all good.

What needs improvement?

The solution provides the same type of RDBMS engine for all use cases. They need to provide different products that will be suitable for all use cases. The solution does not support the documentation of databases.

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.

For how long have I used the solution?

I have been using the solution for the past 15 years. We plan to migrate to licensing. We are now at 11g and plan to migrate to 19c.

What other advice do I have?

I would rate the solution a ten out of ten. It is a wonderful database engine.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Daniel_Nemethy - PeerSpot reviewer
Owner at Nemethy Moderato Kft
Real User
Top 5
Has good partitioning features and vertical scalability
Pros and Cons
  • "In terms of structured databases, I support SQL-based databases. SQL has its place, but not for plannable structure and transactional databases. At the same time, Oracle is very much optimized."
  • "I would like to improve the stability of the Oracle database."

What is our primary use case?

Oracle Database could be useful for companies that need the stability of the Oracle database. People might not have the money, time, and options to maintain commodities-supported systems on their own or have a dedicated DBA team. So, the best is if you buy the service and not simply install a database and hope that it will work but not have enough people to support it. In my opinion, any mid-size business needs the stability and scalability of an Oracle Database.

How has it helped my organization?

Where I work, all the core systems are Oracle-based. In the banks, there were about 400-800 people as users and many customers.

What is most valuable?

In terms of structured databases, I support SQL-based databases. SQL has its place, but not for plannable structure and transactional databases. At the same time, Oracle is very much optimized. If you don’t have a deeper knowledge of how to create a query, the newer versions optimize it without answers as well. So that is a very strong feature.

Another valuable feature is partitioning. You can partition the database, you can move the partitions, and maintain the growth. The unnecessary growth of the database and the backup systems are well supported. So, all the things around which we need the long-lived stability of the database are in Oracle.

What needs improvement?

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

For how long have I used the solution?

I have been using Oracle for ten years. 

What do I think about the stability of the solution?

I would like to improve the stability of Oracle. Although, I would like to give an example here. Finding new core banking systems can be daunting, particularly when vendors don't clearly state their capabilities upfront. To ensure optimal performance and stability, a list of vendors is available with specific requirements listed in the database directory. Although not always explicitly stated upfront, many offer compatibility with Oracle databases when appropriate.

What do I think about the scalability of the solution?

It is very scalable, but the Oracle stability is okay. The vertical scalability works well. There is a lot of hype around horizontal stability. But to be honest, if you are using a transactional database system for a bank, it does not require a big database. The gross of the database is predictable. The first thing we look at is its performance. If we need to get the right performance, we need to scale. But the most important aspect for us is performance. I need both the scalability part and performance.

How are customer service and support?

I have never directly reached out to the Oracle support team.

How was the initial setup?

In banks, there are enough people to set things up, so the setup gets easier and easier.

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

In my opinion, it's not cheap, but every business can decide for itself.

The question is, how successful will Microsoft be in getting into your business? Because, of course, there is competition on the cloud part.

Which other solutions did I evaluate?

Microsoft is trying to get into this business. It's cheaper. One reason is that the banking systems often use PSQL. There is business logic in the database. The reason Microsoft was proposed was for its performance. It costs a lot to transform PSQL into Microsoft SQL. They are two different languages, and even the solutions are different. Another reason to go with Oracle is that it's more mature than its competitors. I would consider it the golden gate.

What other advice do I have?

I would rate Oracle a nine out of ten. I have used different versions in different companies. For example, at the moment, in this company, we have an Oracle record 11g. In my former company, we used 12c and 19c. It's not good to lag too much time because then you will fight with the problems to update the newer versions. We are planning to upgrade it from 11g to 2019.

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.
Jahnavi Koppala - PeerSpot reviewer
Actimize Developer at Infosys
MSP
Top 5Leaderboard
Easy to use, simple data retrieval, and saves large amounts of data
Pros and Cons
  • "The most valuable features of Oracle Database as a Service are the ease of use. We can use a simple syntax to get data and we can easily go to procedures to see data other than using a query."
  • "Oracle Database as a Service is very convenient to use. However, we need to know to which schema we want it to connect specifically, and what are the username and password. The solution requires some basic knowledge of SQL RP and SQL Oracle to use it."

What is our primary use case?

I use Oracle Database as a Service for preparing DBQ. I then check whether my output is as expected or not, and compare it with the LS that is generated. Additionally, when I check any customer data, I use this solution.

What is most valuable?

The most valuable features of Oracle Database as a Service are the ease of use. We can use a simple syntax to get data and we can easily go to procedures to see data other than using a query.

What needs improvement?

Oracle Database as a Service is very convenient to use. However, we need to know to which schema we want it to connect specifically, and what are the username and password. The solution requires some basic knowledge of SQL RP and SQL Oracle to use it.

For how long have I used the solution?

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

How are customer service and support?

I have not used the support from the vendor.

How was the initial setup?

The initial setup of Oracle Database as a Service is difficult. For example, reading all the schemas and providing different users can take time.

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

This solution is costly because it saves a lot of data.

What other advice do I have?

Oracle Database as a Service is a user-friendly option that you can be considered when evaluating solutions. You can easily view available tables and their corresponding data by executing basic queries. The left tab displays all tables and procedures, and you can expand it to view table names directly. By using a simple query, such as "select star from [table name]", you can obtain all information. You can then refine your queries by selecting specific correlated queries that involve loops, joins, and other operations. Overall, using Oracle is a straightforward process that you should consider exploring.

I rate Oracle Database as a Service 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
Robin Saikat Chatterjee - PeerSpot reviewer
Head of Oracle Cloud Infrastructure Solutioning Technology and Architeture at Tata Consultancy Services
Real User
Top 5Leaderboard
You can run it on the Oracle public cloud.

What is most valuable?

It provides the ability to run from a simple schema base to a real application database, including the option to run it on the Oracle public cloud. In cases where the customer has an issue with data locality or privacy, the option to seamlessly switch to a Oracle public cloud machine in the customer's own DC makes this the most flexible cloud solution.

The automatic inclusion of all database options in Enterprise Edition (EE), Extreme Performance and Exadata cloud service make this product very attractive.

How has it helped my organization?

Previously, when proposing cloud solutions for Oracle database to enterprise clients the lack of a viable high availability solution was often cost prohibitive. Oracle offers this as a standard option. With Active Dataguard freely available for Extreme Performance, there is no enterprise cloud service catering to the Oracle database that can match this offering

What needs improvement?

Currently, there is no simple method to modify the orchestrations on which the compute hosts are based. Hence, unlike the IaaS Oracle services, in cases where there is a need to make certain changes to the service, such as adding an IP network or a GRE tunnel, it requires specialized skills from the backend. However, we expect with the rapid pace of innovation that the feature to modify advanced aspects might be added on the fly in later versions.

For how long have I used the solution?

We have been experimenting with the solution for just over a year now and we have clients that are going live on the system as I write this.

What was my experience with deployment of the solution?

We saw some minor hiccups to do with networking and connectivity. We also were utilizing the Exadata database cloud service for one client and faced some issues with the cloud tooling. One minor problem was if we created a database of a particular name in capitals, deleted the database, and then tried to recreate the same database but with small letters, the cloud tooling would not allow this. We raised the issue to Oracle, who provided a fix and will incorporate this in the next version of the Exadata cloud tooling.

What do I think about the stability of the solution?

On the whole, the system was very stable. We only faced one unexplained hiccup, when a server was rebooted and we were not able to track down the root cause.

What do I think about the scalability of the solution?

We did not face any issues with scalability. We are using Oracle OTD for high-availability scale out, which was initially active-passive but later an active-active solution was provided.

How are customer service and technical support?

Customer Service:

We have had very responsive customer support. On several occasions, the Oracle Cloud A-Team directly came on the call with us to help resolve issues.

Technical Support:

The technical team from the vendor side was quite knowledgeable and we were able to resolve some network routing issues quite quickly.

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

We have used other cloud providers. However, they did not have a true high-availability cloud solution. The second issue we found is that I/O bandwidth was comparatively variable on the other cloud providers and we could not scale easily beyond a few terabytes without facing I/O bottlenecks.

How was the initial setup?

Because we had taken training on the platform, it was very familiar for us. However, it would not be so easy for someone implementing this from scratch. We would recommend going with an experienced managed service provider.The platform provides surprising flexibility for something that is billed as platform as a service.

What about the implementation team?

We are ourselves a cloud service provider team that implemented for several customers.

What was our ROI?

This varies across our customers but they all are seeing benefits over their erstwhile in-house solutions.

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

The cloud option provides a lot of benefits for Oracle shops, as it reduces the upfront costs and converts the licensing costs to a running cost.

Which other solutions did I evaluate?

We have utilized other cloud and hosted platforms such as Azure, Macquarie Telecom, Verizon, Xerox, etc. However, this option was superior for Oracle Database hosting.

What other advice do I have?

This provides an enterprise-class cloud solution that can scale to terabyte-sized databases in the cloud without having to compromise.

Disclosure: My company has a business relationship with this vendor other than being a customer: We are an Oracle Diamond partner.
PeerSpot user
Guruprasad Gonjare - PeerSpot reviewer
Director Cloud Architecture at LTIMINDTREE
Real User
Top 5
A high-performing solution that is useful for managing enterprise workloads
Pros and Cons
  • "I like the solution’s performance and real application concepts."
  • "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."

What is our primary use case?

The solution’s new version, Exadata, is good for managing enterprise workloads. It is number one in terms of performance. The solution is also good with sharding concepts.

What is most valuable?

I like the solution’s performance and real application concepts.

What needs improvement?

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.

For how long have I used the solution?

I have been working with the solution for more than 20 years.

What do I think about the stability of the solution?

I would rate the solution’s stability a ten out of ten since it is stable.

What do I think about the scalability of the solution?

The solution is scalable and I would give a rating of ten out of ten for its scalability. We have more than 100 customers for the solution.

How was the initial setup?

The solution’s setup is straightforward and doesn’t take more than a day to complete. The steps for the solution’s deployment include purchasing the tenancy and provisioning the database as per the license which you have purchased.

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

Customers need to pay extra costs for the solution based on their scope and business.

What other advice do I have?

I would rate the solution a ten on ten. Anyone looking to implement the solution should be mindful of the sizing since it affects the licensing and AMC support. I would suggest customers to try the subscription-based pricing model rather than the optimized licensing one.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Ahmad Hida - PeerSpot reviewer
Application and BI manager at Ithmaar-solutions
Real User
Top 5Leaderboard
Secure, useful object types, and helpful online support
Pros and Cons
  • "The most valuable feature of Oracle Database as a Service is the object types. The object types are not available in other databases, such as SQL and Postgres. Additionally, the security is very good."
  • "The price of Oracle Database as a Service could be better."

What is our primary use case?

We are using Oracle Database as a Service for a banking system we are making that requires a good database with high performance and very high capacity. This solution is providing all of these features for us. Additionally, we are using another Oracle tool for development, called Oracle ADS, which is very compatible with the Oracle Database as a Service.

What is most valuable?

The most valuable feature of Oracle Database as a Service is the object types. The object types are not available in other databases, such as SQL and Postgres. Additionally, the security is very good.

What needs improvement?

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

For how long have I used the solution?

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

What do I think about the stability of the solution?

Oracle Database as a Service is stable.

What do I think about the scalability of the solution?

The scalability of Oracle Database as a Service is good.

We have more than 50 people in my company using this solution.

How are customer service and support?

We have rarely used the support. However, whenever we have any issue, we can search it through the Oracle site and find a solution.

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

I'm working on Postgres and Advanced Postgres and we have some products on it, but I found that the performance is not the same as Oracle Database as a Service.

How was the initial setup?

The initial setup of Oracle Database as a Service is straightforward.

What about the implementation team?

We did the implementation of Oracle Database as a Service with our in-house team of four people. One for the application, one for the database, and two for DevOps.

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

I do not know firsthand about the price of Oracle Database as a Service, but it is known that Oracle solutions tend to be priced higher than competitors.

What other advice do I have?

I would recommend this solution to others.

I rate Oracle Database as a Service 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
Adnan Kamarudin - PeerSpot reviewer
Database Engineer at HeiTech Padu Berhad
Real User
Has contributed positively to operational uptime, especially with Data Guard
Pros and Cons
  • "In terms of features, I find Automated Storage Management (ASM) and Data Guard most helpful for improving data security and reliability."
  • "Its application development could be enhanced to fully utilize its features."

What is our primary use case?

On a day-to-day basis, we use Oracle Database for monitoring and managing data volumes, especially adding data files automatically. I haven't directly experienced how Oracle Database enhances data analytics, as my involvement has been more on the application design side.

What is most valuable?

In terms of features, I find Automated Storage Management (ASM) and Data Guard most helpful for improving data security and reliability. 

Oracle Database is scalable, particularly in storage utilization with ASM. The availability of Oracle Database has contributed positively to operational uptime, especially with Data Guard.

What needs improvement?

In terms of improvements, I believe Oracle Database is already quite robust, but application development could be enhanced to fully utilize its features.

For how long have I used the solution?

I've been working with Oracle Database for about 15 years, primarily focusing on application design and monitoring.

What do I think about the scalability of the solution?

I rate scalability as a 5 out of 10, and stability as an 8 out of 10.

How are customer service and support?

For technical support, I'd rate it a 7; there's room for improvement in user interaction.

How was the initial setup?

The initial setup experience for Oracle Database is straightforward, I would rate it around 8 or 9 out of 10. Deployment typically takes no more than 2 hours.

What about the implementation team?

Migrating to Oracle Database from on-premises was a while ago, so I don't remember it well, but it was generally okay.

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

The solution is on the expensive side, but I recommend it because it's a good database.

What other advice do I have?

Overall, I find Oracle Database as a Service to be reliable and efficient for our operational needs. I'd give Oracle Database as a Service an 8 out of 10.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
ARIEL MUNAFO - PeerSpot reviewer
Co-Founder & CEO at CLOUDEX
Real User
Top 5
A highly stable solution that helps you manage your database and backup
Pros and Cons
  • "As a database administrator, it has a lot of features to help you manage the database and the backup."
  • "The solution’s pricing could be improved."

What is our primary use case?

We use Oracle Database as a Service for data warehouse and OLTP systems.

What is most valuable?

Oracle Database as a Service is one of the best databases. As a database administrator, it has a lot of features to help you manage the database and the backup. It's a very good product.

What needs improvement?

The solution’s pricing could be improved.

For how long have I used the solution?

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

What do I think about the stability of the solution?

I rate Oracle Database as a Service ten out of ten for stability.

What do I think about the scalability of the solution?

The solution's on-premises scalability should be improved. Around 100 users, including analysts, database administrators, and developers, use the solution in our organization.

I rate Oracle Database as a Service an eight out of ten for scalability.

How are customer service and support?

Oracle Database as a Service has a good and fast technical support team.

How was the initial setup?

The initial setup of Oracle Database as a Service is easy.

What about the implementation team?

Oracle Database as a Service is easy to deploy, and we deployed it through an in-house team.

What was our ROI?

Although Oracle Database as a Service is expensive, it is worth its cost, and we have seen a return on investment.

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

Oracle Database as a Service has a yearly licensing fee, which is expensive.

What other advice do I have?

One or two people are enough to manage the solution. The development depends on how many applications you need to build.

Overall, I rate Oracle Database as a Service 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.
Flag as inappropriate
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.