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