2 Replies Latest reply on Mar 21, 2019 7:50 AM by MLallo

    Oracle Advanced Compression - Automatic Data Optimization

    MLallo

      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