Optimizing an Oracle Database for an e-commerce service

In this example study, we will tune the initialization parameters of an Oracle Database server instance to minimize the memory required for running KonaKart, a popular Java e-commerce service, without significantly impacting the responsiveness of the whole system.
We’ll use Apache JMeter to stress the system for the test, while we will leverage the Oracle Prometheus exporter to extract the metrics.
Environment Setup
Environment
For this study, we will use three dedicated machines:
oradb.mycompany.com, hosting an Oracle Database 19c instance
konakart.mycompany.com, running the KonaKart Community Edition service
akamas.mycompany.com, which generates the workload using JMeter and will host the OracleDB Prometheus exporter instance
Refer to the following links to install and configure KonaKart Community Edition:
​Install KonaKart: install and configure the service
​Manual Installation: install the demo dataset
For this use case, we provisioned the database on a VM on Oracle Cloud, which allows us to easily provision licensed instances on demand.
Prometheus and exporters
Install the OracleDB Prometheus exporter
Through the OracleDB Prometheus exporter, we can publish as metrics the results of the arbitrary queries defined in the configuration file. In our case, we’ll use it to extract valuable performance metrics from Oracle’s Dynamic Performance (V$) Views.
We can spin up the exporter using the official Docker image using the following command, where cust-metrics.toml is our custom metrics file:
1
docker run -d --name orabench_exporter --restart always \
2
  -p 9161:9161 \
3
  -v ~/oracledb_exporter/cust-metrics.toml:/cust-metrics.toml \
4
  -e CUSTOM_METRICS=/cust-metrics.toml \
5
  -e DATA_SOURCE_NAME='user/passwd@//oradb.mycompany.com:1521/konakart' \
6
  iamseth/oracledb_exporter
The exporter will publish the metrics on the specified port 9161.
Here’s the metrics file used to run the exporter:
1
[[metric]]
2
context= "memory"
3
labels= [ "component" ]
4
metricsdesc= { size="Component memory extracted from v$memory_dynamic_components in Oracle." }
5
request = '''
6
SELECT component, current_size as "size"
7
FROM V$MEMORY_DYNAMIC_COMPONENTS
8
UNION
9
SELECT name, bytes as "size"
10
FROM V$SGAINFO
11
WHERE name in ('Free SGA Memory Available', 'Redo Buffers', 'Maximum SGA Size')
12
'''
13
​
14
[[metric]]
15
context = "activity"
16
metricsdesc = { value="Generic counter metric from v$sysstat view in Oracle." }
17
fieldtoappend = "name"
18
request = '''
19
SELECT name, value
20
FROM V$SYSSTAT WHERE name IN (
21
  'execute count',
22
  'user commits', 'user rollbacks',
23
  'db block gets from cache', 'consistent gets from cache', 'physical reads cache', /* CACHE */
24
  'redo log space requests'
25
 )
26
 '''
27
​
28
[[metric]]
29
context = "system_event"
30
labels = [ "event", "wait_class" ]
31
request = '''
32
SELECT
33
  event, wait_class,
34
  total_waits, time_waited
35
FROM V$SYSTEM_EVENT
36
'''
37
[metric.metricsdesc]
38
  total_waits= "Total number of waits for the event as per V$SYSTEM_EVENT in Oracle."
39
  time_waited= "Total time waited for the event (in hundredths of seconds) as per V$SYSTEM_EVENT in Oracle."
Install and configure Prometheus
Using the following snippet we configure Prometheus to fetch metrics from:
the JMeter exporter exposing the load-generator stats
the OracleDB exporter monitoring the database
1
scrape_configs:
2
  - job_name: jmeter
3
    static_configs:
4
      - targets: ['akamas.mycompany.com:9270']
5
    relabel_configs:
6
      - source_labels: [__address__]
7
        action: replace
8
        regex: "(.*):.*"
9
        target_label: instance
10
​
11
  - job_name: oracle-exp
12
    static_configs:
13
      - targets: ['akamas.mycompany.com:9161']
14
        labels:
15
          instance: oradb
For a complete guide on how to configure and manage Prometheus refer to the official documentation.
Setup the load-generator
The load generator runs containerized on the akamas.mycomopany.com instance using the attached Konakart_optimizePerf.jmx configuration file.
1
<?xml version="1.0" encoding="UTF-8"?>
2
<jmeterTestPlan version="1.2" properties="5.0" jmeter="5.3">
3
  <hashTree>
4
    <TestPlan guiclass="TestPlanGui" testclass="TestPlan" testname="Test Plan" enabled="true">
