RE: MGMT_DB_FEATUREUSAGE is empty

This is outside of my purview in EM but one of my colleagues will be in contact and act as your intermediary between yourself and Development if needed.  If he doesn’t reach out to you in the next 24 hours, please let me know.  He’s based out of Europe so it may be a tad late for that to happen till tomorrow his time. J

Pete

Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA

Phone: HYPERLINK "tel:+61262924095"+61262924095 | | Mobile: +61414443449  Email: HYPERLINK "mailto:pete.sharman_at_oracle.com"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: Le, Binh T. [mailto:Binh.Le_at_lfg.com] Sent: Friday, May 27, 2016 04:38 AM
To: rjoralist3_at_society.servebeer.com; oracle-l_at_freelists.org Subject: RE: MGMT_DB_FEATUREUSAGE is empty

Hi David,

Run this query against your OEM repository database check if you have the feature usage collection turn on.

I think 12c default is not collect this information also check to see at your target level (your database also need to collect this information too)

select t.target_name

      ,c.coll_name

      ,c.is_enabled

      ,c.schedule_ex

from sysman.mgmt_targets t

 left join sysman.mgmt_collections c on t.target_guid = c.object_guid

  and c.coll_name like 'feature_usage_collection_item'

where t.target_type in ('rac_database','oracle_database')

  and t.target_name like '%'||:your_database_name ||'%'

order by t.target_name,c.coll_name;

From: HYPERLINK "mailto:oracle-l-bounce_at_freelists.org"oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich J Sent: Thursday, May 26, 2016 2:18 PM
To: HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org Subject: Re: MGMT_DB_FEATUREUSAGE is empty

On 2016/05/26 11:45, Herring, David wrote:

I have a request from management to pull feature usage statistics for all supported environments so I figured I'd use the view MGMT$DB_FEATUREUSAGE on all EMs.  While the 11g views give me what I want, our 12c EMRs don't return anything as the underlying table MGMT_DB_FEATUREUSAGE is empty.  The OMS is 12.1.0.4, db 12.1.0.2, all on RHEL 6.6.

Anyone see this before and/or know how this table is populated?

It looks like the data I'm expecting is in MGMT$CS_FEATURE_USAGE, which is new in 12c, but I can't be sure.  I also have noted that other MGMT$DB_* views are populated so it appears to be just this one.

I have these views in my 12.1.0.5 OMS respository, under the SYSMAN schema:

CM$MGMT_FEATURE_USAGE_ECM
MGMT$CS_FEATURE_USAGE
MGMT$DB_FEATUREUSAGE
MGMT$DB_FEATURE_USAGE

Of these, the last is empty, possibly a leftover from upgrades past.  All of my DB targets are 11.2.0.3 and my EM DB Agent plugin is 12.1.0.8.

As you've probably guessed, the underlying MGMT_DB_FEATUREUSAGE table to the MGMT$DB_FEATUREUSAGE view is populated.  It's not an EM metric, so I'm not sure why this would not be populated (i.e. it's not a matter of a metric being disabled).

Rich

Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

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