We are using the solution for our online transaction system - that is debit cards - and we are using it for our loan origination system as well. There are two systems that are deployed on it and we are getting a good experience from it.
Head Of Information Technology at a financial services firm with 501-1,000 employees
Stable, with good technical support, but very expensive
Pros and Cons
- "The scalability is quite good."
- "They should be putting more emphasis on the Windows platform. Usually, they run very well on the Linux platform, however, their performance on Windows is a little bit lower quality."
What is our primary use case?
What is most valuable?
The Data Guard feature is the most valuable aspect of the solution.
The initial setup is pretty straightforward.
The solution is stable.
The scalability is quite good.
I have always found the technical support to be very helpful.
What needs improvement?
The solution is expensive. They should work at making the pricing more reasonable.
They should be putting more emphasis on the Windows platform. Usually, they run very well on the Linux platform, however, their performance on Windows is a little bit lower quality.
They have to work on their flashback feature. Right now, it is a cumbersome process.
It is actually very heavy on the storage. If Oracle could do something about it, that would be great.
For how long have I used the solution?
I've been using the solution for the last 23 years at this point. It's been over two decades. I've used it for a long time.
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?
The stability is quite 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 product is quite scalable. You can add as many servers as you would like to. It's not a problem.
The product is not deployed for the user base. It is deployed for the backend service. The amount of actual users is only one or two people.
We do not have plans to increase usage. The cost is too much of a factor now. I'm not sure if I will be using it anymore.
How are customer service and support?
Technical support has been great. I am satisfied with the level of service we receive.
Which solution did I use previously and why did I switch?
We have Oracle Database and SQL Central Server Database in our environment. We're moving to SQL based on the generally high cost of Oracle.
How was the initial setup?
The initial setup is very straightforward.
I'm very comfortable with Oracle as well, so for me, it was very, very convenient. I can't speak to the end-user or a user with the lower skillset in terms of their capabilities of setting it up. However, if you have some experience with Oracle, it's not bad.
The deployment only takes 45 minutes to an hour. It doesn't take long.
What about the implementation team?
I have installed it personally and it is very straightforward. However, it is possible to use an integrator or consultant to get the proper assistance.
What was our ROI?
We don't really calculate the ROI on the database itself. We calculate the ROI for the system. On whichever system is deployed on a database, we calculate it on a community basis. Therefore, of course, we get the ROI from whatever technology we deploy.
What's my experience with pricing, setup cost, and licensing?
While I'm a fan of Oracle as a solution, I am not a fan of the cost. It is very expensive.
For medium to small organizations, the current cost might not be viable as compared to SQL Server, which is much cheaper than Oracle and provides approximately the same functionality that they have.
You can choose a core-based license or a user-based license. There are no extra costs above the standard licensing fees. Typically it is a five-year contract that can be paid monthly or yearly.
What other advice do I have?
We are a customer and an end-user.
I'd advise those considering the solution to always keep their logs on a different database. Also, they have to make sure the parameterization they do in their initial setup is very, very extensively thought out.
I'd rate the solution at a seven 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.
Senior Database Administrator at ITGStore
A stable and scalable solution which is easy to install and offers great support
Pros and Cons
- "Optimization of databases, RAC, Data Guard Replication with Data Guard and RAC Database are the best features."
- "There is a new version of Oracle and Database Firewall, version 20, for which I would be interested in receiving training."
What is our primary use case?
For the Database solution, I'm working with the 12c version. For Security Solution, I'm working with Oracle based Audit Vault and Database Firewall, versions 12 and 20.
We use the solution in Cameroon, where I reside, for payroll purposes.
What is most valuable?
Optimization of databases, RAC, Data Guard Replication with Data Guard and RAC Database are the best features. The solution offers many features. We try to tailor the deployment to the needs of the company involved. Some need replication, others optimization and still others, RAC.
What needs improvement?
There is a new version of Oracle and Database Firewall, version 20, for which I would be interested in receiving training. For the moment, training is not an option. Having the time to undertake this does not pose an issue for me, as I would speak with my supervisor to allot the requisite time.
For how long have I used the solution?
I have been using Oracle Database for nearly four or five years.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
The version of the solution being employed today is definitely scalable.
How are customer service and technical support?
We work as a partner company with Oracle and have a representative in our region to whom we can appeal directly for collaboratively resolving any issues which may arise with our clients.
We are satisfied with the support. While we don't encounter issues on a daily basis, there has not been a single time that we have failed to resolve one when it has arisen.
How was the initial setup?
The installation does not take long. They have provided a simplified edition on the hardware and database of the latest version of Oracle Database Appliance, a product I have recently installed. It is quite user friendly and makes things easier than has been the case in the last five years. With the improved installation, the solution is now easy to install.
What's my experience with pricing, setup cost, and licensing?
The licensing costs are on a yearly basis, although I am a technicican and am not involved in this process. This is in someone else's purview.
What other advice do I have?
In NFC Cameroon the solution is deployed on-premises. When it comes to Oracle Database, certain companies are deployed on-cloud and others on-premises. We have yet to deploy on cloud.
We have many clients, ranging from medium sized to very large. We have assisted more than ten clients in implementing the solution in our data center.
I rate Oracle Database as an eight out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
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.
Consultant at a consultancy with 10,001+ employees
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.
Senior System Administrator / CyberSecurity Analist / SQL Server DBA at Glintt
A robust multi-model database management system
Pros and Cons
- "I like that it's a robust product. It has very good features. One good feature is Oracle REX because, in SQL Server, we don't have that. SQL Server has something similar, but it's not the same stuff."
- "It's not very user-friendly, and it's a little complex. Another issue that I don't like is the licensing complexity."
What is our primary use case?
We developed some products, and most of them run in Oracle because our company is an Oracle partner. In fact, we're using Oracle and SQL Server, and I have more experience with that (SQL Server). But the main core of the company is more related to Oracle.
How has it helped my organization?
More robust product
What is most valuable?
I like that it's a robust product. It has very good features. One good feature is Oracle RAC because, in SQL Server, we don't have that. SQL Server has something similar (SQL Server AlwaysOn), but it's not the same stuff.
What needs improvement?
It's not very user-friendly, and it's a little complex. Another issue that I don't like is the licensing complexity. It's because of the SQL Server. We have several distinct editions, and I know that if I get the Enterprise Edition, I will have all the products. But with Oracle, I can get the Enterprise Edition, but if I need some kind of encryption, I need to pay more. If I need some kind of replication, I need to pay more, and so on. Every time my team needs some of this stuff, we have to ask Oracle. So, what's the point of the license?
For how long have I used the solution?
I have been dealing with Oracle Database for more than 20 years.
What do I think about the stability of the solution?
I think it's a stable product, but we had to add some special patches in the past because of bugs in the product, especially on Oracle REX.
How are customer service and technical support?
We always have support from Oracle.
How was the initial setup?
The initial setup is more complex than SQL Server. SQL Server is very easy to set up and log in. Oracle is a little more complicated.
What's my experience with pricing, setup cost, and licensing?
Oracle Database is expensive. We also need to buy additional products.
What other advice do I have?
I would recommend Oracle Database to potential users. But I would tell them that it depends on their main goal. It depends on how they want to use the database. They also have to consider the costs because Oracle is more expensive.
On a scale from one to ten, I would give Oracle Database an eight.
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: Partner
Domain architect at a financial services firm with 10,001+ employees
Easy to set up on their engineered systems, but the support needs improvement and they are pricing themselves out of the market
Pros and Cons
- "It is easy to set up on their engineered systems."
- "It needs to be more stable, as recently we have experienced some issues."
What is our primary use case?
The primary use case of this solution is as part of our financial systems.
What is most valuable?
It is easy to set up on their engineered systems.
What needs improvement?
It needs to be more stable, as recently we have experienced some issues.
The support should be more customer-friendly.
The pricing should be reduced.
For how long have I used the solution?
I have been using Oracle Database for a few years.
We are using the latest version.
What do I think about the stability of the solution?
It used to be stable and scalable, however, we have had recent stability problems on the Exadata platform.
What do I think about the scalability of the solution?
We have the necessary number of people using the application.
How are customer service and technical support?
We have Oracle support but we are not satisfied with it.
It needs to be responsive, and more customer-friendly.
Which solution did I use previously and why did I switch?
We use different products for different requirements.
We are switching away from Oracle.
When it comes to storage, we are a large organization with many different databases. We haven't migrated between the databases, however, that is now starting to happen as we are moving off Oracle. We won't remove it completely, but we are moving away from it.
How was the initial setup?
It depends on how it is being deployed. For example, if you have multiple designs and you are deploying it on their engineered systems then it's not complex. But if you are running it on a traditional hardware system then it is slightly complex.
I don't know how long it would take to deploy on the monitoring systems, but on the engineering systems, it would take two to three hours.
What about the implementation team?
We did not use a consultant, vendor, or reseller to deploy this solution. We implemented the database ourselves. The engineering system is always done by Oracle, and we don't have a choice. Oracle always deploys the physical equipment.
We have a team of 12 to maintain this solution.
What's my experience with pricing, setup cost, and licensing?
They are pricing themselves out of the market.
What other advice do I have?
We will continue to use this solution in the future.
I wouldn't recommend Oracle Database to others who are planning to use it.
I would rate it a seven 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.
Manager at WSI
Reliable solution that is transparent to the end users
Pros and Cons
- "It is a reliable database warehouse solution that is transparent to the end user."
- "The pricing is the one sticking point for the solution because it is very expensive."
What is our primary use case?
I am an end-user of the Oracle database. The only use of Oracle is the repository of the data. So from the end-user side, it is transparent. A database is a good database if it does not slow down production or data processing. That the database prevents data from being exposed to any malware or any malicious scripting is a good idea. Oracle has these capabilities.
What is most valuable?
Oracle is simply a reliable data warehouse for us.
What needs improvement?
Our Oracle database is very expensive, so probably the cost is an area that can be improved. The cost of the product.
The actual features that might need to be improved is a question that is better answered by any IT person or administrator because they know specifically what are the limitations and what the challenges that they face in using the product or the brand.
On the end-user side, it is all transparent and we depend completely on the administration to care for the stability of the product. So we do not know what they experience on the administrative end as we are isolated from those issues. I don't know if the services are slowing down or if there's an issue and the product is not performing as expected.
If something happens and there is a switchover to using the back-up or something like that, we do not see any of that as end-users.
For how long have I used the solution?
I have been using the product for about 12 years with the same company.
What do I think about the stability of the solution?
I do not have any idea about the specifics of the stability because that is usually taken care of by the IT department. From an end-user standpoint, the stability is very good. At least that is the case for us as the IT department is doing their job.
What do I think about the scalability of the solution?
But definitely as of this moment, due to the COVID crisis, we are not going into the direction of expanding any software or hardware inventory. Everything was put on hold to maximize the usage of current assets.
But of course, Oracle is a scalable solution. We are hoping to go in that direction. If you have a solution that is not scalable, then you probably will be left behind. All software seems to be taking that direction in offering scalability and flexibility.
Oracle can be deployed into whatever architecture you have right now. Whether it be on-prem, on the cloud, or a mix or hybrid. Probably that is a good point for Oracle.
How are customer service and technical support?
I have not heard about any problems with technical support from Oracle and I also do not hear about any escalations regarding support from our IT department. I have not heard about any reports that the Oracle Database has been down.
So the product is good and the back-end support is good.
Which solution did I use previously and why did I switch?
We have been using this Oracle solution from the time that I arrived at this company so there has not been any other product in use.
How was the initial setup?
The setup is taken care of and maintained by the IT and administration.
What's my experience with pricing, setup cost, and licensing?
I am not exactly sure of the precise cost, but I do know that the cost of the product is very expensive compared to some other solutions. Even though we are in a third world country, we do not enjoy any discount for our situation and economy.
Which other solutions did I evaluate?
As far as I am aware this is the only product that was considered because of its reputation and performance.
What other advice do I have?
The advice I have for other people considering this solution is that if they have money then they should go for it. We do not experience performance issues or trouble with throughput.
It is probably a good idea to do some research for use in documentation which can be searched or located on the Internet. I think every company that is looking into creating value from their software assets, they have to do research or evaluation first on the Internet.
They should be sure, before making an investment that the product fits their requirements, probably they will contact a distributor or supplier to get the product.
The next important step would be the proof of concept. They must try to do a POC or work with a demo and see if the Oracle Database can solve the pain points that they are having right now.
One factor they can not forget is the budget. If the product fits their needs but not their budget, they will have to try to fit their budget to the product and make it work perhaps by scaling usage.
On the scale from one to ten, with one being the worst and ten being the best, I would rate Oracle Database as probably around and eight-out-of-ten. That is a good rating. The price is really the only thing which is holding it back from a better score.
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.
Head of IT Division at Industrial Property Institute
Easy to use, relatively straightforward to implement and very stable
Pros and Cons
- "I've never faced any stability issues with the product. I don't recall any bugs, glitches, or crashes. I'd say it's fairly stable and shouldn't cause anyone issues in that regard."
- "It could be slightly more intuitive, but other than that, we really like it as a solution."
What is most valuable?
One of the best aspects of the solution is that it is very easy to use. In my opinion, for how I use it, I find it quite straightforward.
What needs improvement?
Occasionally I do have some technical issues. However, there are very good communities that can help solve problems, so It's not too bad.
It could be slightly more intuitive, but other than that, we really like it as a solution.
For our type of usage, we don't have any particular requirements or needs that the solution doesn't provide. I can't speak to any features that may be lacking in general. Right now, I don't find that it's lacking in any regard.
For how long have I used the solution?
I've been using Oracle Database for about five years now.
What do I think about the stability of the solution?
I've never faced any stability issues with the product. I don't recall any bugs, glitches, or crashes. I'd say it's fairly stable and shouldn't cause anyone issues in that regard.
What do I think about the scalability of the solution?
We are working with the software that moves the current update store. We don't have problems with any new features or applications or integration, so I believe it to be very scalable.
Currently, we have about 3 people using the database. There is only one developer and the rest are admins that are simply connected to the database.
How are customer service and technical support?
We have never faced many issues in terms of having trouble with the solution. For that reason, we haven't really dealt with technical support, so I can't speak to how good or bad they are.
Which solution did I use previously and why did I switch?
We did previously use a different solution, however it was associated with a company that gave us the software and when they switched to Oracle, we, by default, did as well.
How was the initial setup?
At the beginning, I may have found it a bit tricky, and other new users might too. At this point, after a number of years, I don't think it's too difficult. However, it may be because I'm used to the system. Those coming at it completely new may find it a bit complex.
The initial setup is quite quick. For us, it didn't take more than an hour or so. It was probably less than that.
What's my experience with pricing, setup cost, and licensing?
I don't deal with the accounting, so I can't speak to the pricing of the solution.
What other advice do I have?
We're not an Oracle partner. We're just a customer.
We're quite comfortable with this solution at the moment. It provides us with everything we need.
I'd highly recommend Oracle Database to other companies and users. We haven't had any issues at all using it aside from a few small technical issues. It's good software. It's very stable and reliable.
Personally, I would rate the solution nine out of ten. It's almost perfect.
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.
Oracle DBA at Roketsan Missiles Inc.
It has had a multiple-concurrent-user control system from the very beginning.
What is most valuable?
Oracle Database has had a multiple-concurrent-user control system from the very beginning. Most enterprise database solutions have recently become aware of this. Oracle's approach was the true approach to isolate users. Databases have some isolation levels and some anomalies. Oracle's database has solved them in a very brilliant way. From the beginning, 20 years ago, Oracle solved those problems. It is the most ACID-compliant database.
It has a multiple-concurrent-user control system, and it is the most ACID-compliant database.
How has it helped my organization?
We have the opportunity to easily open service requests and get answers from the professional Oracle teams. We have the advanced customer support team in Turkey. If there is a problem, it is easily and elegantly solved. It adds value; we trust Oracle.
What needs improvement?
We have not been using the new release yet, we are running on 11g. We haven’t had much opportunity to deeply examine 12c yet.
See my comments in the initial setup section.
What do I think about the stability of the solution?
Oracle database is stable. When Oracle slows down or if you can't use data, it means you are doing something wrong. The architecture is in the logs, the logging mechanism. If you know how to configure the database, it is impossible for you to lose data. It has the Data Guard disaster solution.
The Oracle database was first designed by people who left the Central Intelligence Agency. They knew how to implement security in the core of the database. I find it reliable and stable.
What do I think about the scalability of the solution?
We are using a three-node RAC database; it is highly scalable. If we want to add another node, we just buy the hardware and add it to the RAC system. It is highly scalable.
How are customer service and technical support?
When you have Oracle products, you have the right to use the Oracle support. We are able to open service requests. If it is urgent, we can open level-one service request. Somebody calls you and tries to find a solution to your problem. It is very useful.
Which solution did I use previously and why did I switch?
When I was hired by my current company, they were already using the Oracle E-Business Suite, which obviously works with same database.
How was the initial setup?
I myself installed the RAC database. I migrated from the old system to the new system with RMAN. We used the Oracle recovery tool to install the RAC and migrate our data to the new RAC system.
For those parts, to be honest, Oracle Database requires more effort than the other databases. It is a little complex. You have to know what you are doing. With RMAN, recovery, backup and restore - those kinds of operations - are a little bit more difficult than with other databases. You need slightly more manpower to run an Oracle database than the other databases.
Which other solutions did I evaluate?
The Microsoft SQL database now has an option to deal with data anomalies, for example, lost updates. Lost updates are a kind of anomaly with consistency. How do you support this with consistency? Those are all design issues. Microsoft has very recently implemented it in their database. There could be some anomalies in the database. You have to enable this option.
Years and years ago, Oracle already had this implementation designed into their database. I was working at a bank before my current company. The reason why they chose Oracle was the approach to data consistency.
What other advice do I have?
Oracle is the most ACID-compliant database, and it is the most professional proficient OLTP database in the world today.
Look at the prices for additional add-ons. For example, partitioning costs in Oracle are a little high and partitioning is a very powerful tool of Oracle Database. Be aware of that partitioning option.
Look at the disaster solutions, for example, because that involves a data dump. Look at whether it is SQL compliant or not.
Determine whether you really need an OLTP database. Oracle Database is an OLTP, ACID-compliant database, and maybe you do not need that; maybe you need some type of document-based database. It depends on how you conduct your business.
When I am looking at vendors to work with, tech support is very important. We are in Turkey and sometimes it is difficult to find a lot of companies. Oracle is very active in Turkey. In Turkey, the banking and telecommunications sectors are very heavily dependent on technology. Most of them are using Oracle technologies. Sometimes. we can't find support easily.
We also look for stability, of course.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
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 ToolsPopular Comparisons
SQL Server
Teradata
MariaDB
SAP HANA
IBM Db2 Database
Amazon Aurora
CockroachDB
LocalDB
IBM Informix
Citus Data
SAP SQL Anywhere
SAP Adaptive Server Enterprise
Oracle Multitenant
Oracle Java DB
Buyer's Guide
Download our free Oracle Database Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Looking for recommendations for a service contract to de-identifiy patient data in databases.
- Which cloud-native database is the most similar to Oracle?
- How do you run Oracle Database at your organization and why?
- Do you know of any disadvantages of Oracle Database?
- What is the best use for Oracle Database?
- Which solution do you prefer: Microsoft SQL Server's enterprise edition or Oracle Database's enterprise edition?
- What exactly can one do with embedded Oracle Database?
- What are the main differences between Oracle Database and SQL Server?
- IBM Informix vs Oracle Database 12g - are these products really the same?
- Which product would you choose: CockroachDB or Oracle Database?