We use this solution as a customer database for our client so all customer information is available through this product. I'm a senior professional security compliance officer and we are partners with Oracle.
Sr. Professional Security Compliance at a computer software company with 10,001+ employees
Endless capacity and a stable platform; licensing formulation is unfortunately complicated
Pros and Cons
- "The solution has an endless capacity."
- "The licensing formulation is too complicated."
What is our primary use case?
What is most valuable?
I like that the solution has an endless capacity, there are no limitations and it's a stable platform.
What needs improvement?
The licensing formulation could be improved; it's too complicated and very rigid.
For how long have I used the solution?
I've been using this solution for a very long time.
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?
It's a stable solution but there are bugs which I think is related to standards compliance. There are limitations in monitoring.
How are customer service and support?
Technical support is somewhat limited.
How was the initial setup?
The initial setup was complex. Compared to the implementation of Microsoft SQL, we needed skilled people to manage Oracle. Implementation took some weeks.
What other advice do I have?
I think this is a good solution because it's easy to administer and manage but it requires the right skilled people. It's not ideal for our requirements but it's improving, whether it's encryption or security, I know they'll get there eventually.
I would rate this solution a seven out of 10.
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
Senior ERP Developer at a university with 1,001-5,000 employees
We have our students, HR, payroll and financial all in one database.
Valuable Features
You can do just about anything with Oracle Database.
Improvements to My Organization
We use it for everything. We have our students, HR, payroll and financial all in one database.
Room for Improvement
We use a third party software called illusion banner on top of the customization that we have, so we wait for their improvements or do customization ourselves.
Use of Solution
I have been using the product for 14 years. I started with Oracle 7.
Stability Issues
I have never had an issue with stability.
Scalability Issues
It needs to be scaled based on how you're using the app.
Customer Service and Technical Support
I have reported few bugs. They do good job, and there are often solutions available on the Internet.
Initial Setup
We have downtime during upgrades that can last from hours to days. The last database update took two or three days.
Other Advice
All I can say is to trust Oracle. I would rate it a ten 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.
Data Modeler at a financial services firm with 1,001-5,000 employees
It brings reliability and security to our environment.
Valuable Features
The most valuable features for us in our experience has definitely been the security and reliability it brings to our environment. We know that our data is safe and secure and that Database is incredibly stable. There's a peace of mind that it affords us.
Improvements to My Organization
Because it's secure and reliable, we can have confidence that we can just go on with business as usual. We're able to focus our efforts on more important aspects of our business instead of worrying about threat protection and lost data.
Room for Improvement
I've been very happy with the progression of the product. One thing I would like to see is a better feature set for pluggable databases, that is, the multi-tenancy of the database. It's still in its infancy at the moment and I'd like to see in 13c a big leap forward with better support for multi-tenancy.
Use of Solution
I've been working with Oracle databases for over 16 years.
Deployment Issues
We haven't had any issues with deployment.
Stability Issues
Database has always been solid. There's been a couple little buggy things at the beginning, because I was working with version 7, but from 8i onwards, everything was solid.
Scalability Issues
There's absolutely no problem scaling it. They give you plenty of options and a lot of best practice in order to be able to do that.
Customer Service and Technical Support
I've always been very happy with Oracle support. I think probably the one thing that I'd like to be able to have is more input into is the feature set for the next release.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
IT Specialist at a government with 1,001-5,000 employees
The most valuable component of the new version 12c is the additional processing power it provides.
Valuable Features
As we're already Oracle customers, we're upgrading from version 11g to 12c. The most valuable component of the new version 12c is the additional processing power it provides.
Improvements to My Organization
For what we primarily do, we do heavy processing of OLTP and OLAP. We've used DB for some additional success in that regard.
Room for Improvement
The middleware, particularly Oracle Fusion, is what concerns us most and what we think needs the most improving.
Deployment Issues
We've had no issues with deploying it.
Stability Issues
There have been various stability issues so far, but the main concern, again, is the middleware. We're looking for some improvements in those areas.
Scalability Issues
We've had no issues scaling it for our needs.
Customer Service and Technical Support
We use technical support all the time. Whenever we run into any issues, we open up Oracle SRs. We get responses and we integrate them into our system, and we generally close out the issues successfully.
Initial Setup
I've been involved in all of our major upgrades and it's never straightforward. There are always complications because of the complexity of it all.
Other Advice
You probably need to consider some onsite support as much as possible because I'm not sure if the SR process is the best way to go. You probably need some expertise right there onsite that's familiar with your specific firm or agency. It's always difficult if you're just doing SRs.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Database Manager at a tech company with 51-200 employees
A powerful Relational Database Management System that offers a large feature set
Valuable Features:
• Oracle ensures high level security by performing each transaction in isolation from others. The database management as well as user management of oracle is very effective
• Provides data consistency as well as data concurrency.
• Oracle database guarantees that the data returned by a single query is committed and consistent with respect to a single point in time.
• Supports very large size databases. So it is very beneficial for multinational organizations having billion of records.
• Oracle database ensures high level availability by providing solutions for fixing problems rapidly and minimize both planned and unplanned downtime. These solutions help enterprises maintain business continuity 24 hours a day, seven days a week.
Room for Improvement:
• Due to its high cost, oracle is not the first priority for the organizations having budget constraints.
• A full time oracle Administration staff is always needed for the complex configuration of oracle.
• After installation, oracle drains lot of memory causing slow performance of system
• Oracle is not popular with open source code. MYSQL is a better option.
Other Advice:
Oracle is a powerful relational database management system that ensures high level security, consistency and data concurrency. Oracle architecture is split between the logical design and the physical design. This structure means that for large-scale distributed computing, the data location seems local and transparent to the user, allowing for a more modular physical structure that can be added to and altered without affecting the activity of the database, its data, or users. The sharing of resources in this way allows for very flexible data networks whose capacity can be adjusted up or down to suit demand, without degradation of service. It also allows for a robust system to be devised as a single point failure can’t bring down the whole database across a network.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Presenter at a consultancy
Beware: Need to monitor disk space
One thing that is annoying is the need to monitor the disk space available. In Oracle, the DBMS can monitor the utilization of a data file(s) but when the data files become full, the DBMS cannot just add a new data file and continue. Everything comes to a deadly halt. This approach makes no sense because the solution is just to add a new data file. So all that Oracle has to provide for are the parameters we want for all data files that are added "automagically" and we do not then run into such deadly issues.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
We have a script which monitors space left based on what the user_segments reports as used. We have also started to use bigfIle tablespaces.
IT Architect at a tech vendor with 11-50 employees
Reliable, feature-rich, and secure
Pros and Cons
- "I like the enterprise features as well as the stability."
- "I believe that the simplicity of installation and configuration for logging in to Microsoft and PostgreSQL could be improved."
What is our primary use case?
We use Oracle Database for banking and data warehousing.
What is most valuable?
I like the enterprise features as well as the stability.
What needs improvement?
The pricing model and scalability could both be improved.
The level of global support given could be improved.
I believe that the simplicity of installation and configuration for logging in to Microsoft and PostgreSQL could be improved.
For how long have I used the solution?
I have been working with Oracle Database for 20 years.
What do I think about the stability of the solution?
Oracle Database is a stable product.
What do I think about the scalability of the solution?
When it comes to scalability, Oracle Database is not at the top, but it is better than some of its competitors.
We have hundreds of users in our organization.
How are customer service and support?
The local support is fine, but the global support is terrible, and not worth the cost.
Which solution did I use previously and why did I switch?
Previously, we used IBM products.
We are also using Microsoft.
We use PostgreSQL, but it is not currently in production.
What's my experience with pricing, setup cost, and licensing?
The pricing model could be better.
When using this solution, there are no additional costs.
What other advice do I have?
I would recommend PostgreSQL for long-term use.
I haven't seen an alternative if they need a reliable and secure solution for a mission-critical quality control system, because Microsoft lacks enterprise features and PostgreSQL isn't well-established in banking.
I would rate Oracle Database 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.
System Specialist at a university with 501-1,000 employees
Easy to use and install, but the security and support need improvement
Pros and Cons
- "Oracle Database is easy to use."
- "Security is an area that needs to be improved."
What is our primary use case?
This solution is used for the collection of data.
What is most valuable?
Oracle Database is easy to use.
What needs improvement?
Security is an area that needs to be improved.
For how long have I used the solution?
I have been using Oracle Database for years.
We are using version 12.2
What do I think about the stability of the solution?
Oracle Database is a stable product.
What do I think about the scalability of the solution?
We have several thousand users in our organization.
How are customer service and technical support?
The support response time could be faster.
Which solution did I use previously and why did I switch?
Previously, we used IBM Db2.
We used IBM Db2 within the last year.
How was the initial setup?
The initial setup was straightforward. It was easy to install.
What other advice do I have?
I would recommend this solution to others who are interested in using it.
I would rate Oracle Database 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.
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?
ok great, you are using best of breed RDBMS technology