Try our new research platform with insights from 80,000+ expert users
Senior Oracle Database Administrator at a financial services firm with 51-200 employees
Real User
Good performance and scalability
Pros and Cons
  • "One of the most valuable features of Oracle Database is the performance."
  • "Oracle Database's migration capabilities could be improved because it's very difficult. So even if you migrate where you host your data, be it on Windows SQL Server, there is a problem because migrating the package is highly complex. The technical support could also be faster."

What is our primary use case?

We use Oracle Database to host data. We use versions 11g, 12c, 19c, and 21c, but it depends on the application. The use does not depend on us, it depends on our editors because the application is totally built on Oracle Database. 

This solution is deployed on-premises, but it's highly probable that it will move to the cloud. 

What is most valuable?

One of the most valuable features of Oracle Database is the performance.

What needs improvement?

Oracle Database's migration capabilities could be improved because it's very difficult. So even if you migrate where you host your data, be it on Windows SQL Server, there is a problem because migrating the package is highly complex. The technical support could also be faster. 

For how long have I used the solution?

We have been using Oracle Database since the company was created, so for more than 15 years. 

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

What do I think about the stability of the solution?

Oracle Database is 100% stable. 

What do I think about the scalability of the solution?

This solution is very scalable. 

In our organization, there are over 300 users. 

How are customer service and support?

Oracle's technical support could be faster. 

How was the initial setup?

The installation is straightforward, but you need to have technical abilities. I maintain the system myself because I installed it myself. For deployment and maintenance, we have two or three administrators. 

What about the implementation team?

I implemented this solution myself. 

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

We pay for an annual license as well as monthly support. 

Which other solutions did I evaluate?

Before using Oracle Database, I also evaluated MySQL and PostgreSQL. 

What other advice do I have?

I rate Oracle Database an eight out of ten, according to performance and scalability. In terms of migration abilities, I would rate it a six out of ten because it's very difficult. 

I would recommend Oracle Database to others, especially for their new cloud policy and their subscription amount for the resources. 

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
reviewer1491816 - PeerSpot reviewer
Senior Architect at a computer software company with 10,001+ employees
Real User
Stable and scalable, recommended for formatted and structured data, and works well for a huge amount of data
Pros and Cons
  • "As compared to SQL Server, Oracle Database performs better when you have a huge amount of data. We didn't face any problems when we had a huge amount of data. There were also no issues with importing/exporting and migrating the data."
  • "We faced some difficulties in the network configuration area. All these things can be fixed with the support of Oracle's networking team. We didn't face any other major problems. Its deployment can be easier. It should be easier to configure for a developer. If a developer is planning a database and trying to configure it, it should be easy for him because many times, we cannot directly get help from DBAs."

What is our primary use case?

Over the past seven years, we have done many projects, and in many of those projects, we have used Oracle as a source. We are using an ETL tool from Informatica, and we have used Oracle as a source for our projects. For our configuration and repository databases, we normally use SQL Server. We are not using Oracle Database for that.

What is most valuable?

As compared to SQL Server, Oracle Database performs better when you have a huge amount of data. We didn't face any problems when we had a huge amount of data. There were also no issues with importing/exporting and migrating the data.

What needs improvement?

We faced some difficulties in the network configuration area. All these things can be fixed with the support of Oracle's networking team. We didn't face any other major problems.

Its deployment can be easier. It should be easier to configure for a developer. If a developer is planning a database and trying to configure it, it should be easy for him because many times, we cannot directly get help from DBAs.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

It is scalable. Around 40 to 50 customers are using Oracle Database.

How are customer service and technical support?

Their technical support is fine.

How was the initial setup?

Until version 11g, I didn't face any problem. You can completely set it up in about two hours. I tried version 12c installation once, and it was slightly different than earlier versions. Oracle Database has worked well from version 8 to version 11. These versions have the same type of things, but I faced some difficulty with version 12c, but that could be because we are not used to it. I need to go through it properly. 

What other advice do I have?

I would recommend this solution to others if they are very particular about formatted and structured data.

I would rate Oracle Database a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
PeerSpot user
Buyer's Guide
Oracle Database
March 2025
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
848,716 professionals have used our research since 2012.
reviewer1498107 - PeerSpot reviewer
Oracle DBA at a computer software company with 51-200 employees
Real User
Reliable with good performance and very good stability
Pros and Cons
  • "Especially with VMs, the solution can scale well."
  • "The initial setup is a bit complex."

What is our primary use case?

The solution is the main database storage for the application that we have. We offer an online purchasing system to our major customer, which is a government. They deal with their purchasing through the solution.

How has it helped my organization?

The organization can't function without it working properly as there would be a lot of upset people complaining. It's fairly integral to the overall functionality of the company.

What is most valuable?

The solution's most valuable aspect is its reliability. In about 17 years, I believe I may have lost about 15 minutes worth of data.

Overall, the solution works very well. It has excellent performance. 

The solution is very stable.

Especially with VMs, the solution can scale well.

What needs improvement?

I'm not crazy about their new version plan that they've just started. It seems like it turns over too quickly. We may have to upgrade within the year, and I really am not crazy about that. I don't want to upgrade so soon. We may not have a choice.

The initial setup is a bit complex.

Technical support could be more consistent.

They used to have something called a database console in version 11. That was very good. It seems like they reduced its functionality over the past couple of versions. I'd like to see that back to the way in which it used to be.

For how long have I used the solution?

I've been using the solution for 17 years. It's been over a decade - in fact, it's almost been two.

What do I think about the stability of the solution?

The solution is very stable. There aren't bugs or glitches. It doesn't crash or freeze. It's quite reliable.

