Re: Tools/monitoring question
- From: kyle Hailey <kylelf@xxxxxxxxx>
- To: pete.sharman@xxxxxxxxxx
- Date: Fri, 19 Jul 2013 11:23:25 -0700
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>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 | | 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@xxxxxxxxx]
> Sent: Friday, July 19, 2013 5:38 PM
> To: Peter Sharman; Christopher.Taylor2@xxxxxxxxxxxx;
> 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>
> To: Christopher.Taylor2@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Cc: Peter Sharman <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 | | 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@xxxxxxxxxxxx [mailto:
> Christopher.Taylor2@xxxxxxxxxxxx]
> Sent: Thursday, July 18, 2013 12:58 AM
> To: 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
> christopher.taylor2@xxxxxxxxxxxx
> 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:
