Try our new research platform with insights from 80,000+ expert users
Technical Manager - Enterprise Application at Thakral One (Pvt) Ltd
Real User
The dynamic PL/SQL feature lets me generate custom and ad hoc reports
Pros and Cons
  • "The most important features of Oracle Database are ease of use and high reliability. I also love the dynamic PL/SQL feature, which I use to generate custom and ad hoc reports."
  • "Oracle support is helpful, and they resolve all our issues, but sometimes the response to our clients isn't as prompt as we'd like."

What is our primary use case?

I work as a software developer designing DevOps and implementing Oracle applications with Oracle Database. I design and develop core banking systems, so my role was to manage a team of developers for design, development, and testing. I do some implementation, too. Our customers use Oracle Database as an RDBMS store data.

What is most valuable?

The most important features of Oracle Database are ease of use and high reliability. I also love the dynamic PL/SQL feature, which I use to generate custom and ad hoc reports.

For how long have I used the solution?

I've worked with Oracle Database for more than 15 years. 

What do I think about the stability of the solution?

Oracle Database is a stable product. Oracle has raised the standards for RDBMS solutions. Most banks and government organizations in Nepal use Oracle Database because they're highly reliable. 

Buyer's Guide
Oracle Database
February 2025
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,713 professionals have used our research since 2012.

What do I think about the scalability of the solution?

Oracle Database is scalable. I've deployed the solution at a government tax agency with more than 500 users. The core banking system was implemented at a bank with 22 branches all over Nepal and 200-plus users. Our most recent public sector project had over 100 users. 

How are customer service and support?

Oracle support is helpful, and they resolve all our issues, but sometimes the response to our clients isn't as prompt as we'd like. 

How was the initial setup?

Deploying Oracle Database is easy for me because I have so many years of experience. The team needed for deployment depends on the project. I had a team of 10 software developers for the core banking system, but we used a six-person crew for one of the government projects, including the front-end developer and documentation experts.

We have a team of four certified Oracle Database admins providing support. What I call EMC is something that provides software upgrade solutions, security passes, and everything, but the customer also needs some local support for creating the VR side to back up the client's data and other daily maintenance. We provide this type to banking and government customers in Nepal.

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

My company is an Oracle Gold Partner, so we proved licenses to the customers as well. The license price is listed globally on the Oracle site. It's basically license plus EMC.

What other advice do I have?

I rate Oracle Database nine out of 10. Oracle releases new versions every year. It's now on 21C, and they regularly provide security patches and bug fixes. The customer will have issues without them. I think Oracle is doing a good job. They are investing massive resources into development. 

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
reviewer1593516 - PeerSpot reviewer
Consultant at a consultancy with 10,001+ employees
Real User
One of the best DBs for business-critical data and scaling for heavy requirements
Pros and Cons
  • "The features that I have found most valuable are things like cluster setup and RAC One. We are using the main CQN and third party plugin support right now. We are relying on different languages support that we are getting from the Oracle side. It is one of the major areas in which Oracle excels compared to other databases."
  • "There are a lot of additional costs. That is the reason we are only leveraging for transactional related purposes, so that we do not spend so much on doing the same thing on Oracle. That is the reason we are looking for open source databases now."

What is our primary use case?

It is deployed on AWS Cloud, but it is an IaaS setup, not the PaaS one.

We are using or leveraging Oracle DB for storing the transaction related details. Along with that we are heavily relying on the CCQ and setup that Oracle provides. They were sending a notification for any changes or transactional log audit purposes that we are using.

What is most valuable?

The features that I have found most valuable are things like cluster setup and RAC One. We are using the main CQN and third party plugin support right now. We are relying on different languages support that we are getting from the Oracle side. It is one of the major areas in which Oracle excels compared to other databases.

What needs improvement?

In terms of what could be improved vis-à-vis our use cases and requirements, there is nothing. Nonetheless, we are trying to move to other companies because of the licensing cost that we're incurring on a monthly basis. Other than that we are not seeing any performance issues or require additional add-ons based on our use cases.

For how long have I used the solution?

