JMeter Learning (eight) perform Oracle stress testing

Environment: oracle:10g

JDBC Driver: Copy the Oracle installation directory (Oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar) file to the Jmeter/lib directory

jmeter:jmeter-2.11

1. Open JMeter, click Test Plan

Click on the "Browse ..." button to add your JDBC driver.

2. Add a thread group, right-click on "Thread Group" and add a "JDBC Connection Configuration" below

To configure the JDBC Connection configuration page.

3. Right click on "Thread Group" and add a "JDBC request" below.

The parameters that need to be modified include variable Name, to fill in the same content as the JDBC Connection configuration above, so: Oracleconn. This indicates that the JDBC Connection configuration establishes a connection pool named Oracle, after which the other JDBC request shared the connection pool.

NOTE:in SQL statements, you can use parameterization .

4. Add an assertion, right-click the thread group----> Add---> Assert----> Response assertion.

5. Let's add some listeners to the line to view:

Add an assertion result: Right-click the thread group----> Add---> Listener----> Result assertion.

Add a graphical result: Right-click the thread group----> Add---> Listener----> Graphical results.

Add a View results tree: Right-click the thread group----> Add---> Listener----> View the results tree.

Here is a list of all the additions:

6. Thread Group page set number of users, start time, number of cycles, and then click the menu bar "Run"----"Start"

Here's the result:

At this point, jmeter to carry out the stress test to this end, in particular, according to the actual project to carry out.

Note: Assertion results has a serious effect on the throughout of JMeter pressure measurement.

JMeter Learning (eight) perform Oracle stress testing