Identificando as options e features estão sendo utilizadas no banco de dados (Oracle 11g e 12c)

Uma das muitas atribuições de um DBA é garantir que o ambiente suportado está adequado ao licenciamento adquirido, evitando assim possíveis problemas jurídicos e financeiros.

Podemos consultar quais as option disponíveis para cada versão e se a mesma precisa ou não ser licenciada a parte, através do Database Licensing Information User Manual.

Agora que sabemos as options/features disponiveis para cada versão e se a mesma necessita ou não de licenciamento a parte. Vamos consultar quais options estão sendo utilizadas atualmente ou que já tiveram alguma utilização em nosso ambiente.
Para isso, podemos consultar através da visão DBA_FEATURE_USAGE_STATISTICS. Porém a mesma não apresenta uma visualização clara e pode confundir um pouco sobre a utilização ou não de uma determinada option.
Afim de facilitar o levantamento das informação de features/option utilizadas a Oracle disponibilizou através do Doc ID 1317265.1 o script options_packs_usage_statistics.sql. Este script é suportado para versões 11.2 e superiores, substituindo os antigos scripts option_usage.sql e used_options_details.sql.
Em ambientes 12c CDB, quando o script options_packs_usage_statistics.sql é executado no ROOT (CDB$ROOT) listará as informações para todos os PDBs que estiverem em modo Open, detectando inclusive a necessidade ou não do licenciamento da Option Multitenant.
Quando executado diretamente em um PDB, o script listará apenas informações do PDB no qual foi executado e não terá visibilidade dos demais PDBs. Esse comportamento ocorre devido a “isolamento” proporcionado pela arquitetura Multitenant. Por este motivo a option multitenant não será detectada nesta execução.
O resultado do script é divido em 2 categorias, PRODUCT USAGE e FEATURE USAGE DETAILS.
Na categoria Product usage teremos uma visão geral de cada option/pack utilizado no banco de dados e se atualmente ainda estão em uso. Além de fornecer a data da primeira e última utilização.
A categoria Feature Usage Details apresentará uma informação mais detalhada das features utilizadas. Este relatório é baseado na view DBA_FEATURE_USAGE_STATISTICS.
Abaixo, segue o exemplo de uma execução em um ambiente Oracle 12.1.0.2 Enterprise Edition, recém criado. Podemos constatar que não existem registro de uso das options.
 SQL> !
Banco=lamimprd-> pwd
/u01/app/oracle/dba
Banco=lamimprd-> ls
options_packs_usage_statistics.sql
Banco=lamimprd-> exit
exit
 
SQL> show con_name;
 
CON_NAME
------------------------------
CDB$ROOT
SQL> show pdbs;
 
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 LAMIMPDB1                      READ WRITE NO
SQL> @options_packs_usage_statistics.sql
OVERALL INFORMATION
 
HOST_NAME                               |INSTANCE_NAME   |DATABASE_NAME |OPEN_MODE       |DATABASE_ROLE   |CREATED            |      DBID|VERSION    |BANNER
----------------------------------------|----------------|--------------|----------------|----------------|-------------------|----------|-----------|--------------------------------------------------------------------------------
ora12c.localdomain                      |lamimprd        |LAMIMPRD      |READ WRITE      |PRIMARY         |2016.12.09_23.40.02|1049999954|12.1.0.2.0 |Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
 
PARAMETER                     |VALUE
------------------------------|--------------------
control_management_pack_access|DIAGNOSTIC+TUNING
enable_ddl_logging            |FALSE
 
 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
MULTITENANT INFORMATION (Please ignore errors in pre 12.1 databases)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 
CON_ID|NAME                          |OPEN_MODE       |RESTRICTED|REMARKS
------|------------------------------|----------------|----------|-----------------------------------------------------------------------------
     1|CDB$ROOT                      |READ WRITE      |NO        |*CURRENT CONTAINER is CDB$ROOT. Information for all open PDBs will be listed.
     2|PDB$SEED                      |READ ONLY       |NO        |
     3|LAMIMPDB1                     |READ WRITE      |NO        |
 