I have been using Oracle Database for around four years.

What do I think about the stability of the solution?

It requires patching that we need to do manually from our end. To use the patches released from the Oracle side requires maintenance.

We have a dedicated team of DBA's that took care of the maintenance and dispatching. There are times reserved for that purpose, and during that time whenever a business requirement is very low or there is less load on the DB, that is when we do it.

It is quite stable.

What do I think about the scalability of the solution?

The RAC One feature that I mentioned is one of the highlights of Oracle. We're using that for scalability and management. If we're increasing we can easily plug the nodes into the DB and we can distribute the load. It's not a problem.

Right now we are creating these transaction logs from different DBs that we have in place so it's not directly any application or anyone in these dealings. ETL jobs are defined and in place so that we can extract and dump the logs into the Oracle DB.

We have a team of administrators working on it.

How are customer service and technical support?

Our team used to do it without any kind of technical challenges. Anything which we are not able to solve from our end our DBA team used to reach out to them.

We have a separate team who is doing all the tickets and stuff.

How was the initial setup?

The initial setup is a bit complex because we need to define rules and permissions for each and every user's perspective. The initial setup took us a bit to put everything in place.

What about the implementation team?

We were getting help from the Oracle DBA support when we we set up Oracle. 

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

Right now we are paying per license to Oracle and for whatever additional features we are leveraging. For that we need to pay extra on top of the license.

There are a lot of additional costs. That is the reason we are only leveraging for transactional related purposes, so that we do not spend so much on doing the same thing on Oracle. That is the reason we are looking for open source databases now.

What other advice do I have?

As I mentioned previously, as per our use cases, the features that Oracle is currently providing are more than enough. We haven't seen any new features that should be included because all the features that we need to support our business requirements are there.

Oracle is a great DB. If you very heavily rely on it for very business-critical data and certain scaling is required or heavy requirements from the technology perspective, I would say Oracle is one of the best DB's. But for that you need to pay a heavy amount for the licensing costs. Everything is included in the package, but apart from a few additional features we also need to pay extra.

On a scale of one to ten, I would give Oracle Database a 10.

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?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Oracle Database
February 2025
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,713 professionals have used our research since 2012.
Eva Kimathi - PeerSpot reviewer
ERP Database Administrator at PSKENYA
Real User
Top 10
Optimal performance, seamless install, and highly stable
Pros and Cons
  • "I have experienced good performance from the solution."
  • "Since the solution is from Oracle it tends to be complex when trying to integrate with other solutions."

What is our primary use case?

We use the solutions as a backend, essentially it runs the database. We have the database to support the ERP, which is our customers, and it is running on Java.

How has it helped my organization?

The original Oracle Database is good for us, especially because even if the ERP is running on Java, we still get good performances. We are able to tune the database to get more optimal performance out of it. For example, we are storing information on the database and we have not had anybody complaining about lag or degradation, it is really good for our company.

What is most valuable?

I have experienced good performance from the solution.

What needs improvement?

Since the solution is from Oracle it tends to be complex when trying to integrate with other solutions.

In a future release, I wish it was easier to run on other cloud services, not just Oracle Cloud. It is possible to run it on other cloud services but it is incredibly difficult to plan and deploy it. However, it is supported by many other cloud services, it is just not easy, but I think maybe that is the direction they are headed.

Additionally, they could make management for security a little more intuitive. It is good so far but it could be easier.

For how long have I used the solution?

I have been using the solution for four years.

What do I think about the stability of the solution?

The solution has never crashed. I have never needed to call Oracle to get a support ticket.

What do I think about the scalability of the solution?

We have a really lightweight set up, we have the solution configured for 400 people.

How are customer service and technical support?

We were using Oracle partner support and they have been very good.

How was the initial setup?

The installation was easy, we had a lot of documentation. We installed the solution on Red Hat Linux and there were sufficient documents informing us on what to expect, hot to install it, and what to set up before you install. The install was seamless.

What about the implementation team?

The deployment did not take long because we installed the solution in our primary location. We did not have to co-locate, the total time was approximately two hours.

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

