Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

why is my database showing advanced compression being used?

GlenStromMay 12 2015 — edited May 12 2015

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

This post has been answered by Srini Chavali-Oracle on May 12 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2015
Added on May 12 2015
3 comments
3,613 views