Compression Best Practices You Need to Know – From Proof-of-Concept to Production


Database & Infrastructure

Date and time






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

Talk Attendence: Attendance in person
Level of difficulty: General
Desirable listeners function: Data scientist , DBA , Manager
Group of activity: Database & Infrastructure

About speaker