5
      <stringProp name="TestPlan.comments"></stringProp>
6
      <boolProp name="TestPlan.functional_mode">false</boolProp>
7
      <boolProp name="TestPlan.tearDown_on_shutdown">true</boolProp>
8
      <boolProp name="TestPlan.serialize_threadgroups">false</boolProp>
9
      <elementProp name="TestPlan.user_defined_variables" elementType="Arguments" guiclass="ArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true">
10
        <collectionProp name="Arguments.arguments">
11
          <elementProp name="HOST" elementType="Argument">
12
            <stringProp name="Argument.name">HOST</stringProp>
13
            <stringProp name="Argument.value">${__P(HOST,konakartoraclecloud.lab.akamas.io)}</stringProp>
14
            <stringProp name="Argument.metadata">=</stringProp>
15
          </elementProp>
16
          <elementProp name="VUSER" elementType="Argument">
17
            <stringProp name="Argument.name">VUSER</stringProp>
18
            <stringProp name="Argument.value">${__P(VUSER,60)}</stringProp>
19
            <stringProp name="Argument.metadata">=</stringProp>
20
          </elementProp>
21
        </collectionProp>
22
      </elementProp>
23
      <stringProp name="TestPlan.user_define_classpath"></stringProp>
24
    </TestPlan>
25
    <hashTree>
26
      <kg.apc.jmeter.threads.UltimateThreadGroup guiclass="kg.apc.jmeter.threads.UltimateThreadGroupGui" testclass="kg.apc.jmeter.threads.UltimateThreadGroup" testname=" Thread Group" enabled="true">
27
        <collectionProp name="ultimatethreadgroupdata">
28
          <collectionProp name="682260423">
29
            <stringProp name="-1375672883">${__P(VUSER,10)}</stringProp>
30
            <stringProp name="0">0</stringProp>
31
            <stringProp name="49586">200</stringProp>
32
            <stringProp name="53430">600</stringProp>
33
            <stringProp name="48">0</stringProp>
34
          </collectionProp>
35
        </collectionProp>
36
        <elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel" testclass="LoopController" testname="Loop Controller" enabled="true">
37
          <boolProp name="LoopController.continue_forever">false</boolProp>
38
          <intProp name="LoopController.loops">-1</intProp>
39
        </elementProp>
40
        <stringProp name="ThreadGroup.on_sample_error">startnextloop</stringProp>
41
      </kg.apc.jmeter.threads.UltimateThreadGroup>
42
      <hashTree>
43
        <RandomVariableConfig guiclass="TestBeanGUI" testclass="RandomVariableConfig" testname="Random catId" enabled="true">
44
          <stringProp name="maximumValue">30</stringProp>
45
          <stringProp name="minimumValue">1</stringProp>
46
          <stringProp name="outputFormat"></stringProp>
47
          <boolProp name="perThread">true</boolProp>
48
          <stringProp name="randomSeed">666</stringProp>
49
          <stringProp name="variableName">catId</stringProp>
50
        </RandomVariableConfig>
51
        <hashTree/>
52
        <HTTPSamplerProxy guiclass="HttpTestSampleGui" testclass="HTTPSamplerProxy" testname="Welcome" enabled="true">
53
          <elementProp name="HTTPsampler.Arguments" elementType="Arguments" guiclass="HTTPArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true">
54
            <collectionProp name="Arguments.arguments"/>
55
          </elementProp>
56
          <stringProp name="HTTPSampler.domain">${HOST}</stringProp>
57
          <stringProp name="HTTPSampler.port">8780</stringProp>
58
          <stringProp name="HTTPSampler.protocol">http</stringProp>
59
          <stringProp name="HTTPSampler.contentEncoding"></stringProp>
60
          <stringProp name="HTTPSampler.path">konakart/Welcome.action</stringProp>
61
          <stringProp name="HTTPSampler.method">GET</stringProp>
62
          <boolProp name="HTTPSampler.follow_redirects">false</boolProp>
63
          <boolProp name="HTTPSampler.auto_redirects">true</boolProp>
64
          <boolProp name="HTTPSampler.use_keepalive">true</boolProp>
65
          <boolProp name="HTTPSampler.DO_MULTIPART_POST">false</boolProp>
66
          <boolProp name="HTTPSampler.BROWSER_COMPATIBLE_MULTIPART">true</boolProp>
67
          <boolProp name="HTTPSampler.image_parser">true</boolProp>
