This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
Click and register at Eventbrite
View analytic
Thursday, April 3 • 16:00 - 16:45
P19 How Hot Is My Data? Leveraging Automatic Database Optimization (ADO) Features in Oracle 12c Database For Dramatic Performance Improvements

Sign up or log in to save this to your schedule and see who's attending!

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

avatar for Jim Czuprynski

Jim Czuprynski

Zero Defect Computing, Inc.
Jim Czuprynski is an Oracle ACE Director and has accumulated over 30 years of experience during his career in information technology. He has served diverse roles at several Fortune 1000 companies in those three decades - mainframe programmer, applications developer, business analyst, and project manager - before becoming an Oracle database administrator in 2001. He currently holds OCP certification for Oracle 9i, 10g and 11g. Jim is a... Read More →

Thursday April 3, 2014 16:00 - 16:45
Auditorium 1 Color Magic