#!/bin/bash
############################################################
# Shell Script: 10gSI_RandomLoadGenerator.sh
# Purpose: Generates a random load for just one connection 
#          string to perpetrate a workload worthy of capture
#          in an Oracle 10.2.0.4.0 single-instance mode.
############################################################

users=80
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-RandomDML"
         ITER=25
         SRVC="DB10G"
      ;;
      2 )   
         UNPW="sh/sh"
         SQLCMD="LG-RandomQuery"
         ITER=250
         SRVC="DB10G"
      ;;
      3 )   
         UNPW="oe/oe"
         SQLCMD="LG-RandomDML"
         ITER=30
         SRVC="DB10G"
      ;;
      4 )   
         UNPW="hr/hr"
         SQLCMD="LG-SpinCPUs"
         ITER=500
         SRVC="DB10G"
      ;;
      5 )   
         UNPW="sh/sh"
         SQLCMD="LG-RandomQuery"
         ITER=500
         SRVC="DB10G"
      ;;
      6 )   
         UNPW="oe/oe"
         SQLCMD="LG-RandomDML"
         ITER=75
         SRVC="DB10G"
      ;;
      7 )   
         UNPW="hr/hr"
         SQLCMD="LG-RandomDML"
         ITER=50
         SRVC="DB10G"
      ;;
      8 )   
         UNPW="oe/oe"
         SQLCMD="LG-RandomDML"
         ITER=125
         SRVC="DB10G"
      ;;
      * )   
         UNPW="hr/hr"
         SQLCMD="LG-SpinCPUs"
         ITER=250
         SRVC="DB10G"
      ;;
   esac
   
   echo $x $y $z $UNPW $SRVC $SQLCMD
   sqlplus -s $UNPW@$SRVC @$SQLCMD.sql $ITER &
   x=`expr $x + 1`
done