{"id":200,"date":"2017-11-15T18:16:07","date_gmt":"2017-11-15T17:16:07","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/?p=200"},"modified":"2017-11-15T18:16:07","modified_gmt":"2017-11-15T17:16:07","slug":"check-advanced-compression-option-usage-on-oracle-database","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2017\/11\/15\/check-advanced-compression-option-usage-on-oracle-database\/","title":{"rendered":"Check Advanced Compression option usage on Oracle database"},"content":{"rendered":"

To check if the “advanced compression” Oracle database option was used on your environment is not so easy, as there are several activities that can activate this option.<\/p>\n

For example for a mix Oracle 11.2.0.4 and 12.1.0.2 environment we can use the following query:<\/p>\n

select * from DBA_FEATURE_USAGE_STATISTICS\r\nwhere ((name like '%Compress%' and name not in ('Backup BASIC Compression','Backup BZIP2 Compression','SecureFile Compression (system)')) \r\n  and detected_usages>0)\r\nor (name='Data Guard' and FEATURE_INFO like '%Compression used: TRUE%')\r\nor (name in ('Oracle Utility Metadata API','Oracle Utility Datapump (Export)','Oracle Utility Datapump (Import)') \r\n  and version like '11.2.%' and feature_info not like '%compression used: 0 times%')\r\nor (name in ('Oracle Utility Metadata API','Oracle Utility Datapump (Import)') \r\n  and version like '12.%' and feature_info like '%compression%')\r\nor (name in ('Oracle Utility Datapump (Export)') \r\n  and version like '12.%' and feature_info not like '%compression used: 0 times%');\r\n<\/pre>\n
Why do we need so many filters? Because the text that shows if compression was used changes depending on the utility and Oracle version!
\nBelow 3 different examples when compression was not used:<\/p>\n
\n\n\n\n\n\n\n
Version<\/td>\nUtilities<\/td>\nFEATURE_INFO text<\/td>\n<\/tr>\n
12.1<\/td>\nOracle Utility Datapump (Export)<\/td>\ninvoked: 1 times, compression used: 0 times (BASIC algorithm used: 0 times, LOW algorithm used: 0 times, MEDIUM algorithm used: 0 times, HIGH algorithm used: 0 times), encryption used: 0 times (AES128 algorithm used: 0 times, AES192 algorithm used: 0 times, AES256 algorithm used: 0 times, PASSWORD mode used: 0 times, DUAL mode used: 0 times, TRANSPARENT mode used: 0 times), parallel used: 0 times, full transportable used: 0 times<\/td>\n<\/tr>\n
12.1<\/td>\nOracle Utility Datapump (Import)<\/p>\n
Oracle Utility Metadata API<\/td>\n
invoked: 1 times, parallel used: 0 times, full transportable used: 0 times<\/td>\n<\/tr>\n
11.2<\/td>\nOracle Utility Metadata API<\/td>\ninvoked: 1 times, compression used: 0 times, encryption used: 0 times<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Also, seems that for “Data Guard” utility the text has capital letters “<\/span>%Compression used: TRUE%”.<\/span><\/p>\n
More information about which features enable the usage of Advanced Compression option can be find here.<\/a><\/p>\n
And how to avoid the usage of the Advanced Compression option by error on Mathias Zarick blog<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
To check if the “advanced compression” Oracle database option was used on your environment is not so easy, as there are several activities that can activate this option. For example for a mix Oracle 11.2.0.4 and 12.1.0.2 environment we can use the following query: select * from DBA_FEATURE_USAGE_STATISTICS where ((name like ‘%Compress%’ and name not […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,6,2,7],"tags":[],"class_list":["post-200","post","type-post","status-publish","format-standard","category-audit","category-oracle","category-oracle-11g","category-oracle-12c","czr-hentry"],"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=200"}],"version-history":[{"count":2,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/200\/revisions"}],"predecessor-version":[{"id":202,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/200\/revisions\/202"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}