notes/tiddlywiki/Data Generator & Swing Bench.md

Author home page: dominicgiles.com

Install JDK

dnf install java-1.8.0-openjdk.x86_64

Create linux user and directories for Data Generator & Swing Bench

groupadd orabench
useradd orabench -g orabench -G orabench
mkdir -p /app/datagenerator
mkdir -p /app/swingbench
chown -R orabench:orabench /app/datagenerator /app/swingbench

Download and run Data Generator

su - orabench
wget http://www.dominicgiles.com/swingbench/datageneratorlatest.zip
unzip datageneratorlatest.zip
rm -rf datageneratorlatest.zip
mv datagenerator stable

export DISPLAY=<your_X_server_IP>:0.0
/app/datagenerator/stable/bin/datagenerator

Depending of schemas to install, create corresponding schemas/tablespaces

create bigfile tablespace SH datafile size 64M autoextend ON next 64M;
create user SH identified by SH default tablespace SH;
grant connect,resource to SH;

create bigfile tablespace SOE datafile size 64M autoextend ON next 64M;
create user SOE identified by SOE default tablespace SOE;
grant connect,resource to SOE;

Download and run Swing Bench

cd /app/swingbench/
wget https://github.com/domgiles/swingbench-public/releases/download/production/swingbenchlatest.zip
unzip swingbenchlatest.zip
rm -rf swingbenchlatest.zip
mv swingbench stable
/app/swingbench/stable/bin/swingbench