Re: Stress my CPU's
- From: Kerry Osborne <kerry.osborne@xxxxxxxxxxx>
- To: Lee.Robertson@xxxxxxxxxx
- Date: Tue, 17 Nov 2009 10:30:13 -0600
just join 2 or 3 or 4 ... really big tables with no where clause
like so:
select a.col2, sum(a.col1)
from kso.skew a, kso.skew b
group by a.col2
/
It'll run for hours - and do nothing but burn cpu time.
Here's a little script for starting a bunch of copies of a script (not
security aware because it puts the user/password on the command line)
###############################################################################
#
# Synopsis: start_scripts.sh script how_many user/password
# Purpose: runs script how_many times in background via nohup
#
# Copyright: Enkitec
# Author: Kerry Osborne
#
###############################################################################
if [ $# -ne 3 ]
then
echo " "
echo "Usage: start_scripts.sh script how_many user/password"
exit 1
fi
echo " "
echo "starting" $2 "copies of" $1
echo " "
rm -f ./nohup.out
cat >> temp_submit << MYEOF
sqlplus -s <<EOF
$3
@$1
exit
EOF
MYEOF
chmod 777 temp_submit
i=0
while [ ${i} -lt $2 ]
do
nohup temp_submit > /dev/null &
i=`expr $i + 1`
done
sleep 2
rm -f ./temp_submit
echo " "
#echo "started" $2 "copies of" $1
Kerry Osborne
Enkitec
blog: kerryosborne.oracle-guy.com
On Nov 17, 2009, at 9:39 AM, Robertson Lee - lerobe 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
Other related posts:
