And to add to this there was an ER created to look into providing a way to
disable advanced compression.
Bug 14079401 : CUSTOMERS NEED A WAY OF DISABLING THE ADVANCED COMPRESSION
FEATURE
I do not believe there are any plans to implement it though
Ta
Fairlie
On Sun, Nov 19, 2017 at 3:22 PM, Stefan Knecht <knecht.stefan@xxxxxxxxx>
wrote:
The advanced compression option is extremely difficult to not accidentally
use. It's literally everywhere:
- Datapump export (but only if you compress the data, metadata-compression
is "free")
- Data Guard redo compression (which you can conveniently enable in the
broker which may lead people to think it's a broker-feature and has nothing
to do with the advanced compression option inside the database)
- Securefile compression
- Table & Index compression (this one is kinda obvious)
- Flashback archives with OPTIMIZE DATA turned on
- Heat map features in 12c
- RMAN Backup compression (anything other than 'BASIC')
- Online partition move (even to basic compression - this one is really
evil)
- ... and there's more: https://docs.oracle.com/
database/122/DBLIC/Licensing-Information.htm#GUID-AB56CEE3-
955E-4E56-8B44-6075E889C283
It's a really sneaky way of pushing this option into so many different
things, and make it really easy to accidentally trigger it somewhere.
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat
| @zztat_oracle
