ORACLE壓力測試
測試環境
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壓力測試的試一下吧。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/70004783/viewspace-2848548/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle壓力測試之orastress!OracleAST
- oracle壓力測試之orabm(二)Oracle
- oracle壓力測試之orabm(三)Oracle
- oracle壓力測試之orabm(一)Oracle
- 壓力測試
- 【SWINGBENCH】使用SwingBench對Oracle進行壓力測試Oracle
- sysbench 壓力測試
- MACOSXApacheab壓力測試MacApache
- laravel壓力測試Laravel
- （一）效能測試（壓力測試、負載測試）負載
- RestCloud測試平臺，支援壓力測試RESTCloud
- 軟體壓力測試知識分享，2022好用壓力測試工具有哪些?
- 讓測試事半功倍軟體壓力測試工具分享，壓力測試報告怎麼收費?測試報告
- Jmeter效能測試 —— 壓力模式JMeter模式
- Apache Bench Web 壓力測試ApacheWeb
- apache ab壓力測試工具-批次壓測指令碼Apache指令碼
- 軟體壓力測試怎麼做?出具壓力測試報告軟體測評中心測試報告
- 軟體壓力測試流程和測試工具分享，讓你寫壓力測試報告再也不愁測試報告
- 壓力測試相關指標指標
- 使用Gatling做web壓力測試Web
- 10大主流壓力測試工具
- 效能壓力測試JMeter替代：LoadjitsuJMeter
- Android Monkey 壓力測試 介紹Android
- 使用JMeter進行壓力測試JMeter
- 介面測試，負載測試，併發測試，壓力測試區別負載
- 軟體產品為什麼要做壓力測試?壓力測試報告如何獲取?測試報告
- 小景的Dba之路--壓力測試和Oracle資料庫快取Oracle資料庫快取
- 開源的負載測試/壓力測試工具 NBomber負載
- Taurus.MVC 效能壓力測試（ap 壓測 和 linux 下wrk 壓測）：.NET 版本MVCLinux
- 效能測試、負載測試、壓力測試有什麼區別？負載
- 後端相關技能（六）：壓力測試後端
- App 壓力測試學習總結APP
- apache-ab 壓力測試詳解Apache
- Linux下使用壓力測試工具stressLinux
- nodejs版的websocket壓力測試工具NodeJSWeb
- Taurus.MVC 效能壓力測試（ap 壓測 和 linux 下wrk 壓測）：.NET Core 版本MVCLinux
- jmeter壓力測試實現負載均衡JMeter負載
- 10大主流壓力測試工具推薦