Re: Oracle License for Optional Packs Question
From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Sun, 19 Nov 2017 11:22:28 +0700
Message-ID: <CAP50yQ9mgPx2f5XsGM7oPxVHDQ4LNUqdOQ90EMHwg9vTE_xvEg_at_mail.gmail.com>
Date: Sun, 19 Nov 2017 11:22:28 +0700
Message-ID: <CAP50yQ9mgPx2f5XsGM7oPxVHDQ4LNUqdOQ90EMHwg9vTE_xvEg_at_mail.gmail.com>
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 | _at_zztat_oracle -- http://www.freelists.org/webpage/oracle-lReceived on Sun Nov 19 2017 - 05:22:28 CET