Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How much efforts in order to set this up?
ps, your graph is very impressive. I still have trouble to make the graph from excel. Thanks to Dennis, after I changed text to cloumns, it made a little progress. But I am still struggling to make it work. Joan [EMAIL PROTECTED] wrote: > > If you're willing to go to the trouble of setting up Perl, DBI, > DBD::Oracle, DBD::Chart > and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I > use to generate charts. > > It includes some modifications to YAPPPACK. > > That sound OK Mogens? > > Jared > > Joan Hsieh > <[EMAIL PROTECTED]> To: Multiple > Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L > <[EMAIL PROTECTED]> > 01/22/2004 09:19 AM cc: > Please respond to ORACLE-L Subject: Re: What to > look for in STATSPACK report > > Jared, > > I played YAPPPACK quite often some time ago. I like it very much. But > somehow I failed to generate the gif file from the csv file as sample > shown. Can someone shade me some light on this? I tied very hard to > make > the graphs from the csv file but just don't know how. > > Thanks, > > Joan > > Jared Still wrote: > > > > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Joan Hsieh > 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: Joan Hsieh 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).