68
          <boolProp name="HTTPSampler.concurrentDwn">true</boolProp>
69
          <stringProp name="HTTPSampler.embedded_url_re"></stringProp>
70
          <stringProp name="HTTPSampler.connect_timeout"></stringProp>
71
          <stringProp name="HTTPSampler.response_timeout"></stringProp>
72
        </HTTPSamplerProxy>
73
        <hashTree/>
74
        <HTTPSamplerProxy guiclass="HttpTestSampleGui" testclass="HTTPSamplerProxy" testname="SelectCat" enabled="true">
75
          <elementProp name="HTTPsampler.Arguments" elementType="Arguments" guiclass="HTTPArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true">
76
            <collectionProp name="Arguments.arguments"/>
77
          </elementProp>
78
          <stringProp name="HTTPSampler.domain">${HOST}</stringProp>
79
          <stringProp name="HTTPSampler.port">8780</stringProp>
80
          <stringProp name="HTTPSampler.protocol">http</stringProp>
81
          <stringProp name="HTTPSampler.contentEncoding"></stringProp>
82
          <stringProp name="HTTPSampler.path">konakart/SelectCat.action?catId=${catId}</stringProp>
83
          <stringProp name="HTTPSampler.method">GET</stringProp>
84
          <boolProp name="HTTPSampler.follow_redirects">false</boolProp>
85
          <boolProp name="HTTPSampler.auto_redirects">true</boolProp>
86
          <boolProp name="HTTPSampler.use_keepalive">true</boolProp>
87
          <boolProp name="HTTPSampler.DO_MULTIPART_POST">false</boolProp>
88
          <boolProp name="HTTPSampler.BROWSER_COMPATIBLE_MULTIPART">true</boolProp>
89
          <boolProp name="HTTPSampler.image_parser">true</boolProp>
90
          <boolProp name="HTTPSampler.concurrentDwn">true</boolProp>
91
          <stringProp name="HTTPSampler.embedded_url_re"></stringProp>
92
          <stringProp name="HTTPSampler.connect_timeout"></stringProp>
93
          <stringProp name="HTTPSampler.response_timeout"></stringProp>
94
        </HTTPSamplerProxy>
95
        <hashTree/>
96
        <com.github.johrstrom.listener.PrometheusListener guiclass="com.github.johrstrom.listener.gui.PrometheusListenerGui" testclass="com.github.johrstrom.listener.PrometheusListener" testname="Prometheus Listener" enabled="true">
97
          <collectionProp name="prometheus.collector_definitions">
98
            <elementProp name="" elementType="com.github.johrstrom.listener.ListenerCollectorConfig">
99
              <stringProp name="collector.help">Sampler Response Time</stringProp>
100
              <stringProp name="collector.metric_name">ResponseTime</stringProp>
101
              <stringProp name="collector.type">SUMMARY</stringProp>
102
              <collectionProp name="collector.labels">
103
                <stringProp name="102727412">label</stringProp>
104
                <stringProp name="3059181">code</stringProp>
105
              </collectionProp>
106
              <stringProp name="collector.quantiles_or_buckets">0.5,0.01|0.85,0.01|0.9,0.01|0.99,0.01;60</stringProp>
107
              <stringProp name="listener.collector.listen_to">samples</stringProp>
108
              <stringProp name="listener.collector.measuring">ResponseTime</stringProp>
109
            </elementProp>
110
            <elementProp name="" elementType="com.github.johrstrom.listener.ListenerCollectorConfig">
111
              <stringProp name="collector.help">Success and failure ratio</stringProp>
112
              <stringProp name="collector.metric_name">Ratio</stringProp>
113
              <stringProp name="collector.type">SUCCESS_RATIO</stringProp>
114
              <collectionProp name="collector.labels">
115
                <stringProp name="102727412">label</stringProp>
116
                <stringProp name="3059181">code</stringProp>
117
              </collectionProp>
118
              <stringProp name="collector.quantiles_or_buckets"></stringProp>
119
              <stringProp name="listener.collector.listen_to">samples</stringProp>
120
              <stringProp name="listener.collector.measuring">SuccessRatio</stringProp>
121
            </elementProp>
122
          </collectionProp>
123
        </com.github.johrstrom.listener.PrometheusListener>
124
        <hashTree/>
125
        <ResultCollector guiclass="ViewResultsFullVisualizer" testclass="ResultCollector" testname="View Results Tree" enabled="false">
126
          <boolProp name="ResultCollector.error_logging">false</boolProp>
127
          <objProp>
