SwingBench配置

SwingBench是一个Oracle压力测试工具，支持10G，11G等版本，它的配置比较简单，首先需要安装JDK1.5以上。

解压swingbench安装文件，在解压目录里面有个swingbench.env或swingbench.sh配置文件，windows的配置文件是以.bat为结尾的，名称都一样，解压之后，然后改配置文件了，仔细核对每项是否指向正确的文件，笔者刚开始就是因为配置路径出错，导致压力测试时 user总是添加不上。

笔者服务器是centos 6 版本，安装的是11gr2数据库，安装的swingbench版本是2.3版本，笔者修改的最后配置文件如下:

[oracle@bank2good swingbench]$ more swingbench.sh
#!/bin/bash
# Set the following to reflect the root directory of your Java installation
export JAVAHOME=/usr/local/jdk1.7.0_03
# Set the following to the directory where you installed swingbench
export SWINGHOME=/home/oracle/test/swingbench
# 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=/opt/app/oracle/product/11.2.0/dbhome_1
#
export ANTHOME=$SWINGHOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/lib
export CLASSPATH=$JAVAHOME/jre/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/ojdbc5.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

 

配置完成以后，执行配置文件，使环境变量生效，然后在bin下面有执行的命令：

首先需要创建SCHEMA，这里就不详述了

创建完成以后运行 ./swingbench -cpuloc localhost 就可以启动swingbench了，而且包含CPU和IO信息，这时你就可以做各种测试了。