#!/bin/bash 
############################################################
# Shell Script: RandomLoadGenerator.sh
# Purpose: Generates a random load across all nodes in a RAC
#          cluster to demonstrate different Load Balancing 
#          Advisor (LBA) features in Oracle 10gR2.
############################################################

users=20
x=1
y=$users
z=0
#SRVC=$1

while [ $x -le $y ]
do
   z=`expr $x % 10`
   case $z in
      1 )   
         UNPW="hr/hr"
         SQLCMD="LG-SpinCPUs"
         ITER=250
         SRVC="OLTP"
      ;;
      2 )   
         UNPW="sh/sh"
         SQLCMD="LG-RandomQuery"
         ITER=250
         SRVC="ADHOC"
      ;;
      3 )   
         UNPW="oe/oe"
         SQLCMD="LG-RandomDML"
         ITER=30
         SRVC="BATCH_STD"
      ;;
      4 )   
         UNPW="hr/hr"
         SQLCMD="LG-SpinCPUs"
         ITER=500
         SRVC="OLTP"
      ;;
      5 )   
         UNPW="sh/sh"
         SQLCMD="LG-RandomQuery"
         ITER=500
         SRVC="DSS"
      ;;
      6 )   
         UNPW="oe/oe"
         SQLCMD="LG-RandomDML"
         ITER=45
         SRVC="BATCH_LOW"
      ;;
      * )   
         UNPW="hr/hr"
         SQLCMD="LG-SpinCPUs"
         ITER=250
         SRVC="OLTP"
      ;;
   esac
   
   echo $x $y $z $UNPW $SRVC $SQLCMD
   sqlplus -s $UNPW@$SRVC @$SQLCMD.sql $ITER &
   x=`expr $x + 1`
done