Try our new research platform with insights from 80,000+ expert users
reviewer1715061 - PeerSpot reviewer
DGM Data Centre at a manufacturing company with 10,001+ employees
Real User
Reliable, scales well, and easy to install
Pros and Cons
  • "They continue to improve and are always introducing new features."
  • "More integration, in my opinion, would be beneficial."

What is our primary use case?

All of our critical databases are running on Oracle Database.

What is most valuable?

They continue to improve and are always introducing new features.

What needs improvement?

More integration, in my opinion, would be beneficial.

For how long have I used the solution?

I have been working with Oracle Database for 20 to 30 years.

Because we have a long-term contract with the software team, we are always up to date. It's always the most up-to-date version.

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

What do I think about the stability of the solution?

Because Oracle Database is incredibly stable, it has been used for 20 to 30 years.

What do I think about the scalability of the solution?

Oracle Database is a scalable solution.

It is being worked on by the development team. As a result, it's reaching our entire organization's population.

How are customer service and support?

I have never contacted technical support.

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

Previously, we were using NetVault. We also use MySQL.

How was the initial setup?

The initial setup is very straightforward.

What about the implementation team?

We have the necessary expertise to set up and deploy this solution in-house.

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

We have a subscription.

What other advice do I have?

I would recommend this solution to others.

I would 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
reviewer1616118 - PeerSpot reviewer
PCI DSS Program Manager at a financial services firm with 1,001-5,000 employees
Real User
Stable, reasonably priced, and straightforward to set up
Pros and Cons
  • "The solution is very stable."
  • "The quality of technical support could be better. They could respond faster."

What is our primary use case?

The solution is primarily used for the core banking system, for cloud disaster recovery, for business continuity planning, and lots of other business cases. We use it for the core banking system and card system for applications.

What is most valuable?

The Oracle BI, Business Intelligence, is its most valuable aspect. Oracle BI has been very helpful for me during my career. To have business analytics and to deal with big data with the multiple organizations I've worked for has been great.

The solution is very stable. 

We've found the solution to be scalable.

The initial setup isn't too complicated.

The pricing isn't too bad. 

What needs improvement?

Their cloud services should be improved and expanded. 

The quality of technical support could be better. They could respond faster.

For how long have I used the solution?

I've been using the solution for 12 to 15 years at this point. It's been well over a decade. I've used it for quite a while. 

What do I think about the stability of the solution?

The stability is very good. There are no bugs or glitches. It doesn't crash or freeze. It's reliable.

What do I think about the scalability of the solution?

The scalability is there if you need it. It expands quite well.

How are customer service and technical support?

Technical support is okay, however, sometimes it takes a while for them to respond It would be nice if they were faster. We aren't 100%v satisfied with the level of service we get from them.

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

I also use Microsoft.

How was the initial setup?

While it depends on the testing scenarios, depends on the application that we're going to serve, and depends on the hardware you're using, it's not hard. I wouldn't describe the process as complex. 

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

We're fine with the licensing and costs. 

What other advice do I have?

We are simply customers and end-users. We don't have a business relationship with Oracle. 

I use various versions of the solution, however, every year, they release a new version and I end to install it. 

I use multiple deployment models, including on-premises and cloud. 

I'd give the solution a perfect ten out of ten rating. It really is a fantastic product. We've been very happy with its capabilities and reliability.

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
Oracle Database
November 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
Irad Dukad - PeerSpot reviewer
IT Manager at Ducart
Real User
Top 20
Stable solution for running ERP software
Pros and Cons
  • "The solution is very stable."
  • "The solution is not easy to use and maintain."

What is our primary use case?

I use the solution to run my ERP software.

What needs improvement?

The solution is not for everyday use. It is not easy to use and maintain. As it is on a Linux server, all its maintenance is outsourced for management as a DBA. 

The interface could be more user-friendly.

For how long have I used the solution?

I have been using Oracle Database for 15 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?

The solution could be more scalable. 

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

I did not use other solutions prior to using Oracle Database.

How was the initial setup?

The initial setup is complex.

It can take up to 48 hours.

What about the implementation team?

We made use of an integrator. 

I pay to have the deployment and maintenance outsourced.

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

There is a need to pay for a license for the solution. This must be done annually. 

The license is inexpensive. 

What other advice do I have?

We use the solution in an organizational setting. There are between 30 and 40 licenses. 

I would not recommend this product to just anyone, only to technical professionals. 

I rate Oracle Database as 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
PeerSpot user
IT Assistant at Hotel 2 Fevrier
Real User
Offers excellent backup security, is stable and powerful
Pros and Cons
  • "Offers a lot of backup security and is very powerful."
  • "The monitoring system is not very user friendly and could include a graphic interface."

What is our primary use case?

We are a hotel and the use the database for many things. It's connected to an API, and we use that to connect directly to the database. 

What is most valuable?

This is a powerful solution. It offers us a lot of backup security and we can make an image and a backup of the database every day. It's also very responsive so that when information is updated, it takes less than five seconds to update everything.

What needs improvement?

I think this solution could be a little more user friendly and they could include a graphic interface for the monitoring of the system. The current monitoring system is not very user friendly. 

For how long have I used the solution?

I've been using this solution for five years. 

What do I think about the stability of the solution?

Stability is solid and powerful. 

What do I think about the scalability of the solution?

The scalability is fine, we have about 50 people who have access to the interface - we have a front office team, managers, housekeeping team, finance, sales and others. There are lot of users eligible to connect and update information.

How are customer service and technical support?

The technical support is very good, they are very responsive.

How was the initial setup?

The initial setup is fine, it took about a day for deployment and some extra time for configuration. We use it for the hotel and that requires creating rooms, codes, things like that. It depends what you need to do. We were able to deploy the solution ourselves but for specific tasks you need support.  

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

We pay an annual license fee to Oracle. 

What other advice do I have?

I would recommend this product. 

I rate this solution a 10 out of 10. 

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
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
reviewer1449669 - PeerSpot reviewer
Divisional Manager at a financial services firm with 1,001-5,000 employees
Real User
A robust solution with valuable concurrency, consistency, and security features
Pros and Cons
  • "The concurrency, consistency, and security features are the most valuable. It is also a very robust solution."
  • "There are plenty of options and features in this solution, but they are, somehow, not being used very well. Therefore, training and support should be increased and improved for this solution. They can make people aware of how to make proper use of their server so that people can optimize it because its cost is just too much. They can provide training on the policies and procedures to be used for archiving and all such things. There should be some kind of segregation in licensing. With a full license, all options should be available. There should also be a basic license with limited functionalities. This kind of basic license would be useful for us because we don't use most of the functionalities."

What is our primary use case?

We use it for our business purposes.

What is most valuable?

The concurrency, consistency, and security features are the most valuable. It is also a very robust solution.

What needs improvement?

There are plenty of options and features in this solution, but they are, somehow, not being used very well. Therefore, training and support should be increased and improved for this solution. 

They can make people aware of how to make proper use of their server so that people can optimize it because its cost is just too much. They can provide training on the policies and procedures to be used for archiving and all such things.

There should be some kind of segregation in licensing. With a full license, all options should be available. There should also be a basic license with limited functionalities. This kind of basic license would be useful for us because we don't use most of the functionalities.

For how long have I used the solution?

I have been using Oracle Database since 1988. 

What do I think about the stability of the solution?

It is absolutely stable.

What do I think about the scalability of the solution?

It is scalable. We have around 2,000 users, and they use it daily on a 24/7 basis.

How are customer service and technical support?

We don't use Oracle support. There is an administration team, and they get in touch with Oracle. I only get in touch with our administration team.

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

We are also using Microsoft SQL Server. Oracle Database has more advantages, but Microsoft SQL Server provides value for money.

How was the initial setup?

I don't set it up, but from what I know, it is not very difficult.

What about the implementation team?

We take the help of the agents from whom we buy the support. For its maintenance, we have two people. One person is from our company, and the other person is provided by Oracle.

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

It is very expensive. We pay in dollars, so the inflation and conversion cost is also there for us. They charge on a yearly basis for the license.

What other advice do I have?

They are coming up with lots of features that will allow a lot of work to be done with respect to the database. They are going to give JSON storage, where JSON objects can be directly stored.

I would 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
it_user522111 - PeerSpot reviewer
ERP Architect at a comms service provider with 1,001-5,000 employees
Real User
Some of the valuable features are Oracle Wallet and Data Guard. We are also using the GRANT feature for high scalability.