What do I think about the scalability of the solution?

The scalability of the solution is quite good. If a company needs to expand, it can do so relatively easily. 

When you were just with bare metal, it wouldn't be as good as it is now with virtual machines as it does not take a lot to spin up another virtual machine and put Oracle on it and have it working. In the old days, when you had a piece of metal, you had to find another piece of metal, get it installed, and then start scaling up from there. With the VM, it's a lot better.

How are customer service and technical support?

I'd rate technical support seven out of ten. They could improve it a bit.

There've been times in which it's been absolutely tremendous. Then there've been other times where it just seemed to take too long. Either the person didn't know enough and had to go to other people and such, and it just took way too long. It's been mixed in terms of results. It's not exactly consistent.

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

It's my understanding that the company has always used Oracle. The company I've been with has been with Oracle for pretty much all of its life. I haven't seen any other solutions.

How was the initial setup?

The initial setup isn't straightforward. It's a bit complex. 

With the setup of it, you need operating system people, whether it be Linux or Windows or whatever operating system, and they need to be coordinating with you. Usually, we're just putting the software on top of an operating system. However, with this, it's just not something that you can just throw out there. You need to have some preparation done, whether it be a VM or a piece of metal.

In implementing the product, the product has gotten simpler to implement over time. Whether you choose to use the cloud or whether you choose to have it on-premises, it has gotten simpler to install. However, that doesn't mean that there isn't preparation that you need to do in regards to the operating system and having everything ready for it.

We have two DBAs, myself and another person. As far as mainline support, we have a couple of units admins that manage the VMs and the hardware that we still have at the moment. And we have some Windows admins, which help with the web interface to the database with the application.

What about the implementation team?

It's best to have some professionals assist with the setup.

What other advice do I have?

We're just a customer and end-user.

I've used various versions of the solution, starting with 10 and moving to 18. We're still a few versions back, and therefore aren't using the latest. The latest is 20 and they are about to release 21.

I'd advise those considering implementing the solution to do some preparation beforehand. This will help ensure a successful setup.

I would rate the solution nine out of ten. There are some improvements that can be made here and there. However, it's largely stable and works 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
it_user419103 - PeerSpot reviewer
Co Founder & Executive Director at SatyaMoksh Inc.
Vendor
The most valuable features for us are the cloud-like traits of ODB, grid computing with version 11g onward, live database, and Data Guard.

What is most valuable?

The most valuable features for us are the cloud-like traits of ODB, grid computing with version 11g onward, live database, and Data Guard.

How has it helped my organization?

We're a non-profit with branches all over the world -- Africa, India, and the US -- so we need a database solution that can be centralized. We have an entire datacenter in India, but our users need access to it from our other locations.

The key thing we need is a database that can pretty much run virtually in the cloud, that is, with a virtual datacenter. When we decided on Oracle three years ago, OBD was the only database that was cloud-like, scalable, and more robust than other solutions available at the time.

What needs improvement?

Honestly, it's not really in the cloud as such, but the definition of "cloud" changes daily. It's more on VMs, but the VM's are so powerful that we can access the database from anywhere without investments in machines or other hardware. We've been doing this since 2010 and we haven't hosted with cloud providers like Datamark or AWS, so we essentially have our own cloud.

While Oracle has been excellent, they haven't been growing or leaping forward like other vendors. I heard that Microsoft SQL Server will begin working with Linux. If that happens, Oracle has to do something because the cost will be one-tenth that of Oracle.

What was my experience with deployment of the solution?

We haven't had any issues with the deployment of ODB.

What do I think about the stability of the solution?

The stability is good as the product has matured over the past few years. We initially implemented in 2014 and had upgrades since. We had some issues, which we told Oracle about and which they fixed. We had integration with a backend database because we are an Oracle workshop when it comes to database. They did not have too many customers using Oracle as a backend database.

What do I think about the scalability of the solution?

We haven't scaled because of the unique constraints of our customized datacenter, but we use Linux because of Windows limitations. But we have been able to go from a mom-and-pop garage shop to where we are now.

How are customer service and technical support?

The support is amazing. We have a great relationship with the non-profit technical support as well as with our sales rep with whom we've been with for ten years.

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

We have used Microsoft SQL Server, but the problem with that is that runs only on Windows. We wanted it on other units. Then we used Sybase, but that is more of a financial database, and didn't help much for our non-profit business. Then we used IBM DB2. That's a nice database, but IBM was considerably more of a hardware than a software part.

We wanted someone who is a player only in the database world because we had everything else and because we are non-profit, we do have tie-up with different companies where we get a different special rate for licensing.

We prefer Oracle because they are the niche players in the database world. We are pretty happy.

How was the initial setup?

Because I'm a technical person and I have experience as a database administrator, the initial setup was pretty simple for me. The support was amazing and we didn't have huge roadblocks. If anything happened, such as issues with plugins, Oracle just gave us a patch.

What about the implementation team?

Our implementation was done in-house by me and my team.

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

Because we're a non-profit, we have a buffet deal. For the first three years, they won't charge us any license fees for any use. It's all-we-can-eat. After three years, they'll come back and look at the footprint and license us based on that. This is a big deal for non-profits, but Oracle is willing to do it.

Which other solutions did I evaluate?

We looked at others who specialize in the cloud, such as CloudData. But Oracle is penetrating the cloud field. If you look at the Magic Quadrant, Oracle is positioned well with its RDBMS and Exadata, along with EMC Greenplum, Microsoft Azure, IBM's cloud solution, and others. We did PoCs with them all.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
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. 

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
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
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 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.