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
3:49 PM
To: Multiple recipients of list ORACLE-L
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
script, but you could re-write a local
copy that queries the snap_ids of interest and feeds it to the rest of
the code cutting out the interactive part. That seems like a pretty
easy idea. Oracle will likely change statspack thus hurting your local
copy one day.
I used expect to do this because
of statistics stored in your STATSPACK tables. Consider direct
queries against these tables to measure performance trends over time. In Don
Burleson's book he has many scripts that will produce trend reports. And you
can modify these scripts to suit your needs. Take a look at his book, and I
think
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
hi, dba friends:
I am analyzing my new added rac database running rac 9.2 on linux cluster.I
did a statspack report and surprised to find the following data:
Top 5 Timed Events
~~ % Total
Event
more and more here, but I am a lazy typist ;-) )
On Tuesday 27 August 2002 14:48, you wrote:
hi, dba friends:
I am analyzing my new added rac database running rac 9.2 on linux
cluster.I did a statspack report and surprised to find the following data:
Top 5 Timed Events
£¬
hi, go to $ORACLE_HOME/rdbms/admin, ls sp*, you will find the sqls
that needed by statspack. and vi spdoc.txt, you will know what statspack is.
There is some paper on statspack performance tuning on otn. and
donald burleson also wrote a book on statspack: oracle statspack high
performance
Thanks Chaos for your invaluable information.
Chuan
-Original Message-
Sent: Thursday, 8 August 2002 7:34 PM
To: Multiple recipients of list ORACLE-L
Chuan Zhang£¬
hi, go to $ORACLE_HOME/rdbms/admin, ls sp*, you will find the sqls that needed
by statspack. and vi spdoc.txt
Just a quick note to thank everyone for the contributions to this and the
ODBC stuff I posted recently.
Regards
Lee
-Original Message-
Sent: 10 August 2002 20:53
To: Multiple recipients of list ORACLE-L
The original question on this thread was for an automated purge for
STATSPACK
respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:FW: STATSPACK Info
All good stuff at the links below.
Regards
Lee
http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html
http://www.oracle.com/oramag
of dba level accounts
such as dbsnmp and outln by Oracle is fixable as well. But I'll wager
there are folks out there who didn't know the grants on the statspack
tables were to public.
Of course none of our developers or ad hoc query writers would ever
write a statement that doesn't use bind
To wit:
$grep -i grant spctab.sql
grant select on STATS$SNAPSHOT_ID to PUBLIC;
grant select onSTATS$DATABASE_INSTANCE to PUBLIC;
grant select onSTATS$SNAPSHOT to PUBLIC;
grant select onSTATS$FILESTATXS to PUBLIC;
grant select onSTATS$TEMPSTATXS to
Sounds like yet another good reason for using bind variables 8-)
Kevin Kennedy
First Point Energy Corporation
-Original Message-
Sent: Wednesday, July 24, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L
To wit:
$grep -i grant spctab.sql
grant select on STATS$SNAPSHOT_ID
Why not just backup the spctab.sql script and then in vi do a g:/PUBLIC/s//DBA or whatever
role you choose to play with statspack before running. Although bind vars are still
appropriate too.
Rodd Holman
On Wed, 2002-07-24 at 12:23, kkennedy wrote:
Sounds like yet another good
I'm not saying it's not fixable. The
creation of dba level accounts such as dbsnmp and outln by Oracle is fixable as
well. But I'll wager there are folks out there who didn't know the
grants on the statspack tables were to public.
Of
course none of our developers or ad hoc query writers
[EMAIL PROTECTED] 07/24/02 04:20PM
I'm not saying it's not fixable. The creation of dba level accounts
such as dbsnmp and outln by Oracle is fixable as well. But I'll wager
there are folks out there who didn't know the grants on the statspack
tables were to public.
Of course none of our
Hey all,
Finally have installed STATSPACK on 8.1.7.2.0, but am disappointed at the
archaic two-lines-per-row 80-columns in spreport.sql.
Anyone have any links to some report SQL that formats STATSPACK reports a
little better? I'll probably use TOAD for my usage, but I'll take anything
to start
Take a look at www.oraperf.com
-Original Message-
Sent: Monday, July 22, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
Hey all,
Finally have installed STATSPACK on 8.1.7.2.0, but am disappointed at
the
archaic two-lines-per-row 80-columns in spreport.sql.
Anyone have any
Mr. Burleson wrote a thick book on Customized reporting from Statspack :)
Some of those scripts may be of some help to you. I am sure those are
available at Oracle Press web site.
- Kirti
-Original Message-
Sent: Monday, July 22, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L
away. This has worked quite well for
me.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, July 19, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I've been having problems with a STATSPACK index running out of extents in
8.1.7. Turns
A. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Statspack Intervals
I don't think it will. V$SQLAREA gives information on
executions, disk reads, logical reads, etc.
It tells nothing about waits. Joining the two
All,
I've just been
rolling out statspack against all of our production DBs. What I am not sure
about is how often I should take a snapshot ?
I am planning on
holding one months worth of data and then backing it up and then purging.
How often do you
guys take snapshots and does my
of list ORACLE-L
Sent: Wednesday, July 10, 2002 11:43
AM
Subject: Statspack Intervals
All,
I've just been
rolling out statspack against all of our production DBs. What I am not sure
about is how often I should take a snapshot ?
I am planning on
holding one months worth
Thanks
for that.
Regards
Lee
-Original Message-From: Anjo Kolk
[mailto:[EMAIL PROTECTED]]Sent: 10 July 2002 11:33To:
Multiple recipients of list ORACLE-LSubject: Re: Statspack
Intervals
Lee,
The rule of thumb is:
Monitoring: 15 to 30 minute interval
Problem
Lee - Good advice from Anjo. If you're getting into STATSPACK this heavily,
you may want to take a look at Burleson's High-Performance Tuning with
STATSPACK. He has a lot of ideas for using STATSPACK as a comprehensive
proactive monitoring tool. He also has some good info on his web site.
Dennis
10, 2002 3:43
AMTo: Multiple recipients of list ORACLE-LSubject:
Statspack Intervals
All,
I've just been
rolling out statspack against all of our production DBs. What I am not sure
about is how often I should take a snapshot ?
I am planning on
holding one months worth
Statspack is a very nice tool, however if one
really wants to find problems lurking in a database even five minute intervals
can be too long. By finding problems I mean locating inefficiencies
proactively. As good as the first few chapters of "Database Tuning 101"
are, the boo
To: Multiple recipients of list ORACLE-L
Statspack is a very nice tool, however if one really wants to find problems
lurking in a database even five minute intervals can be too long. By
finding problems I mean locating inefficiencies proactively. As good as the
first few chapters of Database
? In a previous life (at a
company with abudget), I used Precise to good effect. In an later
previous life I compared Preciseagainst the Quest "me too" tool (the name
escapes me at the moment)and found them to both be a huge improvement over
estat/bstat or statspack. Of course, the price of
Thanks Dennis, I'll take that on board.
Lee
-Original Message-
Sent: 10 July 2002 15:33
To: Multiple recipients of list ORACLE-L
Lee - Good advice from Anjo. If you're getting into STATSPACK this heavily,
you may want to take a look at Burleson's High-Performance Tuning
it, if interested.
Jared
MacGregor, Ian A. [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/10/2002 09:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Statspack Intervals
Statspack is a very nice
, 2002 4:33 PM
Lee - Good advice from Anjo. If you're getting into STATSPACK this
heavily,
you may want to take a look at Burleson's High-Performance Tuning with
STATSPACK. He has a lot of ideas for using STATSPACK as a comprehensive
proactive monitoring tool. He also has some good info on his
I don't think it will. V$SQLAREA gives information on executions, disk reads,
logical reads, etc.
It tells nothing about waits. Joining the two tables you mention does not show you
who has been running the queries, just who parsed them originally. Yes, the rest of
statspack does have
to
know which queries suffered the greatest waits. I want to exclude queries which were
run as part of an export dump. Statspack gives me only part of what I want.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 10, 2002
with,
because deleting is SLOOOW!! As I recall, deleting a 100 snapshots may
take
30 minutes. Anyway, this is the best way I've found to delete STATSPACK
statistics.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, July 08, 2002 3:25 PM
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 08, 2002 5:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: STATSPACK and sppurge.sql
Jesse - I'm doing this from memory, so I may be off a little.
Look at the
table STATS$SNAPSHOT
Hi all,
I'm going to (finally!) be implementing STATSPACK on our 8.1.7.2.0 DB. The
thing that kills me is all the junk that ?/rdbms/admin/sppurge.sql leaves
behind! Is there any harm in deleting the rows from these tables:
select table_name
from user_tab_columns
where
-Original Message-
From: Jesse, Rich
Sent: Monday, July 08, 2002 2:22 PM
To: '[EMAIL PROTECTED]'
Subject: STATSPACK and sppurge.sql
Hi all,
I'm going to (finally!) be implementing STATSPACK on our
8.1.7.2.0 DB. The thing that kills me is all the junk that
?/rdbms/admin/sppurge.sql
are
automatically deleted. Since deleting statistics is a low-risk proposition
for most of us, give it a try. Start by deleting 10 rows to start with,
because deleting is SLOOOW!! As I recall, deleting a 100 snapshots may take
30 minutes. Anyway, this is the best way I've found to delete STATSPACK
Hi List,
How can I use statspack which already installed for an instance using for
another instance or I have to install it individualy for each instances, I
try to find some thing in the spdoc.txt but no hope.
I have installed statpack under one of my instances, but when I try to use
it for any
AFAIK, it has to be installed on every instance to be monitored and it's not
support otherwise. Nevertheless, all the Statspack code is supplied and it's
easy to hack at. (Been there done that.) Basically all it's doing is reading
stuff out of the V$ tables so you could get at that data on other
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon,
Bruce (CALBBAY)
Sent: Monday, May 20, 2002 10:08 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Statspack Problem
Have you connected via BEQ or Net8 initially?
Have you got
with statspack over the last 3
hours and now I have another question. But new question, new email.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom
Schruefer
Sent: Tuesday, May 21, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE
I am running 8.1.6 on a Win2000 SP2 machine.
When I try running 'statscre.sql' as SYS, the first script completes fine,
but when the second script tries to connect perfstat/perfstat , I get the
error, You are no longer connected to Oracle TNS:ORA-12154. Of course the
system then proceeds to
Have you connected via BEQ or Net8 initially?
Have you got oracle_sid set as an environment variable, as it looks like the connect
perfstat/perfstat uses a BEQ connection.
After connecting as sys, can you now do a connect perfstat/perfstat (though maybe
the scripts cleaned up on error and
Cherie,
I have been trying to figure out your upload problems. And I noticed that your
report of statspack looks like it is from 8.1.6, but there are some small
differences.
Can you tell me the source of this statspack, where did you get it ? Did you
modify any of it. I am contemplating a fix
When I try to use YAPP to analyze my STATSPACK report, I get an error
message which states that my SQL is wrapping or too long. It says that I
should set my pagesize and linesize correctly.
The report looks o.k. to the naked eye.
I looked all over their website but I don't see anywhere
Cherie,
Send the report to me, so I can have a look what is causing the problem. On
the secondary upload site, this shouldn't be a problem anymore. It may fail on
the primary.
Anjo.
[EMAIL PROTECTED] wrote:
When I try to use YAPP to analyze my STATSPACK report, I get an error
message
Hi,
I have a question with regard to the best scheduling for Statspack. I am
running Oracle 8.1.6.2 on Hp UX11. I see that the oraperf site recommends
no more than intervals of (5 to 15 minutes) to tune performance problems.
Does setting up a schedule with 96 or 288 snaps at level
Hello All,
I have a need to purge the old statistics accumulated by statspack and I
am manually using the 'SPPURGE" ( I pass 'losnapid' and 'hisnapid' ) utility ,
instead I would like have a PL/SQL program which can be automated through
DBMS_JOB . Would somebody help me in this .
T
Hello All,
I am trying to install the statspack utility by assigning PERFSTAT user to a
locally managed tablespace of size 500 MB, it is giving me the following
error
create table STATS$LEVEL_DESCRIPTION
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment
Hello,
I suggest that you read the readme file for the STATSPACK installation. If
8.1.7, it says that it needs approx. 45MB. You could create a schema, or use
something like TOOLS for the default tblsp, and use TEMP for the temporary
tblsp. Also, I would suggest that you read the articles
recipients of list ORACLE-L
Hello All,
I am trying to install the statspack utility by assigning PERFSTAT user to a
locally managed tablespace of size 500 MB, it is giving me the following
error
create table STATS$LEVEL_DESCRIPTION
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent
Hello,
I suggest that you read the readme file for the STATSPACK installation. If
8.1.7, it says that it needs approx. 45MB. You could create a schema, or use
something like TOOLS for the default tblsp, and use TEMP for the temporary
tblsp. Also, I would suggest that you read the articles on STATSPACK
All,
I am trying to install the statspack utility by assigning PERFSTAT user to a
locally managed tablespace of size 500 MB, it is giving me the following
error
create table STATS$LEVEL_DESCRIPTION
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace
trying to install the statspack utility by assigning PERFSTAT user to a
locally managed tablespace of size 500 MB, it is giving me the following
error
create table STATS$LEVEL_DESCRIPTION
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace
CCXSTL01
.
The extent size for my LMT is 128K.
Steve Orr
Bozeman, MT
-Original Message-
Sent: Friday, March 29, 2002 12:44 PM
To: Multiple recipients of list ORACLE-L
Hello All,
I am trying to install the statspack utility by assigning PERFSTAT user to a
locally managed tablespace of size 500 MB
Perhaps he is not installing as user SYS. The PERFSTAT user is granted
UNLIMITED tablespace in the install scripts on the tablespace that is
selected, so either there is not enough free space or the grant is bombing
because he is not SYS...or something else that I am not thinking about at
the
Yep , Ethan , you are mistaken , Seems my problem is with very big extents ,
I will try with small extents , let all you guys know.
-Original Message-
Sent: Friday, March 29, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L
Perhaps he is not installing as user SYS. The PERFSTAT
Madhu,
Did you try -
1. Diagnosing performance with Statspack - Oracle Magazine - March/April
2000
2. Performance tuning with statspack, Part II - Oracle Technical White
Paper, July 2000
-Shaibal
From: Reddy, Madhusudana [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple
Reddy,
Bjorn Engsig wrote a white paper about statspack. Download it from
http://www.oraperf.com/whitepapers.html (Getting fast results with STATSPACK)
Anjo.
Reddy, Madhusudana wrote:
Hello ALL,
I have set up the statspack on Oracle 8.1.7 and just now I also got the
REPORT , but poor me
? If that is the question,
I would recommend that you invest in the book Oracle High-Performance
Tuning with STATSPACK by Don Burleson, available at your local bookstore.
Don offers some articles on-line at http://www.dba-oracle.com/articles.htm
Let me know if that is the information that you want.
Dennis
to write your own queries? If that is the question,
I would recommend that you invest in the book Oracle High-Performance
Tuning with STATSPACK by Don Burleson, available at your local bookstore.
Don offers some articles on-line at http://www.dba-oracle.com/articles.htm
Let me know
No you don't need a book as such it is a pretty neat schema. Read the
spreport.sql and sprepins.sql scripts, they will tell you a lot of things
that you need to know.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot
Hello ALL,
I have set up the statspack on Oracle 8.1.7 and just now I also got the
REPORT , but poor me unable to understand that . Can anybody help me out in
this ... Well I know www.oraperf.com will do it for me by sending a report ,
but I want to do it myself by writing some queries ... would
that generate reports as well as
comments in the report. I found the book and especially the scripts
real worth while.
As far as writing you own query, you could use the scripts provided
with Statspack and the book as a baseline and get your own canned
reports.
I have used scripts that I have collected
To get resonable results from the reports, your timing interval should
be around 10 to 30 minutes. As running statspack collection every that often
is likely to produce far too much data than you want to have space for, I
always recommend running statspack collection in a system like
REF: PG 3 MARCH/APRIL 2000
DBAs can set specific level of running statspack. Level 0 Level 5 does not impact resource usage that much so that you notice the difference. But Oracle warns not to run Level 10 cause it is marked as resource intensive.
Level 10 Statspack collects all statistics from
Title: STATSPACK impact?
Just curious, but if your shop uses STATSPACK, could you tell me how frequently you run it,
particularly in your OLTP databases; and whether you've noticed any performance issues with
generating frequent STATSPACK snapshots?
Thanks
:48 -0800
Thomas Jeff [EMAIL PROTECTED] wrote:
Just curious, but if your shop uses STATSPACK, could you tell me how
frequently you run it,
particularly in your OLTP databases; and whether you've noticed any
performance issues with
generating frequent STATSPACK snapshots?
Thanks
Hi,
I just want to check something about statspack. Might seam like a silly
question, but I just want to check.
In the Instance Efficiency section, you have the hit ratios. Normally when
people check these, it is from instance startup. I was just wondering if
statspack is the same, or does
HI James,
This will tell you these percentages during the time you are reporting on.
John
[EMAIL PROTECTED] wrote:
Hi,
I just want to check something about statspack. Might seam like a silly
question, but I just want to check.
In the Instance Efficiency section, you have the hit ratios
[EMAIL PROTECTED] wrote:
Hi,
I just want to check something about statspack. Might seam like a silly
question, but I just want to check.
In the Instance Efficiency section, you have the hit ratios. Normally when
people check these, it is from instance startup. I was just wondering if
statspack
Srinivas -
- I assume that you have the Oracle Magazine articles. If not, they
are available on-line.
- I'm confused (easily done). You say that you are tuning SQL
statements that statspack has identified and you want more information on
statspack report interpretation. To me
. If not,
they
are available on-line.
- I'm confused (easily done). You say that you are tuning SQL
statements that statspack has identified and you want more information
on
statspack report interpretation. To me that is two separate issues.
- How statspack identifies the top SQL statement offenders
Hi lists,
I have a request to tune the sql statements that are generated in the
statspack report. I have a puff document on statspack. But it is of only
7 pages and explains only how to install and run statspack.
Does anybody have any document / link for statspack report
intepretations
Raj,
I think there is a book devoted to Statspack if you search Amazon or
Bookpool.
Scott Shafer
San Antonio, TX
Jamadagni, Rajendra wrote:
Hope the list is up ... this message just returned to me about half hour ago
...
Are there any docs available on interpreting statspack output
-
Sent: 14 November 2001 15:45
To: Multiple recipients of list ORACLE-L
Raj,
I think there is a book devoted to Statspack if you search Amazon or
Bookpool.
Scott Shafer
San Antonio, TX
Jamadagni, Rajendra wrote:
Hope the list is up ... this message just returned to me about half hour
ago
Hope the list is up ... this message just returned to me about half hour ago
...
Are there any docs available on interpreting statspack output other than the
report itself? I checked Metalink but couldn't find much.
Thanks in advance
Raj
so long as you look at the wait events, you will
be looking at your database's bottlenecks, and in the
world of Oracle Performance Tuning, that is all that
counts.
What about v$sql?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL
i would probably first use v$sqlarea instead of v$sql
to be able to identify the hash values for bad
ones(high lio's) and then probe v$sql using the same.
Deepak
--- Greg Moore [EMAIL PROTECTED] wrote:
so long as you look at the wait events, you will
be looking at your database's
Hi Greg,
I had already covered the part of getting down to the
SQL earlier in my response.
Gaja
--- Greg Moore [EMAIL PROTECTED] wrote:
so long as you look at the wait events, you will
be looking at your database's bottlenecks, and in
the
world of Oracle Performance Tuning, that is all
Howdy,
I must not know what I'm doing here. I ran a Statspack report for 2
different periods of time, each an hour long. In the first case, my instance
efficiency percentages look pretty bad. They look like this:
Instance Efficiency Percentages (Target 100
Hi Bill,
Cache-hit ratios are probably one of the most
irrelevant and misleading metrics that one has to deal
with in the Oracle performance tuning space. You have
real proof in your hands in the form of 2 statspack
reports. Yes you are comparing apples to oranges, as
the performance health
Hi,
Can some one pl help find the relation between the snap_id and the time it
was taken. I want ot generate a report for a period of time but having a
hard time trying to figure out the starting snap_id and the end snap_id
for the period.
Thanks in advance.
Anjan
--
Please see the official
Take a look at the statsrep.sql script.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
ORACLE-L
Subject:Remove Statspack Snapshots
Anyone found a more efficient way to remove a statspack snapshot prior to
8.17?
***METALINK SAYS***
7) How do I remove StatsPack snapshots that I am no longer interested in?
This functionality is available in Oracle 8.1.7
Rights
Reserved.
Rem
RemNAME
Rem statsdel.sql
Rem
RemDESCRIPTION
Rem SQL*Plus command file to remove old snapshot
values
Rem
RemNOTES
Rem Usually run as the STATSPACK owner, PERFSTAT
Rem
RemMODIFIED (MM/DD/YY)
Remnjohnsto.uk 06/13/00 - Created
Rem
How are you using the 168 snapshots to gather information? I saw a tool out
there that will turn your statspack info into a graphical representation. I
would certainly hate pouring through tons of output from spreport.sql. I
have my own performance monitor for watching most of this stuff. I
probabaly define foreign keys with cascade option and
delete from stast$snapshot .. i love friday nights ;)
deepak
--- Post, Ethan [EMAIL PROTECTED] wrote:
Anyone found a more efficient way to remove a
statspack snapshot prior to
8.17?
***METALINK SAYS***
7) How do I remove StatsPack
Anyone found a more efficient way to remove a statspack snapshot prior to
8.17?
***METALINK SAYS***
7) How do I remove StatsPack snapshots that I am no longer interested in?
This functionality is available in Oracle 8.1.7 using a script called
sppurge.sql located
-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-Original Message-
Sent: Thursday, September 13, 2001 6:15 PM
To: Multiple recipients of list ORACLE-L
!! Please do not post Off Topic to this List !!
Hi, Gurus:
Did you try the Statspack? Will this new feature
increase
!! Please do not post Off Topic to this List !!
Hi, Gurus:
Did you try the Statspack? Will this new feature
increase the performance a lot? how about the
dbms_stats pachage?
Thanks in advance.
Chris Harvest.
Creative Consulting.
__
Terrorist
!! Please do not post Off Topic to this List !!
Statspack does not increase performance. It is an improved version of
utlbstat utlestat. You can find the install instructions on metalink. Once
it is installed you can take periodic performance snapshots and analyze. I
find it is really best
201 - 300 of 319 matches
Mail list logo