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.

 
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----Original Message-----
Sent: Thursday, September 19, 2002 3:03 PM To: Multiple recipients of list ORACLE-L

This has me thinking. What exactly do you want to graph? I guess I'm just trying to see some value in graphing data from a single SP report. Graph waits as a pie chart? Or would it be for several reports combined?

Also, after looking again at the layout of an SP report, a home-rolled query would do much better at feeding MRTG or GNUPLOT.

Just wondering if I can get myself into yet another project... :)

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

> -----Original Message-----
> From: John Kanagaraj [mailto:john.kanagaraj_at_hds.com]
> Sent: Thursday, September 19, 2002 12:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Staspack Grapher/Viewer ?
>
>
> This product seems to use the now infamous CHR which has been
> banned from
> this list :)
>
> Has anyone figured out how to use MRTG (or Cricket) to get
> this done? [Why
> buy when you can use Open Source!]

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).