The price is a little high for the solution, especially when you try and configure it in certain ways. We are using the application-specific user license, which is a little inexpensive. We pay approximately $4,900 USD annually.

The licensing model is complex, you are charged for many configuration setting used. You could deploy the solution and expect a cheaper rate but you might have deployed the solution with some of the costly features and now have to pay for them.

What other advice do I have?

I rate Oracle Database an eight 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
Omar_Ismail - PeerSpot reviewer
ECM, Archives and Digital Preservation Consultant at DataServe
Real User
Top 5Leaderboard
A stable and scalable solution with high performance
Pros and Cons
  • "Oracle Database is the best based on stability and high performance."
  • "The solution could be cheaper."

What is our primary use case?

We use most of our projects with the government and private sector based on Microsoft SQL Server.

How has it helped my organization?

We have an e-correspondence solution leveraging both Microsoft SQL and Oracle databases. This solution utilizes Java on top of IBM cloud technology for business automation, ensuring security through Oracle and Microsoft Secure integration.

What is most valuable?

Many companies are transitioning from AME to Oracle Database due to competitive pricing. This shift is straightforward. Cost is a priority; they are trying to secure market share and ensure robust security measures.

What needs improvement?

The solution could be cheaper.

What do I think about the stability of the solution?

The product is much more stable than Microsoft.

I rate the solution’s stability a nine out of ten.

What do I think about the scalability of the solution?

The solution is scalable. 1,000 users are using this solution.

I rate the solution’s scalability a nine out of ten.

What was our ROI?

Oracle Database offers rigidity and top performance.

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

The product is expensive.

What other advice do I have?

Oracle Database is the best based on stability and high performance.

I recommend this solution.

Overall, I rate the solution a ten 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
reviewer1782720 - PeerSpot reviewer
Technical Lead at a computer software company with 10,001+ employees
Real User
Helpful functionally, good support, and reliable
Pros and Cons
  • "The most valuable feature of Oracle Database is all the functionalities. When we write a code we sometimes have to create an explicit functionality to process the data that we want. At times we find that there is already existing functionality in data created by Oracle itself, it is helpful."
  • "The integration can be made much easier for the Oracle tools, for example, Oracle Database or OPI. The integration sometimes can be a little complicated for us because we have to do a number of integrations with other tools, such as Oracle computation. The integration could be more streamlined and easier to work with."

What is our primary use case?

I worked on private on-premises and hybrid cloud deployments.

We use Oracle Database primary for business intelligence in the telecom domain. We are generating all of our KPIs. Additionally, we use it for data warehousing purposes.

What is most valuable?

The most valuable feature of Oracle Database is all the functionalities. When we write a code we sometimes have to create an explicit functionality to process the data that we want. At times we find that there is already existing functionality in data created by Oracle itself, it is helpful.

What needs improvement?

The integration can be made much easier for the Oracle tools, for example, Oracle Database or OPI. The integration sometimes can be a little complicated for us because we have to do a number of integrations with other tools, such as Oracle computation. The integration could be more streamlined and easier to work with.

For how long have I used the solution?

I have been using Oracle Database for approximately 10 years.

What do I think about the stability of the solution?

Oracle Database is a very stable solution. If we find a bug or issue then we have to log those ourselves with Oracle. After some time we receive a patch update to fix those problems.

What do I think about the scalability of the solution?

Oracle Database is scalable.

I would recommend Oracle Database for large enterprises because the smaller companies would not be able to afford it.

How are customer service and support?

The technical support of Oracle Database is okay. The last time I was working in South Africa and when I have to use the Oracle support of South Africa it was poor. We did not receive a proper response from Oracle then. Every time we had to escalate our issues or we had to log with Oracle to have the higher-level management. Eventually, our issues were resolved. However, I have never had an issue with the support from Oracle in India or the USA.

How was the initial setup?

The implementation of the Oracle Database can be a lengthy process. It is not difficult, but it can take a lot of time.

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

I do not have first-hand knowledge of the price of the support. However, I have heard from my seniors or the experienced people who work on the pricing and scaling, the price of Oracle is a bit higher. The reason is Oracle provides enterprise-level applications, only large enterprises can afford Oracle applications or tools.

