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 by
H on our 9204 instance this package is compiled with the order by ... our
compatible is set to 9.2.0.4
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
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
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
the f
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,
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 :-
modify the sql file and change the format string ... ### indicates value overflow.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have fac
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
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 Invalidati
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:
1-3
FWIW. The database crashed again.I managed to get in a 10466:
BEGIN
GENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ;
END;
call count cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
--
Parse 2737
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 htt
Jonathan,
Wouldn't bind variable issue that prevents cursor from
sharing be visible in bind_mismatch?
How can one simulate this?
var v varchar2(1)
begin select count(5) into :v from dual; end;
/
select address, sql_text from v$sql where sql_text
like '%count(5)%';
ADDRESS SQL_TEXT
Title: STATSPACK interpretation
Using
dbms_application_info package also causes that there are several versions of
same statement - but they share same execution plan. You can check if
this is the case by querying v$sqlarea (module and action
columns).
Regards,
Joze
-Original Mes
Thanks Jonathan.
I was wondering about those memory columns possibly
acting in that manner. I've never used them to
track memory though, and wasn't sure how they might
act. Google and MetaLink didn't turn up anything
too useful in the regard.
Now that you mention it, I recall reading recently
I recall James Morle saying something about
code not being sharable if the declared sizes
of the bind variables don't match. If Informatica
is using a 3GL to call anonymous pl/sql blocks
with different bind variables every time, perhaps
it is causing a bind variable mismatch.
As for the 400MB -
Thomas,
The version count is the number of child cursors
present in the cache for this SQL. The cursor is
not being shared for some reason with 456 versions.
The 400m of memory seems a bit excessive.
There is a script at Jonathan's site with some info
about v$sqlarea and a script you can run th
Jared,
Digging into it more, I found out that it's called from an
Informatica client. Apparently, the gist of the client-side
algorithim is as follows:
For each row in (some view)
Call generate_product_keys
MERGE (upsert) into product table
end loop
CREATE OR REPLACE PROCEDURE generat
What is taking place inside GENERATE_PRODUCT_KEYS() ?
Could be dynamic SQL of the worst kind in there. That
is, not using bind variables.
A 10046 trace level 4 or 12 will show you what is
going on there.
Jared
On Mon, 2003-12-22 at 12:39, Thomas Jeff wrote:
> We recently experienced a crash on
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 database’s performance or not
ist 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 sc
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
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
RTFM, which will point you to the sp*.sql scripts in the "?/rdbms/admin"
directory.
Scott Shafer
San Antonio, TX
210.581.6217
> -Original Message-
> From: Seema Singh [SMTP:[EMAIL PROTECTED]
> Sent: Thursday, July 17, 2003 2:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject:
What you need is detailed information over time. Start with SQL
statements, into sessions, into the instance level. The problem is that
this means that tons of data will be collected. So one has to be clever
and reduce the amount of data collected. If you have data over time
(SQL, session, instanc
Good points, Boris. Thanks for that.
If all users are doing the same things, then I guess system-wide data could
indicate what's wrong for the average user. You can also use system-wide
data to see if something changes overall on the system, then try to dig deeper
- but only if you are very e
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+
application
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 wo
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 that w
clients **
> -Original Message-
> From: Boris Dali [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.
>
> N
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 v
Thanks, Dennis. I am with you on your point about GUI
tools...
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Boris - I think John has an excellent point (as
> always). I just remembered
> that one vendor (can't recall which) has some sort
> of "stealth" method to
> directly sample the SQL buff
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 utili
edhim.org' for Grace and Mercy that is freely
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:
Boris - I think John has an excellent point (as always). I just remembered
that one vendor (can't recall which) has some sort of "stealth" method to
directly sample the SQL buffer. They make a big deal about how it doesn't
impact your system, so I would infer as John says that with a large shared
p
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 the ne
Thanks, John.
Any insight as to why is it primarily the system mode
CPU? I've seen high system mode CPU utilization in
non-Oracle stuff (like NFS), but for Oracle I thought
it should be primarily user mode?
Does Oracle's "CPU used by this session" represents
user-, kernel-mode or both? And what a
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 that
statspack.s
] [mailto:[EMAIL PROTECTED] 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
> > sev
ED] 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 f
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
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
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
Jared,
You've got all the knowledge, for real! Is there a possibility of performance decrease when running statspack in Oracle 8.0.5?
Thanks,
Viktor
[EMAIL PROTECTED] wrote:
No, but you can run the 8.1.6 version.There's a couple of special scripts for doing so.http://www.oracle.com/oramag/oracle/
e recipients of list ORACLE-L
> Subject: RE: STATSPACK
>
> Ruth,
>
> I've heard people talk about "downgrading" the statspack scripts to
> earlier versions, but I've never done it. Try searching "downgrade
> STATSPACK" on Metalink and OTN f
Ruth,
I run statspack on our 8.0.6.0 instance...however rather than running statsrep.sql I
run statsrep80.sql...I think I downloaded from Tim Gorman's site http://www.evdbt.com/
or maybe http://www.oraperf.com/index.html
marc
Navignat International
Oracle DBA
-Original Message-
Sent:
Ruth,
I've heard people talk about "downgrading" the statspack scripts to
earlier versions, but I've never done it. Try searching "downgrade
STATSPACK" on Metalink and OTN for starters.
Good luck
Stephen
>>> [EMAIL PROTECTED] 01/29/03 12:59PM >>>
I believe that an 8.1.7 statspack can run on an
No, but you can run the 8.1.6 version.
There's a couple of special scripts for doing so.
http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.html
Jared
"Ruth Gramolini" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/29/2003 10:53 AM
Please respond to ORACLE-L
Ruth - I think you can, but you must run the 8.1.7 scripts there. Do you
have the 3 Oracle magazine articles that introduced STATSPACK? I think this
was mentioned there.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, January 29, 2003 12
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?
ks you can find on
Amazon.com!
-Original Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 24,
2003 7:45 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Statspack recomendations.
I get the error on solaris 9 and 9.2.0.2 excep
I also get it on 9.2.0.1 on Win2K, same
error code as Robert:
Connected to:Oracle9i Enterprise Edition
Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data
Mining optionsJServer Release 9.2.0.1.0 - Production
SQL> select a.file_name
2 from dba_temp_files a, v$temp
I get the error on solaris 9 and 9.2.0.2 except it's 103
Connected.ERROR:ORA-00600: internal error code, arguments:
[ktfthcf-1], [103], [], [], [], [], [], []>>>
[EMAIL PROTECTED] 01/23/03 04:16PM >>>BUT, I don't get the error on
9.0.1.0.0 on Solaris 5.8!-Original Message-Sent: Thur
Ron
Thanks for explaining that. I'm guessing that being on VMS makes you
always feel overlooked. Sounds like you got what you need.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 23, 2003 4:05 PM
To: Multiple recipients of list ORACLE-
BUT, I don't get the error on 9.0.1.0.0 on Solaris 5.8!
-Original Message-
Sent: Thursday, January 23, 2003 3:20 PM
To: '[EMAIL PROTECTED]'
I just tried in on 9.2.0.1.0 on Solaris 5.8 and get the ORA-00600 error,
except the 2nd arg is 252.
-Original Message-
Sent: Thursday, Janu
I just tried in on 9.2.0.1.0 on Solaris 5.8 and get the ORA-00600 error,
except the 2nd arg is 252.
-Original Message-
Sent: Thursday, January 23, 2003 2:25 PM
To: Multiple recipients of list ORACLE-L
I get the same results. Strange!?!?
-Original Message-
Sent: Thursday, Januar
It's a bug in 9i as well, I finally found the entry for it. I ended up
building this code to do what I wanted:
select /*+ FULL(a) FULL(b) FULL(c) */ 'Temp Files', substr(c.fnnam,1,6),
sum(b.kcftiopyr),
sum(b.kcftioprt/100) "Time/Reading",
round((sum(b.kcftioprt)/100)/decode(sum(kcftiopyr),0,1,sum(
Dennis,
When I ran the scripts to create the statspack info, the srcipts
errored out and exited. I had to read the logs and it showed that
something was not there to delete/remove ( common before creating a
table or view). Openvms on our server is set to error out and not
continue on error. I had
Forgot to mention 9.2.0.1.0 on Win2000
I got data when I changed the join as follows:
select a.file_name, b.*
from dba_temp_files a, v$tempstat b
where b.file#=to_number(a.file_id);
--Jeff
-Original Message-
Sent: Thursday, January 23, 2003 1:14 PM
To: Multiple recipients of list ORAC
I get the same results. Strange!?!?
-Original Message-
Sent: Thursday, January 23, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L
Anyone know a work around to joining v$tempfile and dba_temp_files by file#?
I'm using 9.2.0.1.0 on XP and I'm issuing the statement:
select a.file_n
Robert,
It works in HP-UX 11 Oracle version Oracle9i Enterprise Edition Release
9.0.1.0.0 - 64bit Production
SQL> select a.file_name
2 from dba_temp_files a, v$tempstat b
3 where b.file#=a.file_id;
FILE_NAME
--
>
> Go to bookpool.com. Best prices on tech books. I've ordered
> several books from them and have always been happy.
>
Yes definetly... But this one
"Conducting the Oracle Job Interview"
Is not available at bookpool or amazon...
(personally I like the "buy used" books from amazon) quite a
PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/23/2003 12:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Statspack recomendations.
Anyone know a work around to joining v$tempfile and dba_
Ron - I'm confused (easily done)
Statspack is just a set of SQL and PL/SQL scripts for the installation,
to create the tables and procedures. What is VMS-specific?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 23, 2003 1:50 P
> Don Burleson has a book called "Oracle9i High-Performance
> Tuning with STATSPACK". Check out the link below.
>
> http://www.dba-oracle.com/books.htm
>
> Dave
>
Unfortunatly the ordering feature dosnt work on that site. IE 6 or
Mozilla 1.2.1
I was interested in "Conducting the Oracle Job
Go to bookpool.com. Best prices on tech books. I've ordered several books
from them and have always been happy.
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.co
Anyone know a work around to joining v$tempfile and dba_temp_files by file#?
I'm using 9.2.0.1.0 on XP and I'm issuing the statement:
select a.file_name
from dba_temp_files a, v$tempstat b
where b.file#=a.file_id;
I get an ora-0600 on this with a [ktfthcf-1] [202]
Argument. I looked this up on
List,
While doing a very broad search on Metalink I found an answer to one
of my questions about where the readme files are on openvms...
VMS:
Oracle8i 8.1.7
For Oracle8i 8.1.7.0.0, to get the README file, please contact
Oracle Support Services, and request patch for bug:
[BUG:1745567] - MISS
List,
There have been a lot of good suggestions and recommendations from
all of you. I thank you very much. The information sources list
information about a Unx / NT os and I need to read up on what happens
when the creation scripts fail on OpenVMS. Hopefully the sources will
supply some insight
Get Don Burleson's book - I think it's called "Oracle 9i
High Performance Tuning with STATSPACK".
-Original Message-
Sent: Thursday, January 23, 2003 6:44 AM
To: Multiple recipients of list ORACLE-L
List,
I am looking for a recommendation on a book or web site covering
statspack and i
Thanks to all who replied.
I will look for the book at the local book store this weekend.
Ron
>>> [EMAIL PROTECTED] 01/23/03 10:44AM >>>
Don Burleson has a book called "Oracle9i High-Performance Tuning with
STATSPACK". Check out the link below.
http://www.dba-oracle.com/books.htm
Dave
-
ist ORACLE-L
> Subject: RE: Statspack recomendations.
>
>
> Get Don Burleson's book - I think it's called "Oracle 9i
> High Performance Tuning with STATSPACK".
>
>
> -Original Message-
> Sent: Thursday, January 23, 2003 6:44 AM
> To: Multiple re
Oracle9i High-Performance Tuning with STATSPACK
Donald K. Burleson, Oracle Press
http://www.amazon.com/exec/obidos/ASIN/0072190582/qid=996445780/sr=1-4/ref=s
c_b_4/102-7596303-7878550
URL will be wrapped..
Also on Don's site:
http://www.dba-oracle.com/art_statspack.htm
HTH
Mark
-Original
Ron - There are a series of articles available on-line.
http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html
Don Burleson has some articles on-line
http://www.dba-oracle.com/articles.htm
And Don has an entire book titled: Oracle High-Performance Tuning with
STATSPACK.
Let us know
Don Burleson has a book called "Oracle9i High-Performance Tuning with STATSPACK".
Check out the link below.
http://www.dba-oracle.com/books.htm
Dave
-Original Message-
Sent: Thursday, January 23, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L
List,
I am looking for a recomme
;
> >
> >
> >John Kanagaraj <[EMAIL PROTECTED]>
> >Sent by: [EMAIL PROTECTED]
> > 01/08/2003 01:55 PM
> > Please respond to ORACLE-L
> >
> >
> >To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]> cc:
o: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Statspack performance problem
Jared,
Did you snap with the default value of 5? If so, then the SNAP proceduer
will have to scan / sort V$SQLAREA and that can be very time-consuming. If
TECTED]>
Sent by: [EMAIL PROTECTED]
01/08/2003 01:55 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Statspack performance problem
Jared,
Did you snap with the default value of 5? If so, t
Jared,
Did you snap with the default value of 5? If so, then the SNAP proceduer
will have to scan / sort V$SQLAREA and that can be very time-consuming. If
you are CPU starved or have very high shared_pool access or issues in that
area, then this could explain it Try this with a snap level of 0
ECTED]>
Sent by: [EMAIL PROTECTED]
01/08/2003 11:21 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Statspack performance problem
Jared,
Obvious question, but have to tried to trace it to se
Jared - I am on 8.1.6, but on Unix. How heavily loaded is your system when
you take the snapshot? If it is just normal load, this sounds high. When
I've had a hanging system, several minutes for a snapshot wouldn't be
unusual.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Or
Title: RE: Statspack performance problem
Jared,
Obvious question, but have to tried to trace it to see which statement it is hanging??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any
Title: RE: Statspack Viewer
It is good, and for me, it is worth the money.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of
http://www.statsviewer.narod.ru/
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 9:58 AM
>
> What is the URL for this product?
>
> RWB
>
> --
> Please see the official ORAC
http://www.geocities.com/alexdabr/
I have not seen any comments about this product from anyone yet. I am not sure if it
is too new, unknown or what. Again, I am looking for any comments from
anyone
who has used or evaluated it. Thanks
Please respond to [EMAIL PROTECTED]
Sent by:[EM
What is the URL for this product?
RWB
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
http://www.geocities.com/alexdabr/
George
George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Cell: 082 655 2466
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:[EMAIL PROTECTED]
Web: http://www.did
Title: RE: Statspack Viewer
It works very nice and it also seems that Alexey is genuinely interested in making this product better. He usually gets back less than 12 hours (so far) for all my emails. ..
Raj
__
Rajendra Jamadagni
We just bought it and will start using it this month
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 03, 2003 5:28 AM
> Hi there
>
> Been using it on and off for 2 yrs now since the original standard
edition.
> Very good and def wo
Hi there
Been using it on and off for 2 yrs now since the original standard edition.
Very good and def worth while, Alexey also normally releases a new/updated
version every 1-2 months.
There is some great features planed for the future from discussions with
him.
George
_
STATSPACK related can be found under $ORACLE_HOME/rdbms/admin directory in these
documents.
Version 8.1.6 or prior ( must be 8i )
$ORACLE_HOME/rdbms/admin/statspack.doc
Version 8.1.7
$ORACLE_HOME/rdbms/admin/spdoc.txt
Prior to 8i: ( No statspack! )
$ORACLE_HOME/rdbms/admin/utlbstat.sql
$ORAC
Eriovaldo - Okay, we'll be here when you're ready. I can highly recommend
STATSPACK. It seems appropriate to my level of expertise and has helped me
get to the bottom of a lot of performance issues very quickly, had one this
morning in fact. Some people on the list have had to dig deeper than
STATS
Dennis,
No, I don't want more information now. I am not using it.
I has just willing to know what is this.
Be sure , that when i will use it, i will post questions here.
Thanks a lot.
Eriovaldo
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wed
Title: RE: STATSPACK
Raj,
Do you need beta testers for that?
I'd volunteer :-)
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 12, 2002 8:23
AM
Su
Title: RE: STATSPACK
Right now we are evaluating the performance of that package (specifically the beer part) ... once it is ready ... I'll let you know.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at
You may be right if you want to delete part of the accumulated stats.
He asked about removing ALL the old stats.
Drop and recreate seems to me a good and fast way.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, Decemb
Title: RE: STATSPACK
There's some cascade delete action going on but you can start by deleting the dependent child rows and work your way up. Reverse-engineering the statspack datamodel with an ER diagramming tool is cool.
Steve Orr
Bozeman, Montana
-Original Message-
If you are on 8.1.6, that is pretty much what you have to do. I check the
snap_id's first, since the delete can run a LONG time per row.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, December 11, 2002 11:19 AM
To: Multiple recipients o
Title: RE: STATSPACK
Ayup.
I go to the store every Friday afternoon and pick up a statspack of Stroh's
Lite.
--Walt
Weaver
Bozeman, Montana
-Original Message-From: Farnsworth, Dave
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December
11, 2002 9:39 AMTo: Mul
I remember that I delete from stats$snapshot where snap_time < sysdate
-? works too.
Joan
Yechiel Adar wrote:
>
> Simple.
> run statsdrp and statscre.
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Monday, December
1 - 100 of 168 matches
Mail list logo