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@xxxxxxxxxxxxxxxxxxx>
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@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> 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. ****