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, Oracle-related configuration 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 Java version of Jave "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 =/users/Oracle/orahome10g2. 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 # change 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 ora Cle_home environment variable set uncomment the following and change it to reflect your environment export ORACLE_HOME =/users/Oracle/volumes # 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/ T. 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/secrets # The following is only needed for TimesTen environments export classpath = $ classpath: $ tthome/lib/classes15.jar3. Install SOE schema to start xmanager-Pas You can also run the command 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 SOE installation table name tablespace last analyzed # of rows cannot exceed ------------ MERs SOE 16-nov-2012 16:11:31 1,000,411 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 # start to implement swingbench started swingbench, version 2.3.0.422. Using config file swingconfig. xml Bi graph version [2.7.5.32] Engine version [2.7.5.32]

3. Graphical description

1. OE Installation Wizard

Run./oewizard to start the installation wizard.

Set the connection string and specify the sysdba account

Set the tablespace and data file path for creating OE schema. You can check the partition option. The following figure shows that partitions are not used.

Set the number of rows for creating a table

Start creating users and objects on users

Create OE output log

OE schema created successfully

2. Implement swingbench

Enter./swingbench at the command prompt to start the swingbench interface. First configure the connection

Next, you can specify the connected user data and the minimum maximum latency. The default value is retained here, and the benchmark time is set to 10 minutes.

Real-time performance chart

Click the output selector to view the output result. You can also click the File menu and save summary results to save the result.

The following figure shows the statistics

The swingbench 2.4 diagram is more vivid. You can download version 2.4 for testing.