oracle 压测工具 swingbench

os: centos 7.6
db: oracle 19.3

oracle 安装的是 19.3 版本，使用的是 oracle MAA 架构。

To install Swingbench release 2.5 or 2.6, all you need to do is ensure you have a Java 8 JVM available and then unzip the swingbench file. Change into the bin/winbin directory and run the files from there.

配置 epel 源

# wget -P /etc/yum.repos.d/ http://mirrors.aliyun.com/repo/epel-7.repo
# yum clean all  
# yum makecache  

安装 oracle JDK

# which java
/usr/bin/java

# /usr/bin/java -version
openjdk version "1.8.0_212"
OpenJDK Runtime Environment (build 1.8.0_212-b04)
OpenJDK 64-Bit Server VM (build 25.212-b04, mixed mode)

# yum list installed|grep -i java
java-1.7.0-openjdk.x86_64               1:1.7.0.221-2.6.18.0.el7_6     @updates 
java-1.7.0-openjdk-headless.x86_64      1:1.7.0.221-2.6.18.0.el7_6     @updates 
java-1.8.0-openjdk.x86_64               1:1.8.0.212.b04-0.el7_6        @updates 
java-1.8.0-openjdk-headless.x86_64      1:1.8.0.212.b04-0.el7_6        @updates 
javapackages-tools.noarch               3.4.1-11.el7                   @base    
python-javapackages.noarch              3.4.1-11.el7                   @base    
tzdata-java.noarch                      2019a-1.el7                    @updates 

# rpm -qa |grep -i -E 'java|jdk' |sort
copy-jdk-configs-3.3-10.el7_5.noarch
java-1.7.0-openjdk-1.7.0.221-2.6.18.0.el7_6.x86_64
java-1.7.0-openjdk-headless-1.7.0.221-2.6.18.0.el7_6.x86_64
java-1.8.0-openjdk-1.8.0.212.b04-0.el7_6.x86_64
java-1.8.0-openjdk-devel-1.8.0.212.b04-0.el7_6.x86_64
java-1.8.0-openjdk-headless-1.8.0.212.b04-0.el7_6.x86_64
javapackages-tools-3.4.1-11.el7.noarch
python-javapackages-3.4.1-11.el7.noarch
tzdata-java-2019a-1.el7.noarch


# rpm -e --nodeps tzdata-java-2019a-1.el7.noarch ;
rpm -e --nodeps java-1.7.0-openjdk-1.7.0.221-2.6.18.0.el7_6.x86_64 ;
rpm -e --nodeps java-1.7.0-openjdk-headless-1.7.0.221-2.6.18.0.el7_6.x86_64 ;
rpm -e --nodeps java-1.8.0-openjdk-1.8.0.212.b04-0.el7_6.x86_64 ;
rpm -e --nodeps java-1.8.0-openjdk-devel-1.8.0.212.b04-0.el7_6.x86_64 ;
rpm -e --nodeps java-1.8.0-openjdk-headless-1.8.0.212.b04-0.el7_6.x86_64 ;

https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
下载 JDK 1.8

# rz
# rpm -Uvh ./jdk-8u211-linux-x64.rpm

# which java
/usr/bin/java
# /usr/bin/java -version
java version "1.8.0_211"
Java(TM) SE Runtime Environment (build 1.8.0_211-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.211-b12, mixed mode)

# vi /etc/profile
export JAVA_HOME=/usr/java/jdk1.8.0_211-amd64
export CLASSPATH=.:${JAVA_HOME}/jre/lib/rt.jar:${JAVA_HOME}/lib/dt.jar:${JAVA_HOME}/lib/tools.jar:${CLASSPATH}
export PATH=${JAVA_HOME}/bin:$PATH

swingbench 在图形界面下使用比较方便，安装个 gnome 桌面

# yum -y groups install "GNOME Desktop"
# startx

安装 swingbench

下载 http://dominicgiles.com/swingbench/swingbench261076.zip

# su - oracle
$ rz
$ unzip swingbench261076.zip
$ ls -l
drwx------ 12 oracle oinstall       4096 Jan 16  2018 swingbench
-rw-r--r--  1 oracle oinstall   23872694 Jun 10 11:50 swingbench261076.zip

导入数据

$ cd swingbench
$ ./bin/oewizard

按照提示数据相关信息后，我选择了1G的小数据量，之后会连接到目标数据库上创建表空间，用户，表。

运行swingbench执行测试

数据导完之后在该目录下运行swingbench执行测试

$ ./swingbench

修改数据库连接名，用户连接数设置为300，测试时间设置为5分钟

可以大致看到压力测试中，数据库可以达到的TPM，TPS等性能指标，作为今后系统正式上线后的一个参考依据。

参考:
http://dominicgiles.com/swingbench.html
http://dominicgiles.com/index.html