Database DataWarehousing (MOSC)

MOSC Banner

Compression Advisor and Compression Ratios

This thread is for discussion and questions about Compression advisor and compression ratios.

DBMS_COMPRESSION package gathers compression-related information within a database environment. This includes tools for estimating compressibility of a table for both partitioned and non-partitioned tables, and gathering row-level compression information on previously compressed tables. This gives the user with adequate information to make compression-related decision.

General Advice:

If Your DB Version is 11.2 and above, Please refer below document to know more about Compression advisor and usage of DBMS_COMPRESSION.GET_COMPRESSION_RATIO.

  • How to use compression advisor - 11.2 and above
  • How Does Compression Advisor Work? (Doc ID 1284972.1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center