In this session, we will discuss best practices, gathered from users across the globe, related to index and data compression. We will also discuss how Basic, Advanced Row, Hybrid Columnar and Index Compression are enabled for new and existing database objects and how Automatic Data Optimization (ADO) enables data to be compressed in place. We will also explore how Automatic Data Optimization can be used to create policies to automate storage tiering and compression tiering -- based on the actual usage of tables and partitions. This session will also discuss how Compression Advisor, included with Oracle Database 11g Release 2 and above, can be used on any Oracle Database platform to estimate data, index and LOBS compression ratios.