128
            <name>saveConfig</name>
129
            <value class="SampleSaveConfiguration">
130
              <time>true</time>
131
              <latency>true</latency>
132
              <timestamp>true</timestamp>
133
              <success>true</success>
134
              <label>true</label>
135
              <code>true</code>
136
              <message>true</message>
137
              <threadName>true</threadName>
138
              <dataType>true</dataType>
139
              <encoding>false</encoding>
140
              <assertions>true</assertions>
141
              <subresults>true</subresults>
142
              <responseData>false</responseData>
143
              <samplerData>false</samplerData>
144
              <xml>false</xml>
145
              <fieldNames>true</fieldNames>
146
              <responseHeaders>false</responseHeaders>
147
              <requestHeaders>false</requestHeaders>
148
              <responseDataOnError>false</responseDataOnError>
149
              <saveAssertionResultsFailureMessage>true</saveAssertionResultsFailureMessage>
150
              <assertionsResultsToSave>0</assertionsResultsToSave>
151
              <bytes>true</bytes>
152
              <sentBytes>true</sentBytes>
153
              <url>true</url>
154
              <threadCounts>true</threadCounts>
155
              <idleTime>true</idleTime>
156
              <connectTime>true</connectTime>
157
            </value>
158
          </objProp>
159
          <stringProp name="filename"></stringProp>
160
        </ResultCollector>
161
        <hashTree/>
162
        <ResultCollector guiclass="SummaryReport" testclass="ResultCollector" testname="Summary Report" enabled="false">
163
          <boolProp name="ResultCollector.error_logging">false</boolProp>
164
          <objProp>
165
            <name>saveConfig</name>
166
            <value class="SampleSaveConfiguration">
167
              <time>true</time>
168
              <latency>true</latency>
169
              <timestamp>true</timestamp>
170
              <success>true</success>
171
              <label>true</label>
172
              <code>true</code>
173
              <message>true</message>
174
              <threadName>true</threadName>
175
              <dataType>true</dataType>
176
              <encoding>false</encoding>
177
              <assertions>true</assertions>
178
              <subresults>true</subresults>
179
              <responseData>false</responseData>
180
              <samplerData>false</samplerData>
181
              <xml>false</xml>
182
              <fieldNames>true</fieldNames>
183
              <responseHeaders>false</responseHeaders>
184
              <requestHeaders>false</requestHeaders>
185
              <responseDataOnError>false</responseDataOnError>
186
              <saveAssertionResultsFailureMessage>true</saveAssertionResultsFailureMessage>
187
              <assertionsResultsToSave>0</assertionsResultsToSave>
188
              <bytes>true</bytes>
189
              <sentBytes>true</sentBytes>
190
              <url>true</url>
191
              <threadCounts>true</threadCounts>
192
              <idleTime>true</idleTime>
193
              <connectTime>true</connectTime>
194
            </value>
195
          </objProp>
196
          <stringProp name="filename"></stringProp>
197
        </ResultCollector>
198
        <hashTree/>
199
      </hashTree>
200
      <kg.apc.jmeter.threads.UltimateThreadGroup guiclass="kg.apc.jmeter.threads.UltimateThreadGroupGui" testclass="kg.apc.jmeter.threads.UltimateThreadGroup" testname="jp@gc - Ultimate Thread Group - slow slope" enabled="false">
201
        <collectionProp name="ultimatethreadgroupdata">
202
          <collectionProp name="-811668396">
203
            <stringProp name="50">2</stringProp>
204
            <stringProp name="48">0</stringProp>
205
            <stringProp name="1722">60</stringProp>
206
            <stringProp name="1508508">1140</stringProp>
207
            <stringProp name="0"></stringProp>
208
          </collectionProp>
209
          <collectionProp name="1110318546">
210
            <stringProp name="50">2</stringProp>
211
            <stringProp name="50547">300</stringProp>
212
            <stringProp name="1722">60</stringProp>
213
            <stringProp name="55476">840</stringProp>
214
            <stringProp name="0"></stringProp>
215
          </collectionProp>
216
          <collectionProp name="-277728215">
217
            <stringProp name="50">2</stringProp>
218
            <stringProp name="53430">600</stringProp>
219
            <stringProp name="1722">60</stringProp>
220
            <stringProp name="52593">540</stringProp>
221
            <stringProp name="0"></stringProp>
222
          </collectionProp>
223
          <collectionProp name="1889215593">
224
            <stringProp name="50">2</stringProp>
225
            <stringProp name="56313">900</stringProp>