The multitenant architecture with one user-created pluggable database (single tenant) is available in all editions without the Multitenant Option.
If more than one PDB containers are created, then Multitenant Option licensing is needed
 
 
 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>> Selecting from CDB_FEATURE_USAGE_STATISTICS
 
 
DBA_FEATURE_USAGE_STATISTICS (DBA_FUS) INFORMATION - MOST RECENT SAMPLE BASED ON LAST_SAMPLE_DATE
 
CON_ID|LAST_DBA_FUS_DBID|LAST_DBA_FUS_VERS|LAST_DBA_FUS_SAMPLE|SYSDATE            |REMARKS
------|-----------------|-----------------|-------------------|-------------------|-----------------
     1|       1049999954|12.1.0.2.0       |2016.12.10_05.53.12|2017.04.20_21.17.41|
     3|       4180948263|12.1.0.2.0       |                   |2017.04.20_21.17.41|
 
 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
PRODUCT USAGE
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 
CON_NAME                      |PRODUCT                                            |USAGE                   |LAST_SAMPLE_DATE   |FIRST_USAGE_DATE   |LAST_USAGE_DATE
------------------------------|---------------------------------------------------|------------------------|-------------------|-------------------|-------------------
--ALL--                       |Active Data Guard                                  |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Advanced Analytics                                 |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Advanced Compression                               |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Advanced Security                                  |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Database In-Memory                                 |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Database Vault                                     |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Diagnostics Pack                                   |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Label Security                                     |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Multitenant                                        |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |OLAP                                               |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Partitioning                                       |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |RAC or RAC One Node                                |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Real Application Clusters                          |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Real Application Clusters One Node                 |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Real Application Testing                           |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Spatial and Graph                                  |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |Tuning Pack                                        |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |.Database Gateway                                  |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |.Exadata                                           |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |.GoldenGate                                        |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |.HW                                                |NO_USAGE                |2016.12.10_05.53.12|                   |
--ALL--                       |.Pillar Storage                                    |NO_USAGE                |2016.12.10_05.53.12|                   |
 
CON_NAME                      |PRODUCT                                            |USAGE                   |LAST_SAMPLE_DATE   |FIRST_USAGE_DATE   |LAST_USAGE_DATE
------------------------------|---------------------------------------------------|------------------------|-------------------|-------------------|-------------------
CDB$ROOT                      |Active Data Guard                                  |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Advanced Analytics                                 |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Advanced Compression                               |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Advanced Security                                  |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Database In-Memory                                 |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Database Vault                                     |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Diagnostics Pack                                   |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Label Security                                     |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Multitenant                                        |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |OLAP                                               |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Partitioning                                       |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |RAC or RAC One Node                                |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Real Application Clusters                          |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Real Application Clusters One Node                 |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Real Application Testing                           |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Spatial and Graph                                  |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |Tuning Pack                                        |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |.Database Gateway                                  |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |.Exadata                                           |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |.GoldenGate                                        |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |.HW                                                |NO_USAGE                |2016.12.10_05.53.12|                   |
CDB$ROOT                      |.Pillar Storage                                    |NO_USAGE                |2016.12.10_05.53.12|                   |
 
 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
