Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Advanced Compression - Automatic Data Optimization

MLalloMar 20 2019 — edited Mar 21 2019

I need some clarification about ADO.

It's clear for me that it's an automatic compression (for example it compress data after 30 days of table "inactivity" based on policy settings) but it's not clear form me this situation:

I've a oracle 12 database with 4TB data already allocated.

If I would like to use ADO I have not space saving because I've already allocated the space. Is it correct?

For example I create a new table after enable ADO (30 days) about 100GB of data.

After 30 days if I don't modify the table ADO compress it. Right?

But in this case I don't reclaim (save) space because I've already the 100GB allocated when i create the table and for example other 50GB of new compressed table....

Regards,

Mario

Comments

Processing

Post Details

Added on Mar 20 2019
#advanced-compression, #data-warehousing
3 comments
509 views