Message-
From: Anjo Kolk [mailto:[EMAIL PROTECTED]
Sent: 27 January 2004 13:29
To: Multiple recipients of list ORACLE-L
Subject: RE: What to look for in STATSPACK report
No, the server is in my basement.
Anjo.
-Original Message-
Rachel Carmichael
Sent: Tuesday
disappeared and I had to (re)subscribe to
www.oraperf.com.
--
David Lord
-Original Message-
From: Anjo Kolk [mailto:[EMAIL PROTECTED]
Sent: 27 January 2004 13:29
To: Multiple recipients of list ORACLE-L
Subject: RE: What to look for in STATSPACK report
No, the server is in my basement
No,
It is mine!
Anjo.
-Original Message-
Rachel Carmichael
Sent: Friday, January 23, 2004 11:49 AM
To: Multiple recipients of list ORACLE-L
well, I can't get to the site at the moment to test it.. if I remember
correctly, Anjo said he had leased it to Veritas for a couple of
years,
that's pretty definitive. :)
I did say retaining permanent ownership
Is Veritas hosting it for you?
--- Anjo Kolk [EMAIL PROTECTED] wrote:
No,
It is mine!
Anjo.
-Original Message-
Rachel Carmichael
Sent: Friday, January 23, 2004 11:49 AM
To: Multiple recipients of list
No, the server is in my basement.
Anjo.
-Original Message-
Rachel Carmichael
Sent: Tuesday, January 27, 2004 11:44 AM
To: Multiple recipients of list ORACLE-L
that's pretty definitive. :)
I did say retaining permanent ownership
Is Veritas hosting it for you?
--- Anjo Kolk [EMAIL
- -Original Message-
- From: Anjo Kolk [mailto:[EMAIL PROTECTED]
- Sent: Tuesday, January 27, 2004 8:29 AM
- To: Multiple recipients of list ORACLE-L
- Subject: RE: What to look for in STATSPACK report
-
-
- No, the server is in my basement.
why? was it being a bad server
0kay, then the alcohol we were consuming fogged my brain :)
getting older is a pain in the butt... I do know I was getting emails
from Veritas about the oraperf site. That must be where the confusion
lies
--- Anjo Kolk [EMAIL PROTECTED] wrote:
No, the server is in my basement.
Anjo.
Kolk [mailto:[EMAIL PROTECTED]
Sent: 27 January 2004 13:29
To: Multiple recipients of list ORACLE-L
Subject: RE: What to look for in STATSPACK report
No, the server is in my basement.
Anjo.
-Original Message-
Rachel Carmichael
Sent: Tuesday, January 27, 2004 11:44 AM
:Re: What to look for in STATSPACK report
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
Hi Tim,
Are you sure it's still owned by Veritas? Doesn't look that way when I
checked it just now.
Mogens
Tim Gorman wrote:
Helmut,
Register with http://www.oraperf.com; and run those STATSPACK reports
through the YAPP analyzer, which will reformat them in such a way that they
make sense.
well, I can't get to the site at the moment to test it.. if I remember
correctly, Anjo said he had leased it to Veritas for a couple of
years, while retaining permanent ownership.
On the other hand, he's on this list, he can confirm or deny that
himself!
--- Mogens_Nørgaard [EMAIL PROTECTED]
I've tried to get ahold of Anjo off-list several times. I'm sure he is
busy, but I really need to get ahold of him. Can someone off-list ask
him to e-mail me at either/both of these addresses?
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Thanks
Stephen
[EMAIL PROTECTED] 01/23/04 12:19AM
Hi Tim,
cc:
Please respond to ORACLE-LSubject: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
ltiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: What to look for in STATSPACK report
Date: Fri, 23 Jan 2004 08:19:25 -0800
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 m
respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: What to look for in STATSPACK report
Hi Jared,
Is this offer open to everybody -:) I would like to get the perl/shell stuff you are referring to. I had problem to install DBI
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
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 apparentor something like that. .now if I could
only remember what it was I did to fix it. hmmm.
..i think it was some
Chris - In Excel, click on Data -- Text to Columns.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-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
09:19 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
]
Sent by: [EMAIL PROTECTED]
01/22/2004 09:19 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
Chris - In Excel, click on Data -- Text to Columns.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-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
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
Helmet,
Mogens makes a lot of good points as normal. As usual it's never as simple as
we'd like it too be and it depends on how your system runs. One thing that is
worth monitoring is changes in statistic values over time.
For example if your buffer cache hit ratio is normally 85% during your
Helmut,
Performance, like beauty, is in the eye of the beholder. Ideal thresholds only
exist in poor tuning courses and poor tuning books. IMHO, the wisest thing to do would
be to collect information at a time when performance is perfectly satisfactory and use
it as a baseline. Then check
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
Helmut,
Register with http://www.oraperf.com; and run those STATSPACK reports
through the YAPP analyzer, which will reformat them in such a way that they
make sense.
All of the ratio stuff on the STATSPACK report is ignored by the YAPP
analyzer, and instead the reformatting looks at things from
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
--
27 matches
Mail list logo
