What is our primary use case?
We primarily use the solution for the storing of data.
It can also be used for other purposes. For example, at the bank, and other financial institutions, they are using the database for transacting their information.
What is most valuable?
It's quite a big database. I have seen it in companies sized from medium to large enterprise-level. It also works for government organizations that are quite sizeable.
The solution is quite stable. When you work on planning for salaries, you can notice that Oracle is extremely stable.
It's a very flexible product. You are able to accomplish a lot of things.
It's extremely easy to use and the performance is great.
Oracle support is great. They are quite helpful when you run into problems. They help you overcome any issues. If you run into a bug, you contact support, and they solve it.
If you have a stored database with the five standards that Oracle recommends, you will never experience something like, your database being down.
What needs improvement?
The integration could be improved. If you are integrating with other Oracle products, it is fine, however, if your goal is to integrate with third-party products, Oracle isn't as good. There was a time when I was working on the other project and we were trying to integrate the database with Microsoft Active Directory. It was quite difficult to find a connection. We were eventually able to connect, however, it was quite difficult.
There's a new version right now. May have managed to rectify the issues with third-party integrations in that version. However, I haven't tested it yet.
For how long have I used the solution?
I've been using the solution for a couple of years now. It's been since 2010.
What do I think about the stability of the solution?
The stability is very, very good. There aren't really bugs and glitches, however, if there are, Oracle will help resolve them quickly. It doesn't crash or freeze. You never really have to worry about your database going down.
What do I think about the scalability of the solution?
It's a big database. There is lots of room to scale. The solution can work well for large-scale organizations.
Depending on the number of the requirements, in terms of information, if you want to change the memory or you want to expand the storage, it has the capability to do that. So It's quite a flexible database.
Oracle has done a tremendous job of really allowing companies to scale in and out as needed.
I've worked with many clients and they've been of varying sizes. the company I am working with right now has 200 users on the solution.
We do plan to continue to use the solution and to upgrade to the new version, 19C.
How are customer service and technical support?
We've used technical support in the past and they have always been very good. If you provide the information the way it's supposed to be presented - and that means being explicit in your issue - they can help you very fast.
How was the initial setup?
On-prem deployments take quite a long time. However, depending on what you want to achieve, it could go faster. Either you are doing the direct installation, which takes time, or you are doing a cloud deployment, and on the cloud, it takes less than five minutes to deploy. It's very, very fast.
We have about five people on our technical team that can handle deployment and maintenance tasks.
What about the implementation team?
I can handle the installation myself. I've done both on-premises and cloud deployments at this point and both I am able to handle quite easily. I do not need the assistance of a consultant or integrator.
What's my experience with pricing, setup cost, and licensing?
I work with clients and they are the ones that have to pay for the license. If they are using it for production purposes, they need to pay. I can't speak to the exact costs.
What other advice do I have?
While we mostly work with on-premises deployments, I've recently also tried the cloud deployment.
We work with a variety of versions, including 11G, 12C, and 18C.
I recommend Oracle. I always do. They are an excellent company with a very good product.
I'd rate the solution at a nine out of ten.
Everyone should keep in mind that the way of the future is to move to the cloud. Oracle is working to support this. They're encouraging everyone to move to the cloud.
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.
Im using oracle with my basic knowledge its been about 4 years and I think that oracle DB is a great product,
with pluggable DB, datapump utility, alerts, speed, etc..
except the princing wich is so expensive.