Installation and configuration of OracleSwingbench stress testing software

This was developed by an employee of OracleUK on the basis of a abandoned project. The current stable version is 2.2, the latest version is 2.3, based on JDK1.5. This tool is free of charge.

This was developed by an Oracle UK employee on the basis of a abandoned project. The current stable version is 2.2, the latest version is 2.3, based on JDK1.5. This tool is free of charge.

1 Swingbench

1.1 Overview

This was developed by an Oracle UK employee on the basis of a abandoned project. The current stable version is 2.2, the latest version is 2.3, based on JDK1.5. This tool is free of charge and can be freely downloaded from the author's website and has detailed user guides. In addition to Swingbench, the author also developed two related tools: Test Data Generation Tool DataGenerator and Trace Analyzer.

Swingbench can perform four different benchmark tests. It has three front-end display Methods: Swingbench, Charbench, and Minibench. Charbench is in character mode, and the other two are in GUI mode. In addition, you can use ClusterOverview to aggregate all the results.

Swingbench is mainly used to demonstrate the load and test of RAC, but it can also be used in a single instance environment. The latest version 2.3 supports TimesTen memory databases.

:
Document address:

2 install Swingbench for windows
2.1 decompress swingbench stress testing software
Download the latest version 2.3zip with the file name swingbench230422.zip. The file size is about 9 MB.
The cut pressure is at D: \ swingbench230422 \ swingbench.
Shows the directory structure after decompression:
Swingbench (Top Level Directory, contains Swingbench. env)
|
+ -- Bin (Linux/Unix executables)
|
| + -- Sample (sample config files)
|
| + -- Data (data used by benchmarks)
|
| + -- Schema (xml schemas for config files)
|
+ -- Lib (Java Libraries I. e. *. jar)
|
+ -- Source (source code & build scripts for transactions)
|
+ -- SQL (SQL scripts used by the wizards to create the schemas)
|
+ -- Winbin (Windows executables)

2.2 install JDK
Java support is required to run this software. The jdk 1.5 for windows installation package I downloaded here
The resolution is jdk-rj5_0-windows-i586.exe.

2.3 install the oracle 10g Client
Because the client is in windows, you need to install oci or jdbc to connect to the p595 aix server.
The resolution is 10201_client_win32.zip.

2.4 configure the environment variable swingbenchenv. bat as follows:
REM Set the following to reflect the root directory of your Java installation
Set JAVAHOME = C: \ jdk15
REM Set the following to the directory where you installed swingbench
Set SWINGHOME = D: \ swingbench230422 \ swingbench
REM Set the following to the location of your TimesTen install (optional)
Set TTHOME = C: \ TimesTen \ tt70
REM If you don't have the ORACLE_HOME environment variable set uncomment the following and change it to reflect your environment
SET ORACLE_HOME = F: \ oracle \ product \ 10.2.0 \ db_1
Set ANTHOME = % SWINGHOME % \ lib
Set CLASSPATH = % JAVAHOME % \ lib \ rt. jar; % SWINGHOME % \ lib \ mytransactions. jar; % SWINGHOME % \ lib \ swingbench. jar;
REM The following is needed for 10g environments
Set CLASSPATH = % CLASSPATH %; % ORACLE_HOME % \ jdbc \ lib \ ojdbc14.jar; % ORACLE_HOME % opmn \ lib \ ons. jar
REM The following is only needed for 11g environments
Set CLASSPATH = % CLASSPATH %; % ORACLE_HOME % \ jdbc \ lib \ ojdbc5.jar
REM The following is only needed for TimesTen environments
Set CLASSPATH = % CLASSPATH %; $ TTHOME/lib/classes15.jar

3. Configure swingbench to connect to the database and create tablespaces, users, and table orders.

3.1 configure the tnsnames. ora File
FSYYK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 11.4.128.89) (PORT = 1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 11.4.128.91) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = fsyyk)
)
)

3.2 run the oewizard. bat file in the $ SWINGHOME/winbin directory.
Input jdbc or oci connection method
Jdbc is // host name or IP Address: 1521/sid or services_name
Oci is the service name in tnsnames. ora
Allows you to create tablespaces, users, and table structures.

4. run $ SWINGHOME/winbin/swingbench. bat for stress testing.
Select the jdbc or oci connection
Enter the number of users and the number of related orders to perform stress testing.