RE: Stress my CPU's

From: Robertson Lee - lerobe <Lee.Robertson_at_acxiom.com>
Date: Tue, 17 Nov 2009 17:12:15 -0000
Message-ID: <F1A191B056E5E04EA2134D842F9396F819B329BC_at_sunmsx01.Corp.Acxiom.net>

Hi guys,

Thanks so much for the prompt responses....The winner is Tom's answer below. Immediately whacked out my CPU's.

Thanks again...

Lee

-----Original Message-----
From: tom dale [mailto:tom.dale_at_fivium.co.uk] Sent: 17 November 2009 16:40
To: Robertson Lee - lerobe
Subject: Re: Stress my CPU's

simple script to max as many cpu's as you want

set serveroutput on

declare

  l_job_out     integer;
  l_what        dba_jobs.what%type;
  l_cpus_to_hog CONSTANT integer :=4;
  l_loop_count  varchar2(10) := '500000000';

begin
  /*

• Create some jobs to load the CPU */ for l_job in 1..l_cpus_to_hog loop dbms_job.submit( job => l_job_out , what => 'declare a number := 1; begin for i in 1..'||l_loop_count||' loop a := ( a + i )/11; end loop; end;' ); commit; dbms_output.put_line( 'job - '|| l_job_out );

    select what into l_what from dba_jobs where job = l_job_out;     dbms_output.put_line( 'what - '|| l_what );   end loop;

end;
/

On Tue, Nov 17, 2009 at 3:39 PM, Robertson Lee - lerobe <Lee.Robertson_at_acxiom.com> wrote:
> 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 - 11:12:15 CST