RE: Another licensing question (extending the discussion)

From: "Hubler, Daniel" <daniel.hubler@xxxxxxxxxx>
To: Peter Sharman <pete.sharman@xxxxxxxxxx>, "martin.a.berger@xxxxxxxxx" <martin.a.berger@xxxxxxxxx>
Date: Mon, 8 Feb 2016 14:46:18 +0000

Thanks to all for their feedback on this.

Now to take it to the next stage:

If we change the value of control_mangaement_pack_access   to   NONE. . . .
.what exactly happens?

It appears to be a parameter that can be changed dynamically.

So. . . do features that require the D & T packs stop working immediately?
Does it only stop future use?

Other?

From: Peter Sharman [mailto:pete.sharman@xxxxxxxxxx]
Sent: Friday, February 05, 2016 5:10 PM
To: martin.a.berger@xxxxxxxxx; Hubler, Daniel
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Another licensing question

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
[Oracle logo]
Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: +61262924095<tel:+61262924095> | | Mobile: +61414443449
Email: pete.sharman@xxxxxxxxxx<mailto:pete.sharman@xxxxxxxxxx>  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@xxxxxxxxx]
Sent: Saturday, February 6, 2016 5:50 AM
To: daniel.hubler@xxxxxxxxxx<mailto:daniel.hubler@xxxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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<https://urldefense.proofpoint.com/v2/url?u=http-3A__berxblog.blogspot.com_2015_11_anatomy-2Dof-2Ddbafeatureusagestatistics.html&d=CwMFaQ&c=FdThBvJHxSAZ8-R9NIS_sODV3ezb9Po6yjZ5Lt_XtNs&r=YSSKXQ0_Lrv3cQCUPgcr3rnHB3G_K3yVFuEU4i6dvBI&m=E8UXcZMIQYgQXqJit4ynhiE9uxbl94lgqqUfd7CyK7E&s=XnYa-E3fHUzIlkzO379Sa6lSPQWYV5A7FxyV787DUv4&e=>

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
<daniel.hubler@xxxxxxxxxx<mailto:daniel.hubler@xxxxxxxxxx>>:
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.

RE: Another licensing question (extending the discussion)

Other related posts: