Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: stress testing

RE: stress testing

From: Poras, Henry R. <Henry_Poras_at_dfci.harvard.edu>
Date: Mon, 05 Jan 2004 08:54:26 -0800
Message-ID: <F001.005DBB7C.20040105085426@fatcity.com>


Good catch on the array. I never noticed that.

Henry

-----Original Message-----
Jared Still
Sent: Monday, January 05, 2004 10:59 AM
To: Multiple recipients of list ORACLE-L

The patch I refer to is one I made that didn't make it into the most recent version of yapppack.

YP uses an array as internal storage, and walks through it with a for i in 1..n loop. Since arrays are sparsely populated there is a fair chance of hitting an array element that does not exist.

The patch consists of rewriting the loop with array.first/next/last in a while loop to avoid the problem.

Yes, it is high level, but it can pinpoint time periods that you may want to investigate.

Jared

On Mon, 2004-01-05 at 06:19, Poras, Henry R. wrote:
> 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-----
> Jared.Still_at_radisys.com
> Sent: Friday, January 02, 2004 2:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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_at_dfci.harvard.edu>
> Sent by: ml-errors_at_fatcity.com
>
>
> 01/02/2004 10:54 AM
> Please respond to ORACLE-L
>
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_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_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).
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

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).
-- 
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 - 10:54:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US