Jim Hannan (@jim_m_hannan ), Principal Architect
Updated: March 29, 2019
Is this blog post we will take a look at general Oracle database licensing and how the Oracle database tracks feature usage. This can be helpful in preparing for a LMS audit or for taking inventory before renewing an Oracle contract. We will also provide general tips for entitlements and Oracle contracts. As most people close to Oracle know, licensing and product discovery can be complex. The intent of this blog is to help clear up some of the common misunderstandings.
Tip: Oracle audits are not for the faint of heart. House of Brick strongly recommends that any organization going through an Oracle LMS audit consult with experts in the licensing of Oracle products. House of Brick offers expert guidance regarding Oracle licensing. Learn more about our Oracle License Services.
As you may be aware, every seven days (default behavior) the view dba_feature_usage_statistics updates with what features have been used in the database. You can manually kickoff a refresh by running the procedure below[1]:
Oracle support document 1317265.1 provides the scripts necessary to query this table. This document is a must read for any DBA involved in Oracle licensing.
Below is a description of dba_feature_usage_statistics:
SQL> DESC dba_feature_usage_statistics
Name                               Null?               Type
—————————————————————————————————————————————————————————————————————————DBIDÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â NOT NULLÂ Â Â Â Â Â Â Â Â Â Â NUMBER
NAMEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â NOT NULLÂ Â Â Â Â Â Â Â Â Â Â VARCHAR2(64)
VERSIONÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â NOT NULLÂ Â Â Â Â Â Â Â Â Â Â VARCHAR2(17)
DETECTED_USAGESÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â NOT NULLÂ Â Â Â Â Â Â Â Â Â Â NUMBER
TOTAL_SAMPLESÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â NOT NULLÂ Â Â Â Â Â Â Â Â Â Â NUMBER
CURRENTLY_USEDÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â VARCHAR2(5)
FIRST_USAGE_DATEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DATE
LAST_USAGE_DATEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DATE
AUX_COUNTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â NUMBER
FEATURE_INFOÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â CLOB
LAST_SAMPLE_DATEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DATE
LAST_SAMPLE_PERIODÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â NUMBER
SAMPLE_INTERVALÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â NUMBER
DESCRIPTIONÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â VARCHAR2(128)
What happens when I clone a database?
This is something you should keep in mind when reviewing your usage. Cloning will carry over the statistics from the source to the cloned environment. In a DEV or TEST database, a particular feature may not have been used. An example of this is SQL Tuning Advisor, which is part of the Tuning Pack.
First Usage and Last Usage Columns
The columns first_usage and last_usage are good for determining when a feature has been used. For example, as mentioned above, you may have recently cloned your DEV database. These tools will give you insight regarding whether the feature was used since the clone date. In this example we cloned our database on June 10, 2015, and you can see from the query below that the feature has not yet been used in the cloned database.
—————————————————————————————————————————————————————————————————————————
SQL Tuning Advisor       24        5-AUG-11         5-JUN-2015
Advance Compression
Many customers are surprised to find out that they are using the Advance Compression. What catches them off guard is all of the places Advance Compression can be used in the database. When using any of the following features, you need to keep in mind that these count as using Advance Compression[2]:
- Data Guard Compression
- Data Pump Compression
- RMAN Compression Level (Medium and High) — Updated 8/10/15
- OLTP Table Compression
- SecureFile Compression and Deduplication
- Total Recall
Entitlement
Entitlements are Oracle products that you are entitled to because you own a parent product. For example, purchasing Oracle E-Business Suite entitles you to Oracle Database Enterprise Edition, but only if you do not do internal development to the EBS database (which is rare in our experience). A better example is GoldenGate and Active Data Guard; you are entitled to Active Data Guard wherever GoldenGate is installed.
Oracle Contracts
The vast number of Oracle contracts and education documents can be very confusing. Below is an image illustrating the Oracle contracts and guides. Yes, there is difference between a contract and a guide. A guide is simply that – a document that provides additional information on licensing, but is not contractual. Guides are represented with red borders in the image below.
The first document, shown in the image with a greens border, represents the Master Agreement or OLSA. This document is signed by the customer upon making their first Oracle purchase. It should be noted that new Master Agreements may be signed with Oracle that can change some of the terms, so understanding what Master Agreements are in place, and which products they impact is essential. The other two documents bordered in green are also contractual documents the Core Processor Factor Table and the Technical Support Policy. The Core Processor Factor Table documents the core factor in place for a given platform. For example, x86 would have a core factor of 0.5, meaning that for every two cores, a processor license would be needed for processor based licensing. The Technical Support Policy lays out the terms and conditions for using Oracle software.
The remaining documents represent an example of an Ordering Document with products purchased, an Ordering Document Amendment and the Renewal Document for renewing product support and maintenance. The arrows represent the order of priority. Any additional terms in the Ordering Document Amendment, or Renewal Document, take precedence over the original Ordering Document.
If you are interested in other licensing blogs we encourage you to read:
- Honing Your Ninja Skills – Engaging Oracle on Licensing Topics
- Managing Oracle Licensing in a Shared Storage Environment
- Oracle Licensing: Soft Partitioning on VMware is Your Contractual Right
References
[1] Reference: https://oracle-base.com/articles/misc/tracking-database-feature-usage
[2] Reference: http://docs.oracle.com/cd/E11882_01/license.112/e47877/options.htm#DBLIC142
