RE: Stress my CPU's
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "Lee.Robertson@xxxxxxxxxx" <Lee.Robertson@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Nov 2009 10:56:31 -0500
Lee,
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Robertson Lee - lerobe
Sent: Tuesday, November 17, 2009 10:39 AM
To: oracle-l@xxxxxxxxxxxxx
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.
****************************************************************************
Other related posts:
