Database 12c offers great new features
October 04, 2019
Database 12c offers great new features
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database 12c
Oracle Database 12c is used by multiple departments at our company. It is the backend database for a number of applications that we run, both Oracle provided applications and supported applications. It addresses the performance and daily functions of our business. We use it for a variety of functions from customer-facing to internal apps.
Pros
- Oracle 12c offers many new features that are performing well. Online partitioning has been a large benefit that was not offered in past versions.
- From a larger perspective, I think that Oracle 12c Database offers better performance than Microsoft SQL Server does.
- Oracle 12c allows the ability to restore just one table via RMAN and that allows us to save time.
Cons
- Oracle 12c has some slight differences from version 12.1 to 12.2 that have forced us to recode or alter DDL to allow the same features to work.
- I wish that RMAN would error out at the beginning instead of the end when there are version discrepancies.
- I do not have hard numbers, but it has sped up our partitioning process by hours (maybe days).
- It allows us to save time on restores when only a single table is needed.
- Better monitoring features and visibility have made my job easier.
Oracle Database 12c is head and shoulders above SQL Server for what we need it to do, and the performance is much better. Oracle Database has been in place at our company for a while, and it was really a no brainer going to Oracle Database version 12c instead of another software platform.
Comments
Please log in to join the conversation