RE: stress testing
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 (NTfor 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 PMTo: Multiple recipients of list ORACLE-LSubject: Re: stress testingAs 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 testingWe are planning on running some stress tests on a PeopleSoft/Oracle/Solarissystem starting next week (using LoadRunner). I have never gone through aformalized stress test before (most of my stress is brought about informally).So far I am planning to gather statspack information, and periodically getvmstat from the OS. Is there anything else that I should collect? Thanks for thehelp.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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: stress testing
John, Thanks for the tip. I've used sar and vmstat, but not in enough depth to have any preferences. So far I don't have permissions for sar at this site, but I should be able to get that. Henry -Original Message- John Kanagaraj Sent: Friday, January 02, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Poras, Henry R. [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L 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: John Kanagaraj 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).
RE: stress testing
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).
RE: stress testing
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).
Re: stress testing
Hi Tim Tony Jambu here. Saw your posting to Oracle-l with regards to your sp_vmstat.sh script. I am not sure if know but I write a regular hints tips column for Select Journal. I read your article and would like to mention your script and point people to the script. Do you mind if I mention it and also to point them to somewhere where they are able to get a copy of it? Dont want them hassling you and sending emails requesting it. Let me know what you think ta tony At 09:14 AM 03/01/2004 -0800, Tim Gorman wrote: Henry, I use the attached shell script to gather and store VMSTAT information in a custom table within the PERFSTAT schema (i.e. schema belonging to STATSPACK). Allows for some nice reporting over time, rather than anecdotal here-and-there observations. Should work OK on Solaris, HP, and Linux. Be aware: the script expects to use the standard oraenv and dbhome scripts to set up the Oracle environment variables, and expects a hidden file in the $HOME directory of the owner's UNIX account for storing Oracle passwords, and also has optional functionality to email/page in the event of trouble. Hope this helps... -Tim on 1/2/04 11:54 AM, Poras, Henry R. at [EMAIL PROTECTED] wrote: 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 _ / |Tony Jambu, DatabaseWeb Consultant /_ _/_ __ / |Wizard Consulting Pty Ltd /(_)/ )(_/ \_/(///(/_)/_( |IOUG's Select Asia-Pacific Tech. Editor \___/ |EMAIL: TJambu @ wizard.cx (REMOVE Spaces from email ) |PHONE: +61-419-TJAMBU(852628) -- 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 - 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).
Re: stress testing
Henry, I use the attached shell script to gather and store VMSTAT information in a custom table within the PERFSTAT schema (i.e. schema belonging to STATSPACK). Allows for some nice reporting over time, rather than anecdotal here-and-there observations. Should work OK on Solaris, HP, and Linux. Be aware: the script expects to use the standard oraenv and dbhome scripts to set up the Oracle environment variables, and expects a hidden file in the $HOME directory of the owner's UNIX account for storing Oracle passwords, and also has optional functionality to email/page in the event of trouble. Hope this helps... -Tim on 1/2/04 11:54 AM, Poras, Henry R. at [EMAIL PROTECTED] wrote: 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 sp_vmstat.sh Description: Binary data
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).
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).
RE: stress testing
Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Poras, Henry R. [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L 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: John Kanagaraj 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).
RE: stress testing
Henry: John is partially correct. SAR, in concert with VMSTAT / IOSTAT, will provide you with a wealth of information. However, something is missing from the equation here. LoadRunner will generate scattered statistics on overall performance of an application (sorry: biased because Compuware has a better tool), but misses the mark on what other things could affect overall application performance. For example, are you doing to perform a virgin load test where no one is on the network and nothing but this application is running on the client? What about other traffic that would affect overall performance throughout your enterprise network? What about other applications/activities running on the client machines performing the load test. Only then will you have an effective measurement of application performance in the real world. If you truly have to use LoadRunner, get some software that can measure Network Performance as it relates to the load test and as it relates to general network traffic. The load test should account for other activity being performed such as email, backups, file transfers, reading of documents, etc. Otherwise, your numbers will be skewed. Good luck. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- John Kanagaraj Sent: Friday, January 02, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Subject:RE: stress testing Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Poras, Henry R. [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L 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: John Kanagaraj 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen 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
Re: stress testing
And when you're doing stress testing, make sure you load your system for quite long time. Stress testing shouldn't only verify system performance, but it should also test system's reliability. One of my clients had a problem with Oracle Apps, where they did a stress test for just one hour and concluded that the performance was acceptable. But one of the components in Apps (forms server) started just hanging after 5-6 hours of usage in their system, so if they had done an automated stress test over a weekend or even more, they'd have found it. Also, any kind of testing should simulate real life, if possible - otherwise you'll get results which might not match with future production usage all. That means, the amounts of data should be similar, if you can use a copy of real system for testing it'd be the best, also note that there are probably different usage patterns in your future system (such as month/year ending, campaign periods in retail businesses etc) so your system has to cope with all of them. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 02, 2004 9:29 PM Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Poras, Henry R. [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L 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: John Kanagaraj 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: Tanel Poder 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).
Stress Testing Peoplesoft App
Anybody have experience with stress testing software for Peoplesoft? Links, thoughts, comments etc... Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: OT: Application stress testing tool
Hi, look for WinRunner. I think it does that stuff and is scriptable (of course ;). [EMAIL PROTECTED] schrieb: Hello, Apologies for an off-topic posting. Does anybody have any positive or negative experience with any system stress testing tools? I do not mean DB stress testing (we have software fot that) but a test package for system with a fat GUI client? Need something that would simulate user input (keystrokes/mouse clicks), allow scripting, simulate multiple users and record results so that they can be analyzed later. Any info would be highly appreciated. Thanks, Val Gamerman. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FBOM | | Tel.: 0211/533-4893| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT: Application stress testing tool
Hello, Apologies for an off-topic posting. Does anybody have any positive or negative experience with any system stress testing tools? I do not mean DB stress testing (we have software fot that) but a test package for system with a fat GUI client? Need something that would simulate user input (keystrokes/mouse clicks), allow scripting, simulate multiple users and record results so that they can be analyzed later. Any info would be highly appreciated. Thanks, Val Gamerman. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Application stress testing tool
SQA robot is suppose to be one of the best. Out of curiosity, what do you do on the DB end? Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Hello, Apologies for an off-topic posting. Does anybody have any positive or negative experience with any system stress testing tools? I do not mean DB stress testing (we have software fot that) but a test package for system with a fat GUI client? Need something that would simulate user input (keystrokes/mouse clicks), allow scripting, simulate multiple users and record results so that they can be analyzed later. Any info would be highly appreciated. Thanks, Val Gamerman. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).