What is our primary use case?
I have been working with Oracle products for more than 10 years, and as a consultant, I did a lot of implementations that include different database vendors. To be honest, Oracle Database provides you with different features that don't exist in any database, or you can find relevant features in other vendors, but it will not give the same capability Oracle Database has. Let's take for example RAC or real application cluster that provides HA for Oracle Database, it's considered as one of the best solutions for the database.
I have worked on different environments for different big client names since it's my job role, and Oracle provides a different solution for DR, performance tuning, security, and HA.
How has it helped my organization?
Talking about this will be unfair because regarding my experience (which is on related services), Oracle Database improved client solution by discussing what they want first, and then finding what database is the best solution for them. Most of the time an Oracle Database license is so expensive if you want to compare it with different vendors, but on the other hand, if you're looking for the best features that a database could provide to you, then Oracle is considered as the number one database of all time.
What is most valuable?
- The most valuable feature for me is the pluggable database because it provides database consolidation and the solution for utilizing your resource. On the other hand, I find security products that are provided by Oracle very strong and not in comparison with any database vendor.
- The encryption, database reduction, audit vault, database firewall: All of these products provide an extra layer of security when they are implemented in the right way.
- Let's also mention real application cluster, and disaster recovery solution.
What needs improvement?
The additional features that should be included in the database: I would like to see improvements for database security products.
For how long have I used the solution?
More than five years.
Which solutions did we use previously?
Yes, I used a different solution. The migration was to Oracle because we had to find the best for the client. It was a production database, and we needed 24/7 HA which other databases provided, but not as good as Oracle Database.
What's my experience with pricing, setup cost, and licensing?
The cost of Oracle Database is so high if you compare it to other vendors. Therefore you have to study your solution and know exactly which features you want; this will minimize the cost and licensing price. For that, Oracle provides different types of DB such as EE, SE, SE1, etc. depending on what the clients want.
Which other solutions did I evaluate?
Yes, I worked on SQL Server, MongoDB, MySQL, and MariaDB.
Disclosure: I am a real user, and this review is based on my own experience and opinions.