Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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!
>-----Original Message-----
>From: Poras, Henry R. [mailto:Henry_Poras_at_dfci.harvard.edu]
>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: 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: John Kanagaraj INET: john.kanagaraj_at_hds.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).Received on Fri Jan 02 2004 - 13:29:24 CST
![]() |
![]() |