Use Swingbench for Oracle Database stress testing

How can we evaluate the performance of the database to be launched soon? swingbench is the best choice except Benchmark Factory for Databases, which can be described as short and concise and completely free of charge, you don't need to get your google registration code from day to night. What are you waiting for? Come on ......

I. Introduction to swingbench

It is a JAVA program. Currently, it is divided into two versions, one is 2.3 and the other is 2.4. It supports the windons/linux/unix platform and tested the win7 64 platform, which is not stable.

Supports Oracle single instance and Oracle RAC, and Oracle 10g and 11g. To run the environment, you must install the oracle client or instant client.

Contains OrderEntry, SalesHistory, CallingCircle, and StressTest seed databases. For more information, see the author's website.

The software is composed of load generator, coordinator, and cluster overview. It can generate loads and transactions, and display the response time in graphs.

Download swingbench, http://www.dominicgiles.com/downloads.html from author's website

If you download the latest version 2.4, you need to install java (6) 1.6 or later without modifying any configuration files.

To download version 2.3, you need to install java 1.5 or later and modify the swingbench. env configuration file.

Because version 2.4 can be directly run (java 6 and Oracle client are installed), this article describes it in Version 2.3.

2. Preparations before installation

1. Confirm the Installation Platform and java and oracle configurations.
Oracle @ SZDB: ~> Cat/etc/issue # view the system version

Welcome to SUSE Linux Enterprise Server 10 SP3 (x86_64)-Kernel \ r (\ l ).

Oracle @ SZDB: ~> Java-version # use this method to confirm the current version of jave
Java version "1.5.0 _ 22"
Java (TM) 2 Runtime Environment, Standard Edition (build 1.5.0 _ 22-b03)
Java HotSpot (TM) 64-Bit Server VM (build 1.5.0 _ 22-b03, mixed mode)

SZDB:/# find/-name java | grep jdk # view the java path
/Usr/java/jdk1.5.0 _ 22/bin/java
/Usr/java/jdk1.5.0 _ 22/jre/bin/java
/Users/oracle/OraHome10g/jdk/bin/java
/Users/oracle/OraHome10g/jdk/jre/bin/java

Oracle @ SZDB: ~> Env | grep ORACLE_HOME
ORACLE_HOME =/users/oracle/OraHome10g

2. install and configure swingbench
Use the ftp tool to transmit the downloaded zip file to the linux server. This document uses winscp.
The uploaded and decompressed path and file are as follows:
Oracle @ SZDB :~ /Robinson/swingbench> pwd
/Users/oracle/robinson/swingbench
Oracle @ SZDB :~ /Robinson/swingbench> ls
Bin lib README.txt source SQL swingbench. env swingbenchenv. bat winbin
Oracle @ SZDB :~ /Robinson/swingbench> vi swingbench. env
#! /Bin/bash
# Set the following to reflect the root directory of your Java installation
Export JAVAHOME =/usr/java/jdk1.5.0 _ 22 # modify this path to the correct path
# Set the following to the directory where you installed swingbench
Export SWINGHOME =/users/oracle/robinson/swingbench # modify this path to the correct path
# Set the following to the location of your TimesTen install (optional)
Export TTHOME =/opt/TimesTen/tt70
# If you don't have the ORACLE_HOME environment variable set uncomment the following and change it to reflect your environment
Export ORACLE_HOME =/users/oracle/OraHome10g # modify this path to the correct path
#
Export ANTHOME = $ SWINGHOME/lib
Export LD_LIBRARY_PATH =$ {LD_LIBRARY_PATH }:$ ORACLE_HOME/lib: $ TTHOME/lib
Export CLASSPATH = $ JAVAHOME/lib/rt. jar: $ JAVAHOME/lib/tools. jar: $ SWINGHOME/lib/mytransactions. jar:
$ {SWINGHOME}/lib/swingbench. jar: $ ANTHOME/ant. jar:
# The following is needed for 10g environments
Export CLASSPATH = $ CLASSPATH: $ ORACLE_HOME/jdbc/lib/ojdbc14.jar: $ ORACLE_HOME/opmn/lib/ons. jar
# The following is only needed for 11g environments
Export CLASSPATH = $ CLASSPATH: $ ORACLE_HOME/jdbc/lib/ojdbc5.jar
# The following is only needed for TimesTen environments
Export CLASSPATH = $ CLASSPATH: $ TTHOME/lib/classes15.jar

3. Install soe schema
Start Xmanager-Passive. You can also run commands remotely to linux to use the GUI.
Oracle @ SZDB :~ /Robinson/swingbench> export DISPLAY = 192.168.7.20.: 0.0
Oracle @ SZDB :~ /Robinson/swingbench> cd bin
Oracle @ SZDB :~ /Robinson/swingbench/bin>./oewizard # Use the GUI Wizard to install oe schema
Soe @ SYBO2SZ> @ dba_tables_user # Check the result of installing soe

Table Name Tablespace Last Analyzed # of Rows
------------------------------------------------------------------------------------------
Customers soe 16-NOV-2012 16:11:31 1,000,411
Inventories soe 16-NOV-2012 16:11:48 5,760
Logon soe 16-NOV-2012 16:11:48 0
Orders soe 16-NOV-2012 16:11:55 1,000,000
ORDER_ITEMS SOE 16-NOV-2012 16:12:13 3,503,005
PRODUCT_DESCRIPTIONS SOE 16-NOV-2012 16:12:20 288
PRODUCT_INFORMATION SOE 16-NOV-2012 16:12:20 288
Warehouses soe 16-NOV-2012 16:12:20 20

# Author: Robinson
# Blog: http://blog.csdn.net/robinson_0612
Oracle @ SZDB :~ /Robinson/swingbench/bin>./swingbench # Implementation of swingbench
Started Swingbench, Version 2.3.0.422. Using config file swingconfig. xml
BI Beans Graph version [2.7.5.32] Engine version [2.7.5.32]

1 2 3 Next Page