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

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 22 Jan 2004 16:34:28 -0800
Message-ID: <F001.005DDEB0.20040122163428@fatcity.com>

Chris - In Excel, click on Data --> Text to Columns.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com=20

-----Original Message-----
Sent: Thursday, January 22, 2004 1:00 PM To: Multiple recipients of list ORACLE-L

I had this same problem. It ended up being that when I opened the file = in
exel, all the columns from the csv went into one excel column and for = some
reason it wasn't apparent....or something like that. .....now if I = could
only remember what it was I did to fix it. hmmm.

.i think it was some searching and replacing or something.

.that should get you started though.

..sorry for the not so helpful post, but maybe this will trigger something.

chris

-----Original Message-----
Sent: Thursday, January 22, 2004 11:19 AM To: Multiple recipients of list ORACLE-L

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:

>=20

> You will find a utility add on for statspack at Mogens company site,
> www.miracleas.dk. It is called YAPPPACK.
>=20
> You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to =
generate
> response time graphs for your databases.
>=20
> 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?

>=20

> 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?

>=20

> Use YAPPPACK to track response times. When response times spike
> abnormally, then dig into the statspack data.

>=20

> JMO,

>=20

> Jared

>=20

> On Sun, 2004-01-18 at 23:54, Mogens N=C3=B8rgaard 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: =3D?ISO-8859-1?Q?Mogens_N=3DF8rgaard?=3D
> > INET: mln_at_miracleas.dk
> >
> > 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).
> >

>=20

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com

>=20


> 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).
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20
Author: Joan Hsieh
INET: joan.hsieh_at_tufts.edu

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). --=20
Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20
Author: Chris Stephens
INET: ChrisStephens_at_affina.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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).

Received on Thu Jan 22 2004 - 18:34:28 CST