Oracle Database is cloud ready, not only for the software standardization, but also for the scripting. You can install Oracle Database software, patching, and create/configure Oracle databases in silent using scripts. Therefore, you can easily automate everything in cloud.
Team Leader at a tech consulting company with 501-1,000 employees
It provides Exadata, the engineered system where you can achieve maximum performance
Pros and Cons
- "You can install Oracle Database software, patching, and create/configure Oracle databases in silent using scripts"
- "Performance is the best key value. Oracle provides Exadata, the engineered system designed for Oracle Database, where you can achieve maximum performance."
- "Upgrade is the most critical phase for the lifecycle of a database. In order to be sure that the migration succeeds, you need to be up-to-date. Therefore, regularly install the patchset and security updates."
- "Be informed of the known issues using My Oracle Support."
How has it helped my organization?
What is most valuable?
Performance is the best key value. Oracle Database is suitable for OLTP applications or data warehouse. You can run Oracle Database software on-premise or in the cloud. Also, Oracle provides Exadata, the engineered system designed for Oracle Database, where you can achieve maximum performance.
What needs improvement?
Upgrade is the most critical phase for the lifecycle of a database. In order to be sure that the migration succeeds, you need to be up-to-date. Therefore, regularly install the patchset and security updates.
For how long have I used the solution?
More than five years.
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 stability of the solution?
No. The most critical error was due to a bug on database policies, so selecting it got the wrong results.
What do I think about the scalability of the solution?
No issues.
How are customer service and support?
I would give technical support a seven out of 10 rating.
Which solution did I use previously and why did I switch?
As of now, I use different database solutions depending on the use case (for example, MySQL or Microsoft SQL Server).
How was the initial setup?
It is not complex, but you need to be aware of the best practices provided by Oracle. Therefore, I recommend to read the official documentation before starting a new Oracle installation. Also, be informed of the known issues using My Oracle Support.
What about the implementation team?
If it is the first time implementing, contact a partner or an expert in order to install/configure your Oracle Database. This is the best way or think about Oracle PaaS in the Cloud.
What's my experience with pricing, setup cost, and licensing?
Not in my scope.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner since 1998.
Program Manager (Software Asset Management) at a financial services firm with 5,001-10,000 employees
Mature product means there are many who have the skills to use it
What is most valuable?
- It's a leading relational database brand; that makes it valuable
- There's a good amount of knowledge on the market
- Availability of skills
- It's quite a mature product
- Very advanced now
- Market leader.
What needs improvement?
It is already a market leader. The latest comparison to products like SAP HANA, and in-memory computing, and container computing, container-based database structures; these are the areas where I think there is good competition.
For how long have I used the solution?
I've been using it about 20, 25 years.
What do I think about the stability of the solution?
It's a very stable solution. You have to configure it to your requirements. It's one of the leading databases. You can have a mission-critical database system to make it available 24/7.
We have 24/7 platforms, from development databases to mission critical databases, they all run on Oracle.
What do I think about the scalability of the solution?
Very scalable.
How is customer service and technical support?
Good. Their normal ticketing system, their incident management system is quite responsive. All their large accounts have a technical Account Manager. You have your OCI, your Oracle Customer Identifier. Using your OCI, customers can put in their tickets, incidents.
What other advice do I have?
I would recommend it
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.
Associate Director at a pharma/biotech company with 10,001+ employees
Some features enable cloud technology. Technical support gets a high rating.
Valuable Features
It's probably one of the rapidly expanding database technologies in the world and has one of the best feature sets that an RDBMS can provide.
There are a lot of Oracle MR features that are pretty much unique in the database world. Some of them are pretty outstanding, especially those that enable cloud technology.
Room for Improvement
Everybody wants things to be faster and faster, so speed is one thing that probably they can improve.
Use of Solution
I have been using it for more than 20 years.
Stability Issues
It is very stable; I have not found any issues.
Scalability Issues
It is scalable; it will meet the company’s needs going forward.
Customer Service and Technical Support
On a scale of one to five, with five being the highest, I would say technical support is around five. They’re good.
Initial Setup
The upgrades are straightforward. I haven't seen any issues. It has been getting better, especially with these newer versions; especially with 11g and 12c. Of course, with 12c, it's much better.
Other Advice
When I select working with a vendor such as Oracle, they have to be reliable, with a good reputation. They have to have a good support organization. They have to be cheap, fast and scalable.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
DB Admin with 5,001-10,000 employees
Multitenant Architecture reduces operating cost and it could lead to license cost savings depending on the aggregation of DBs.
What is most valuable?
The most valuable feature of the product for me is the Oracle MTA (Multitenant Architecture) because it can reduce dramatically the operating costs. And, it could lead to license cost savings depending on the aggregation of DBs.
First is operating cost down. There is a lot administrative work, even if there is only one DB, such as backup, tuning, monitoring and patching. DB Integration with MTA contributes to reducing operating costs. Using Oracle MTA, we can operate above actions to multiple database with just one operation. So we can reduce operating cost.
Second is license cost down. With Oracle MTA, we can reduce license cost. Because we can integrate MTA server(s) from a lot of Oracle servers.
How has it helped my organization?
Using MTA, the development environment can be easily prepared. Efficient maintenance such as patching and backup to multiple environments can be carried out in a single operation. Also it can be easily migrated to the cloud environment.
In the same user, it is suitable in the test and development environment. And it is also suitable for databases with large numbers of environments.
For how long have I used the solution?
I have used this solution for over 13 years of pre-sales activities as engineer of Oracle products in the company-wide organization. Recently, I'm in charge of DB security, DB In-Memory, Multitenant and Oracle Cloud.
What do I think about the stability of the solution?
I did encounter issues with stability. But it was the first release (12.1.0.1). Now, MTA is quite stable at the latest version.
What do I think about the scalability of the solution?
We didn't encounter any issues with scalability. We can use MTA and RAC (Real Application Clusters) in combination, so it can also meet scalability requirements.
Which solution did I use previously and why did I switch?
Previously, instance consolidation and schema integration was the mainstream. However, instance consolidation can consume a lot of resources, and schema consolidation entails a cost for application modification. MTA has resolved these challenges.
How was the initial setup?
Although the setup itself is not significantly different, we needed a little consideration to configure multitenant designs, such as security settings and operation design.
What's my experience with pricing, setup cost, and licensing?
High DB consolidation ratio leads to reduced license costs, regardless of the Enterprise Edition and Oracle multitenant option license. In addition, running costs should be considered.
There is a lot administrative work, even if there is only one DB, such as backup, tuning, monitoring and patching. DB Integration with MTA contributes to reducing operating costs.
Which other solutions did I evaluate?
We did not evaluate other options, because there are no other options. Oracle Multitenant is the only option.
What other advice do I have?
The current optimal use case is test and development environment. If you would like to use MTA in advance, you can check it out on Oracle Cloud (PaaS). Because Oracle Cloud can be used as a prepaid system, you can try a variety of optional features without caring about the license costs.
Oracle Database is the industry standard product for a long time. This has been achieved precisely they provide what the customers really want in every new version.
Disclosure: My company has a business relationship with this vendor other than being a customer: My company is an Oracle Platinum Partner.
Chief, Application Management Branch at a government with 501-1,000 employees
We appreciate the fact that Oracle Database is the industry standard for RDBMS solutions.
Valuable Features
We like and appreciate the fact that Database is the industry standard for RDBMS solutions. Because of this, we know that the product is constantly being developed and improved in terms of functionalities and stability. It's very stable and a very secure place to store data.
Improvements to My Organization
We know that it's an investment that gives us peace of mind. It's mature and has a broad community of users.
Room for Improvement
There are a lot of features that I'm just not sure of yet in their ability to provide us value. I'd like to try a rack implementation and a replication-type software, though I'm not sure of their ability to add value. A more specific area of improvement, would be in technical support. It needs to be better, especially for Oracle's flagship product.
Use of Solution
I've been working with it since the 90s, going back to 733.
Deployment Issues
We don't have any issues deploying it.
Stability Issues
We haven't had any issues with crashing or downtimes or anything due to the product. It's been very stable, and there's not really even a thought of it being unstable.
Scalability Issues
Some of our bigger projects that are non-E-Business Suite, like SAP implementations, go up to five terabyte databases and there no problems scaling there. We've had no issues with inability to scale.
Customer Service and Technical Support
Technical support is definitely challenging as they are not always the most forthcoming with information, nor are they the most highly-trained techs when you open SRs. There have definitely been issues there, especially compared to the costs that you pay for the support.
Other Advice
There's always room for improvement, but we're happy overall.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
New Technologies Manager at a tech services company with 501-1,000 employees
I like its ability to be tuned so that we can gather data and our developers can build their code in it without too much hassle.
Valuable Features
The most valuable feature is its ability to be tuned so that we can gather data and our developers can build their code in it without too much hassle. Oracle Database has a lot of memory and other parameters that you can specify in the .ORA file and tune.
Room for Improvement
They should make new releases more stable, rather than waiting for the product to mature and releasing patches. Also, they should improve their tech support so that it's more consistent.
Also, I'm looking for more security. They give you a lot of options, but they all cost extra. I'm hoping that in the enterprise edition they include some of those options at no extra cost as standard features. It's already expensive as it is.
Use of Solution
I've been using it for 20 years.
Deployment Issues
We've had no issues deploying it.
Stability Issues
The newer releases always have bugs and issues, but as the releases mature, they become stable. Take 11g R1, for example, which is a good product, but it initially contained a lot of bugs and kinks. 11g R2 was a lot more stable with many of the issues worked out. There were still some bugs, but they were minor and fixed with patches.
Scalability Issues
We have used it in rack environments where we use it with Oracle Clusterware and Oracle Grid, and we can scale it.
Customer Service and Technical Support
Technical support, in our experience, is both good and bad. There have been times when we log an issue and the feedback we get or the support we're getting are just not good. But the there are times when within an hour or two we get the right feedback. So I guess it all depends on the engineer who evaluates the ticket and receives it and works on it.
Other Advice
Oracle Database is definitely a great tool. If you're looking for a database technology or tool, you should definitely use Oracle Database. There are many other databases in the market, but I think Oracle has really matured its product over the last ten years. It has a lot of options that do cost extra, but there are a lot of security options in there that are built-in, such as encryption, transportable table spaces, etc.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Vice Director of IT Department at a financial services firm with 1,001-5,000 employees
For me as a DBA, the most important features are the partitioning option, active data guard, and security options.
What is most valuable?
For me as a DBA, the most important features are the partitioning option, active data guard, and security options. All of these are very useful for my daily workflow.
How has it helped my organization?
Oracle Database is the core of our enterprise information system, which I maintain.
What needs improvement?
I think Oracle 12c has a lot of new functionality that has never been in the previous versions I work with, 8i to 11g, for example, master-slave architecture where you can plug and run multiple databases from a single master database as well as the ability to create a container database (CDB) that contains all the Oracle-level data and data dictionary.
For how long have I used the solution?
I have used it since 2000, so more than 15 years.
What was my experience with deployment of the solution?
All the issues I dealt with during deployment have been related to other applications and not the Database itself. All of the issues were fixed by programmers during the deployment and test implementation phases.
What do I think about the stability of the solution?
All the issues I dealt with in regards to instability have been related to other applications and not the Database itself. All of the issues were fixed by programmers during the deployment and test implementation phases.
What do I think about the scalability of the solution?
All the issues I dealt with in scaling it have been related to other applications and not the Database itself. All of the issues were fixed by programmers during the deployment and test implementation phases.
How are customer service and technical support?
Oracle has an excellent knowledge base and, using this, I fixed over 90% of issues myself.
Which solution did I use previously and why did I switch?
I have experience with Microsoft SQL Server 2008 and 2012, but my main activity is Oracle RDBMS.
How was the initial setup?
Initial setup steps are very straightforward and clearly set out in the documentation.
What about the implementation team?
I have experience with implementation both through a vendor team and in-house. I would strongly recommend to have a very clear understanding of how an applied system works because the most issues you will have to deal with are with the applied logic, and not with the Database itself.
What was our ROI?
It depends on applied information system and what kind of RDBMS features and options have been used by your development team or by the vendor.
What other advice do I have?
If you want to have a high-performing, stable, secure, and scalable system, you will choose Oracle Database.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Lead Oracle / Peoplesoft DBA at a government with 1,001-5,000 employees
In our experience, Oracle Database is highly stable, which is the best part of it.
Valuable Features
The key and most valuable feature of any database solution is its stability. In our experience, Oracle Database is highly stable, which is the best part of it. It's certainly much more stable than Microsoft SQL Server.
Improvements to My Organization
The biggest improvement to our organization is that with ODB's stability, it gives us back our time and attention to deal with more pressing issues. We know that we have ready access to our data with ODB, and that it can be relied on.
Room for Improvement
Although ODB is stable and reliable, to make stable and reliable it has to be carefully planned because it's complicated. You really have to know how Oracle works in order to not make mistakes that compromises the DB's functioning. You have to know what you're doing and you should make sure your entire team is familiar with the documentation.
Deployment Issues
We've had no issues deploying it. Again, you have to be careful, though, because it's complicated.
Stability Issues
Stability is a 5 out of 5. Again, ODB's stability is its best and most important feature for us.
Scalability Issues
Scalability is a 5 out of 5. We've been able to scale it for our needs.
Customer Service and Technical Support
Technical support isn't perfect. I give them a 4 out of 5.
Initial Setup
I found setup to be complicated depending on how it's to be used. For us, it was complicated but we knew what we were doing.
Other Advice
There's a lot more to Oracle, and it's not as simple as you think. It's not like anybody can go and install it because you need to know what you're doing. As a team, you have to go through all the proper documentation.
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?