RE: Another licensing question

From: Peter Sharman <>
Date: Fri, 5 Feb 2016 15:10:14 -0800 (PST)
Message-ID: <9c2fa19a-66c4-4fff-a525-f1235040dddc_at_default>

The MOS note that Martin refers to is the correct place to find out what is being used.  DBA_FEATURE_USAGE_STATISTICS is documented in the 12c doc, but I would have to say the doc doesn’t help much with Daniel’s original question.



Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: HYPERLINK "tel:+61262924095"+61262924095 | | Mobile: +61414443449  Email: HYPERLINK ""  Twitter: @SharmanPete  LinkedIn: Website:


"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook


"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA



From: Martin Berger [] Sent: Saturday, February 6, 2016 5:50 AM To:
Subject: Re: Another licensing question




the best I've found is the MOS document
Database Options/Management Packs Usage Reporting for Oracle Databases 11gR2 and 12c (Doc ID 1317265.1) 


I've tried to collect some details about dba_feature_usage_statistics in this blog article:


You need to accept none of those methods are save in case of a License Audit. 





2016-02-05 15:55 GMT+01:00 Hubler, Daniel <HYPERLINK "">:

If this has been answered somewhere already . . . sorry. . . I am not finding an exact answer.

Where can I find documentation that associates the information found in sys.dba_feature_usage_statistics with the features/options/packs that have to be licensed?

For example the following is returned from sys.dba_feature_usage_statistics:


-------------------------------------- --------------- --------------- ----- --------- --------- ------------------ --------------------------------------------------
SQL Profile                                     40 TRUE  05-FEB-16 05-FEB-16             209045 SQL profiles have been used.

This implies (correctly) that we have SQL-profiles in place. We need to have Diagnostic/Tuning pack(s) licensed.

But there are hundreds of other items in that table.

Where can I find which NAMEs in the dba_feature_usage_statistics table, actually require additional licensing?

Thanks in advance.

Received on Sat Feb 06 2016 - 00:10:14 CET

Original text of this message