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----- > [EMAIL PROTECTED] > 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." <[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). > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). -- 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).