RE: Tools/monitoring question

From: Peter Sharman <pete.sharman_at_oracle.com>
Date: Fri, 19 Jul 2013 01:30:41 -0700 (PDT)
Message-ID: <70b73da6-f966-4d55-ab96-7eab18b573c2_at_default>



Wolfgang asked exactly the same question. I did actually reply to this earlier, but I sent two messages to oracle-l at once and got a message about over-quoting on one, from which I couldn't actually identify the message that was over-quoted, so I assume it must have been this one. If not, I apologize for resending the message.

My reply to Wolfgang was something along the lines of this (can't find the damn thing now so retyping it from memory):

"Sorry for the delayed response, I've been down with a stomach bug. :(

Yes, EM Express does require a Diagnostics Pack license to use the Performance screens. Having said that, the original poster also mentioned they had Spotlight. I have a vague recollection that Spotlight also uses a Diag Pack license. I know one of the non-Oracle tools out there does that, and I think that was Spotlight."

Of course, I don't know the ins and outs of Spotlight so I might be wrong on that, so please do double check.

In any case, you are correct, it does need a license and I should have made that point earlier.

Pete

Pete Sharman
Principal Product Manager
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA Phone: +61262924095 | | Fax: +61262925183 | | Mobile: +61414443449 

"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

-----Original Message-----
From: Chris Dunscombe [mailto:cdunscombe_at_yahoo.com] Sent: Friday, July 19, 2013 5:38 PM
To: Peter Sharman; Christopher.Taylor2_at_Parallon.com; oracle-l_at_freelists.org Subject: Re: Tools/monitoring question

Hi Pete,
Don't you need the Diagnostics pack for for the Performance screens in EM Express? And as I'm sure you know many sites aren't licensed to use the Diagnostics pack.

Cheers,

Chris



 From: Peter Sharman <pete.sharman_at_oracle.com> To: Christopher.Taylor2_at_Parallon.com; oracle-l_at_freelists.org Cc: Peter Sharman <pete.sharman_at_oracle.com> Sent: Thursday, 18 July 2013, 0:27
Subject: RE: Tools/monitoring question  

What is this concept of being "too dependent upon Grid Control"?  I don't understand.  ;)

Seriously, while I know it's too early for most folks, have a look at the Performance screens in EM Express.  All you gotta do is migrate all your databases to DB12c, and I just KNOW you're planning that already!  :)

Pete

Pete Sharman
Principal Product Manager
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA Phone: +61262924095 | | Fax: +61262925183 | | Mobile: +61414443449 

"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

-----Original Message-----
From: Christopher.Taylor2_at_Parallon.com [mailto:Christopher.Taylor2_at_Parallon.com] Sent: Thursday, July 18, 2013 12:58 AM
To: oracle-l_at_freelists.org
Subject: Tools/monitoring question

I have come to the realization I've become a little too dependent upon Grid Control for giving me a "quick overview" of system performance.  Those colorful graphs are like DBA crack ;) So let's say Grid is down or I'm in an environment where Grid is not available.  I'm pretty good with SQL but I still like that overview that Grid gives me where I can quickly identify "blips" related to performance.

I'm curious what tools/scripts you guys have in your toolboxes to give you a quick overview when your favorite tool is unavailable.  I have several tools in my toolbox as well, but nothing quite as good as Grid when it comes to giving me that "big picture" view to quickly see issues that are impacting users.

I do have Spotlight available but we haven't configured it and I'm not entirely sure I want to go that route as it adds objects to the database. I have Toad as well but I'm really thinking along the lines of SQL scripts would be handy.

Thoughts?

Chris D. Taylor
Oracle DBA
Parallon ITS
6640 Carothers Parkway
Franklin, TN  37067
P:  615.344-8419
christopher.taylor2_at_parallon.com
www.parallon.com<http://www.parallon.com>

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


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


--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 19 2013 - 10:30:41 CEST

Original text of this message