RE: Stress my CPU's

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Tue, 17 Nov 2009 13:08:43 -0500
Message-ID: <21469B88E0EA11498818517F21033531126D7430_at_EPRI17P32001A.csfb.cs-group.com>

I have also found that a script along the lines of  

LABEL: goto LABEL  

does a pretty good job of CPU consumption.  

Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com  

---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of japplewhite_at_austinisd.org

	Sent: Tuesday, November 17, 2009 11:04 AM
	To: oracle-l_at_freelists.org
	Cc: Lee.Robertson_at_acxiom.com
	Subject: Re: Stress my CPU's
	
	
	Not a database-generated CPU stress, but I find that gzip /

gunzip really suck up CPU. Sometimes I launch 8 parallel gzip sessions and bring the 8 CPUs on one of our newer servers to near 100% utilization each.         

        Write a little script that spawns 16 gzip -9 processes, then gunzips, then gzips on some multi-GB sized files. Since the CPUs won't care how they're stressed - database or otherwise - you might get the results you want.         

	Jack C. Applewhite - Database Administrator
	Austin I.S.D. - MIS Department
	512.414.9715 (wk)  /  512.935.5929 (pager)
	
	
	
	
From: 	"Robertson Lee - lerobe" <Lee.Robertson_at_acxiom.com> 
To: 	<oracle-l_at_freelists.org> 
Date: 	11/17/2009 09:40 AM 
Subject: 	Stress my CPU's 
Sent by: 	oracle-l-bounce_at_freelists.org



________________________________




	Hi, 
	  
	Oracle 10.2.0.3 
	AIX 6.1 
	  
	I have been asked to do some stress testing and it is causing me

stress ;-)           

        I need to really hammer the CPU's on the box as we want to test dynamically allocating CPU's from another partition to handle the increased workload.           

        I am having difficulty getting the CPU's maxed out or indeed to even use more than 2.           

        I have been running cartesian joins with various hints (parellism, using hashes etc) but just cannot get the relevant amount of work generated. It tends to spike at about 80% on a couple of CPU's then the result set comes back after about 30 secs and CPU useage then obviously drops. This is a T & D server with 16 CPU's on it. Are there any clever tricks out there I can use to simulate a full on workload??           

        TIA                    Lee                             

---

 Please access the attached hyperlink for an important electronic communications disclaimer:  http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

---

 

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 17 2009 - 12:08:43 CST