RE: Tools/monitoring question
Date: Wed, 17 Jul 2013 10:55:30 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E887A2D17E74_at_NADCWPMSGCMS10.hca.corpad.net>
I use snapper but its biggest usefulness seems to be when examining specific sessions. I thinking more of an overview/system level type set of scripts (reporting maybe?). Thinking thru this, I'm probably going to have to write a set of reports that will give me varying degrees of performance data (top waits, top sessions) by intervals. I know AWR does this but it generates a LOT of information that takes some time to generate where my aim is to get a quick snapshot on demand. Maybe snapper will give me what I want - I need to go back and investigate what it will give me and how presentable it is versus what I'm looking for. Thanks!
Chris
From: Don Seiler [mailto:don_at_seiler.us]
Sent: Wednesday, July 17, 2013 10:48 AM
To: usn_at_usn-it.de
Cc: Taylor Christopher - Nashville; ORACLE-L
Subject: Re: Tools/monitoring question
I'd highly recommend getting familiar with at least a couple of the basic options for Tanel Poder's snapper.sql.
http://tech.e2sn.com/oracle-scripts-and-tools/session-snapper
On Wed, Jul 17, 2013 at 10:22 AM, Martin Klier <usn_at_usn-it.de<mailto:usn_at_usn-it.de>> wrote: Impacting users without Enterprise Manager and Spotlight is not that easy.
But generating AWR (or Statspack) reports is always a good idea to find out what's going on - by means of how resources are wasted, and which SQL is responsible for the worst.
What I do a lot is:
http://www.usn-it.de/index.php/2012/09/10/effecting-oracle-miracles-with-standard-edition-and-statspack-without-awr/
But with Diagnostics Pack enabled, using ASH is great too.
Regards
Martin Klier
Christopher.Taylor2_at_Parallon.com<mailto:Christopher.Taylor2_at_Parallon.com> schrieb:
> 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<mailto:christopher.taylor2_at_parallon.com>
> www.parallon.com<http://www.parallon.com><http://www.parallon.com>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Usn's IT Blog for Oracle and Linux http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-l -- Don Seiler http://www.seiler.us -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 17 2013 - 17:55:30 CEST