You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK.
You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens NÃrgaard wrote: > Hi Helmut, > > There are so many opinions about this that it's hard to point at one > specific document or recommendation. If anything, start with stuff > written by Graham Wood (who has done a good deal of the work on it), > Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about > it in his new book, so go look on asktom.oracle.com for his opinions > about it. > > If you hope to find threshold numbers for certain values, etc.... then > someone would have automated it a loooong time ago. There can be two > reasons for this not having happened: It depends on the installation, > situation, etc. - or a lot of system-level measurements are in reality > useless. That's pretty much my opinion, but thankfully a lot of much > smarter people disagree with me. > > Best regards, > > Mogens > > Daiminger, Helmut wrote: > > >Hi! > > > >We want to introduce a performance monitoring policy here. We are using the > >STATSPACK utility. > > > >What are sections in statspack reports to look for? What are threshold > >numbers for these values? > > > >Does anybody have any power points or papers about it? > > > >This is 9.2 on HP-UX. > > > >Thanks, > >Helmut > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).