FEATURE USAGE DETAILS
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 
CON_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
------------------------------|---------------------------------------------------|--------------------------------------------------------|------------------------|-------------------|----------|-----------|---------------|-------------|--------------|-------------------|-------------------|--------------------------------------------------------------------------------
CDB$ROOT                      |Active Data Guard                                  |Active Data Guard - Real-Time Query on Physical Standby |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Active Data Guard                                  |Global Data Services                                    |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Analytics                                 |Data Mining                                             |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Advanced Index Compression                              |SUPPRESSED_DUE_TO_BUG   |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Backup HIGH Compression                                 |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Backup LOW Compression                                  |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Backup MEDIUM Compression                               |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Backup ZLIB Compression                                 |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Data Guard                                              |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |HeapCompression                                         |SUPPRESSED_DUE_TO_BUG   |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Heat Map                                                |SUPPRESSED_DUE_TO_BUG   |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Hybrid Columnar Compression Row Level Locking           |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Information Lifecycle Management                        |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Oracle Advanced Network Compression Service             |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Oracle Utility Datapump (Export)                        |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |Oracle Utility Datapump (Import)                        |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |SecureFile Compression (user)                           |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Compression                               |SecureFile Deduplication (user)                         |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Security                                  |Data Redaction                                          |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Security                                  |Encrypted Tablespaces                                   |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Security                                  |Oracle Utility Datapump (Export)                        |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Security                                  |Oracle Utility Datapump (Import)                        |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Security                                  |SecureFile Encryption (user)                            |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Advanced Security                                  |Transparent Data Encryption                             |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Database In-Memory                                 |In-Memory Aggregation                                   |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Database In-Memory                                 |In-Memory Column Store                                  |SUPPRESSED_DUE_TO_BUG   |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Database Vault                                     |Oracle Database Vault                                   |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Database Vault                                     |Privilege Capture                                       |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Diagnostics Pack                                   |ADDM                                                    |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Diagnostics Pack                                   |AWR Baseline                                            |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Diagnostics Pack                                   |AWR Baseline Template                                   |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Diagnostics Pack                                   |AWR Report                                              |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Diagnostics Pack                                   |Automatic Workload Repository                           |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Diagnostics Pack                                   |Baseline Adaptive Thresholds                            |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Diagnostics Pack                                   |Baseline Static Computations                            |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Diagnostics Pack                                   |EM Performance Page                                     |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Label Security                                     |Label Security                                          |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Multitenant                                        |Oracle Pluggable Databases                              |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              1|            1|TRUE          |2016.12.10_05.53.12|2016.12.10_05.53.12|AUX_COUNT=1
CDB$ROOT                      |OLAP                                               |OLAP - Analytic Workspaces                              |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |OLAP                                               |OLAP - Cubes                                            |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Partitioning                                       |Partitioning (user)                                     |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Partitioning                                       |Zone maps                                               |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |RAC or RAC One Node                                |Quality of Service Management                           |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Real Application Clusters                          |Real Application Clusters (RAC)                         |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Real Application Clusters One Node                 |Real Application Cluster One Node                       |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Real Application Testing                           |Database Replay: Workload Capture                       |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Real Application Testing                           |Database Replay: Workload Replay                        |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Real Application Testing                           |SQL Performance Analyzer                                |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Spatial and Graph                                  |Spatial                                                 |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Tuning Pack                                        |SQL Access Advisor                                      |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Tuning Pack                                        |SQL Monitoring and Tuning pages                         |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Tuning Pack                                        |SQL Profile                                             |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |Tuning Pack                                        |SQL Tuning Advisor                                      |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.Database Gateway                                  |Gateways                                                |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.Database Gateway                                  |Transparent Gateway                                     |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.Exadata                                           |Exadata                                                 |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.GoldenGate                                        |GoldenGate                                              |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.HW                                                |Hybrid Columnar Compression                             |SUPPRESSED_DUE_TO_BUG   |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.HW                                                |Hybrid Columnar Compression Row Level Locking           |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.HW                                                |Sun ZFS with EHCC                                       |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.HW                                                |ZFS Storage                                             |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.HW                                                |Zone maps                                               |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.Pillar Storage                                    |Pillar Storage                                          |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
CDB$ROOT                      |.Pillar Storage                                    |Pillar Storage with EHCC                                |NO_CURRENT_USAGE        |2016.12.10_05.53.12|1049999954|12.1.0.2.0 |              0|            1|FALSE         |                   |                   |
 
USER is "SYS"
 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
DESCRIPTION:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
The two reports, PRODUCT USAGE and FEATURE USAGE DETAILS, provide usage statistics for Database Options, Management Packs
and their corresponding features.
Information is extracted from DBA_FEATURE_USAGE_STATISTICS view.
 
