We use Oracle Database in our company for finding data.
Data Scientist at a insurance company with 11-50 employees
Helpful support and reliable
Pros and Cons
- "The technical support is good, we have responses to our problems."
- "Oracle Database required some time to learn the basics and how it works. However, this is typical for database solutions."
What is our primary use case?
What needs improvement?
Oracle Database required some time to learn the basics and how it works. However, this is typical for database solutions.
For how long have I used the solution?
I have been using Oracle Database for approximately three years.
What do I think about the stability of the solution?
Oracle Database is stable.
Buyer's Guide
Oracle Database
December 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
What do I think about the scalability of the solution?
Oracle Database is scalable to a limit. It depends on the use case and other factors.
How are customer service and support?
The technical support is good, we have responses to our problems.
Which solution did I use previously and why did I switch?
I have used SQL Server.
How was the initial setup?
The deployment of the database takes approximately two hours.
What about the implementation team?
We have used an integrator for more difficult implementations. However, we have implemented Oracle Database.
What's my experience with pricing, setup cost, and licensing?
The price of Oracle Database is high and could be reduced.
What other advice do I have?
We know that Oracle is a little bit expensive and there are other solutions that we can use to reduce costs. For example, there are some features in Oracle Database that we don't use and we probably do not need.
I rate Oracle Database a nine 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 System Administrator at Debre Markos University
A scalable and easily installable solution for storing and retrieving information
Pros and Cons
- "The solution is scalable."
- "The solution could have better security and integration."
What is our primary use case?
I made personal use of the solution for my projects. Customers use it as a database to store and retrieve information.
What needs improvement?
The solution could have better security and integration.
For how long have I used the solution?
We have been using Oracle Database for a couple of months.
What do I think about the scalability of the solution?
The solution is scalable.
How are customer service and technical support?
I have never contacted tech support.
Which solution did I use previously and why did I switch?
We did not use another solution prior to Oracle Database, although we do use MySQL.
How was the initial setup?
The solution is easy to install, although I don't recall how long this took.
What's my experience with pricing, setup cost, and licensing?
There are no licensing costs because the solution for me is open source.
What other advice do I have?
The solution is cloud-based.
I would recommend it to others.
I rate Oracle Database as an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Oracle Database
December 2024
Learn what your peers think about Oracle Database. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Information Technology Manager at OrchidaSoft
Easy to set up with lots of features and in general good to work with
Pros and Cons
- "The initial setup isn't too difficult."
- "The main issue with Oracle is the maintenance required."
What is our primary use case?
We use this solution based on the requirements of a client.
How has it helped my organization?
We primarily use it for a client that has a huge amount of data and has another application that also has lots of data. It's very good at handling jobs that have huge datasets.
What is most valuable?
I'm not a regular user of the solution.
It's a great product overall.
The initial setup isn't too difficult.
The product does have a lot of features. However, I've barely explored them.
What needs improvement?
The main issue with Oracle is the maintenance required. They should work to make it less maintenance-heavy. This is especially true if you are using it on Linux. You need more experience and skills in order to maintain it on Linux in general.
We've had corruption occur if the power gets cut off. We had a bad experience with some cases. However, this might have been due to our own infrastructure issues that have since been dealt with.
For how long have I used the solution?
We've used the solution for three or four years.
What do I think about the scalability of the solution?
The solution isn't widely used by our company. I'm the only one testing it. The people in our company don't use Oracle at all.
How are customer service and technical support?
I've never directly dealt with technical support. I cannot speak to how helpful or responsive they would be. Whenever I have a problem or issue, I google it and search for answers online.
How was the initial setup?
While I don't have much personal experience, my understanding is that the initial setup isn't too difficult. It's pretty simple and straightforward.
In our organization, we don't use Oracle, aside from in labs. We use Oracle in our labs just for testing and connectivity. We have versions of Oracle in our labs and other SQL devices.
What's my experience with pricing, setup cost, and licensing?
We don't really use the solution too much in the company and therefore don't have a license. We test it for customers. I can't speak to the licensing process or costs.
What other advice do I have?
I'd rate the solution at an eight out of ten. It's mostly been a positive experience, working with the product.
Between Oracle and SQL, I would recommend SQL to other users and companies.
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.
Operations Director at ALTERSIS Performance
Good support, works well for self-service portals and information systems
Pros and Cons
- "The most valuable feature is that it is a complete product with all of the functionality that you need, and there is no need for any special features."
What is our primary use case?
We are a system integrator and Oracle Database is one of the products that we implement for our clients. We have good knowledge when it comes to Oracle integrations.
There are many use cases but it is most often used for specific software development projects, such as portals. We have some enterprise portals, for example, and it is also useful for self-service applications such as payments or other requests.
It is often used for information systems.
What is most valuable?
The most valuable feature is that it is a complete product with all of the functionality that you need, and there is no need for any special features.
For how long have I used the solution?
We have been working with Oracle Database for a couple of years.
What do I think about the scalability of the solution?
We have approximately 10 customers who are using Oracele.
How are customer service and technical support?
Technical support is perfect.
How was the initial setup?
The installation is quite straightforward. As long as you follow the proper process, there is no problem with it. Typically, it takes three or four hours to deploy.
For security aspects, our customers prefer an on-premises deployment over a cloud-based one.
What about the implementation team?
We have two database administrators who are responsible for maintenance. One is a senior-level engineer and the other is a junior.
What's my experience with pricing, setup cost, and licensing?
Our customers sometimes complain about the price of the license, as it is very high for them.
What other advice do I have?
I would rate this solution an eight out of ten.
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: Integrator
Associate Consultant Oracle DBA at ATOS GITSS Pvt. Ltd.
Good recovery manager, but needs support services for more production access
Pros and Cons
- "The features that we find most valuable are Data Pump, GoldenGate, and the RMAN (Recovery Manager)."
- "This product would be improved with Support Services for more production access."
What is our primary use case?
Our primary use for all Oracle Activity is to maintain and monitor six database servers.
How has it helped my organization?
For the past nine years, we have been supporting our client's company database fully with developer and database support.
What is most valuable?
The features that we find most valuable are Data Pump, GoldenGate, and the RMAN (Recovery Manager).
What needs improvement?
This product would be improved with Support Services for more production access.
For how long have I used the solution?
Four years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Technical Trainer at a non-tech company with 501-1,000 employees
Container Databases help reduce server sprawl and improve resource management.
What is most valuable?
Container Databases (CDBs) help reduce server sprawl and manage resources in a much better way. It's a feature that consolidates all your application data with Oracle database metadata, still keeping a strict role to manage each of them respectively. With the CDBs, it's become easy to deploy, clone and administer Oracle databases.
Application Continuity simply helps application to be highly available by doing a lot fewer application code changes.
How has it helped my organization?
It helped consolidate most of our database servers, and saved annual maintenance costs of up to 23% on physical servers.
What needs improvement?
Oracle could provide a few extra features as part of the standard offering in their main license.
For how long have I used the solution?
I have used it for a few years.
What do I think about the stability of the solution?
It depends on the kind of database solution you are applying, but I have not yet encountered any stability issues.
How is customer service and technical support?
Customer Service:
10/10 MOS Support is actually something you can heavily rely on.
Technical Support:Technical support is 9/10, very proactive and very helpful.
What's my experience with pricing, setup cost, and licensing?
Use licensing with caution, read the fine print. :) ?This is an important point and usually it's not skipped by the companies paying for the license. Nonetheless, Oracle supports your applications and database only if Oracle has certified the ?hardware and software that the companies have used to build and deploy their applications and databases on; which basically means that you have to use industry-standard hardware and software.
It is possible that your hardware is not supported or has been desupported for a specific version of the Oracle product, so just remember to read the fine print before you deploy your applications.
Which other solutions did I evaluate?
MS SQL Server was also under consideration, but we had more Oracle DBA's to work with and Oracle’s training requirements were also more favorable.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
President at a tech consulting company with 51-200 employees
It has been around forever, so the scalability is the most valuable feature.
What is most valuable?
Of course, it has been around forever, so the scalability of Database is, in my experience, the most valuable feature. The fact that there's so many applications written for it is great. We've seen others who have used other databases, but they don't have nearly the suite of applications and APIs to work with as RDBMS has.
How has it helped my organization?
It is such a mature product with the ability to handle many things. The newer version, 12c, has some features that people have been asking for. It was the same way going from 10 to 11 to 12, as they always seem to be listening to the customers and adding in some more features that they need.
What needs improvement?
With Oracle, the complexity of Database makes it a little bit more cumbersome. You're going to generally have more of a senior DBA to handle the intricacies when you get a large, very high, and intensive database that needs to be up all the time. You have to have a little bit more expertise in there.
What was my experience with deployment of the solution?
We've had no issues deploying it, but, again, it requires expert administration from a more senior DBA.
What do I think about the stability of the solution?
Usually, you don't see any stability issues, but that really depends on the level of expertise of the DBA handling it.
What do I think about the scalability of the solution?
There are no scalability issues, so long as the DBA is experienced.
How was the initial setup?
The more expertise you have, the more the interfaces and UI become straightforward and easier to use in the initial setup.
What's my experience with pricing, setup cost, and licensing?
If you look at the price point with it and how they structure the licensing, it is definitely going to be one of the more expensive ones. You do get everything with it because they throw everything in with the kitchen sink. If they could pare down the solution, then you could just choose the pieces that you want and maybe pricing might be a little bit more along the lines of what customers could use. It is definitely on the more expensive side.
What other advice do I have?
In terms of scalability, make sure it's going to be what you need. Know exactly what purpose you're going to be using your database for. I'm one of the few people who knows a lot of different kinds of databases and which is best for what you want to do.
Disclosure: My company has a business relationship with this vendor other than being a customer: We're partners.
Software Developer at a security firm with 501-1,000 employees
The small things that it does compared to the free alternatives are valuable. Its optimization could be improved.
What is most valuable?
I can't think of any specific features that are the most valuable, but all the small things that Oracle does compared to the free alternatives, such as MySQL, are valuable. I do appreciate having that power to do it. Even though 90% percent of the time I don't use those features, it's nice to have them should I need them.
How has it helped my organization?
It actually kind of fractured our organization. Half of us use Oracle for some things and the other half use MySQL for the other. I really don't care; I use both. We use Oracle a lot for authentication. I can't think of anything specific that is all that great about it. I'm not bashing Oracle, I just can't think of anything. I can't think of anything that makes me think, “Oh, we have to have it.”
What needs improvement?
I can't think of any but I know my manager was unhappy with certain features that we use, but we had to pay for those features along with a bunch of other ones that we didn't use. He wanted an option to not bundle a lot of the features. Other than that, I don't know the specifics about what he was talking about.
It's got a lot of good features, but at the same time sometimes certain niche things aren't mentioned. Some things break and I don't know why. Then when I Google it, there are thousands of reasons why they break, so it takes me a while to really pinpoint why. Its optimization could be improved a little bit, but it's good for the most part.
What do I think about the stability of the solution?
It's very stable, we've had no problems with that.
What do I think about the scalability of the solution?
For the most part, as long as you do your research and don't screw up your table structures, I don't have any scalability problems.
How are customer service and technical support?
I haven't used technical support; every issue I've run into I've been able to Google it and figure it out. I haven't had to call in or anything.
Which solution did I use previously and why did I switch?
I believe we used MySQL for a while, it was free and that was the only reason we were using it. It wasn't the most stable, it was a little slow, and it doesn't scale as well, so we decided to go with a more professional solution.
Which other solutions did I evaluate?
I don't know why we chose Oracle, but I know we were debating between Oracle, MongoDB, and PostgreSQL. For whatever reason, I'm not sure why my manager went with Oracle, but we did.
What other advice do I have?
Take cost into consideration and pick whichever really suits your needs. Every single database has its strong and weak points. I wouldn't say it's an end-all, be-all solution, but it just happens to work for us.
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: December 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 Adaptive Server Enterprise
SAP SQL Anywhere
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?
There is no doubt that multi-tenant feature is awesome and I have also implemented in my current project or peoplesoft HRMS upgrade , where user always request more DBs during the upgrade path.