Doing some checks with the Oracle supplied scripts option_usage.sql & used_options_details.sql shows a couple of our databases using the advanced compression option.
At first I thought perhaps this was an option that someone forgot to uncheck during install, but I see this is not a configurable option during install.
I asked one databases vendor if it was used and/or necessary in the database and the answer was no - none of their table creation scripts had specified compression and the database was not designed to use it.
However, when I run the oracle supplied scripts above it shows that the database is indeed using advanced compression. When I query the dba_feature_usage_statistics table there is no listing for advanced compression but the heap compression (which I assume is advanced compression) shows up as being used a couple of dozen times, but not in the last year or more, here is what the detected_usages, first_usage_date, last_usage_date and currently_used columns show :
HeapCompression 17 04-MAY-10 25-APR-12 FALSE
HeapCompression 32 14-MAY-13 20-MAY-14 FALSE
Since none of the tables use it, I'm assuming these usages must have been data pump or something like that.
Since there seems to be no way to disable this option I'm wondering what to do to prevent usage of it, I don't want to be using something we're not licensed for & get in trouble over it.
thanks in advance