RE: Another licensing question (extending the discussion)

From: Hubler, Daniel <>
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?


From: Peter Sharman [] Sent: Friday, February 05, 2016 5:10 PM To:; Hubler, Daniel Cc:
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.

[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:<> 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:<> Cc:<> 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 <<>>: 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 Mon Feb 08 2016 - 15:46:18 CET

Original text of this message