Quantum data in EM repository?

From: Herring, David <HerringD_at_DNB.com>
Date: Thu, 24 Sep 2015 20:11:02 +0000
Message-ID: <CY1PR0201MB1049433E7325DABD98E6E7F5D4430_at_CY1PR0201MB1049.namprd02.prod.outlook.com>



Folks,

I've got a strange situation in querying data in MGMT$TARGET_ASSOCIATIONS in a 12.1.0.2 EM repository. We have 7 different EM repositories and I'm trying to pull data from all for a report, "Oracle Real Application Cluster (RAC) Database Topology". It's a great EM report but obviously it's only local. I thought it'd be great for management if I copied that report, created table versions of various MGMT$* views, then had a weekly job to pull from each repository into these C_MGMT$* tables.

This all works EXCEPT a number of rows in MGMT$TARGET_ASSOCIATIONS are playing hide-and-seek. Within the report above, chart "Aggregated RAC Databases Nodes Distribution" uses a cursor against this view. When I noticed the consolidated data didn't look correct I checked one of the 12c repositories and ran the following as SYSMAN:

SELECT COUNT(*) FROM sysman.mgmt$target_associations

WHERE SUBSTR(source_target_name, 1, 8) IN (<various database names>)

   AND assoc_def_name = 'contains';

          COUNT(*)


                92

SELECT COUNT(*) FROM sysman.mgmt$target_associations WHERE assoc_def_name = 'contains';

          COUNT(*)


                 0

The 2 cursors use different plans which might hint at a wrong results issue. Since this cursor involves views of views ... I checked the following:

SELECT /*+ NO_QUERY_TRANSFORMATION */ COUNT(*) FROM sysman.mgmt$target_associations ta WHERE assoc_def_name = 'contains';

          COUNT(*)


              2506

I'm not missing something incredibly obvious with EM data, am I?

Regards,

Dave

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 24 2015 - 22:11:02 CEST

Original text of this message