Oracle Database Licensing Insights and Tips
Jim Hannan (@HoBHannan), Principal Architect
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 Assessment 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:
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:
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.
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:
- 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
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.
The vast number of Oracle contracts and education documents can be very confusing. Below is an image of all the Oracle contracts and guides. Yes, there is difference between a contract and a guide. The guide is simply that – a guide provides additional information on licensing, but it is not contractual. Guides are represented with blue borders in the image below. The documents with red and black borders are contractual.
If you are interested in our other recent 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