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

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

Gregg Christman
Product Manager

I was planning to discuss three ILM-focused features of Oracle Database 12c, but, I think we’ll save that for January’s 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 this 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!

Please see the link below for the Advanced Compression POC Technical Brief.

See 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 some 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 Before POC Testing Begins
- Direct-Path and Conventional-Path Loads and AWR
- RMAN Compression
- More about Compression, Performance and Compression Ratio’s
- 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 might want to review the document as well, it has a number of insights regarding Oracle compression that you will find useful. Please leave comments regarding anything else that you think would be useful to include in this document that would help during an Advanced Compression POC.

For now the database storage optimization adventure continues my next blog, in which we will finally discuss three ILM-focused features of Oracle Database 12c.

Happy Holidays!

Join the discussion

Comments ( 1 )
  • JohnA Friday, April 2, 2021
    The link to the pdf is blocked
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.