RE: Another licensing question (extending the discussion)

From: Hubler, Daniel <daniel.hubler_at_aurora.org>
Date: Mon, 8 Feb 2016 14:46:18 +0000
Message-ID: <850425C04FB76547AC0ED12C5F7E0B804165628C_at_HEIMSEAT021.ahc.root.loc>

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_at_oracle.com] Sent: Friday, February 05, 2016 5:10 PM To: martin.a.berger_at_gmail.com; Hubler, Daniel Cc: oracle-l_at_freelists.org
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_at_oracle.com<mailto: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<mailto:daniel.hubler_at_aurora.org> Cc: oracle-l_at_freelists.org<mailto: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<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_at_aurora.org<mailto: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 Mon Feb 08 2016 - 15:46:18 CET