OUGN Vårseminar 2014

Oracle Database Release 12cR1’s new Automatic Database Optimization (ADO) features now make it possible to automatically locate data within the most appropriate storage tier and at the appropriate compression level based on its usage patterns. Oracle DBA and Oracle University instructor Jim Czuprynski will demonstrate how to take advantage of these features to speed queries and DML while still saving crucial Tier 0 and Tier 1 storage space.

Through presentations and online demonstrations, this session illustrate how to:
- Automatically gather your database’s hottest, lukewarm, and ice-cold data into appropriate storage structures for most and least frequently accessed data using Oracle 12c’s Heat Maps
- Automatically migrate your data to more appropriate storage structures when its access patterns change over time
- Improve query and DML performance against heavily-updated segments versus read-mostly segments
- Monitor access patterns of “hot” versus “cold” data to insure that the appropriate ADO policies have been deployed

1. Automatic Database Optimization (ADO): Architecture and Terminology
2. Just How “Hot” is Hot? Using Heat Maps
3. Setting Up Heat Maps for Maximum Effectiveness
4. Storage Tiering Concepts
5. Applying Compression to Lukewarm, Cold, and Frigid Data
6. Monitoring ADO Policies vs. Expected Effectiveness
7. Conclusions