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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] > 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: '[EMAIL PROTECTED]' > > > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).