Oracle DBA Place

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...

In this example we are using Swingbench 2.6 with Order Entry stress test - using a configuration file (SOE_Server_Side_V2.xml) Connection String: The connection will always be defined to pluggable database (not CDB) - if installed. //hostname/service_name valid for driver type: Oracle oci Driver & Oracle jdbc Driver ( oewizard , sbutil use only this option) . Make sure the service name is recognized by the listener ( lsnrctl services | grep Service ) Tnsnames alias valid only for driver type: Oracle oci Driver – requires Oracle 12.2 client Creating the schema: cd swingbench/bin $ ./oewizard -dbap change_on_install -ts SOE -nopart -u soe -p soe -cl -df +DATA -create -scale 1 -cs //db_server/db_service Running: If you need to use Connection Pooling : Change the driver type to " Oracle oci Driver" Change the format of the connection string to tns alias For further needed changes, look at: Application Continuity in Oracle Database 12c (12.1.0.2) charben...