226
            <stringProp name="1722">60</stringProp>
227
            <stringProp name="49710">240</stringProp>
228
            <stringProp name="0"></stringProp>
229
          </collectionProp>
230
        </collectionProp>
231
        <elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel" testclass="LoopController" testname="Loop Controller" enabled="true">
232
          <boolProp name="LoopController.continue_forever">false</boolProp>
233
          <intProp name="LoopController.loops">-1</intProp>
234
        </elementProp>
235
        <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
236
      </kg.apc.jmeter.threads.UltimateThreadGroup>
237
      <hashTree>
238
        <RandomVariableConfig guiclass="TestBeanGUI" testclass="RandomVariableConfig" testname="Random catId" enabled="true">
239
          <stringProp name="maximumValue">30</stringProp>
240
          <stringProp name="minimumValue">1</stringProp>
241
          <stringProp name="outputFormat"></stringProp>
242
          <boolProp name="perThread">true</boolProp>
243
          <stringProp name="randomSeed">666</stringProp>
244
          <stringProp name="variableName">catId</stringProp>
245
        </RandomVariableConfig>
246
        <hashTree/>
247
        <HTTPSamplerProxy guiclass="HttpTestSampleGui" testclass="HTTPSamplerProxy" testname="Welcome" enabled="true">
248
          <elementProp name="HTTPsampler.Arguments" elementType="Arguments" guiclass="HTTPArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true">
249
            <collectionProp name="Arguments.arguments"/>
250
          </elementProp>
251
          <stringProp name="HTTPSampler.domain">${__P(HOST,konakartoraclecloud.lab.akamas.io)}</stringProp>
252
          <stringProp name="HTTPSampler.port">8780</stringProp>
253
          <stringProp name="HTTPSampler.protocol">http</stringProp>
254
          <stringProp name="HTTPSampler.contentEncoding"></stringProp>
255
          <stringProp name="HTTPSampler.path">konakart/Welcome.action</stringProp>
256
          <stringProp name="HTTPSampler.method">GET</stringProp>
257
          <boolProp name="HTTPSampler.follow_redirects">false</boolProp>
258
          <boolProp name="HTTPSampler.auto_redirects">true</boolProp>
259
          <boolProp name="HTTPSampler.use_keepalive">true</boolProp>
260
          <boolProp name="HTTPSampler.DO_MULTIPART_POST">false</boolProp>
261
          <boolProp name="HTTPSampler.BROWSER_COMPATIBLE_MULTIPART">true</boolProp>
262
          <boolProp name="HTTPSampler.image_parser">true</boolProp>
263
          <boolProp name="HTTPSampler.concurrentDwn">true</boolProp>
264
          <stringProp name="HTTPSampler.embedded_url_re"></stringProp>
265
          <stringProp name="HTTPSampler.connect_timeout"></stringProp>
266
          <stringProp name="HTTPSampler.response_timeout"></stringProp>
267
        </HTTPSamplerProxy>
268
        <hashTree/>
269
        <TestAction guiclass="TestActionGui" testclass="TestAction" testname="think time" enabled="true">
270
          <intProp name="ActionProcessor.action">1</intProp>
271
          <intProp name="ActionProcessor.target">0</intProp>
272
          <stringProp name="ActionProcessor.duration">100</stringProp>
273
        </TestAction>
274
        <hashTree/>
275
        <HTTPSamplerProxy guiclass="HttpTestSampleGui" testclass="HTTPSamplerProxy" testname="SelectCat" enabled="true">
276
          <elementProp name="HTTPsampler.Arguments" elementType="Arguments" guiclass="HTTPArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true">
277
            <collectionProp name="Arguments.arguments"/>
278
          </elementProp>
279
          <stringProp name="HTTPSampler.domain">${__P(HOST,konakartoraclecloud.lab.akamas.io)}</stringProp>
280
          <stringProp name="HTTPSampler.port">8780</stringProp>
281
          <stringProp name="HTTPSampler.protocol">http</stringProp>
282
          <stringProp name="HTTPSampler.contentEncoding"></stringProp>
283
          <stringProp name="HTTPSampler.path">konakart/SelectCat.action?catId=${catId}</stringProp>
284
          <stringProp name="HTTPSampler.method">GET</stringProp>
285
          <boolProp name="HTTPSampler.follow_redirects">false</boolProp>
286
          <boolProp name="HTTPSampler.auto_redirects">true</boolProp>
287
          <boolProp name="HTTPSampler.use_keepalive">true</boolProp>
