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 🙂