RE: Quantum data in EM repository?

From: Herring, David <HerringD_at_DNB.com>
Date: Thu, 24 Sep 2015 23:25:22 +0000
Message-ID: <CY1PR0201MB1049C917A7B7FCC0ABDEC543D4430_at_CY1PR0201MB1049.namprd02.prod.outlook.com>

That's awesome! Thx Pete.

Regards,

Dave

[cid:image001.png_at_01D05044.5C2AEE60]

Dave Herring
DBA
103 JFK Parkway
Short Hills, New Jersey 07078
Mobile 630.441.4404

dnb.com<http://www.dnb.com/>

[cid:image002.png_at_01D05044.5C2AEE60]<http://www.facebook.com/DunBradstreet>[cid:image003.png_at_01D05044.5C2AEE60]<http://twitter.com/dnbus>[cid:image004.png_at_01D05044.5C2AEE60]<http://www.linkedin.com/company/dun-&-bradstreet>[cid:image005.png_at_01D05044.5C2AEE60]<http://www.youtube.com/user/DunandBrad>

From: Peter Sharman [mailto:pete.sharman_at_oracle.com] Sent: Thursday, September 24, 2015 6:02 PM To: Herring, David; oracle-l_at_freelists.org Subject: RE: Quantum data in EM repository?

Dave

I've bounced this one up to our EM architect who knows these views far better than me (which is not difficult, I must admit!) He's travelling for work this week so it'll probably be next week before I get a response from him.

Pete
[Oracle logo]
Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA Phone: +61262924095<tel:+61262924095> | | Fax: +61262925183<fax:+61262925183> | | Mobile: +61414443449 Email: pete.sharman_at_oracle.com<mailto: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: Herring, David [mailto:HerringD_at_DNB.com] Sent: Friday, September 25, 2015 6:11 AM To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: Quantum data in EM repository?

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 Fri Sep 25 2015 - 01:25:22 CEST