Re: Quantum data in EM repository?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 25 Sep 2015 07:37:54 +0100
Message-ID: <CABe10sYZwpE25ZTnbYmVmCujsA0mhqFhQkGV1y8V4YqbUu5P8w_at_mail.gmail.com>

Use the guids you must?!
On 25 Sep 2015 03:56, "Peter Sharman" <pete.sharman_at_oracle.com> wrote:

> Yoda's EM architect, actually! (in joke, for those that are confused)
>
> Pete
>
> Sent while mobile, please excuse my typos!
>
> On 25 Sep 2015, at 9:29 am, Tim Gorman <tim_at_evdbt.com> wrote:
>
> Schrodinger's EM Architect?
>
>
>
> On 9/24/15 17:25, Herring, David wrote:
>
> That's awesome! Thx Pete.
>
>
>
> Regards,
>
>
>
> Dave
>
>
>
> <mime-attachment.png>
>
>
>
> *Dave Herring*
>
> DBA
>
> 103 JFK Parkway
>
> Short Hills, New Jersey 07078
>
> Mobile 630.441.4404
>
>
>
> *dnb.com <http://www.dnb.com/>*
>
>
>
> [image: cid:image002.png_at_01D05044.5C2AEE60]
> <http://www.facebook.com/DunBradstreet><mime-attachment.png>
> <http://twitter.com/dnbus><mime-attachment.png>
> <http://www.linkedin.com/company/dun-&-bradstreet>[image:
> cid:image005.png_at_01D05044.5C2AEE60]
> <http://www.youtube.com/user/DunandBrad>
>
>
>
> *From:* Peter Sharman [mailto:pete.sharman_at_oracle.com
> <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
>
> <mime-attachment.jpg>
>
> Pete Sharman
> Database Architect, DBaaS / DBLM
> Enterprise Manager Product Suite
> 33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
>
> Phone: +61262924095 | | Fax: +61262925183 | | Mobile: *+61414443449
> <%2B61414443449>*
> Email: pete.sharman_at_oracle.com Twitter: _at_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 [ <HerringD_at_DNB.com>mailto:HerringD_at_DNB.com
> <HerringD_at_DNB.com>]
> *Sent:* Friday, September 25, 2015 6:11 AM
> *To:* 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 - 08:37:54 CEST