Re: extra cost options and DBA_FEATURE_USAGE_STATISTICS

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Wed, 9 Dec 2015 11:48:02 +0100
Message-ID: <CALH8A92pJ6aVXgiRO4HvLwzZiE=n5+vzhiDBdAwVQpGiPVzOnA_at_mail.gmail.com>

If you need to know what checks are (not) used to populate - you can identify every single check by
select name,

       decode(INST_CHK_Method, 1, 'NO', 2, 'Object', 4,'Test', 'Unknown') INST_Check,

       decode(USG_DET_METHOD, 1, 'SQL', 2, 'PROCEDURE', 4,'Test', 'Unknown') USG_DET_METHOD,

       USG_DET_LOGIC
from sys.wri$_dbu_feature_metadata where upper(name) like upper('%&1%');

and if USG_DET_METHOD is PROCEDURE, read the procedure named in USG_DET_LOGIC.

you can run this procedure with a simple anonymous block like this (just change the procedure to anything you are interested): set serveroutput on

declare

    feature number;

    aux       number;
    info      clob := empty_clob();

begin
  sys.dbms_feature_goldengate(
    feature, aux, info
  );

    dbms_output.put_line(' Feature: ' || feature);
    dbms_output.put_line(' Aux:     ' || aux);
    dbms_output.put_line(' Info:    ' || info);

end;
/

I've done a presentation on those topics at DOAG2015 - http://www.slideshare.net/berxx/473721-dba-featureusagestatistics

but as always the disclaimer: that research is only about some objects in the DB, NOT an Oracle Audit.

Martin

2015-12-09 9:20 GMT+01:00 Stefan Knecht <knecht.stefan_at_gmail.com>:

> I found that view to be not very reliable. Some things aren't caught at
> all, for example what I documented here:
>
> http://www.pythian.com/blog/advanced-compression-option-oracle/
>
> I encountered other scenarios over the years which similarly didn't show
> up there. It's probably good to catch some obvious ones as you mentioned in
> the case of partitioning, but I wouldn't rely on its data to get through an
> audit.
>
> Stefan
>
>
>
>
> On Wed, Dec 9, 2015 at 3:20 AM, Matt Adams <MAdams_at_troversolutions.com>
> wrote:
>
>> Seems to be missing a few (Real application testing, OLAP, etc), but I
>> can probably adjust as needed.
>>
>>
>>
>> Many thanks
>>
>>
>>
>>
>>
>>
>>
>> *From:* Kellyn Pot'Vin-Gorman [mailto:dbakevlar_at_gmail.com]
>> *Sent:* Tuesday, December 08, 2015 3:13 PM
>> *To:* Matt Adams
>> *Cc:* oracle-l_at_freelists.org
>> *Subject:* Re: extra cost options and DBA_FEATURE_USAGE_STATISTICS
>>
>>
>>
>> Yes, this blog post will tell you the exact query to do so and no, you
>> don't have to use EM12c to do so and I won't hold it against you IDF you
>> don't, (much:))
>> http://dbakevlar.com/2013/12/em12c-information-reporting/
>>
>> Good luck,
>> Kellyn
>>
>> On Dec 8, 2015 13:09, "Matt Adams" <MAdams_at_troversolutions.com> wrote:
>>
>> We currently using v11.2 EE on solaris
>>
>>
>>
>> During a licensing audit last year, we found out that a developer started
>> using partitioning even though it’s not licensed on the development
>> servers, which obviously cost us money for licensing that we hadn’t
>> anticipated spending.
>>
>>
>>
>> So, my boss wants to know if we can come up with a report that we can run
>> regularly that will examine the DBA_FEATURE_USAGE_STATISTICS table and tell
>> use which extra-cost options we are using.
>>
>>
>>
>> Before I go through and figure out row-by-row which items related to
>> extra cost options and which ones don’t, has anybody else already gone
>> through this exercise?
>>
>>
>>
>> I did couple of google queries and a brief look through metalink (yes,
>> dammit, I still call it metalink) and didn’t find anything.
>>
>>
>>
>> Matt Adams
>>
>> **** This communication may contain privileged and/or confidential
>> information. If you are not the intended recipient, you are hereby notified
>> that disclosing, copying, or distributing of the contents is strictly
>> prohibited. If you have received this message in error, please contact the
>> sender immediately and destroy any copies of this document. ****
>>
>> **** This communication may contain privileged and/or confidential
>> information. If you are not the intended recipient, you are hereby notified
>> that disclosing, copying, or distributing of the contents is strictly
>> prohibited. If you have received this message in error, please contact the
>> sender immediately and destroy any copies of this document. ****
>>
>
>

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

Received on Wed Dec 09 2015 - 11:48:02 CET