[oracle-l] Re: What to look for in STATSPACK report

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 <joan.hsieh@xxxxxxxxx>
Sent by: ml-errors@xxxxxxxxxxx
 01/22/2004 09:19 AM
 Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L <ORACLE-L@xxxxxxxxxxx>
        cc: 
        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: mln@xxxxxxxxxxxx
> >
> > 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@xxxxxxxxxxx (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: jkstill@xxxxxxxxxx
> 
> 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@xxxxxxxxxxx (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: joan.hsieh@xxxxxxxxx

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@xxxxxxxxxxx (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).




Other related posts: