RE: Stress my CPU's
Date: Tue, 17 Nov 2009 10:56:31 -0500
You might give this a try:
But, you may need to run multiple concurrent sessions to max out 16 CPUs.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robertson Lee - lerobe
Sent: Tuesday, November 17, 2009 10:39 AM
Subject: Stress my CPU's
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??
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
http://www.freelists.org/webpage/oracle-l Received on Tue Nov 17 2009 - 09:56:31 CST