Oracle DB12c for OLTP or DWH usage

We are using Oracle Database 12c with version 12.2.0.1. Our database administrators upgraded our Oracle Database 11GR2 (11.2.0.1) with ease and started to use our environment with the expansion of new features and tighter security. We are using Oracle Database 12cR2 in the entire company and business users did not understand the upgrade process. As an architect, I used adaptive query optimization and online stats gathering as the new features which address my performance issues. As a developer, an increase of size limit on VARCHAR2, NVARCHAR2 data types, and inline PL/SQL functions and procedures helped me a lot. But having Identity Columns replaced my sequences. As a database administrator, online migration of table partitions or subpartitions helped me to move a part of the table without any deduction of any service. DDL logging helped me to log any type of DDL operations (such as truncate, drop partition or any other DDL statements).