SLOB
SLOB is an Oracle I/O workload generation tool kit, supports testing extreme REDO logging I/O (minimal amount of CPU overhead) The SLOB package can be downloaded from Kevin Closson's Blog: SLOB Resources SLOB 2.4.2 requires Linux with Oracle Client Installation Unzip the SLOB tar.gz file in the desired directory ($SLOB). Create tablespace for SLOB data (the script creates IOPS) $ cd $SLOB $ sqlplus / as sysdba @ misc/ts Load SLOB data by running setup.sh script located in the $SLOB directory. Using two mandatory parameters: Tablespace into which SLOB will create and load the test schemas The number of schemas to create and load $ ./setup.sh IOPS 8 configuration One time compilation $ cd $SLOB/wait_kit $ make Edit runtime parameter in slob.conf configuration file $ cd $SLOB $ vi slob.conf Execute slob using number of SLOB schemas $ cd $SLOB $ ./runit.sh 8 We can edit the slob.conf file to modify some parameters. UPDATE_PCT - Percentage of SLOB update operations SCA