DBA_FEATURE_USAGE_STATISTICS view is updated once a week, so it may take up to 7 days for the report to reflect usage changes.
DBA_FEATURE_USAGE_STATISTICS view contains a different set of entries for each VERSION and DBID occurring in the database history.
The weekly refresh process updates only the current row set.
 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
NOTES:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
The report lists all detectable products and features, used or not used.
The CURRENTLY_USED column in the DBA_FEATURE_USAGE_STATISTICS view indicates if the feature in question was used during the last sampling interval
or is used at the refresh moment.
CURRENT_USAGE represents usage tracked over the last sample period, which defaults to one week.
PAST_OR_CURRENT_USAGE example: Datapump Export entry indicates CURRENTLY_USED='TRUE' and FEATURE_INFO "compression used" counter
indicates a non zero value that could have been triggered by past or current (last week) usage.
For historical details check FIRST_USAGE_DATE, LAST_USAGE_DATE, LAST_SAMPLE_DATE, TOTAL_SAMPLES, DETECTED_USAGES columns
Leading dot (.) denotes a product that is not a Database Option or Database Management Pack
 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
DISCLAIMER:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Information provided by the reports is to be used for informational purposes only and does not represent your license entitlement or requirement.
The usage data may indicate, in some cases, false positives.
This may be due to inclusion of usage by sample schemas (such as HR, PM, SH...) or system/internal usage.
 
Please refer to MOS DOC ID 1317265.1 and 1309070.1 for more information.
 
End of script
SQL>
Para mais informações sobre licenciamento:
https://docs.oracle.com/database/121/DBLIC/options.htm#DBLIC140
www.oracle.com/us/corporate/license-management-services/index.html
Fonte:http://www.lamimdba.com.br/2017/04/quais-options-e-features-estao-sendo.html
%name Identificando as options e features estão sendo utilizadas no banco de dados (Oracle 11g e 12c)

Autor: Jhonata Lamim

MBA em Banco de Dados Oracle, formado pelo Centro Universitário de Araraquara (UNIARA), graduado em Sistemas de Informação pelo Centro Universitário de Brusque (UNIFEBE).

Atua com Banco de Dados Oracle desde Junho de 2010 pela Teiko Soluções em Tecnologia da Informação.

Principais atividade:
  • Implementação, migração, gerenciamento e suporte a produtos Oracle (10g, 11g, 12c, RAC), multiplataforma;
  • Monitoramento de ambientes 24×7;
  • Backup e Recovery;
  • Performance e Tuning;
  • Alta disponibilidade (HA);
  • EM database/grid/cloud control 12c/13c;
  • Conversão de databases;
  • Standby database / Oracle Data Guard;
  • Migração de dados para Oracle;

Experiência:

  • DBA Oracle, Outsourcing – Marfrig Group – Set/2013 – Atual
  • DBA Oracle, Outsourcing – Grupo Notre Dame – Intermédica – Mar/2017 – Atual
  • DBA Oralce, Outsourcing – Hospital Beneficiência Portuguesa de São Paulo – Set/2015 – Atual
  • DBA Oracle, Outsourcing – Fundação São Francisco Xavier –  Set/2015 – Fev/2017
  • DBA Oracle, Outsourcing – Unimed Grande Florianopolis – Set/2014 – Jul/2016
  • DBA Oracle, Outsourcing – Hospital Moinhos de Vento – Set/2014 – Set/2015
  • DBA Oracle, Outsourcing – Santa Casa de Misericórdia de Porto Alegre – 2013

Certificações:

  • OCS 12C – Oracle Real Application Clusters 12c Certified Implementation Specialist
  • OCS 12C – Oracle Database 12c Certified Implementation Specialist
  • OCE 11G – Oracle Database 11g: Performance Tuning
  • OCA 11G – Oracle Certified Associate Administrator
  • OCP 11G/12C – Oracle Certified Professional Administrator
  • OCS 11G – Oracle Certified Specialist
  • OPNCS 11G – Oracle Partner Network Certified Specialist
  • OCS – Oracle Linux 6 Implementation Essentials

Linkedin: https://www.linkedin.com/in/jhonata-lamim-dba-oracle-61366484/