Database Storage Optimization best practices, tips and tricks and guidance from Database Compression Product Management

Advanced Compression Proof-of-Concept (PoC) Insights and Best Practices

Gregg Christman
Product Manager

I was going to discuss rolling compression using partitioning but I think we’ll save that for a future blog. Instead, I thought we’d discuss what I believe is useful information for anyone currently running an Advanced Compression PoC , or anyone who is planning an Advanced Compression PoC in the future.

During my Advanced Compression session, at last year’s Open World, someone mentioned that an Advanced Compression focused document that discussed best practices, and provided some insights regarding performing an Advanced Compression PoC, would be very helpful.

That was a great idea, so I’m pleased to provide just such a document, please see this brand new document here:

Please note that this document isn’t meant to be a step-by-step guide to performing a compression PoC. Instead, this document is intended to provide best practices
learned from customer PoC’s and to provide insights to help plan your compression PoC, as well as help you understand the results of your PoC.

Some of the topics covered include:

- What is Useful to Know for Your Compression PoC
- Enabling Advanced Row Compression
- When Advanced Row Compression Occurs
Direct-Path versus Conventional-Path Inserts
- Index Key Compression/Advanced Index Compression
- What to Consider for Before PoC Testing Begins
- Direct-Path and Conventional-Path Loads and AWR

- RMAN Compression
- More about Compression, Performance and Compression Ratios
- What does the Typical Compression PoC Look Like?
- Example of Compression PoC as a Multi-Step Process

Even if you’re already a user of Advanced Compression, you’ll want to review the Advanced Compression PoC document, it has a number of insights regarding Oracle
compression that you will find useful. Please leave comments regarding anything else, that should be included in this document, which you believe would be
useful during an Advanced Compression PoC.

Also, next month (May), I will be presenting at the Great Lakes Oracle Conference (GLOC) in Cleveland Ohio. If you’re planning on going to GLOC, please stop by for my
session titled Insiders Guide to Getting the Most Out of Database Compression and ILM which is scheduled for
Thursday, May 18, 2017, at 2:45 pm - 3:45 pm. This is a great opportunity to get all your questions about Oracle Compression and ILM answered by Product Management.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.