RE: Another licensing question

From: Peter Sharman <pete.sharman_at_oracle.com>
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

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 "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com  Twitter: @SharmanPete  LinkedIn: au.linkedin.com/in/petesharman Website: petewhodidnottweet.com

  _____  

"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 [mailto:martin.a.berger_at_gmail.com] Sent: Saturday, February 6, 2016 5:50 AM To: daniel.hubler_at_aurora.org
Cc: oracle-l_at_freelists.org
Subject: Re: Another licensing question

 

Daniel, 

 

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:

http://berxblog.blogspot.com/2015/11/anatomy-of-dbafeatureusagestatistics.html

 

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

 

hth,  

 Martin 

 

2016-02-05 15:55 GMT+01:00 Hubler, Daniel <HYPERLINK "mailto:daniel.hubler_at_aurora.org"daniel.hubler_at_aurora.org>:

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:

NAME                                   VERSION         DETECTED_USAGES CURRE LAST_USAG LAST_SAMP LAST_SAMPLE_PERIOD DESCRIPTION

-------------------------------------- --------------- --------------- ----- --------- --------- ------------------ --------------------------------------------------

SQL Profile                            11.2.0.4.0                   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.

--
http://www.freelists.org/webpage/oracle-l

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