RE: Staspack Grapher/Viewer ?

Ahhhhh, that makes much more sense to me. That's more the idea I had in mind when I installed STATSPACK. That, and the ability to be able to look back in time to potentially see why our nightly jobs are still running at 8:00 AM. (insert system-stats-vs-session-stats argument here) :)

Thanks, Dennis!

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> Sent: Thursday, September 19, 2002 4:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Staspack Grapher/Viewer ?
>
>
>
> Sent: Thursday, September 19, 2002 2:55 PM
> To: 'ORACLE-L_at_fatcity.com'
>
>
> Rich - I think the original poster mentioned Don Burleson's book. Don
> suggests you take multiple STATSPACK snapshots over time, say
> every hour for
> a week, then query the STATSPACK tables directly to, say
> graph database
> transactions over time. From this you can identify the peak times your
> database is being used, either day of week, or time of day. Once you
> identify the peak usage times, you can drill in deeper to identify the
> problems in that area, like maybe the waits. You may perform some
> small-interval STATSPACK snapshots in that time area.
> Don presents a simple idea of doing a simple query and then
> cutting an
> pasting that into MS Excel. I've done this and you can create
> some pretty
> impressive-looking charts very quickly. The drawback is that method is
> pretty labor-intensive and it is easy to make an error and produce an
> erroneous chart. I would highly recommend it as a prototype
> method, or if
> you are a consultant that needs to quickly produce some
> impressive charts
> for your clients.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).