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@xxxxxxxxx]
Sent: Tuesday, December 08, 2015 3:13 PM
To: Matt Adams
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxx<mailto:MAdams@xxxxxxxxxxxxxxxxxxx>> 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. ****
