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