Performance 09 Article-oracle Database Performance test

Nine easy steps to perform Oracle database performance testing

1) Copy the JDBC Driver jar package file (Ojdbc14.jar) from Oracle to the JMeter Lib directory. The Ojdbc14.jar file is typically located in the Jdbc\lib directory under the Oracle installation directory.

2) Enter the bin directory to run Jmeter.bat boot jmeter.

3) Add a new thread group under the test plan. such as thread Group 5, loop execution 10 times, that is, a total of 50 requests.

4) Add a JDBC Connection pool configuration under the thread group.

The configuration is as follows:

Database URL: DB address in the format: Jdbc:oracle:thin:@[ip address]:[Port number]:[instance name], such as: JDBC:ORACLE:THIN:@192.168.0.162:1521:YDGL

JDBC Driver class: Database JDBC Driver class name, Oracle.jdbc.driver.OracleDriver.

Username: Database connection user name.

Password: Database connection password.

5) Add a JDBC request. such as input test sql:select count (*) from Dba_tables. You need to replace SQL in your actual work.

6) Add an aggregated report to show the test results.

7) Save the test plan, it is a good habit to save the test plan before running the test.

8) Determine the test from the Run menu.

9) Review the test results by aggregating the reports. The aggregated report shows information about the test, such as number of visits, average time, maximum time, minimum time, error rate, and so on.

Long press QR Code recognition concern, your support is our greatest power.

Public Number: Testing DreamWorks

QQ Group: 300897805

　　

Performance 09 Article-oracle Database Performance test