We are mainly using it for our business applications. Our main business application is the ERP application, and the other one is the payroll application. Both applications are developed on the Oracle platform. The ERP application covers our sales and marketing side, as well as manufacturing and finance.
Chief Information Officer at Cjp
A capable and stable solution with good security and support
Pros and Cons
- "The database capability and the security side of the database are the real valuable features. The cloud SaaS model is also valuable."
- "They can simplify and make the deployment more user-friendly. Deploying Oracle solutions requires a lot of technical input. If that can be improved, it would really add value to the business."
What is our primary use case?
What is most valuable?
The database capability and the security side of the database are the real valuable features. The cloud SaaS model is also valuable.
In terms of support, they are very supportive and always available.
What needs improvement?
They can simplify and make the deployment more user-friendly. Deploying Oracle solutions requires a lot of technical input. If that can be improved, it would really add value to the business.
There should be features related to business intelligence and business analytics. These features are not built into the database. They are separate. They can at least add basic analytics features to the database.
For how long have I used the solution?
I have been using this solution for a few years.
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?
Its performance depends on the data center you are connected to. At the moment, we are subscribed to one of the US data vendors. Other than that, it is very stable and highly available.
What do I think about the scalability of the solution?
It is scalable. Because we are using the cloud platform, it is very easy to scale it up. We have approximately 1,000 users.
How are customer service and support?
They're really good in terms of providing support and attending to the issues. I am satisfied with their support.
How was the initial setup?
Its deployment is quite complex, and it should be made simpler.
Its maintenance is minimal. You only need to take care of database patches, and you need to always follow up and update it on time. Other than that, when you configure it with the backup and all those things and automate, you don't need to worry much about the maintenance.
What about the implementation team?
We were doing it internally.
What's my experience with pricing, setup cost, and licensing?
Its price is a little bit high in terms of competitiveness. It is a little bit expensive. For any additional features, there are additional costs.
What other advice do I have?
I would recommend starting with the SaaS model cloud platform. You can start at a small scale, and then you can expand based on your requirements. You can start with a small investment and grow as your business is growing.
We are going to explore the autonomous part. It has already been improved. We'll start using that area, but because we are already using this one, and it is stable, we didn't try to use the autonomous side. That would be the area that would be most useful for us in terms of the SaaS solution.
I would rate it a nine out of ten.
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?
Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
jmitchell@natbankmw.com at NBM
Fast, very stable, and suitable for large sites
Pros and Cons
- "It is very fast. The response times are very fast."
- "Its price can be improved."
What is our primary use case?
It is for our core banking system. We are using version 19c, and the data is version eight.
How has it helped my organization?
All the database issues that we had have been resolved by using 19c. The database used to crash frequently, and now, that's a thing of the past. We haven't had any crashes in two months.
What is most valuable?
It is very fast. The response times are very fast.
What needs improvement?
Its price can be improved.
In terms of features, we've just started using it, so we haven't yet come up with a list of features to be improved.
For how long have I used the solution?
We have been using this solution for about two months.
What do I think about the stability of the solution?
It is very stable. We haven't had any crashes in two months.
What do I think about the scalability of the solution?
It is very scalable. In terms of its usage, it is used by our core banking system. So, it is used by one system. It is not used directly by people. We don't have any plans to increase its usage.
How are customer service and support?
It is quite good.
Which solution did I use previously and why did I switch?
We were using Oracle but on different infrastructure.
How was the initial setup?
It is complex, but it is doable. Our people were trained to do it and had the money to do it.
Its deployment did take long. We started the programming processes around August, and it went live only at the end of January.
What about the implementation team?
Oracle helped us implement it.
What's my experience with pricing, setup cost, and licensing?
It is quite expensive.
What other advice do I have?
It is a very good product, especially for large sites. I would rate it a nine 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.
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.
Lead Oracle Database Administrator at a insurance company with 10,001+ employees
One of the features that stands out to me is the Real Application Cluster. This gives us the ability to have active-active clustering functionality.
Valuable Features
One of the features that stands out to me is the Real Application Cluster. This gives us the ability to have active-active clustering functionality. We can scale horizontally to multiple database servers and instances, which gives us both High Availability and load balancing, great features both.
There's also the new In-Memory feature that allows us to do a lot of OLAP transactions.
Improvements to My Organization
As with any organization, before we embark on anything, we have to look at the ROI as well as the ability of a particular tool. Database is rock solid, which, of course, affects our ability to do work and provide customer service. We're a mutual fund company, so stability is really key in providing satisfactory customer service. Oracle Database really gives us this key factor from an IT perspective.
Room for Improvement
We'd like to see a few more security improvements. Security right now is a very, very big issue. Oracle is doing a very good job with security enhancements with each now releases, the latest of which, I think, is 12c release 2. But I'd really like for it to have a lot more security enhancements that are added to Database, rather than pushing the enhancements into some of their other tools that you have to buy in order to be able to take advantage of those enhancements and functionalities. Like I said, security really is key for us as we do a lot of encryption, so it would be best if the additional security features and enhancements were part of Database rather than part of some other product we'd have to buy.
Deployment Issues
Deploying it was no problem. We had no issues with it at all.
Stability Issues
Stability is not an issue at all. Oracle is a database company and Database, as their flagship RDBMS, is the product at the highest level of maturity.
Scalability Issues
It's scaled to our needs.
Customer Service and Technical Support
We have premier support from Oracle, so we have a very good relationship with technical support.
Initial Setup
It's the most mature Oracle product, so setting up the RDBMS was straightforward.
Other Advice
Despite the fact that it's the most expensive of the RDBMS solution available, there's a reason why Oracle Database has the largest market share. It's the best there is. If there's another RDBMS vendor that provides some functionality that Oracle doesn't, then you'd really have to evaluate what your true ROI will be. From my perspective, though, Database is worth it.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Sr. Database Consultant at IGT
It provides reliability, in terms of handling large volumes of data.
What is most valuable?
The most valuable feature is how evolved the solution is right now. It's been around for a while, and I think it's been servicing a lot of different use cases. I think it's really stabilized, evolved, and you can actually put it to use in multiple scenarios. It adapts itself just as well to most business use cases.
I think the best part about Oracle is it keeps evolving. It's not adding any more features to it. There's a big move toward custom cloud services - big databases in the cloud - and obviously there are people with apprehensions in terms of what will happen if that data is shared. They are working towards addressing that issue. They are kind of compartmentalized, and kind of made some of the domains private, to maintain the security for certain critical domains. You still have the power of using the cloud. That's the great thing about it: It keeps evolving. It doesn't stay still. It's very compelling.
It also provides reliability, in terms of handling large volumes of data. I don't believe there's another database server that people would pick. Given a choice, everybody would like to go with Oracle.
I think those are the two big features that really stick out.
How has it helped my organization?
It has definitely improved the way my organization functions. It's our database management tool. We have a lot of sensitive information. Different business verticals have a lot of sensitive information that they want to reliably preserve somewhere, and also be able to call back upon in a very secure manner. Oracle does just that.
At the same time, it has a lot of the algorithms where it tries to optimize itself in terms of how fast you can get the data out, and also how fast you can write to it as well. I think it's definitely improved and provides benefits to the industry; not just for the gaming industry that I'm part of, but generally for all verticals in the business world. As I’ve mentioned, it’s the database of choice for most business verticals.
What needs improvement?
I’d like to see them include a certain amount of intuitiveness in the optimization of the queries, and the algorithms for that could be better. There's still room for improvement in those areas.
One of the things that is also mentioned about Oracle is that with the RAC architecture, the storage is shared, and that sometimes becomes contentional. It's not so much the processing on the nodes; it's the data processing that becomes a point of contention sometimes – if they could do something so we can customize the RAC in some way, and also implement sharing, something along the lines of what Perl OOP has, where the storage is also exclusive to the nodes. I'm sure something like that can be brought in. Having mentioned that, I'm pretty sure they're already researching into it. That's something from my experience that can be improved.
What do I think about the stability of the solution?
I don't think you would pick another database for stability; for financial data, or anything related to money transactions, where you want to reliably store data, and you don't want to lose any data. You don't want to try to save something in the database and then go in the next day and not have it, obviously. Oracle is right up there in terms of stability.
What do I think about the scalability of the solution?
Obviously, the scalability factor was increased with the Oracle Real Application Clusters (RACs). You have multiple instances of Oracle, with the shared storage, so you can spawn multiple processes to do large volume data lifting. You don't want to rely on one instance alone. You don't want to load that one node alone. It can do everything. You can spread it across nodes. The RAC solution gives you that.
In terms of the data scalability itself, if you don't want a shared storage, you have solutions such as Exadata. It provides very good storage and gives you great performance.
In all respects, Oracle on all fronts is doing great, including scalability. I don't see any issues with it right now. As I’ve mentioned, the great thing about the product is that it keeps evolving and tries to improve.
I think it's great to have those features.
How are customer service and technical support?
Technical support is a little sketchy. It depends on who you get on any particular day. Oracle is a worldwide organization, so I guess there are certain sections that are not really well covered, in terms of building up a knowledgebase, and trying to go back and see how a problem was solved in the past, which should be an easy thing to do.
I think sometimes it comes down to doing that: going back, looking at the issue you are reporting, determining whether you've faced it before, and what the solution was. If there isn't a solution and if this issue hasn't been reported earlier, then be intuitive about it. That part was missing in the few instances where I've had the opportunity to call support.
As I’ve mentioned, it’s a worldwide organization. They're available around the clock, covering different time zones. All those aspects are covered. I think a little more intuitiveness in the solutioning for the support issues would go a long way in improving the experience.
Which solution did I use previously and why did I switch?
We previously used plenty of solutions. Oracle was an easy choice. If cost is not a constraint, I would recommend Oracle ten times out of ten.
How was the initial setup?
Setup is never straightforward. It's a pretty complex piece. I have actually overseen it, but it's mainly the database administrators, the DBAs, who actually worked on it. They do come back and work closely with us architects and engineers, in terms of how to best configure the infrastructure.
I wouldn't say that it is straightforward, but at the same time, it's been done so many times, there are so many use cases to fall back on. I'm pretty sure that if you get stuck somewhere, you will get the knowledge base, go back and get past that issue that you're facing at that moment.
It's all down to being so evolved. Oracle has been around for a while, so you have those benefits.
Which other solutions did I evaluate?
We moved from another solution, knowing the history of Oracle. We earlier conceptualized to be on Informix. Informix was one of the options we really considered. There wasn't much of innovation happening in Informix. It was more legacy. I think that is a reason why we moved to another database system that is more active with more innovation covering different aspects: scalability, data volume management and those kinds of things. At that point, Informix was definitely the only other option. Subsequently, we looked at other solutions such as MySQL for cost purposes, but having explored each of those, they don't really match up with Oracle for me; the scalability, the data volume management, those features, along with the reliability. There's a lot of hand-holding support that needs to go into those products to be able to match what Oracle offers.
What other advice do I have?
In terms of data security and reliability, if that is of paramount importance, I would definitely suggest Oracle. If cost becomes a factor, in terms of the licensing models I’ve mentioned, then probably I would recommend a cheaper solution - maybe even open source - but that comes with a tradeoff of the data not being reliable.
For financial institutions, financial organizations, you would not want to put your data at risk. I think it's tradeoff with those aspects when making your choice.
The most important criteria when I’m looking at a vendor such as Oracle are the support and licensing. I look at the licensing model, in terms of whether there are certain things that they can do to support a company like ours, who've been engaging with them for so long. We have different business models. If they can offer some licensing options that would be more attractive to meet those business models, maybe offer some innovative solutions, that's something that I would look for.
In terms of the support aspects I’ve already mentioned, there are specific business use cases we're trying to solve, and not just rely on the knowledge base that's already accumulated.
Those are some of the things I look for.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Principal Consultant at SandFil International
Enables us to support applications
Pros and Cons
- "We use Oracle Database to run applications. We use it for our clients' databases and applications."
- "The product is expensive."
What is our primary use case?
We use Oracle Database to run applications. We use it for our clients' databases and applications.
Whenever a client has problems or requires new implementations, they approach us. We provide training and coaching with application implementations. Currently, one such implementation is underway in the UK.
What is most valuable?
The product is very stable. We use it for supporting applications, including data warehousing.
What needs improvement?
The solution could be cheaper and adopt AI space.
For how long have I used the solution?
I have been using Oracle Database for 25 years.
What do I think about the stability of the solution?
The product is stable.
I rate the solution’s stability a nine out of ten.
What do I think about the scalability of the solution?
The solution’s scalability is good. It caters to small and medium enterprises with different products and ranges.
I rate the solution’s scalability a nine out of ten.
How are customer service and support?
Technical support could get better.
How would you rate customer service and support?
Neutral
How was the initial setup?
The initial setup is quite simple. We mostly use the installation pack and code pack. Our setup includes a script center, shell scripts, and commercial Java courses.
What's my experience with pricing, setup cost, and licensing?
The product is expensive.
What other advice do I have?
We use database clusters for different clients depending on the SLA. We use Oracle Clusterware and Oracle Advanced Compression. We use These specific options for various clients; however, the selection depends on the client's needs.
We have robust protection measures that are ensured using encryption technologies such as Transparent Database Encryption provided by Oracle. These features are available across all our database offerings, and we have implemented them for our clients accordingly.
We are heavily involved in AI development, and eventually, our products are tailored to fit into the AI space seamlessly.
Integrations are pretty transparent based on the type of solutions and the specific customer requirements. Customer relations between Oracle products are typically straightforward, whereas integrating with third-party products may present some challenges.
Overall, I rate the solution an eight out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
Last updated: Apr 3, 2024
Flag as inappropriateGroup CEO at Mmusi Group
A multi-model database management system with a useful reporting feature
Pros and Cons
- "The reporting feature was fine for what we were using it for. Oracle Database has been serving its purpose, and I was happy."
- "Their migration strategies could be better because most of these companies keep the same version for six or seven years and then update it to the latest version."
What is our primary use case?
I use Oracle Database for storage, proxy, and general database stuff.
What is most valuable?
The reporting feature was fine for what we were using it for. Oracle Database has been serving its purpose, and I was happy.
What needs improvement?
Their migration strategies could be better because most of these companies keep the same version for six or seven years and then update it to the latest version.
For how long have I used the solution?
I have been using Oracle Database for five years.
What do I think about the scalability of the solution?
Oracle Database is scalable. It simply comes down to how you design the transaction screen of the database. We have more than 100 users because they use the applications.
Which solution did I use previously and why did I switch?
Before Oracle Database, I used IBM Db2 and Microsoft SQL.
How was the initial setup?
The initial setup was straightforward. It doesn't take long once you have the server. I would say it takes a maximum of five minutes to implement this solution. We have five technical people to deploy and maintain this database solution.
What about the implementation team?
We implemented this solution by ourselves.
What's my experience with pricing, setup cost, and licensing?
The price is relative. Licensing costs differ based on how often you'll use the product. They also provide discounts based on the bandwidth or the use cases you want to run on it.
What other advice do I have?
I would recommend this solution to potential users.
On a scale from one to ten, I would give Oracle Database a nine.
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.
Business Development Director at a tech consulting company with 201-500 employees
Good database with decent performance
Pros and Cons
- "Oracle is a good database with decent performance, which is fortunate because we are required to use this database for our ERP system. Even if we thought Oracle was the worst database in the world, we would still have to use it."
- "In my opinion, the pricing of all the additional tools that Oracle provides is very complicated. The pricing model is very unfriendly for the user, and for the web vendors."
What is our primary use case?
We use Oracle Database for our ERP systems mainly because we provide IFS for customers and the IFS utilizes Oracle Database. We generally don't use other Oracle tools because of a bad experience with an R&D project in the past where we had to find the best solution for AI/neural network platforms.
We assessed using Oracle for these AI platforms, but we had plenty of problems with the proper setup of the test version of Oracle Cloud. Frankly speaking, we stopped testing and using Oracle in this R&D project and switched to other tools that are simpler to setup and simpler to understand the pricing. No one was sure how much would have to be paid for the platform to support our AI requirements such as natural language recognition and other things.
Because of these factors, we have essentially stopped using the other Oracle tools and we now only use Oracle Database for the ERP systems that we run for ourselves and for our customers. For this purpose, we use Oracle as a permanent database that is situated on-premises. We have quite a wide range of versions of Oracle Database amongst ourselves and our customers because many of them are older installations that are still operating. In all, there are about 10,000 users of Oracle Database throughout our customers, and perhaps 2,000 users in my organization.
What is most valuable?
Oracle is a good database with decent performance, which is fortunate because we are required to use this database for our ERP system. Even if we thought Oracle was the worst database in the world, we would still have to use it.
What needs improvement?
In my opinion, the pricing of all the additional tools that Oracle provides is very complicated. The pricing model is very unfriendly for the user, and for the web vendors.
When it comes to new features, we don't desire anything at this moment. We are completely dependent on this ERP system which we provide and we only need the tools from Oracle that our ERP system needs, and nothing more. Our only concern is the performance of the database. If Oracle could make the performance better on low-end hardware, that would be nice.
For how long have I used the solution?
I have been using Oracle Database for 10 years.
What do I think about the stability of the solution?
As far as I know, we have no problems with stability.
What do I think about the scalability of the solution?
The scalability is good.
How are customer service and support?
There have been no issues with their technical support. As I am aware, we have had issues in the past, especially with servers and other things, but today there are no special issues or problems. Everything is quite well-addressed by Oracle, in my opinion.
How was the initial setup?
The setup of the Oracle database for an ERP system is generally quite simple. There are specific installation steps that are completely scripted by the ERP system, so you simply have to do everything the documentation asks you to do, and that's all. There's nothing special or super difficult about it and we are generally able to install a database within a day.
What's my experience with pricing, setup cost, and licensing?
We mainly use a special license for ERP systems specifically, instead of a general purpose license. This ERP-focused license is very simple. You just have to use Oracle Database with an ERP system and that's it.
What other advice do I have?
As databases go, Oracle Database is quite a good database with decent performance, and I think that's all there needs to be said.
I would rate it 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.
Consultant at SmartCloud
Performs well, easy to use, and the technical support is quite good
Pros and Cons
- "In general, Oracle is quite good. It's a large database that houses many applications."
- "When you try to tell customers that you can critically patch their system, they always complain about the cost."
What is our primary use case?
Because I worked with various organizations, most of the time we used it for government and other centers, such as managing transport systems.
What is most valuable?
It performs quite well.
In general, Oracle is quite good. It's a large database that houses many applications.
In terms of backup Basically, I believe that will depend, particularly on backup and those components, on the knowledge that you have. However, if you have the proper knowledge, it should not be a problem for you. The database does not cause problems when properly configured and best practices of database administration are followed.
When compared to others such as Postgres, Oracle is a very good database.
Oracle Database is easy to use.
What needs improvement?
The only issue was the same as with the EDS licenses. When you try to tell customers that you can critically patch their system, they always complain about the cost. In terms of pricing, I believe Oracle should be aware of this fact. I'm not sure if it's because it's only happening here in Africa, but some of the guys I spoke with prefer to patch all the time. When you ask people in this town, "Look guys, can you critically patch the system?" they will tell you it's too expensive.
That, I believe, is a major issue. But with that solution, I'm not sure how it can be resolved, but I think most people will be willing to always do patches on a monthly, quarterly basis, as Oracle recommends.
They can increase the number of products available in free accounts for people to try. So many more people will be able to migrate to the cloud.
For how long have I used the solution?
I have been using Oracle Database for approximately five years.
We are using both old and new versions.
What do I think about the scalability of the solution?
Oracle Database is quite scalable.
They have a large number of options depending on the needs of the organization, allowing any organization to deploy according to their requirements. You can add or remove items as time allows, it's very scalable.
In our organization, we have more than 100, but less than 1,000 users.
Recently, I proposed the migration from on-premises to the cloud. I've noticed that alternatives are bringing a lot in the business, particularly in the cloud spectrum. Convincing customers to try to migrate to the cloud today is another task. It's more like there's something frightening there. I'm not sure what they're afraid of, but it's a matter of education and demonstration. I can download Oracle Database and experiment with it on my own, as long as I'm not using it for commercial purposes. I can do it if I try it on my own.
I believe they should increase that even in the cloud. They have an Oracle Always Free account on the cloud, but it has a time limit, of a month. They will give you one month's free package for you to try. I have tried it many times. What I've noticed is that they should add more products to the Always Free account so that people, particularly on our continent, who are still skeptical of the cloud, are not left out.
They believe they will inquire as to where we will store our information. How do you know you're getting access to our data? As a result, there is still a lot of information that needs to be taught. I think the best thing Oracle could do is try to improve on that so that most people can keep trying and see that there's nothing to be skeptical about.
How are customer service and support?
Technical support is quite good.
How was the initial setup?
The initial setup is quite easy. In part, it is easy depending on the scope of the project. Maybe it's different for each project. For example, if you need to set up a rec, you need to know what is required, because this is a single database.
It took a few hours to deploy.
What about the implementation team?
For my personal use, I completed the installation myself.
When deploying for production, I worked with a partner who had a specialized team of system administrators and application developers.
This solution is only deployed and maintained by me.
What's my experience with pricing, setup cost, and licensing?
It's been quite a long time since I looked into the price.
What other advice do I have?
I believe they should also devote more time to learning Oracle. They will also notice that Oracle is not difficult to install or administer if best practices are followed. And, depending on your goals, I believe anyone can do it. Because Oracle Database has so many features, you can do audit vaults and data guides on it, depending on how you want to run your business.
Another thing I would recommend is that people be aware that Oracle has opened its website for people to sign up for free and then download the software for practice, study, or training purposes only. If you intend to use it for production purposes, that is when you should purchase a license.
Because of the prices, I would rate Oracle Database a nine out of ten, otherwise, I think that Oracle is still the best.
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.
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?
I like the post. With lots of great features, there are few chances of data corruption in Oracle database.
We faced the corruption issue in our organisation. Stellar Phoenix Oracle Database Recovery software repaired the corrupt database. Read more about this software from here: www.stellarinfo.com