RE: Tools/monitoring question
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <kylelf@xxxxxxxxx>, <pete.sharman@xxxxxxxxxx>, <jkstill@xxxxxxxxx>, <dbvision@xxxxxxxxxxxx>, <shrekdba@xxxxxxxxx>
- Date: Mon, 22 Jul 2013 08:18:56 -0500
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@xxxxxxxxx]
Sent: Friday, July 19, 2013 1:23 PM
To: pete.sharman@xxxxxxxxxx
Cc: cdunscombe@xxxxxxxxx; Taylor Christopher - Nashville; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx<mailto:pete.sharman@xxxxxxxxxx>> 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@xxxxxxxxx<mailto:cdunscombe@xxxxxxxxx>]
Sent: Friday, July 19, 2013 5:38 PM
To: Peter Sharman;
Christopher.Taylor2@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>;
oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxx<mailto:pete.sharman@xxxxxxxxxx>>
To: Christopher.Taylor2@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>;
oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Cc: Peter Sharman <pete.sharman@xxxxxxxxxx<mailto:pete.sharman@xxxxxxxxxx>>
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@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>
[mailto:Christopher.Taylor2@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>]
Sent: Thursday, July 18, 2013 12:58 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxx<mailto:christopher.taylor2@xxxxxxxxxxxx>
www.parallon.com<http://www.parallon.com><http://www.parallon.com>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
