RE: Tools/monitoring question
Date: Mon, 22 Jul 2013 08:18:56 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E887A3DC2D77_at_NADCWPMSGCMS10.hca.corpad.net>
Thank you to everyone who responded! I now have a few additional items in my toolbox that I believe will open up many new ways of attacking a problem or challenge in the future. It is pleasing [beyond words] to know that I'm not terribly exposed if my favorite tool(s) are not available at any particular time as I have backup options available. Thanks again to all of you!
Chris
From: kyle Hailey [mailto:kylelf_at_gmail.com]
Sent: Friday, July 19, 2013 1:23 PM
To: pete.sharman_at_oracle.com
Cc: cdunscombe_at_yahoo.com; Taylor Christopher - Nashville; oracle-l_at_freelists.org
Subject: Re: Tools/monitoring question
For global perspective tools :
This looks cool http://jagjeet.wordpress.com/2012/09/20/sql-dashboard-v2/ !
Almost never use http://dboptimizer.com/ash-masters-2/ashmon/ these days. Wrote a web enabled version which code wise is much simpler though I haven't hammered on it much, W-ASH<http://dboptimizer.com/2011/10/31/w-ash-web-enabled-ash/>, web enabled ASH and it works on Standard Edition.
What I use most is lab128<http://dboptimizer.com/2013/02/17/lab-128-expert-dbas-secret-weapon/> which is super fast! It requires a payfor license. It also works on standard edition.
For most people who want something free and fast I point them to MOATS<http://blog.tanelpoder.com/2011/03/29/moats-the-mother-of-all-tuning-scripts/> by Tanel and Adrian.
I keep a list of tools at http://dboptimizer.com/2011/01/12/best-oracle-peformance-tools and am always looking for feedback on peoples experiences.
- Kyle Hailey http://dboptimizer.com
On Fri, Jul 19, 2013 at 1:30 AM, Peter Sharman <pete.sharman_at_oracle.com<mailto:pete.sharman_at_oracle.com>> wrote: 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<tel:%2B61262924095> | | Fax: +61262925183<tel:%2B61262925183> | | Mobile: +61414443449<tel:%2B61414443449>
"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<mailto:cdunscombe_at_yahoo.com>]
Sent: Friday, July 19, 2013 5:38 PM
To: Peter Sharman; Christopher.Taylor2_at_Parallon.com<mailto:Christopher.Taylor2_at_Parallon.com>; oracle-l_at_freelists.org<mailto: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<mailto:pete.sharman_at_oracle.com>> To: Christopher.Taylor2_at_Parallon.com<mailto:Christopher.Taylor2_at_Parallon.com>; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Cc: Peter Sharman <pete.sharman_at_oracle.com<mailto: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<tel:%2B61262924095> | | Fax: +61262925183<tel:%2B61262925183> | | Mobile: +61414443449<tel:%2B61414443449>
"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> [mailto: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<mailto: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<tel:615.344-8419>
christopher.taylor2_at_parallon.com<mailto:christopher.taylor2_at_parallon.com>
www.parallon.com<http://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 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 22 2013 - 15:18:56 CEST