288
          <boolProp name="HTTPSampler.DO_MULTIPART_POST">false</boolProp>
289
          <boolProp name="HTTPSampler.BROWSER_COMPATIBLE_MULTIPART">true</boolProp>
290
          <boolProp name="HTTPSampler.image_parser">true</boolProp>
291
          <boolProp name="HTTPSampler.concurrentDwn">true</boolProp>
292
          <stringProp name="HTTPSampler.embedded_url_re"></stringProp>
293
          <stringProp name="HTTPSampler.connect_timeout"></stringProp>
294
          <stringProp name="HTTPSampler.response_timeout"></stringProp>
295
        </HTTPSamplerProxy>
296
        <hashTree/>
297
        <TestAction guiclass="TestActionGui" testclass="TestAction" testname="think time" enabled="true">
298
          <intProp name="ActionProcessor.action">1</intProp>
299
          <intProp name="ActionProcessor.target">0</intProp>
300
          <stringProp name="ActionProcessor.duration">100</stringProp>
301
        </TestAction>
302
        <hashTree/>
303
        <com.github.johrstrom.listener.PrometheusListener guiclass="com.github.johrstrom.listener.gui.PrometheusListenerGui" testclass="com.github.johrstrom.listener.PrometheusListener" testname="Prometheus Listener" enabled="true">
304
          <collectionProp name="prometheus.collector_definitions">
305
            <elementProp name="" elementType="com.github.johrstrom.listener.ListenerCollectorConfig">
306
              <stringProp name="collector.help">Sampler Response Time</stringProp>
307
              <stringProp name="collector.metric_name">ResponseTime</stringProp>
308
              <stringProp name="collector.type">SUMMARY</stringProp>
309
              <collectionProp name="collector.labels">
310
                <stringProp name="102727412">label</stringProp>
311
                <stringProp name="3059181">code</stringProp>
312
              </collectionProp>
313
              <stringProp name="collector.quantiles_or_buckets">0.5,0.01|0.85,0.01|0.9,0.01|0.99,0.01;60</stringProp>
314
              <stringProp name="listener.collector.listen_to">samples</stringProp>
315
              <stringProp name="listener.collector.measuring">ResponseTime</stringProp>
316
            </elementProp>
317
            <elementProp name="" elementType="com.github.johrstrom.listener.ListenerCollectorConfig">
318
              <stringProp name="collector.help">Success and failure ratio</stringProp>
319
              <stringProp name="collector.metric_name">Ratio</stringProp>
320
              <stringProp name="collector.type">SUCCESS_RATIO</stringProp>
321
              <collectionProp name="collector.labels">
322
                <stringProp name="102727412">label</stringProp>
323
                <stringProp name="3059181">code</stringProp>
324
              </collectionProp>
325
              <stringProp name="collector.quantiles_or_buckets"></stringProp>
326
              <stringProp name="listener.collector.listen_to">samples</stringProp>
327
              <stringProp name="listener.collector.measuring">SuccessRatio</stringProp>
328
            </elementProp>
329
          </collectionProp>
330
        </com.github.johrstrom.listener.PrometheusListener>
331
        <hashTree/>
332
        <ResultCollector guiclass="ViewResultsFullVisualizer" testclass="ResultCollector" testname="View Results Tree" enabled="false">
333
          <boolProp name="ResultCollector.error_logging">false</boolProp>
334
          <objProp>
335
            <name>saveConfig</name>
336
            <value class="SampleSaveConfiguration">
337
              <time>true</time>
338
              <latency>true</latency>
339
              <timestamp>true</timestamp>
340
              <success>true</success>
341
              <label>true</label>
342
              <code>true</code>
343
              <message>true</message>
344
              <threadName>true</threadName>
345
              <dataType>true</dataType>
346
              <encoding>false</encoding>
347
              <assertions>true</assertions>
348
              <subresults>true</subresults>
349
              <responseData>false</responseData>
350
              <samplerData>false</samplerData>
351
              <xml>false</xml>
352
              <fieldNames>true</fieldNames>
353
              <responseHeaders>false</responseHeaders>
354
              <requestHeaders>false</requestHeaders>
355
              <responseDataOnError>false</responseDataOnError>
356
              <saveAssertionResultsFailureMessage>true</saveAssertionResultsFailureMessage>
357
              <assertionsResultsToSave>0</assertionsResultsToSave>
358
              <bytes>true</bytes>
359
              <sentBytes>true</sentBytes>
360
              <url>true</url