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 Henry_Poras_at_dfci.harvard.edu 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, Database&Web 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: tjambu_fatcity_at_yahoo.com.au

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).