What other advice do I have?

I rate Oracle Database an eight out of ten.

I rated the solution an eight because there is still a lot of improvement needed. The user experience could be better, the interfaces could improve.

I know that there are a couple of new applications already out by Oracle, such as Oracle Analytical Services and Oracle Analytical Clouds, which are more user-friendly. Oracle needs to make databases more user-friendly and easier to work on. At this time we have to login into the front end and the backend to do a lot of configurations and it would be much better if we had some type of interface to work on.

If I want to teach someone who is totally new to this environment, he or she might have worked in some other applications similar to Oracle Database, such as SQL Server or MySQL, but if I want them to learn in Oracle it can be difficult for us to teach them. It would be much better if the overall solution was easier to use.

Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
reviewer1089354 - PeerSpot reviewer
System/Security Engineer at a tech vendor with 10,001+ employees
Real User
Mature, stable, and easy to deploy
Pros and Cons
  • "It is a mature product. It is pretty stable. I've got a lot of experience with it, so it is pretty easy to use."
  • "The software really doesn't need any improvement, but the way they do the billing should be improved. They charge by all the chips on the server, whether you use them or not. If you have a server that has 64 chips on it and you use one chip, they charge you for 64, and that's a terrible business model."

What is our primary use case?

We are using it for inventory control. We have about 220 servers running Oracle Database, but we're migrating from Oracle to Postgres.

How has it helped my organization?

We've had it for a very long time, and up until they changed the way they do the billing, we were happy. A few years ago, they changed the way they charge for the product, and they hit us with a $6 million bill for one year, and that was it. People got very unhappy.

What is most valuable?

It is a mature product. It is pretty stable. I've got a lot of experience with it, so it is pretty easy to use.

What needs improvement?

The software really doesn't need any improvement, but the way they do the billing should be improved. They charge by all the chips on the server, whether you use them or not. If you have a server that has 64 chips on it and you use one chip, they charge you for 64, and that's a terrible business model.

Their support is terrible and should be improved.

For how long have I used the solution?

I've been using Oracle Database for probably 20 years.

What do I think about the stability of the solution?

It is very stable. It has been around for a very long time, and it is stable now.

What do I think about the scalability of the solution?

It scales vertically. So, the more stuff you want to do, you have to get a bigger server. That's okay if you can do that, but the strategy now is that everybody is scaling horizontally because you can buy a ton of cheap servers and spread them out all over the network.

We have about 10,000 users, and they're doing inventory control. We don't plan to increase its usage. We are planning to decrease its usage and go to Postgres.

How are customer service and support?

Their support is terrible. I stand a better chance talking to my four-year-old grandson than talking to them. At least, he pays attention.

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

They weren't using any other product previously. They have been using Oracle for maybe 20 years.

How was the initial setup?

It is very straightforward. It takes about three or four hours.

What about the implementation team?

We do it ourselves. For its maintenance, there are probably seven or eight people.

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

Its cost is astronomical. They charge by the size of the server rather than what you're actually using. It is just a terrible business model.

It has got a ton of features that are great, but you have to pay for them, and we don't want to spend a lot of money.

If you use any of their additional products, you have to pay for those. Almost everything extra is at an additional charge. We also use RAC, and there is an additional charge for that. 

Which other solutions did I evaluate?

I guess they did evaluate other products, but I wasn't there.

What other advice do I have?

If money is no object, it is a great product, but if you're worried about your budget, find another solution.

I would rate it a 10 out of 10. It is a great product. It has been around forever. It works, but it is too expensive.

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
Petr Bunka - PeerSpot reviewer
System Architect at CGI
Real User
Top 10
A stable solution which performs well and is suitable for enterprise applications
Pros and Cons
  • "The solution is stable and has good performance."
  • "The licensing could be cheaper and clearer."

What is our primary use case?

We use version 12c, but are planning to migrate to 19c. 

The solution is suitable for enterprise applications. We use it for trade systems and a betting system. We use it with applications that need a huge amount of data, such as SQL enterprise applications.