What is most valuable?

Some of the valuable features are Oracle Wallet and Data Guard. We are also using the GRANT feature for high scalability.

How has it helped my organization?

It has helped us in terms of the higher scalability, higher response time, and good performance with the other features. It is also stable.

What do I think about the stability of the solution?

The I would give the stability a rating of 8/10.

What do I think about the scalability of the solution?

It's highly scalable, I would say.

How are customer service and technical support?

We did use technical support. You just call Oracle support and they are good.

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

We have been using Oracle database for a long time. We prefer Oracle database, because it is more stable and has lot of support for most of the application. When looking for a vendor, I look to see if it a stable solution, if it has good support, and if the initial installation is well-documented.

How was the initial setup?

The setup gets complex sometimes, when you don't use the products that are supported. If I used REL, versus Oracle Linux, you get no support on Oracle Linux, rather than REL.

We couldn't go for Oracle Linux, because we have everything on REL. That took time to setup.

Which other solutions did I evaluate?

We chose Oracle because it has more features than the other products. The integrations points are easy. It is better than many other products because it has better integration.

What other advice do I have?

I think they'd need a little bit of training, but once they know the ins and outs, it is more robust. As long they have the training, and understand the basic architecture, and then it is easy to use.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user522033 - PeerSpot reviewer
Oracle Exadata /Oracle 12c Multi-Tenant/Oracle Golden Gate Consultant at a computer software company with 1,001-5,000 employees
Real User
With multi-tenancy, you can set up background processes and memory at the container level.

What is most valuable?

The most valuable feature we have found is the multi-tenancy. You can set up background processes and memory at the container level, not at the pluggable level. he second thing is, I can set up a disaster recovery solution for the container database, not at the pluggable level, so that if I have more pluggable databases, I do not need to worry about disaster recovery setup at the pluggable database level. I only have to set it up one time at the containment level. I can reduce my time, effort, cost, everything. I feel this is one of the best features in 12c, multi-tenancy.

Another valuable feature Oracle has released is the Flex ASM in RAC. In 10g and 11c, if something goes wrong for you with A, some instance, your database will go down. But in 12c, if something goes wrong for you with A, some instance, your database will not go down. You automatically use the next two machines, A, some instance. These are two wonderful features that we have used in database 12c.

One more very cool feature is called Information Lifecycle Management, ILM. It is one of the best features right now.

How has it helped my organization?

Instead of maintaining multiple servers, multiple databases, multiple disaster recovery solution setups for several levels, if you implement the 12c multi-tenancy, I only have to set it up for one container, not for all of the pluggable databases. I can reduce my support, my time, my effort, my cost, my server cost.

What needs improvement?

Upgrades.

For how long have I used the solution?

We have been using 12c for 10 months.

What do I think about the stability of the solution?

We have been using it for the past 10 months. We have not had any stability issues, at all. We updated the PSU patches, just the CPU patches; it's up and running for months.

What do I think about the scalability of the solution?

We haven’t exactly scaled it right now. Once we upgrade the remaining databases, we can go ahead with scaling it.

How is customer service and technical support?

We raised a couple of SR requests with the Oracle team, and they responded quickly. We have successfully upgraded one database to 12c.

We are really pretty happy. In the coming months, we are going to upgrade three to four databases to 12c. I attended an Oracle OpenWorld conference to get some information about how I can upgrade with nearly zero down time. I was looking for that.

How was the initial setup?

Upgrading it is not easy, because application to application could be different architecture. Before upgrading to 12c, we have to go into QA and development, from us to QA and development. Once that is successful, you can go ahead with production. Until now, out of six databases, we have upgraded to 12c on one platform; it was smooth.

What other advice do I have?

When you upgrade from 11g to 12c, consider your execution plans. Before upgrading, check it out in the QA and development environments. The third thing is, when you go about upgrading from 11g to 12c, plan how many databases you are going to make as pluggable, and how much memory it requires, and what flat file from exactly you are moving to upgrade. These are the three things you have to keep it mind when it comes to upgrading from 11g to 12c.

Although it is smooth coming into production, you have to be careful. Until now, it has been very smooth. We didn't raise any issues, but we have raised a couple of SR requests. Oracle has provided a smooth solution.

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: November 2024
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.