This content has been marked as final. Show 1 reply
I wouldn't expect a lot of value in Advanced Compression but I've never tried it. Here is my reasoning with respect to not being optimistic.
A/C works by finding duplicates within a block. You don't mention a block size but assuming the standard 8K block ... how many duplicates do you expect to find? ... Even if you have 32K blocks (and there are issues with them I won't go into here) how many duplicates?
Granted this is not done at the level of level of visible characters but still I wouldn't expect a lot of value.
That said ... this is Oracle and the correct answer to almost every question is "it depends" so create a test schema ... test it ... find out ... and then update this thread so the rest of us know too. You might also want to test SecureFile tablespace compression. Thank you.