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, so I’m pleased to provide the link below to just such a document, please


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!

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.