Helpful article https://www.dba-oracle.com/oracle_tips_prices.htm
Oracle Database Licensing Information User Manual
https://support.oracle.com/rs?type=doc&id=1317265.1
Pricing https://www.oracle.com/assets/technology-price-list-070617.pdf
Compliance https://www.oracle.com/corporate/license-management-services/compliance.html
Cores + perpetual + Support + (compression + tuning pack + diagnostics pack + partitioning pack)
If any VM in a cluster is using a feature then all VMs in the cluster get billed.
Perpetual = the ability to run the software without support or upgrades.
select (select instance_name from v$instance) DB, version, description, detected_usages, last_usage_date from dba_feature_usage_statistics where name like ‘Automatic Workload%’ or name like ‘AWR%’ ;
show parameter CONTROL_MANAGEMENT_PACK_ACCESS
The value of control_management_pack_access controls access to Oracle Diagnostic Pack and Oracle Tuning Pack and can be set to non, diagnostic or diagnostic+tuning
Feature availability by edition https://docs.oracle.com/cd/E21659_01/html/E10594/editions.htm
Things to think about when auditing Oracle licensing.
· Find your Oracle installations
· Editions, packs, and options.
· NUP – Named user plus model
· CPU – Licensing model and don’t forget the cores.
· Virtualization
My DBA Notes 