Jared,
Are
you talking about yapppack? I've been using that for a while (nice display.
Though like statspack it is system wide so I usually just look for high level
stuff and changes). Not aware of a patch though.
With
most peoplesoft applications I have seen, the bottlenecks aren't database
related, though I still need to get all appropriate data. That means application
server, OS (NT for app server, Sun for Oracle), web server, ...
stuff too. I'm still trying to find what numbers the tool itself gathers, and
if/how it analyzes the stuff. In the meantime, I've been reviewing some of the
papers on orapub (i.e. Ratio Modeling, Predicting Computing System Capacity and
Throughput).
Thanks.
Henry
As the
ultimate indicator of performance is response time, you might like to
investigate YAPP
at
http://www.miracleas.dk/. The data generated gives a good indicator of
response time from
a database
perspective.
If you use it, ask me
for the patch.
Jared
|
| "Poras, Henry R."
<Henry_Poras@dfci.harvard.edu>
Sent by: ml-errors@fatcity.com
01/02/2004 10:54 AM
Please respond to ORACLE-L
|
To:
Multiple recipients of list ORACLE-L
<ORACLE-L@fatcity.com>
cc:
Subject: stress
testing |
We are planning on running some stress tests on a
PeopleSoft/Oracle/Solaris
system starting next week (using LoadRunner). I
have never gone through a
formalized stress test before (most of my stress
is brought about informally).
So far I am planning to gather statspack
information, and periodically get
vmstat from the OS. Is there anything
else that I should collect? Thanks for the
help.
Henry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Poras, Henry R.
INET:
Henry_Poras@dfci.harvard.edu
Fat City Network Services --
858-538-5051 http://www.fatcity.com
San Diego, California
-- Mailing list and web hosting
services
---------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing
list you want to be removed from). You may
also send the HELP command
for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Poras, Henry R.
INET: Henry_Poras_at_dfci.harvard.edu
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Jan 05 2004 - 08:19:26 CST
