RE: Stress my CPU's

From: "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>
To: "tom dale" <tom.dale@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 17 Nov 2009 17:12:15 -0000
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@xxxxxxxxxxxx] 
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@xxxxxxxxxx> 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.
>
************************************************************************
****
>
--
//www.freelists.org/webpage/oracle-l
RE: Stress my CPU's

Other related posts:
