What is our primary use case?
We work with a bank and our core banking application sits on Oracle Database. Most of the applications in our ecosystem are all developed on Oracle RDBMS, so Oracle Database. They are all running mostly on Oracle Database. I'd estimate that 75-80% of our applications all run on Oracle Database in our environment.
What is most valuable?
The solution has been around for a long time, so it's very mature. We've used various versions, from 8 to 12 c. The RDBM has a strong reputation.
The solution is able to run on different types of machines, from IBM AIX to UNIX.
The solution has very robust integrity due to how it is designed and implemented.
The security is very tight. Users can be very sure of Oracle's safety. It has a variety of different security layers that make it very, very safe.
Oracle offers a great disaster recovery tool called Oracle Data Guard, which is fantastic.
The solution has very good failover capabilities. You can do it manually or automate the process if you like. It's all very transparent.
You can query around the rack as well you call it the rack cluster. There's great availability. It helps to handle high availability within the nodes. Even if you have a problem with one server, the others are still available and will continue the job without going down.
We work in a back-end environment that is mission-critical, and we cannot afford downtime. Oracle is a perfect solution, as it will never go down. Customers will always be served at any point without experiencing a delay, which is of vital importance to banking.
Oracle is constantly working to improve its products. It now offers AI and machine learning capabilities to run queries.
There's lots of research and development being done constantly. This ensures they are always one step ahead of other databases.
What needs improvement?
The solution can be quite expensive for small and medium-sized enterprises. Not too many companies can actually afford the pricing.
The way it is designed, there are a lot of constraints on the solution. Everything doesn't just happen at once.
Oracle doesn't handle SQL. You can use other products for that instead, including another Oracle product. If you need SQL, you can use MongoDB, MariaDB, or the Cassandras.
For how long have I used the solution?
I've been using the solution for fifteen years now.
What do I think about the stability of the solution?
Oracle Database is 200% stable. Most of the time when you have issues, it's not with Oracle but with the applications that are running on it that are not properly tuned. Oracle, however, if absolutely reliable.
The causes on the application end need to be properly looked at and tuned up properly, to reduce the overhead costs that are there. The loads are something we can have effect if we need to, and that's where we usually see problems.
What do I think about the scalability of the solution?
We do a lot of scaling. When we need to scale, we need to go through the Change Application Board at the company to make sure everything is properly documented, and everyone is made aware of the changes. When you scale or make changes on the system, it doesn't lead to downtime. that's extremely important to note. We use a rank model where you do changes one node at a time.
Ultimately, the solution is very easy to scale.
How are customer service and technical support?
We are satisfied with technical support.
However, people need to know how to manage Oracle support. Around here, we added what we call Advanced Customer Support, Oracle ACS. This is white-glove service for items that are of critical importance.
With Advanced Customer Support, if they need to fly down, they will fly down and come directly to you to help you look at further into very critical issues. With their premier support, which is still quite good, I would rate them 90%, however, with ACS, I would rate them 100% satisfactory.
Which solution did I use previously and why did I switch?
I've worked with other databases in the past.
In terms of the ruggedness of the database, especially in relational databases, I find Oracle design very strong. I want to believe that so many of the other databases that started coming up were trying to imitate what Oracle had. However, when you talk about databases holding data, they are managing very large databases, Oracle is still what you would want to go for.
For smaller data, there are other relational databases that are good. However, if the customer must have a response that will be like the speed of light, then you still have to go for Oracle.
How was the initial setup?
The difficulty of the initial setup varies. It depends on the company and who is setting it up. The truth of the matter is that you need a little bit of experience to be able to manage Oracle. That is why not every Database Administrator that does it for Oracle is a specialist in running it on a Unix level environment. Once you are able to get to that level, there is a pretty good graphical user interface that brings you through the selection process. You need SPS to do some form of tuning.
Were paid to set up the solution appropriately. We try to mitigate any performance issues and to lay out the parameters. You really need to look at memory and to look at your LGA to have a successful implementation. It all requires quite a bit of knowledge. You can't just be experienced in databases; you need to be experienced specifically in Oracle. In that sense, overall, it's not too straightforward.
To deploy the solution, the amount of time also depends on a lot of factors, including the person's experience with Oracle, and the company's overall requirements. With my experience, I can do it within a few hours.
For deployment, you would need a small team to assist in the process. You must always ensure the continuity of the business, so it's smart to not just rely on one person. If your database has two terabytes of data, you'll need a solid team with a minimum of five people on it. That way, everything is managed competently and everything is proactively monitored. For the bank, we have a team of 15 people managing the entire database for the group.
What's my experience with pricing, setup cost, and licensing?
This solution is definitely geared towards larger enterprises. It's quite expensive.
What other advice do I have?
Currently, we're using the 12c version fo the solution and we're migrating over to the 18c version soon. We're mostly using the on-premises versions, however, we're likely to migrate over to the cloud in the future.
Having used other products, I can say that hands down Oracle DB is a fantastic product.
I'd rate the solution nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.