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
[EMAIL PROTECTED] wrote:
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
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
The
order by st1.hash_value,ss.text_subset; -- deadlock avoidance
Statement in the following Statspack code causes the package not to compile.
Oracle 9.2.0.4.0 64 bit.
Compatible is set to 9.2.0
If I remove the two ORDER BY's in error the package compiles fine. Could
not find anything
: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
Ethan:
You can remove the order by if you are not using RAC. Basically it is
to avoid two identical SQLs inserted at the SAME time in RAC setup.
If you are using RAC just add another column in the order by
condition. (st1.hash_value,ss.text_subset,st1.piece)
I don't have the bug # handy. But
.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Post, Ethan
Sent: Monday, January 26, 2004 12:54 PM
To: Multiple recipients of list ORACLE-L
The
order by st1.hash_value,ss.text_subset; -- deadlock avoidance
Statement in the following Statspack code
Thanks.
Gee, the Oracle sales folks keep telling our Lead Architect that RAC
requires zero code changes...guess this was not true for Statspack.
:)
-Original Message-
Sent: Monday, January 26, 2004 12:14 PM
To: Multiple recipients of list ORACLE-L
Ethan:
You can remove the order
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
] wrote:
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
,
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.
All
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
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
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
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
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
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
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
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
Jan 2004 22:24:36
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
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
Hi
Statspack exceptionally showing the following on a particular day :-
Top 5 Wait Events
~ Wait %
Total
Event Waits Time (cs)
Wt Time
facts, having an opinion is an art !
-Original Message-
Sent: Tuesday, January 06, 2004 9:14 AM
To: Multiple recipients of list ORACLE-L
Hi
Statspack exceptionally showing the following on a particular day :-
Top 5 Wait Events
Just go in the spreport.sql ($ORACLE_HOME/rdbms/admin) and change the time
format for that output. On my W2K install it's at line 579 and then again
line 635 for the full wait events list.
At 07:14 AM 1/6/2004, you wrote:
Hi
Statspack exceptionally showing the following on a particular day
Alternate solution:
Don't run it for an hour. One would expect the accumulated wait times to be
smaller then and not leading to the value overflow.
At 07:14 AM 1/6/2004, you wrote:
Statspack taken from a Production Database for a 1 hour period on Oracle
8.1.7.4 version
Wolfgang Breitling
Oracle7
Hi Vivek,
I am not a statspack expert but your problem is simply an SQL issue. The
### means that the field format is not big enough for the value being
returned in the SQL. Simply open the SQL file and find the SQL that
prints this and look for the column format somewhere above that. Change
Your Parse time is high, and cpu is
close to elapsed, so you are almost
certainly hard-parsing all the time.
This is either a bug, or you have enough
parse activity going on, and a small enough
shared pool that you keep invalidating the
cursor (and it's dependents).
Did you report the
Thanks for the information - that test has
been on my TODO list for the last couple
of years. Apart from being useful information,
it also tells us that it's not the OP's problem,
as the number of different possibilities is too
low.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The
generated by
background
processes (Oracle support has confirmed there is a bug involved),
however, since that crash occurred, a certain nightly batch job has
slowed to a
crawl.
Trying to recreate what has happened, I came across this in the
STATSPACK report.
The interval
that looks
at the current memory requirements for a SQL statement.
http://www.jlcomp.demon.co.uk/sqlarea.html
Does the output match what you see in statspack?
Also, the number of executions is much lower than
the version count, which is rather odd. There's a bug
in early 9i versions that would
at the current memory requirements for a SQL statement.
http://www.jlcomp.demon.co.uk/sqlarea.html
Does the output match what you see in statspack?
Also, the number of executions is much lower than
the version count, which is rather odd. There's a bug
in early 9i versions that would cause
requirements for a SQL statement.
http://www.jlcomp.demon.co.uk/sqlarea.html
Does the output match what you see in statspack?
Also, the number of executions is much lower than
the version count, which is rather odd. There's a bug
in early 9i versions that would cause
Title: STATSPACK interpretation
Using
dbms_application_info package also causes that there are several versions of
same statement - but theyshare same execution plan. You cancheck if
this is the case by queryingv$sqlarea (module and action
columns).
Regards,
Joze
-Original Message
a bit excessive.
There is a script at Jonathan's site with some
info
about v$sqlarea and a script you can run that
looks
at the current memory requirements for a SQL
statement.
http://www.jlcomp.demon.co.uk/sqlarea.html
Does the output match what you see in statspack?
Also
Notes in-line.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see
for a SQL statement.
http://www.jlcomp.demon.co.uk/sqlarea.html
Does the output match what you see in statspack?
Also, the number of executions is much lower than
the version count, which is rather odd. There's a bug
in early 9i versions that would cause this, but was supposed
Thanks, Jonathan.
Of course you are right :-)
Playing with this a little longer, I can get up to 4
versions (child_number from 0 to 3) of the same pl/sql
cursor by changing bind variable sizes. It ceases
being sharable when bv size changes from 32 to 33,
from 128 to 129 and from 2000 to 2001:
Title: STATSPACK interpretation
We recently experienced a crash on our prod datewarehouse running 9.2.0.2 on
AIX 4.3.3. The cause of the crash was 4031 errors generated by background
processes (Oracle support has confirmed there is a bug involved), however,
since that crash occurred
to recreate what has happened, I came across this in the
STATSPACK report.
The interval for this report is 30 minutes.
Is it telling me that I have 746 versions of this call eating up 400+ mb
at
the time of the snapshot? Why would that be? The procedure in
question
uses bind variables
Query Shows DIFFERING values (taken concurrently) for:-
Execute from SQL_TRACE = 2584
Executions from Statspack report = 10,000
Qs. What is the reason for this?
Qs. Have we possibly missed some SQL trace files?
SQL_TRACE :-
call count cpuelapsed disk querycurrent
rows
Vivek,
as others have pointed out before, Statspack is instance wide snapshot. Trace file is
session specific.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
Vivek did mention single DB connect process, so this should increase the possibility
of statspack matching the trace file
Did you have parallel query occurring - as then the single trace wouldn't have caught
everything.
Are you SURE no other users were active at the same time - eg look
concurrently) for:-
Execute from SQL_TRACE = 2584
Executions from Statspack report = 10,000
Qs. What is the reason for this?
SQL_TRACE :-
call count cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
--
Parse
Hi.
Execute in sqltrace is for that particular session only whereas in statspack, it's system wide.
A lot of sessions might have executed the same query.
Best regards
VIVEK_SHARMA [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/17/2003 02:19 PM
Please respond to ORACLE-L
We are doing Interest processing on a SET of 10,000
Bank A/cs
Following SQL Query Shows DIFFERING values for :-
Execute from SQL_TRACE = 2584
Executions from Statspack report =
10,000
Qs. What is the reason for this?
SQL_TRACE :-
call count cpu elapsed disk
query current
We are doing Interest processing on a SET of 10,000 Bank A/cs
Following SQL Query Shows DIFFERING values for :-
Execute from SQL_TRACE = 2584
Executions from Statspack report = 10,000
Qs. What is the reason for this?
SQL_TRACE :-
call count cpuelapsed disk query
We are doing
Interest processing on a SET of 10,000 Bank A/cs
Following SQL
Query Shows DIFFERING values for :-
Execute from SQL_TRACE = 2584
Executions
from Statspack report = 10,000
Qs. What is the
reason for this?
SQL_TRACE :-
call
count cpu
elapsed disk
query current
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
Hi Scott,
Although the recommendation of RTFM often has it's merits, where precisely
do you suggest Seema should look for the above mentioned FM within the
*8.1.6* doco set for the sp* statspack scripts ?
Cheers
Richard Foote
- Original Message -
To: Multiple recipients of list ORACLE-L
Subject: Re: STATSPACK in Oracle 8.1.6.0
Hi Scott,
Although the recommendation of RTFM often has it's merits, where precisely
do you suggest Seema should look for the above mentioned FM within the
*8.1.6* doco set for the sp* statspack scripts ?
Cheers
Richard Foote
- Original
Hi,
I want to delete all old records of statspack from perfstat schema.
What would be best way to do this either by truncating all tables or remove
and recreate ?
Pl advice.
thx
-Seema
_
Add photos to your e-mail with MSN 8. Get 2
The latter.
Scripts are already supplied.
- Kirti
--- Seema Singh [EMAIL PROTECTED] wrote:
Hi,
I want to delete all old records of statspack from perfstat schema.
What would be best way to do this either by truncating all tables or remove
and recreate ?
Pl advice.
thx
-Seema
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, June 10, 2003 2:15 PM
To: Multiple recipients of list ORACLE-L
Hello All,
We have a job ( shell Script ) which deletes from the statspack tables
every
Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems
the statspack tables every
Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is
not deleting all tables and hence causing the tablespace to grow. Does
anybody has a different approach which deletes all table without any
referential integrity issues ??
I do not want to use
I just remove a
hundred
or so at a time.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, June 10, 2003 2:15 PM
To: Multiple recipients of list ORACLE-L
Hello All,
We have a job ( shell Script ) which deletes from the statspack
To: Multiple recipients of list ORACLE-L
Um, if I understand correctly, you're just trying to
keep the volume down in your statspack tables.
I use Tim Gorman's sppurpkg.sql package (on several
different versions across several different operating
systems). (www.evdbt.com)
I have it set up
at level 5, and my largest
table is 10 megs.
It's very odd that your STATS$LATCH_CHILDREN table is
nearly 3 gigs. I have to wonder if something else is
wrong. You might check your perfstat user to insure
that the user has adequate privs; you might even
consider removing and re-installing statspack
Search
MetaLink ... Burleson has a good book "High PerformanceTuning with
Statspack" .. Tom Kytes Book "Oneon One" in Chapter 10 also
hassome good information.. Look in your
$ORACLE_HOME/rdbms/admin and depending on you version their is a sp*.doc or
st*.txt document
, Michael
[mailto:[EMAIL PROTECTED]Sent: Tuesday, June 10,
2003 12:44 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: any intro statspack docs
online?
Search MetaLink ... Burleson has a good book "High
PerformanceTuning with Statspack" .. Tom Kytes Book
Hello All,
We have a job ( shell Script ) which deletes from the statspack tables every Sunday,
but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all
tables and hence causing the tablespace to grow. Does anybody has a different approach
which deletes all table
.
Stephen
[EMAIL PROTECTED] 06/10/03 12:14PM
Hello All,
We have a job ( shell Script ) which deletes from the statspack tables
every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems
like it is not deleting all tables and hence causing the tablespace to
grow. Does anybody has a different
To: Multiple recipients of list ORACLE-L
Hello All,
We have a job ( shell Script ) which deletes from the statspack tables every
Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is
not deleting all tables and hence causing the tablespace to grow. Does
anybody has a different
a job ( shell Script ) which deletes from the statspack tables every
Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is
not deleting all tables and hence causing the tablespace to grow. Does
anybody has a different approach which deletes all table without any
referential
Um, if I understand correctly, you're just trying to
keep the volume down in your statspack tables.
I use Tim Gorman's sppurpkg.sql package (on several
different versions across several different operating
systems). (www.evdbt.com)
I have it set up to keep 14 days of data, but you can
change
Nice one, John!
And quite portable. Runs on Solaris and Linux alike.
On HP-UX 11.0 I had to modify it slightly, but it
looks good too:
if [ $# -eq 1 ] ;then
UNIX95= ps -eo pid,pcpu,ruser,time,etime,args | grep
$1 | sort -nr +1 | awk '{if (NR = 20) print
substr($0,1,80)}'
else
same as above
Mogens, Dennis,
I know I am going to catch flames for this, but here
goes:
It seems to be quite fashionable to bash statspack,
but help me out in understanding the alternatives to
the StatsPack in the following cases:
Case1:
-
At the client I am currently with, they have some 50
Sent: Thursday, May 22, 2003 5:41
PM
Subject: any intro statspack docs
online?
Ive read the otn stuff and the niemic articles from Oracle
mag.anything else? any articles that give a brief intro that includes
installation? Id prefer not to dig into the Burleson book. Im really looking
experienced and have stared at 100's of Statspack
collection outputs and your system is behaving in some constant, predictable
manner.
Mogens
Boris Dali wrote:
Mogens, Dennis,
I know I am going to catch flames for this, but here
goes:
It seems to be quite fashionable to bash statspack
at 100's of Statspack collection outputs and your system is
behaving in some constant, predictable manner.
Mogens
Boris Dali wrote:
Mogens, Dennis,
I know I am going to catch flames for this, but here
goes:
It seems to be quite fashionable to bash statspack,
but help me out
As subject line indicates standard (level 5) snapshots
make vmstat 1 or sar -u 1 100 show 100% CPU
utilization (75% system mode) for about 3 seconds.
Is this normal? Is statspack that brutal on CPU? And
why would that be a system mode primarily?
Environment:
Oracle 9.2.0.2 on Mandrake 9.0
Boris - I'm not surprised in your results. I wouldn't describe STATSPACK as
brutal, but it is a significant hit, so you wouldn't want to start doing
snaps at 1 second intervals. STATSPACK does collect a LOT of data, and you
can adjust the amount of data collected with the level if you feel
Boris,
The default statspack snapshot is at level 5, which collects Top SQL (by
buffer and Phys reads, etc.) from the Shared pool, and that would cause
significant latching for a large shared pool which in turn results in a high
CPU usage. You could try a level 0 snapshot and look at the CPU
Thanks, Dennis.
I've been using statspack for quite some time now, but
I've never bothered to ask myself an obvious question,
namely what overhead does statspack impose on the
system (taking about Heisenberg's principle of
uncertainty, he-he)
I guess part of the reason is the fact
about c in the
raw traces?
Thanks John,
Boris Dali.
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Boris,
The default statspack snapshot is at level 5, which
collects Top SQL (by
buffer and Phys reads, etc.) from the Shared pool,
and that would cause
significant latching for a large shared
pool this might be significant.
My point is to just collect the information that is of value to you. If a
level 0 gets you everything you need, go with that. When I suggest writing
your own routines, I'm not proposing that you could collect all the
information STATSPACK collects more efficiently
writing
your own routines, I'm not proposing that you could
collect all the
information STATSPACK collects more efficiently, but
if you only use one or
two pieces of information and you need a level 5
snapshot to get it, then
you might consider a quick script to collect just
what you need. Also
Thanks, John.
No there's no paging/swapping going on (1GB real
memory for a single 200MB SGA and just a couple of
users).
Out of curiousity, John. I usually measure paging via
vmstat (si/so columns on Linux and pi/po everywhere
else - everywhere else being HP-UX, Solaris and
AIX), as well as
[mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: statspack snapshots cause 3-4 sec of 100% CPU utilization
Thanks, John.
No there's no paging/swapping going on (1GB real
memory for a single 200MB SGA and just a couple
Couldn't agree more. We need to stop using StatsPack for gathering lots
and lots of stats we can't use for anything anyway. When two experts can
look at the same summary data and get to different conclusions you're
not gathering data at the correct level. It's sort of like the
economists
available!
** The opinions and statements above are entirely my own and not those of my
employer or clients **
-Original Message-
From: Boris Dali [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: statspack snapshots
] On Behalf Of
Bob Metelsky
Sent: Thursday, January 23, 2003 4:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Statspack recomendations.
Go to bookpool.com. Best prices on tech books. I've ordered
several books from them and have always been happy.
Yes definetly
] On Behalf Of
Bob Metelsky
Sent: Thursday, January 23, 2003 4:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Statspack recomendations.
Go to bookpool.com. Best prices on tech books. I've ordered
several books from them and have always been happy.
Yes definetly
H. It seems that I don't get replies to a lot of my posts. Do I ask
the hard questions or just stupid ones? On sencond thought, don't answer
that... ;)
In any case, in reinventing the wheel, I decided to just create a function
that uses a REF CURSOR to generically concat the column for me:
Hey all,
In 8.1.7.4, does anyone have a SQL that will take the output from the
following:
SELECT sql_text
FROM PERFSTAT.STATS$SQLTEXT SS
WHERE SS.HASH_VALUE = :myhash
ORDER BY PIECE
...and append/concat all the rows into a single column.
I *know* someone's done this before and I don't want to
Thanks! I have the 8.1.7 scripts, do I have to install
them in the 8.0.6.3 databases? Ruth
- Original Message -
From:
DENNIS
WILLIAMS
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 29, 2003 2:49
PM
Subject: RE: STATSPACK
Ruth - I think you
Thanks Scott! That's just what I need.
Ruth
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 29, 2003 5:19
PM
Subject: RE: STATSPACK
See:http://www.oracle.com/oramag/oracle/00-Mar/index.html
On Wednesday 29 January 2003 16:38, Viktor wrote:
Jared,
You've got all the knowledge, for real! Is there a possibility of
I wish.
performance decrease when running statspack in Oracle 8.0.5? Thanks,
I'm running level 0 snapshots every 15 minutes on 8.0.4 with
no noticeable impact.
Jared
Hello everyone,
I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3
instance?
Thanks in advance,
Ruth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
I believe that an 8.1.7 statspack can run on an Oracle8 or higher database.
Dave
-Original Message-
Sent: Wednesday, January 29, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Hello everyone,
I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3
instance
1 - 100 of 319 matches
Mail list logo