How to use Swingbench for Oracle database stress Testing

The Swingbench is an open source Oracle Stress test Tool on the Web that supports the Oracle 11g version and also tests the RAC. The latest software version can be downloaded from the official page http://dominicgiles.com/downloads.html.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4B/BB/wKiom1Qx2GDhPRnSAAGf-N_yano842.jpg "title=" ee.jpg "alt=" Wkiom1qx2gdhprnsaagf-n_yano842.jpg "/>

Swingbench can run on Windows and Linux platforms, this test takes the Linux platform, the specific test process is as follows:

1, first use VMVARE10 to build a redhat6.5 virtual machine.

2, install the ORACLE11G database on the virtual redhat6.5.

3, using Oewizard Import test data, you can follow the wizard prompts for data import.

4, the use of swingbench for pressure testing.

Test steps:

1, the data need to modify the temp table space before it can accommodate the corresponding import data

Create Temporarytablespace temp tempfile '/home/oracle/oradata/orcl/temp.dbf ' size 1g;

Alter Databasedefault temporary tablespace temp;

2. Install the Swingbench test software and unzip it directly to run.

Unzip-x Swingbench25919.zip

3. Enter the Swingbench/bin directory to perform oewizard import 1G test data and modify the database connection name and DBA password

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/4B/BD/wKioL1Qx2h3TrIIGAAGyVq92CVA180.jpg "title=" e1.jpg "alt=" Wkiol1qx2h3triigaagyvq92cva180.jpg "/>

Enter the location where the import data file is stored:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/4B/BB/wKiom1Qx2nGTFbZFAAGBnRUybxU038.jpg "title=" e2.jpg "alt=" Wkiom1qx2ngtfbzfaagbnruybxu038.jpg "/>

Select Import 1G Data:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/4B/BD/wKioL1Qx2tnyThWoAAE8qLLgIJI464.jpg "title=" e3.jpg "alt=" Wkiol1qx2tnythwoaae8qllgiji464.jpg "/>

Run Swingbench in this directory after the data is executed, modify the database connection name, set the number of user connections to 300, and set the test time to 10 minutes

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/4B/BB/wKiom1Qx2v6S6yjvAAKAl63J5mg784.jpg "title=" e4.jpg "alt=" Wkiom1qx2v6s6yjvaakal63j5mg784.jpg "/>

Modify the distributed controls to collect the test monitoring information during the test, test the connection is correct after the modification, and can count the host CPU disk IO information

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4B/BD/wKioL1Qx24DDSssqAAFmiLc2VSU132.jpg "title=" e5.jpg "alt=" Wkiol1qx24ddsssqaafmilc2vsu132.jpg "/>

You can also pull out the awr report

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/4B/BD/wKioL1Qx3O2gzw45AADH_p4CEeQ979.jpg "title=" e7.jpg "alt=" Wkiol1qx3o2gzw45aadh_p4ceeq979.jpg "/>

Set Insert,update, ratio of select

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4B/BD/wKioL1Qx3RHB32ITAAEK9ABjiPI261.jpg "title=" e8.jpg "alt=" Wkiol1qx3rhb32itaaek9abjipi261.jpg "/>

When the settings are complete, click the Green button on the top left to perform the test

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4B/BB/wKiom1Qx24zgsNQ-AAEJ51YcKSs614.jpg "title=" e6.jpg "alt=" Wkiom1qx24zgsnq-aaej51yckss614.jpg "/>

Testing process

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/4B/BB/wKiom1Qx3QaxFssnAAGpJeiYV6Q924.jpg "title=" e9.jpg "alt=" Wkiom1qx3qaxfssnaagpjeiyv6q924.jpg "/>

The test results are persisted as XML documents, and the final view is displayed as follows

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/4B/BD/wKioL1Qx3YTjl5FJAAHAP8c-C8k663.jpg "title=" E10.jpg "alt=" Wkiol1qx3ytjl5fjaahap8c-c8k663.jpg "/>

This article is from the "Hollows Jie Sun" blog, be sure to keep this source http://xjsunjie.blog.51cto.com/999372/1560779

How to use Swingbench for Oracle database stress Testing