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
Friday, April 4 • 08:30 - 09:15
P35 Something Old, Something New: Leveraging Oracle 12c’s Information Lifecycle Management (ILM) Features for Improved Database Performance

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

Oracle Database Release 12cR1 introduced dramatically new capabilities for Information Lifecycle Management (ILM). Oracle DBA and Oracle University instructor Jim Czuprynski will delve into how best to leverage these transformative features to improve query and DML performance in an Oracle 12cR1 environment.

Through presentations and online demonstrations, this session will explore how best to:
- Leverage different storage tiers for inactive and active data to increase query performance via 12c’s In-Database Archiving (IDA) features
- Store past (and future!) data within the same table simultaneously via 12c’s Temporal Validity (TV) features without having to load or unload old and/or new data
- Dramatically increase application accessibility to your most crucial data without ever interrupting DML activity by leveraging Oracle 12c’s Online Move Partition (OMP) features to create, combine, split, and move data between different partitions of a partitioned table
Via live demonstrations against an Oracle 12cR1 database instance, Jim will explore 12c’s ILM features as well as provide SQL*Plus scripts, code examples, and Enterprise Manager 12c screen shots so any attendee can immediately begin to take advantage of these features.

1. Information Lifecycle Management (ILM): Architecture and Terminology
2. In-Database Archiving (IDA) Concepts
3. Leveraging Storage Tiers for IDA Data
4. Temporal Validity (TV) Concepts
5. Using Online Move Partition (OMP) For Seamless DML
6. 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 →

Friday April 4, 2014 08:30 - 09:15
Auditorium 1 Color Magic