Swingbench is a great tool for OLTP testing but also to learn Oracle database, as it is an OLTP application in its own right that generates data and runs transaction processing.
Swingbench is included in Outrun as pre-configured RPM packages including dependencies.
- Via the menu
- Go to System - Install, select "swingbench" and install it
- Via the CLI
yum install swingbench
Swingbench is a Java application that requires X Window system - so installing Swingbench also resolves dependencies to make this work. Java is also installed.
Another tool that gets installed is "lightvnc" - a lightweight VNC desktop which is not feature rich but provides a very efficient way to run GUI apps.
The Swingbench package sets up a user named "swing" and copies the password from root. You need a VNC client to login.
- Connect to VNC server on port 5900 (VNC desktop 0)
- Login as "swing" (password is set to the root password)
You should see a fancy light grey desktop with lots of bells and whistles.
NOTE: If the desktop is black for more than a few seconds, something is wrong. Don't try to mess with the VNC settings, in some cases a restart of the VNC service helps:
chkconfig lvnc-0 off chkconfig lvnc-0 on initctl restart prefdm
Also, restarting the network stack:
service network restart might help.
Running the OE Wizard
On the grey desktop, the menu is under the right mouse button.
- Keep it pressed and navigate to Swingbench -> Run OE Wizard
- Click through the default Swingbench settings:
- version 2.0
- Create Order Entry Schema
- Database details should be pre-filled (don't change unless you know what you are doing)
- Schema details - the default +DATA/soe.dbf works fine for very small tests. Create a larger tablespace first before starting the wizard if you want to run a large scale benchmark.
- Database options - leave default
- Sizing details:
- Important! For a small functional test the default size is much too large. Change the scale to "0.1" so the schema size becomes 0.3 GB
(you can always build a larger dataset but first use a small set to verify everything works correctly)
- Parallellism - leave default (2x the number of CPUs)
If you get a message on the size of the TEMP tablespace you can ignore it - the TEMP tablespace will automatically be enlarged where needed.
Schema creation can take a very long time (hours) if you select a large data size. A 0.3 GB (300MB) dataset should finish in a few minutes.
After schema creation you should get a popup titled "Schema Created" along with timing statistics. The second section is "Object Name" and shows the valid database objects.
There should be NO entries in the Missing or Invalid rows!
Once done, you need to click "Cancel" to exit the wizard.
Running the SOE benchmark
SOE stands for Sales Order Entry and is the default benchmark in Swingbench.
You can run it using a full GUI by selecting "Run Swingbench" from the right-mouseclick menu.
All parameters have been preconfigured to work with the local database. The workload is set to be very light (1 user only).
All you have to do is start the benchmark run (Green arrow button top left) to get going.
The screen should show "Users logged on: 1" and a moving chart with five columns running 2D statistics.
You may change the benchmark parameters and save them for a next run.
Running the SOE Minibench
Minibench is a lightweight version of the Swingbench frontend which requires less resources. You cannot use it to change benchmark parameters, but it loads the parameters saved in the full Swingbench GUI for the benchmark run.