Oracle 12c New Features

Oracle 12c New Features  

Compression - Auto compression with Heat Maps / Automatic Data Optimization

        This is for the first time in database mgmt, we gonna have intelligent compression. With the metadata in hand, oracle let's us know how is my data used by the applications. Based on my data usage heat maps are generated which are classified as

• Hot       -   Active Modifications - Last modified is less than a week's time.
• Warm  -   Moderate Modifications - Last modified is greater than a week and less than a Year.
• Cold    -   Nill - Last modified is greater than a year

When I look into a tablespace which is holding the tables shown in the picture (Heat Maps), Oracle 12c provides a clear data usage differentiation through heat maps. The EMP table is under HOT section as it is subject to modifications. But when we drill down into EMP table and look into its partitions Oracle 12c provides data usage details across partitions. 

Using these info, automatic data optimization creates policies to perform automatic data compression.

The compression levels are 
3x   - Advanced Row Compression
10x - Columnar Query Compression
15x - Columar Archive Compression

        Now with these advanced levels of compression we can load more data into memory, so does that mean are we heading towards in-memory database in Oracle 12c? Lots more features to be explored, watch out in this space :)




















Disclaimer - The views expressed are my own and not necessarily those of Oracle  and its affiliates or whom so ever.