Less than a month ago, Oracle support released a major update of the reporting script for options\/features\/packs usage. It can be found at:<\/p>\n
Database Options\/Management Packs Usage Reporting for Oracle Databases 11gR2, 12c, 12cR2 and 18c (Doc ID 1317265.1)<\/a><\/p>\n It is a simple script that takes no time to execute. It will show both product and feature usage, including parameters that enable packs, like control_management_pack_access (Diagnostics and Tuning part) and enable_ddl_logging (Lifecycle Management pack). When run on a container database, it will show the feature usage per PDB. <\/p>\n It is important to know that it is based on DBA_FEATURE_USAGE_STATISTICS view, which is updated once a week. You can trigger an manual update using the information at How to Manually Refresh Dba_feature_usage_statistics (Doc ID 1629485.1)<\/a> <\/p>\n More details on each paid feature of Oracle Database Options and Packs can be found in the Oracle 12.2 Database Licensing Information<\/a> guide (same for 11.2<\/a>, 12.1<\/a> and 18c<\/a>).<\/p>\n An example of the output of the script can be found below:<\/p>\n Less than a month ago, Oracle support released a major update of the reporting script for options\/features\/packs usage. It can be found at: Database Options\/Management Packs Usage Reporting for Oracle Databases 11gR2, 12c, 12cR2 and 18c (Doc ID 1317265.1) It is a simple script that takes no time to execute. It will show both product […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,20,2,7],"tags":[],"class_list":{"0":"post-213","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-licensing","7":"category-my-oracle-support","8":"category-oracle-11g","9":"category-oracle-12c","10":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/213","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=213"}],"version-history":[{"count":5,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/213\/revisions"}],"predecessor-version":[{"id":218,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/213\/revisions\/218"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\r\nSQL> connect \/ as sysdba\r\nSQL> alter session set "_SWRF_TEST_ACTION"=53;\r\nSQL> alter session set NLS_DATE_FORMAT='DD\/MM\/YYYY HH24:MI:SS';\r\nSQL> select MAX(LAST_SAMPLE_DATE) from dba_feature_usage_statistics;\r\n<\/pre>\n
\r\nDatabase Options\/Management Packs Usage Reporting for Oracle Databases 11gR2, 12c, 12cR2 and 18c (Doc ID 1317265.1)\r\n\r\nSQL> @options_packs_usage_statistics.sql\r\nOVERALL INFORMATION\r\n\r\nHOST_NAME |INSTANCE_NAME |DATABASE_NAME |OPEN_MODE |DATABASE_ROLE |CREATED | DBID|VERSION |BANNER\r\n----------------------------------------|----------------|--------------|----------------|----------------|-------------------|----------|-----------|--------------------------------------------------------------------------------\r\nanjovm1 |ANJOCDB |ANJOCDB |READ WRITE |PRIMARY |2018.01.31_08.47.22| 380093466|12.2.0.1.0 |Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n\r\nPARAMETER |VALUE\r\n------------------------------|--------------------\r\ncontrol_management_pack_access|DIAGNOSTIC\r\nenable_ddl_logging |FALSE\r\n\r\n\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\nMULTITENANT INFORMATION (Please ignore errors in pre 12.1 databases)\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\n\r\nCON_ID|NAME |OPEN_MODE |RESTRICTED|REMARKS\r\n------|------------------------------|----------------|----------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\r\n 1|CDB$ROOT |READ WRITE |NO |*CURRENT CONTAINER is CDB$ROOT. Information for all open PDBs will be listed.\r\n 2|PDB$SEED |READ ONLY |NO |\r\n 3|ANJOPDB1 |READ WRITE |NO |\r\n\r\nThe multitenant architecture with one user-created pluggable database (single tenant) is available in all editions without the Multitenant Option.\r\nIf more than one PDB containers are created, then Multitenant Option licensing is needed\r\n\r\n\r\n\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\n>>> Selecting from CDB_FEATURE_USAGE_STATISTICS\r\n\r\n\r\nDBA_FEATURE_USAGE_STATISTICS (DBA_FUS) INFORMATION - MOST RECENT SAMPLE BASED ON LAST_SAMPLE_DATE\r\n\r\nCON_ID|LAST_DBA_FUS_DBID|LAST_DBA_FUS_VERS|LAST_DBA_FUS_SAMPLE|SYSDATE |REMARKS\r\n------|-----------------|-----------------|-------------------|-------------------|--------------------------------------------------------------------\r\n 1| 380093466|12.2.0.1.0 |2018.09.01_06.37.39|2018.09.06_09.19.25|\r\n 3| 380093466|12.2.0.1.0 |2018.09.01_18.37.40|2018.09.06_09.19.25|\r\n\r\n\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\nPRODUCT USAGE\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\n\r\nCON_NAME |PRODUCT |USAGE |LAST_SAMPLE_DATE |FIRST_USAGE_DATE |LAST_USAGE_DATE\r\n------------------------------|---------------------------------------------------|------------------------|-------------------|-------------------|-------------------\r\n--ALL-- |Active Data Guard |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Advanced Analytics |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Advanced Compression |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Advanced Security |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Database In-Memory |CURRENT_USAGE |2018.09.01_18.37.40|2018.06.02_06.28.39|2018.09.01_18.37.40\r\n--ALL-- |Database Vault |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Diagnostics Pack |CURRENT_USAGE |2018.09.01_18.37.40|2018.05.26_12.27.59|2018.09.01_06.37.39\r\n--ALL-- |Label Security |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Multitenant |NO_USAGE |2018.09.01_06.37.39| |\r\n--ALL-- |OLAP |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Partitioning |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |RAC or RAC One Node |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Real Application Clusters |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Real Application Clusters One Node |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Real Application Testing |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Spatial and Graph |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |Tuning Pack |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |.Database Gateway |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |.Exadata |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |.GoldenGate |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |.HW |NO_USAGE |2018.09.01_18.37.40| |\r\n--ALL-- |.Pillar Storage |NO_USAGE |2018.09.01_18.37.40| |\r\n\r\nCON_NAME |PRODUCT |USAGE |LAST_SAMPLE_DATE |FIRST_USAGE_DATE |LAST_USAGE_DATE\r\n------------------------------|---------------------------------------------------|------------------------|-------------------|-------------------|-------------------\r\nCDB$ROOT |Active Data Guard |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Advanced Analytics |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Advanced Compression |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Advanced Security |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Database In-Memory |CURRENT_USAGE |2018.09.01_06.37.39|2018.06.02_06.28.39|2018.09.01_06.37.39\r\nCDB$ROOT |Database Vault |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Diagnostics Pack |CURRENT_USAGE |2018.09.01_06.37.39|2018.05.26_12.27.59|2018.09.01_06.37.39\r\nCDB$ROOT |Label Security |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Multitenant |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |OLAP |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Partitioning |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |RAC or RAC One Node |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Real Application Clusters |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Real Application Clusters One Node |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Real Application Testing |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Spatial and Graph |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |Tuning Pack |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |.Database Gateway |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |.Exadata |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |.GoldenGate |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |.HW |NO_USAGE |2018.09.01_06.37.39| |\r\nCDB$ROOT |.Pillar Storage |NO_USAGE |2018.09.01_06.37.39| |\r\n\r\nCON_NAME |PRODUCT |USAGE |LAST_SAMPLE_DATE |FIRST_USAGE_DATE |LAST_USAGE_DATE\r\n------------------------------|---------------------------------------------------|------------------------|-------------------|-------------------|-------------------\r\nANJOPDB1 |Active Data Guard |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Advanced Analytics |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Advanced Compression |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Advanced Security |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Database In-Memory |CURRENT_USAGE |2018.09.01_18.37.40|2018.06.02_18.28.39|2018.09.01_18.37.40\r\nANJOPDB1 |Database Vault |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Diagnostics Pack |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Label Security |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |OLAP |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Partitioning |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |RAC or RAC One Node |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Real Application Clusters |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Real Application Clusters One Node |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Real Application Testing |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Spatial and Graph |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |Tuning Pack |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |.Database Gateway |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |.Exadata |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |.GoldenGate |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |.HW |NO_USAGE |2018.09.01_18.37.40| |\r\nANJOPDB1 |.Pillar Storage |NO_USAGE |2018.09.01_18.37.40| |\r\n\r\n\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\nFEATURE USAGE DETAILS\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\n\r\nCON_NAME |PRODUCT |FEATURE_BEING_USED |USAGE |LAST_SAMPLE_DATE | DBID|VERSION |DETECTED_USAGES|TOTAL_SAMPLES|CURRENTLY_USED|FIRST_USAGE_DATE |LAST_USAGE_DATE |EXTRA_FEATURE_INFO\r\n------------------------------|---------------------------------------------------|--------------------------------------------------------|------------------------|-------------------|----------|-----------|---------------|-------------|--------------|-------------------|-------------------|--------------------------------------------------------------------------------\r\nCDB$ROOT |Active Data Guard |Active Data Guard - Real-Time Query on Physical Standby |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Active Data Guard |Global Data Services |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Analytics |Data Mining |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Advanced Index Compression |SUPPRESSED_DUE_TO_BUG |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Backup HIGH Compression |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Backup LOW Compression |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Backup MEDIUM Compression |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Backup ZLIB Compression |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Data Guard |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |HeapCompression |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Heat Map |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Hybrid Columnar Compression Row Level Locking |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Information Lifecycle Management |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Oracle Advanced Network Compression Service |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |Oracle Utility Datapump (Export) |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 10| 31|TRUE |2018.05.19_10.21.15|2018.09.01_06.37.39|compression used: 0 times\r\nCDB$ROOT |Advanced Compression |Oracle Utility Datapump (Import) |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |SecureFile Compression (user) |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Compression |SecureFile Deduplication (user) |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Security |Data Redaction |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Security |Encrypted Tablespaces |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Security |Oracle Utility Datapump (Export) |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 10| 31|TRUE |2018.05.19_10.21.15|2018.09.01_06.37.39|encryption used: 0 times\r\nCDB$ROOT |Advanced Security |Oracle Utility Datapump (Import) |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Security |SecureFile Encryption (user) |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Advanced Security |Transparent Data Encryption |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Database In-Memory |In-Memory Aggregation |CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 14| 31|TRUE |2018.06.02_06.28.39|2018.09.01_06.37.39|\r\nCDB$ROOT |Database In-Memory |In-Memory Column Store |CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 14| 31|TRUE |2018.06.02_06.28.39|2018.09.01_06.37.39|\r\nCDB$ROOT |Database Vault |Oracle Database Vault |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Database Vault |Privilege Capture |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Diagnostics Pack |ADDM |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Diagnostics Pack |AWR Baseline |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Diagnostics Pack |AWR Baseline Template |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Diagnostics Pack |AWR Report |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Diagnostics Pack |Automatic Workload Repository |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Diagnostics Pack |Baseline Adaptive Thresholds |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Diagnostics Pack |Baseline Static Computations |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Diagnostics Pack |EM Performance Page |CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 5| 31|TRUE |2018.05.26_12.27.59|2018.09.01_06.37.39|\r\nCDB$ROOT |Label Security |Label Security |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Multitenant |Oracle Multitenant |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 31| 31|TRUE |2018.01.31_15.38.04|2018.09.01_06.37.39|AUX_COUNT=1\r\nCDB$ROOT |OLAP |OLAP - Analytic Workspaces |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |OLAP |OLAP - Cubes |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Partitioning |Partitioning (user) |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Partitioning |Zone maps |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |RAC or RAC One Node |Quality of Service Management |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Real Application Clusters |Real Application Clusters (RAC) |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Real Application Clusters One Node |Real Application Cluster One Node |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Real Application Testing |Database Replay: Workload Capture |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Real Application Testing |Database Replay: Workload Replay |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Real Application Testing |SQL Performance Analyzer |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Spatial and Graph |Spatial |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Tuning Pack |SQL Access Advisor |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Tuning Pack |SQL Monitoring and Tuning pages |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Tuning Pack |SQL Profile |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |Tuning Pack |SQL Tuning Advisor |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.Database Gateway |Gateways |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.Database Gateway |Transparent Gateway |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.Exadata |Cloud DB with EHCC |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.Exadata |Exadata |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.GoldenGate |GoldenGate |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.HW |Hybrid Columnar Compression |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.HW |Hybrid Columnar Compression Conventional Load |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.HW |Hybrid Columnar Compression Row Level Locking |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.HW |Sun ZFS with EHCC |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.HW |ZFS Storage |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.HW |Zone maps |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.Pillar Storage |Pillar Storage |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nCDB$ROOT |.Pillar Storage |Pillar Storage with EHCC |NO_CURRENT_USAGE |2018.09.01_06.37.39| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\n\r\nCON_NAME |PRODUCT |FEATURE_BEING_USED |USAGE |LAST_SAMPLE_DATE | DBID|VERSION |DETECTED_USAGES|TOTAL_SAMPLES|CURRENTLY_USED|FIRST_USAGE_DATE |LAST_USAGE_DATE |EXTRA_FEATURE_INFO\r\n------------------------------|---------------------------------------------------|--------------------------------------------------------|------------------------|-------------------|----------|-----------|---------------|-------------|--------------|-------------------|-------------------|--------------------------------------------------------------------------------\r\nANJOPDB1 |Active Data Guard |Active Data Guard - Real-Time Query on Physical Standby |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Active Data Guard |Global Data Services |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Analytics |Data Mining |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Advanced Index Compression |SUPPRESSED_DUE_TO_BUG |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Backup HIGH Compression |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Backup LOW Compression |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Backup MEDIUM Compression |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Backup ZLIB Compression |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Data Guard |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |HeapCompression |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Heat Map |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Hybrid Columnar Compression Row Level Locking |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Information Lifecycle Management |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Oracle Advanced Network Compression Service |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Oracle Utility Datapump (Export) |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |Oracle Utility Datapump (Import) |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 5| 31|FALSE |2018.02.17_09.22.16|2018.03.17_11.41.30|\r\nANJOPDB1 |Advanced Compression |SecureFile Compression (user) |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Compression |SecureFile Deduplication (user) |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Security |Data Redaction |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Security |Encrypted Tablespaces |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Security |Oracle Utility Datapump (Export) |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Security |Oracle Utility Datapump (Import) |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 5| 31|FALSE |2018.02.17_09.22.16|2018.03.17_11.41.30|\r\nANJOPDB1 |Advanced Security |SecureFile Encryption (user) |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Advanced Security |Transparent Data Encryption |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Database In-Memory |In-Memory Aggregation |CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 14| 31|TRUE |2018.06.02_18.28.39|2018.09.01_18.37.40|\r\nANJOPDB1 |Database In-Memory |In-Memory Column Store |CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 14| 31|TRUE |2018.06.02_18.28.39|2018.09.01_18.37.40|\r\nANJOPDB1 |Database Vault |Oracle Database Vault |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Database Vault |Privilege Capture |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Diagnostics Pack |ADDM |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Diagnostics Pack |AWR Baseline |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Diagnostics Pack |AWR Baseline Template |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Diagnostics Pack |AWR Report |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Diagnostics Pack |Automatic Workload Repository |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Diagnostics Pack |Baseline Adaptive Thresholds |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Diagnostics Pack |Baseline Static Computations |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Diagnostics Pack |EM Performance Page |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Label Security |Label Security |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |OLAP |OLAP - Analytic Workspaces |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |OLAP |OLAP - Cubes |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Partitioning |Partitioning (user) |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Partitioning |Zone maps |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |RAC or RAC One Node |Quality of Service Management |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Real Application Clusters |Real Application Clusters (RAC) |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Real Application Clusters One Node |Real Application Cluster One Node |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Real Application Testing |Database Replay: Workload Capture |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Real Application Testing |Database Replay: Workload Replay |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Real Application Testing |SQL Performance Analyzer |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Spatial and Graph |Spatial |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Tuning Pack |SQL Access Advisor |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Tuning Pack |SQL Monitoring and Tuning pages |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Tuning Pack |SQL Profile |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |Tuning Pack |SQL Tuning Advisor |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.Database Gateway |Gateways |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.Database Gateway |Transparent Gateway |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.Exadata |Cloud DB with EHCC |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.Exadata |Exadata |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.GoldenGate |GoldenGate |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.HW |Hybrid Columnar Compression |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.HW |Hybrid Columnar Compression Conventional Load |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.HW |Hybrid Columnar Compression Row Level Locking |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.HW |Sun ZFS with EHCC |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.HW |ZFS Storage |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.HW |Zone maps |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.Pillar Storage |Pillar Storage |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\nANJOPDB1 |.Pillar Storage |Pillar Storage with EHCC |NO_CURRENT_USAGE |2018.09.01_18.37.40| 380093466|12.2.0.1.0 | 0| 31|FALSE | | |\r\n\r\nUSER is "SYS"\r\n\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\nDESCRIPTION:\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\nThe two reports, PRODUCT USAGE and FEATURE USAGE DETAILS, provide usage statistics for Database Options, Management Packs\r\nand their corresponding features.\r\nInformation is extracted from DBA_FEATURE_USAGE_STATISTICS view.\r\n\r\nDBA_FEATURE_USAGE_STATISTICS view is updated once a week, so it may take up to 7 days for the report to reflect usage changes.\r\nDBA_FEATURE_USAGE_STATISTICS view contains a different set of entries for each VERSION and DBID occurring in the database history.\r\nThe weekly refresh process updates only the current row set.\r\n\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\nNOTES:\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\nThe report lists all detectable products and features, used or not used.\r\nThe CURRENTLY_USED column in the DBA_FEATURE_USAGE_STATISTICS view indicates if the feature in question was used during the last sampling interval\r\nor is used at the refresh moment.\r\nCURRENT_USAGE represents usage tracked over the last sample period, which defaults to one week.\r\nPAST_OR_CURRENT_USAGE example: Datapump Export entry indicates CURRENTLY_USED='TRUE' and FEATURE_INFO "compression used" counter\r\nindicates a non zero value that could have been triggered by past or current (last week) usage.\r\nFor historical details check FIRST_USAGE_DATE, LAST_USAGE_DATE, LAST_SAMPLE_DATE, TOTAL_SAMPLES, DETECTED_USAGES columns\r\nLeading dot (.) denotes a product that is not a Database Option or Database Management Pack\r\n\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\nDISCLAIMER:\r\n++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\r\nInformation provided by the reports is to be used for informational purposes only and does not represent your license entitlement or requirement.\r\nThe usage data may indicate, in some cases, false positives.\r\nThis may be due to inclusion of usage by sample schemas (such as HR, PM, SH...) or system\/internal usage.\r\n\r\nPlease refer to MOS DOC ID 1317265.1 and 1309070.1 for more information.\r\n\r\nEnd of script (v 18.1 Apr-2018)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"