RE: Stress my CPU's

You might give this a try:
http://jonathanlewis.wordpress.com/2008/05/10/cpu-usage/

But, you may need to run multiple concurrent sessions to max out 16 CPUs.

-Mark

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 To: oracle-l_at_freelists.org
Subject: Stress my CPU's

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

The information contained in this communication is confidential, is

intended only for the use of the recipient named above, and may be legally

privileged.

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.

Thank You.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 17 2009 - 09:56:31 CST