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
:
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
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 the
standpoint
of response-time analysis, as described in the white papers at
http://www.oraperf.com
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.
All of the ratio stuff on the STATSPACK report is ignored by the
YAPP
- -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
.
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.
All of the ratio stuff on the STATSPACK report is ignored
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
.
All of the ratio stuff on the STATSPACK report is ignored by the YAPP
analyzer, and instead the reformatting looks at things from the standpoint
of response-time analysis, as described in the white papers at
http://www.oraperf.com/whitepapers.html;.
Yes, I know OraPerf is now owned by Veritas
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 the
standpoint
of response-time analysis, as described in the white papers at
http://www.oraperf.com/whitepapers.html;.
Yes, I know OraPerf
of the ratio stuff on the STATSPACK report is ignored by the YAPP
analyzer, and instead the reformatting looks at things from the
standpoint
of response-time analysis, as described in the white papers at
http://www.oraperf.com/whitepapers.html;.
Yes, I know OraPerf is now owned by Veritas and the real URLs
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
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
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
. 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
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
. 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
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
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
--
Title: Re: Statspack Report!
Without looking at other parts of the report, there is no way of telling if this information is important or not. There is not enough timing information displayed to understand whether these issues are a significant part of your databases performance or not.
Please
Hi all,
could you please clarify me what these might mean (and how to tune the db in order to avoid those).
So I have done a performance report with statspack and the instance is 9.2.0.3 on Solaris8 box. On a report there are a couple of issues I don't understand:
Child Get Spin Latch Name Num
Hello All,
I am working on understanding the statspack report. To understanding it
better I would like to compare my report with a report on well tuned low
OLTP database . Some of you guys might have used the statspack to well tune
your DB and now it might be running at peak performance , if you
Someone had asked this question ... maybe this will help ..
Batch mode report generation
To run a report without being prompted, assign values to the
and the report name before running spreport.
The variables are:
begin_snap -
EXCELLENT! This is EXACTLY what I was looking for. Thank you very much!
Erik
-Original Message-
Sent: Friday, August 30, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
Someone had asked this question ... maybe this will help ..
Batch mode report generation
I have the collections of snapshots scheduled in DBMS_JOBS, but I was
looking for a way to automate running of the reports from these snapshots.
It looks as though there is no easy way to do this.
Thanks for the quick responses.
Erik
-Original Message-
Sent: Wednesday, August 28, 2002
it up someday...miracles can
happen.
Here is my little qd:
#!/usr/local/bin/tclsh
# - run local statspack report for last two snaps
# - mail report output
package require Expect
set rwd /home/stellr/statspack
## start sqlplus session
set cmd /db03/app/oracle/product/8.1.7/bin/sqlplus /nolog
Erik - I'm suggesting that you may be looking at the issue from the
spreport.sql perspective. Spreport just compares the performance between two
distinct snapshots. Rather than automating this report, consider a fresh
approach. If you collect snapshots at regular intervals, then you have a
wealth
I would like to schedule the creation of statspack reports with DBMS_JOBs.
The statsrep.sql script does not take any arguments and seems to require
user interaction. Has anyone here tried to automate the creation of these
reports? I am being asked to produce these reports by other people in my
On Wed, Aug 28, 2002 at 08:52:03AM -0800, Erik Williams wrote:
I would like to schedule the creation of statspack reports with DBMS_JOBs.
The statsrep.sql script does not take any arguments and seems to require
user interaction. Has anyone here tried to automate the creation of these
reports?
Erik - Two thoughts for you.
1) If you are looking at regular collection of STATSPACK statistics, take a
look at Don Burleson's book Oracle High-Performance Tuning with STATSPACK.
He offers many scripts for reporting on selected STATSPACK statistics over
time, rather than just point in time
ORACLE-L
Subject:Schedule Statspack Report Creation
I would like to schedule the creation of statspack reports with DBMS_JOBs.
The statsrep.sql script does not take any arguments and seems to require
user interaction. Has anyone here tried to automate the creation of these
reports? I am
Hierarchical, network and relational. That's what it was.
My true age is - as per 4th of May this year - is 40. Big party, band playing,
etc. About 130 guests. My wish list for all the guests I had invited was very
short. Among the very few items were black socks, the latest book by John le
Subject: Re: Statspack report !! Resending Can someone help Please
Hierarchical, network and relational. That's what it was.
My true age is - as per 4th of May this year - is 40. Big party, band
playing,
etc. About 130 guests. My wish list for all the guests I had invited was
very
short
)
==
Valiveru, Siva wrote:
All,
Can some there PLEASE clarify this question..
what is the corelation between user calls in the statspack report to
number of sql's executed during the timeframe..
This is what i am doing please correct me !!
We
Hi Mogens,
I think SQL*Net was called SQL*Star or something, at least
with version 5?
SQL*Star, as I remember it was SQL*Net + OpenGateway (or something like
that). It was basically SQL*Net to other DBMS. (And there were three types
of DBMS's - Hierarchical, something else, and that
All,
Can some there PLEASE clarify this question..
what is the corelation between user calls in the statspack report to
number of sql's executed during the timeframe..
This is what i am doing please correct me !!
We are trying to capture the total number of sql's calls during two time
events
All,
Can some there PLEASE clarify this question..
what is the corelation between user calls in the statspack report to
number of sql's executed during the timeframe..
This is what i am doing please correct me !!
We are trying to capture the total number of sql's calls during two time
events
The following is from a Statspack report from an 8.0.5 database on a Sun
server during a load test.
Can anyone explain what type of enqueues these are and where I can find some
doco on them? I did look on MetaLink and Steve Adams' site.
Thanks.
Enqueue activity for DB
Enqueue
CI - Cross-instance Call Invocatiom
UL - User-defined locks
[EMAIL PROTECTED] wrote:
The following is from a Statspack report from an 8.0.5 database on a Sun
server during a load test.
Can anyone explain what type of enqueues these are and where I can find some
doco on them? I did look
47 matches
Mail list logo