What needs improvement?

The licensing could be cheaper and clearer. It is not clear how it applies to certain options. The licensing of the solution for only several virtual servers is a big issue which should be addressed. 

For how long have I used the solution?

I have been using Oracle Database for many years, perhaps since 2001. 

What do I think about the stability of the solution?

The solution is stable. 

How are customer service and support?

I have not had direct contact with tech support, although my colleagues have. 

How was the initial setup?

I cannot comment on the initial installation, as it is handled by the Database Administrator, not I. He possesses the skill to install the solution and has never mentioned any issues with this. Perhaps my colleagues would be in a position to give a more comprehensive answer. 

What about the implementation team?

In respect of the deployment and maintenance, we have two administrators, developers, an architect and a tester who are in charge of four applications. 

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

The licensing could be cheaper and clearer. It is not clear how it applies to certain options. The licensing of the solution for only several virtual servers is a big issue which should be addressed. 

The license is yearly. 

Which other solutions did I evaluate?

Although I would recommend the solution for certain applications, as there are licensing issues, I would prefer to use PostgreSQL where possible. 

What other advice do I have?

There are many people making use of the solution in my organization, including developers, testers, end users and end application users. We may be talking about thousands. But when it comes to those with personal experience using the solution, we are talking about 40 or 50 people. 

We plan to continue using the solution, as there are certain applications of ours which must remain on Oracle Database. 

The solution is stable and has good performance. Licensing is the big issue we encounter. 

Were I to rate Oracle Database strictly on its technical capabilities, I would have to give it a rating of nine out ten. However, its licensing issues bring this rating down to seven. 

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
reviewer1489539 - PeerSpot reviewer
General Manager (IT/MIS) at a energy/utilities company with 10,001+ employees
Real User
A leading database that's stable and easy to set up
Pros and Cons
  • "It's one of the leading databases on the market."
  • "On the ERP side, they do not seem to be improving the on-premises version. They seem to want to push the cloud option on users."

What is our primary use case?

We are using the Oracle E-Business Suite ERP system and the backend of that application is Oracle Database. We are using the customer care and billing application and the backend of that application is also Oracle Database. 

What is most valuable?

The customer care and billing capabilities are very good.

It is very stable. We are getting good performance from it. The reliability is excellent. 

It's one of the leading databases on the market.

We get good support on the database side. 

The cloud setup is very simple. 

The solution works well for enterprise-level organizations.

What needs improvement?

We've used the solution for so long, it would be hard to switch off of it. 

On the ERP side, they do not seem to be improving the on-premises version. They seem to want to push the cloud option on users. The roadmap for each seems to be diverting, and the on-premises side simply isn't getting the same amount of attention.

The pricing could be high.

For how long have I used the solution?

In our company, we've been working with the solution here for 15 years.

What do I think about the stability of the solution?

The solution is quite stable. There are no bugs or glitches. We do not find that it crashes or freezes. It's reliable.

What do I think about the scalability of the solution?

The scalability is very good. They are providing the structure, the architecture, and everything you need to scale. It's very easy to scale to whatever size you need. Usually, we can do scalable sites with no issue.

How are customer service and technical support?

Technical support is okay for the most part. On the database sites, things are okay. However, if we talk about the application sites, sometimes we are getting a response time that is delayed.

How was the initial setup?

The initial setup, for the cloud implementation, is very straightforward. Companies won't have any issues with the deployment. 

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

The solution is very expensive as they are charging their products in different categories. For example, we have to pay on the application side, on the technology side, and on the licensing. On an enterprise level, if we compare with other solutions, there are a lot of open-source options which would be cheaper.

What other advice do I have?

We're just a customer and an end-user.

I'd rate the solution at a nine out of ten. I'd rate it at a perfect ten if the could and on-premises versions we treated with equal weight, and they didn't try to simply push cloud on users. 

On the enterprise level, it's very stable and reliable. It's great if users are looking for enterprise quality. However, there are options available in the Unix and Linux systems as well. 

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
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: February 2025
Product Categories
Relational Databases Tools
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.