测试环境
oracle19c rac prod_pdb1
centos7.9
测试软件 SwingBench 2.6 dominicgiles.com/downloads.html
测试client centos
测试软件 swingbenchlatest.zip
1、下载压力测试软件
有时网站不好用，可以从这里下载
链接：pan.baidu.com/s/188wUGtyIaaBSrisfIBqrRw
提取码：tofg
dominicgiles.com/downloads.html
下载java8并配置。(略)
可参考blog.csdn.net/ctypyb2002/article/details/91380268
2、测试软件
[root@bms-2 bin]# pwd /root/swingbench/bin [root@bms-2 bin]#
3、导入数据
[root@bms-2 swingbench]# ./bin/oewizard
注意：我这边连接的是rac的scanip
[oracle@bms-10 ~]$ cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 #public ip 10.0.0.10 bms-10 10.0.0.11 bms-9 #priv ip 192.168.149.10 bms-10-priv 192.168.149.11 bms-9-priv #vip ip 10.0.0.12 bms-10-vip 10.0.0.13 bms-9-vip #scan ip 10.0.0.14 cluster-scan [oracle@bms-10 ~]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-JAN-2022 16:07:15 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 05-JAN-2022 17:20:07 Uptime 0 days 22 hr. 47 min. 8 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19c/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/bms-10/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.10)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.12)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DGDATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DGFRA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DGMGMT" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DGOCR" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "SYS$SYS.SCHEDULER$_EVENT_QUEUE.PROD_PDB1" has 1 instance(s). Instance "prod1", status READY, has 1 handler(s) for this service... Service "d4bdf3b6be4a9f09e0530a00000a8d07" has 1 instance(s). Instance "prod1", status READY, has 1 handler(s) for this service... Service "d4be902fbbfbba81e0530a00000a5878" has 1 instance(s). Instance "prod1", status READY, has 1 handler(s) for this service... Service "prod" has 1 instance(s). Instance "prod1", status READY, has 1 handler(s) for this service... Service "prodXDB" has 1 instance(s). Instance "prod1", status READY, has 1 handler(s) for this service... Service "prod_pdb1" has 1 instance(s). Instance "prod1", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@bms-10 ~]$
看性能，需要一段时间。我这里花了12分钟
4、压力测试，我这边是rac，直接连接rac的scan ip测试即可
[root@bms-2 bin]# pwd /root/swingbench/bin [root@bms-2 bin]# ./swingbench
同时可以测试一下rac其中一台机器的disk 和cpu
看一下scan ip所在主机然后配置一下
点击左上角绿色按钮开始测试
主备机都可以查看到连接
tcp 0 0 10.0.0.13:1521 10.0.0.4:54190 ESTABLISHED 81036/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54586 ESTABLISHED 81125/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54250 ESTABLISHED 81052/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54122 ESTABLISHED 81000/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54402 ESTABLISHED 81095/oracleprod2 tcp 0 16 10.0.0.13:1521 10.0.0.4:54144 ESTABLISHED 81010/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55670 ESTABLISHED 81412/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55336 ESTABLISHED 81364/oracleprod2 tcp 0 354 10.0.0.13:1521 10.0.0.4:54594 ESTABLISHED 81139/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54128 ESTABLISHED 81002/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54056 ESTABLISHED 80968/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54674 ESTABLISHED 81155/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:53960 ESTABLISHED 80958/oracleprod2 tcp 0 970 10.0.0.13:1521 10.0.0.4:54420 ESTABLISHED 81101/oracleprod2 tcp 0 16 10.0.0.13:1521 10.0.0.4:55400 ESTABLISHED 81384/oracleprod2 tcp 0 515 10.0.0.13:1521 10.0.0.4:54994 ESTABLISHED 81225/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54834 ESTABLISHED 81205/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55654 ESTABLISHED 81406/oracleprod2 tcp 0 497 10.0.0.13:1521 10.0.0.4:55322 ESTABLISHED 81358/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55662 ESTABLISHED 81408/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55364 ESTABLISHED 81370/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55686 ESTABLISHED 81352/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54010 ESTABLISHED 80982/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54894 ESTABLISHED 81215/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:53862 ESTABLISHED 80936/oracleprod2 tcp 0 16 10.0.0.13:1521 10.0.0.4:54744 ESTABLISHED 81175/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54152 ESTABLISHED 81012/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54378 ESTABLISHED 81089/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55410 ESTABLISHED 81378/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54816 ESTABLISHED 81195/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54178 ESTABLISHED 81030/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55058 ESTABLISHED 81237/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55222 ESTABLISHED 81287/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55360 ESTABLISHED 81372/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55008 ESTABLISHED 81227/oracleprod2 tcp 0 16 10.0.0.13:1521 10.0.0.4:55666 ESTABLISHED 81348/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:53938 ESTABLISHED 80948/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54230 ESTABLISHED 81046/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54800 ESTABLISHED 81191/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55126 ESTABLISHED 81255/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54468 ESTABLISHED 81109/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55690 ESTABLISHED 81418/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54532 ESTABLISHED 81123/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:55522 ESTABLISHED 81404/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54366 ESTABLISHED 81081/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:53882 ESTABLISHED 80938/oracleprod2 tcp 0 0 10.0.0.13:1521 10.0.0.4:54166 ESTABLISHED 81020/oracleprod2 [root@bms-9 ~]# netstat -antpl | grep 10.0.0.4
图形方式的显示就出来了
保存测试结果
只是简单的用了一下该软件，有需要做oracle压力测试的试一下吧。