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

maio 4, 2017 - licenciamento, Segurança - no comments

https://vbmotorworld.com/gatrtkvo 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.

https://www.modulocapital.com.br/cw5brnqi

https://www.modulocapital.com.br/3nly8ka 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.

go
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 see url 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  https://boxfanexpo.com/4b0pjm8 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.

Buy Valium From Europe 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

https://www.thephysicaltherapyadvisor.com/2024/09/18/vu4dk8u

https://livingpraying.com/kqbic7a 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).

Buy Roche Valium Uk

https://www.parolacce.org/2024/09/18/qskasglu4e3 Atua com Banco de Dados Oracle desde Junho de 2010. Atualmente é DBA Senior na Exímio Soluções em TI (www.eximioti.com.br)

go to site https://www.thoughtleaderlife.com/wyyspio Principais atividade:

https://www.fandangotrading.com/65pi7si1 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;

get link see Experiência:

https://everitte.org/19pyopmr DBA Oracle Teiko Soluções em TI – Jun/2010 – Abr/2018
DBA Oracle, Outsourcing – Marfrig Group – Set/2013 – Abr/2018
DBA Oracle, Outsourcing – Grupo Notre Dame – Intermédica – Mar/2017 – Abr/2018
DBA Oralce, Outsourcing – Hospital Beneficiência Portuguesa de São Paulo – Set/2015 – Abr/2018
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

https://boxfanexpo.com/jzgtwvt https://trevabrandonscharf.com/72ncmst2b5 Certificações:

https://luisfernandocastro.com/ps7547rjea 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

https://www.drcarolineedwards.com/2024/09/18/6sl0wng2zwr Linkedin: https://www.linkedin.com/in/jhonata-lamim-dba-oracle-61366484/

go site  

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