JMeter Performance Test Method for Oracle databases

Download the jdbc database driver package for Oracle. Pay attention to the version of the Oracle database. Here we use: OracleDatabase11gEnterpriseEditionRelease11.2.

Download the jdbc Database driver package for Oracle. Pay attention to the version of the Oracle Database. Here we use: Oracle Database 11g Enterprise Edition Release 11.2.

Download the jdbc Database driver package for Oracle. Pay attention to the version of the Oracle Database. Here we use: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production;

Generally, the driver package file of the database is in the installation path: D: \ oracle \ product \ 10.2.0 \ db_1 \ jdbc \ lib; the database driver package is irrelevant to the operating system platform where the database is located. It is only related to the database version. For databases of the same version on Linux and Windows, the database driver package is the same;

Driver ojdbc6.jar:

Scenario: To test the performance of a server, you must check the processing capability of inserting 1000 data entries/s into the database;

Follow the previous idea: Write a java program to insert data cyclically and write a batch file to call the java program. Then, the LR system () function is used to call the batch file for stress testing.

However, JMeter is easy to implement. The process is as follows:

Prerequisites: 1. database exists; 2. Tables in the database, such as user_dyl (code, name );

Requirements: Insert a large volume of data into the database, 1000 entries/s;

1. Create a test plan and import the used database driver package

2. Add a thread group and set the number of virtual users, startup time, and number of cycles.

3. Create a JDBC Connection Configuration under the thread and set relevant information.

4. Create a JDBC Request. We need to insert the database. Note that the value includes''

5. Add a listener. Here, select "graphic result" and "view result tree", and click "run"> "start" on the menu bar to view the running result.

This article permanently updates the link address: