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
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]
Sent: Friday, January 02, 2004 2:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: stress testing
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." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]01/02/2004 10:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
