Compression Best Practices You Need to Know – From Proof-of-Concept to Production
Track
Database & Infrastructure
Date and time
-
Room
-
Duration
45'
Oracle Database provides innovative row and columnar compression technologies that improve database performance while reducing storage costs. If you currently use database compression, or are starting your planning for compression and a proof-of-concept, this session is for you. Join me to discuss getting the best results with data, index, LOB and backup compression, as well as how to determine the storage savings you can expect. We will discuss when compression occurs during bulk loads and DML inserts/updates, when to use Index Key (prefix) Compression versus Advanced Index Compression, how compression benefits RMAN backup/recovery times, what to compress and what not to compress, whether or not to compress your entire database and more best practices. Join me to help your organization achieve the best compression storage savings, and database performance.
Lecture details
About speaker
Gregg Christman, author
Gregg Christman is a Senior Manager in Core Database Product Management at Oracle responsible for Advanced Compression, Hybrid Columnar Compression and Information Lifecycle Management. Gregg has been with Oracle for 15 years, having previously held the position of Senior Director of Competitive Intelligence for Database and Data Warehousing. Before Oracle, Gregg was a Senior Product Manager for Enterprise Database Servers and the Senior Director of Product Management and Marketing for Cloudscape at Informix Software.