Oracle 12c R2 is the best Oracle release yet
October 25, 2017
Oracle 12c R2 is the best Oracle release yet
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database 12c
Oracle 12c R2 has proven to be the apex of Oracle database development in terms of features and speed. For example in memory tables are now about 4.5X faster than in 12c R1 while consuming even less memory. This has greatly improved our data warehousing initiatives.
- In memory feature has been improved substantially
- Database tuning and optimization less time consuming (i.e. more self tuning than before)
- Query optimizer seems to have once again improved such that existing apps simply run faster
- Oracle enterprise manager for database management still time consuming as OEM is a production app all by itself
- Price for enterprise edition add-on such as partitioning, in-memory and such are simply too expensive
- The optional diagnostics and tuning packs simply need to be part of the database (i.e. not optional cost add-on)
- Positive - some apps or portions of those apps just run better/quicker due to improved query optimizer
- Positive - spending less person-hours managing the database for tasks such as tuning, optimization and configuration tweaking
- Positive - 12c R2 just seems to have fixed everything that was not 100% in 12c R1 while still adding tons of new features
- ibm DB2 and micrsoft sql server
While there are several very good relational databases, some are offered by companies where the database is not the key focus. Even though Oracle's software portfolio has expanded greatly over the years, they remain keenly focused on database technology.