-
-
Save jongsma/1957659dc0eae97ed5d00e1f7df8ed24 to your computer and use it in GitHub Desktop.
JMeter Oracle DB test
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<jmeterTestPlan version="1.2" properties="5.0" jmeter="5.1.1 r1855137"> | |
<hashTree> | |
<TestPlan guiclass="TestPlanGui" testclass="TestPlan" testname="Test Plan" enabled="true"> | |
<stringProp name="TestPlan.comments"></stringProp> | |
<boolProp name="TestPlan.functional_mode">false</boolProp> | |
<boolProp name="TestPlan.tearDown_on_shutdown">true</boolProp> | |
<boolProp name="TestPlan.serialize_threadgroups">false</boolProp> | |
<elementProp name="TestPlan.user_defined_variables" elementType="Arguments" guiclass="ArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true"> | |
<collectionProp name="Arguments.arguments"> | |
<elementProp name="threads" elementType="Argument"> | |
<stringProp name="Argument.name">threads</stringProp> | |
<stringProp name="Argument.value">${__P(threads,1)}</stringProp> | |
<stringProp name="Argument.metadata">=</stringProp> | |
</elementProp> | |
<elementProp name="rampup" elementType="Argument"> | |
<stringProp name="Argument.name">rampup</stringProp> | |
<stringProp name="Argument.value">${__P(rampup,10)}</stringProp> | |
<stringProp name="Argument.metadata">=</stringProp> | |
</elementProp> | |
<elementProp name="loop" elementType="Argument"> | |
<stringProp name="Argument.name">loop</stringProp> | |
<stringProp name="Argument.value">${__P(loop,1)}</stringProp> | |
<stringProp name="Argument.metadata">=</stringProp> | |
</elementProp> | |
</collectionProp> | |
</elementProp> | |
<stringProp name="TestPlan.user_define_classpath">/Users/klaasjan/bin/instantclient_18_1/ojdbc8.jar</stringProp> | |
</TestPlan> | |
<hashTree> | |
<SetupThreadGroup guiclass="SetupThreadGroupGui" testclass="SetupThreadGroup" testname="setUp Thread Group" enabled="true"> | |
<stringProp name="ThreadGroup.on_sample_error">continue</stringProp> | |
<elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel" testclass="LoopController" testname="Loop Controller" enabled="true"> | |
<boolProp name="LoopController.continue_forever">false</boolProp> | |
<stringProp name="LoopController.loops">1</stringProp> | |
</elementProp> | |
<stringProp name="ThreadGroup.num_threads">${threads}</stringProp> | |
<stringProp name="ThreadGroup.ramp_time">${rampup}</stringProp> | |
<boolProp name="ThreadGroup.scheduler">false</boolProp> | |
<stringProp name="ThreadGroup.duration"></stringProp> | |
<stringProp name="ThreadGroup.delay"></stringProp> | |
</SetupThreadGroup> | |
<hashTree> | |
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="JDBC: Create table" enabled="true"> | |
<stringProp name="dataSource">oracle_db</stringProp> | |
<stringProp name="queryType">Callable Statement</stringProp> | |
<stringProp name="query">create table jmeter_${__threadNum} (text1 varchar2(4000))</stringProp> | |
<stringProp name="queryArguments"></stringProp> | |
<stringProp name="queryArgumentsTypes"></stringProp> | |
<stringProp name="variableNames"></stringProp> | |
<stringProp name="resultVariable"></stringProp> | |
<stringProp name="queryTimeout"></stringProp> | |
<stringProp name="resultSetHandler">Store as String</stringProp> | |
</JDBCSampler> | |
<hashTree/> | |
</hashTree> | |
<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="JDBC Users" enabled="true"> | |
<stringProp name="TestPlan.comments">Thread group for JDBC users</stringProp> | |
<stringProp name="ThreadGroup.on_sample_error">stoptest</stringProp> | |
<elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel" testclass="LoopController" testname="Loop Controller" enabled="true"> | |
<boolProp name="LoopController.continue_forever">false</boolProp> | |
<stringProp name="LoopController.loops">${loop}</stringProp> | |
</elementProp> | |
<stringProp name="ThreadGroup.num_threads">${threads}</stringProp> | |
<stringProp name="ThreadGroup.ramp_time">${rampup}</stringProp> | |
<boolProp name="ThreadGroup.scheduler">false</boolProp> | |
<stringProp name="ThreadGroup.duration"></stringProp> | |
<stringProp name="ThreadGroup.delay"></stringProp> | |
</ThreadGroup> | |
<hashTree> | |
<JDBCDataSource guiclass="TestBeanGUI" testclass="JDBCDataSource" testname="Oracle JDBC Connection Configuration" enabled="true"> | |
<boolProp name="autocommit">true</boolProp> | |
<stringProp name="checkQuery">select 1 from dual</stringProp> | |
<stringProp name="connectionAge">5000</stringProp> | |
<stringProp name="dataSource">oracle_db</stringProp> | |
<stringProp name="dbUrl">jdbc:oracle:thin:@//localhost:1521/nocdb</stringProp> | |
<stringProp name="driver">oracle.jdbc.OracleDriver</stringProp> | |
<stringProp name="initQuery"></stringProp> | |
<boolProp name="keepAlive">true</boolProp> | |
<stringProp name="password">test</stringProp> | |
<stringProp name="poolMax">0</stringProp> | |
<stringProp name="timeout">10000</stringProp> | |
<stringProp name="transactionIsolation">DEFAULT</stringProp> | |
<stringProp name="trimInterval">60000</stringProp> | |
<stringProp name="username">stress</stringProp> | |
</JDBCDataSource> | |
<hashTree/> | |
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="JDBC: Fill table" enabled="true"> | |
<stringProp name="dataSource">oracle_db</stringProp> | |
<stringProp name="query">declare | |
sql_stmt varchar(200); | |
begin | |
for i in 1..1000 loop | |
sql_stmt := 'insert /*+ append_values */ into jmeter_${__threadNum} select lpad( ''x'','||i||',''x'') from dual'; | |
execute immediate sql_stmt; | |
commit; | |
end loop; | |
end;</stringProp> | |
<stringProp name="queryArguments"></stringProp> | |
<stringProp name="queryArgumentsTypes"></stringProp> | |
<stringProp name="queryTimeout"></stringProp> | |
<stringProp name="queryType">Callable Statement</stringProp> | |
<stringProp name="resultSetHandler">Store as String</stringProp> | |
<stringProp name="resultVariable"></stringProp> | |
<stringProp name="variableNames"></stringProp> | |
</JDBCSampler> | |
<hashTree/> | |
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="JDBC: Count(*)" enabled="true"> | |
<stringProp name="dataSource">oracle_db</stringProp> | |
<stringProp name="queryType">Select Statement</stringProp> | |
<stringProp name="query">select count(*) from jmeter_${__threadNum}</stringProp> | |
<stringProp name="queryArguments"></stringProp> | |
<stringProp name="queryArgumentsTypes"></stringProp> | |
<stringProp name="variableNames"></stringProp> | |
<stringProp name="resultVariable"></stringProp> | |
<stringProp name="queryTimeout"></stringProp> | |
<stringProp name="resultSetHandler">Store as String</stringProp> | |
</JDBCSampler> | |
<hashTree/> | |
</hashTree> | |
<PostThreadGroup guiclass="PostThreadGroupGui" testclass="PostThreadGroup" testname="tearDown Thread Group" enabled="true"> | |
<stringProp name="ThreadGroup.on_sample_error">continue</stringProp> | |
<elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel" testclass="LoopController" testname="Loop Controller" enabled="true"> | |
<boolProp name="LoopController.continue_forever">false</boolProp> | |
<stringProp name="LoopController.loops">1</stringProp> | |
</elementProp> | |
<stringProp name="ThreadGroup.num_threads">${threads}</stringProp> | |
<stringProp name="ThreadGroup.ramp_time">${rampup}</stringProp> | |
<boolProp name="ThreadGroup.scheduler">false</boolProp> | |
<stringProp name="ThreadGroup.duration"></stringProp> | |
<stringProp name="ThreadGroup.delay"></stringProp> | |
</PostThreadGroup> | |
<hashTree> | |
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="JDBC: Delete table" enabled="true"> | |
<stringProp name="dataSource">oracle_db</stringProp> | |
<stringProp name="queryType">Callable Statement</stringProp> | |
<stringProp name="query">drop table jmeter_${__threadNum}</stringProp> | |
<stringProp name="queryArguments"></stringProp> | |
<stringProp name="queryArgumentsTypes"></stringProp> | |
<stringProp name="variableNames"></stringProp> | |
<stringProp name="resultVariable"></stringProp> | |
<stringProp name="queryTimeout"></stringProp> | |
<stringProp name="resultSetHandler">Store as String</stringProp> | |
</JDBCSampler> | |
<hashTree/> | |
</hashTree> | |
<ResultCollector guiclass="SummaryReport" testclass="ResultCollector" testname="Summary Report" enabled="true"> | |
<boolProp name="ResultCollector.error_logging">false</boolProp> | |
<objProp> | |
<name>saveConfig</name> | |
<value class="SampleSaveConfiguration"> | |
<time>true</time> | |
<latency>true</latency> | |
<timestamp>true</timestamp> | |
<success>true</success> | |
<label>true</label> | |
<code>true</code> | |
<message>true</message> | |
<threadName>true</threadName> | |
<dataType>true</dataType> | |
<encoding>false</encoding> | |
<assertions>true</assertions> | |
<subresults>true</subresults> | |
<responseData>false</responseData> | |
<samplerData>false</samplerData> | |
<xml>false</xml> | |
<fieldNames>true</fieldNames> | |
<responseHeaders>false</responseHeaders> | |
<requestHeaders>false</requestHeaders> | |
<responseDataOnError>false</responseDataOnError> | |
<saveAssertionResultsFailureMessage>true</saveAssertionResultsFailureMessage> | |
<assertionsResultsToSave>0</assertionsResultsToSave> | |
<bytes>true</bytes> | |
<sentBytes>true</sentBytes> | |
<url>true</url> | |
<threadCounts>true</threadCounts> | |
<idleTime>true</idleTime> | |
<connectTime>true</connectTime> | |
</value> | |
</objProp> | |
<stringProp name="filename">summary.txt</stringProp> | |
</ResultCollector> | |
<hashTree/> | |
<ResultCollector guiclass="ViewResultsFullVisualizer" testclass="ResultCollector" testname="View Results Tree" enabled="true"> | |
<boolProp name="ResultCollector.error_logging">false</boolProp> | |
<objProp> | |
<name>saveConfig</name> | |
<value class="SampleSaveConfiguration"> | |
<time>true</time> | |
<latency>true</latency> | |
<timestamp>true</timestamp> | |
<success>true</success> | |
<label>true</label> | |
<code>true</code> | |
<message>true</message> | |
<threadName>true</threadName> | |
<dataType>true</dataType> | |
<encoding>false</encoding> | |
<assertions>true</assertions> | |
<subresults>true</subresults> | |
<responseData>false</responseData> | |
<samplerData>false</samplerData> | |
<xml>false</xml> | |
<fieldNames>true</fieldNames> | |
<responseHeaders>false</responseHeaders> | |
<requestHeaders>false</requestHeaders> | |
<responseDataOnError>false</responseDataOnError> | |
<saveAssertionResultsFailureMessage>true</saveAssertionResultsFailureMessage> | |
<assertionsResultsToSave>0</assertionsResultsToSave> | |
<bytes>true</bytes> | |
<sentBytes>true</sentBytes> | |
<url>true</url> | |
<threadCounts>true</threadCounts> | |
<idleTime>true</idleTime> | |
<connectTime>true</connectTime> | |
</value> | |
</objProp> | |
<stringProp name="filename">results.txt</stringProp> | |
</ResultCollector> | |
<hashTree/> | |
<ResultCollector guiclass="RespTimeGraphVisualizer" testclass="ResultCollector" testname="Response Time Graph" enabled="true"> | |
<boolProp name="ResultCollector.error_logging">false</boolProp> | |
<objProp> | |
<name>saveConfig</name> | |
<value class="SampleSaveConfiguration"> | |
<time>true</time> | |
<latency>true</latency> | |
<timestamp>true</timestamp> | |
<success>true</success> | |
<label>true</label> | |
<code>true</code> | |
<message>true</message> | |
<threadName>true</threadName> | |
<dataType>true</dataType> | |
<encoding>false</encoding> | |
<assertions>true</assertions> | |
<subresults>true</subresults> | |
<responseData>false</responseData> | |
<samplerData>false</samplerData> | |
<xml>false</xml> | |
<fieldNames>true</fieldNames> | |
<responseHeaders>false</responseHeaders> | |
<requestHeaders>false</requestHeaders> | |
<responseDataOnError>false</responseDataOnError> | |
<saveAssertionResultsFailureMessage>true</saveAssertionResultsFailureMessage> | |
<assertionsResultsToSave>0</assertionsResultsToSave> | |
<bytes>true</bytes> | |
<sentBytes>true</sentBytes> | |
<url>true</url> | |
<threadCounts>true</threadCounts> | |
<idleTime>true</idleTime> | |
<connectTime>true</connectTime> | |
</value> | |
</objProp> | |
<stringProp name="filename">response.png</stringProp> | |
</ResultCollector> | |
<hashTree/> | |
</hashTree> | |
</hashTree> | |
</jmeterTestPlan> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment