The approximate steps are as follows:
(1) Copy the JDBC Driver jar package file (Ojdbc14.jar) from Oracle to the JMeter Lib directory.
(2) Running Jmeter.bat
(3) Create thread Group: Right-click Test Plan, add->threads-> thread Group
(4) To establish a JDBC Connection configuration: Right-click Thread Group, add-and-configure Originals->jdbc Connection Config
(5) In database Connection configuration input virable name Bound to pool variable name content
(6) In database Connection configuration information
For example:
Database Url:jdbc:oracle:thin:@192.168.1.168:1521:ptoracl
JDBC Driver Class:oracle.jdbc.driver.OracleDriver
Username:lianggzone
Password:lianggzone
Note:
Database URL Format: Jdbc:oracle:thin:@[ip address]:[Port number]:[instance name]
User name, password is the user name and password to connect to the database
(7) To create a JDBC request: Right-click the thread group, add->SAMPLER->JDBC request
Variable Name: Fill in the same content with the JDBC Connection configuration above.
SQL query: is the SQL statement.
(8) Add Monitor: Right-click Thread Group, add-on monitor
(9) Final effect
For more information, see: http://edu.51cto.com/course/2324.html
If you have a loss of help, forwarding + likes = support
JMeter Testing the Oracle Database