-
Notifications
You must be signed in to change notification settings - Fork 18
/
oltpxcset.html
318 lines (223 loc) · 9.33 KB
/
oltpxcset.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
<!-- Creator : groff version 1.22.3 -->
<!-- CreationDate: Mon Mar 18 08:51:13 2024 -->
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta name="generator" content="groff -Thtml, see www.gnu.org">
<meta http-equiv="Content-Type" content="text/html; charset=US-ASCII">
<meta name="Content-Style" content="text/css">
<style type="text/css">
p { margin-top: 0; margin-bottom: 0; vertical-align: top }
pre { margin-top: 0; margin-bottom: 0; vertical-align: top }
table { margin-top: 0; margin-bottom: 0; vertical-align: top }
h1 { text-align: center }
</style>
<title>oltpxcset</title>
</head>
<body>
<h1 align="center">oltpxcset</h1>
<a href="#NAME">NAME</a><br>
<a href="#SYNOPSIS">SYNOPSIS</a><br>
<a href="#OPTIONS">OPTIONS</a><br>
<a href="#USAGE">USAGE</a><br>
<a href="#NOTES">NOTES</a><br>
<a href="#BUGS">BUGS</a><br>
<a href="#COPYRIGHT">COPYRIGHT</a><br>
<a href="#SEE ALSO">SEE ALSO</a><br>
<hr>
<h2>NAME
<a name="NAME"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">oltpxcset
− Modify settings in an ongoing run</p>
<h2>SYNOPSIS
<a name="SYNOPSIS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>oltpxcset
[-H --help] [-k key] [--key key] [--hostname name]
...</b></p>
<p style="margin-left:11%; margin-top: 1em">Change certain
run parameters while a run using oltpxcrun is in progress.
The key and the hostname are the primary keys of the table
(rwlrun_xc) that saves the external control parameter, and
these default to the RWLOLTP_NAME environment and the
hostname of the system where oltpxcset is called.</p>
<p style="margin-left:11%; margin-top: 1em">If no
parameters or only key and/or hostname are provided, the
current values will be shown without doing any changes.</p>
<p style="margin-left:11%; margin-top: 1em">To do changes,
provide one or more of the long options shown below.</p>
<h2>OPTIONS
<a name="OPTIONS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>-h|-H|--help</b></p>
<p style="margin-left:17%;">Print short help.</p>
<p style="margin-left:11%; margin-top: 1em"><b>-k|--key
key</b></p>
<p style="margin-left:17%;">Set the key that will be used
when storing results in the repository database. The default
is the same as the project name, i.e. the RWLOLTP_NAME
environment.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--hostname
name</b></p>
<p style="margin-left:17%;">Set the hostname. The default
is the name of the host where oltpxcset is called.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--ratefactor
D</b></p>
<p style="margin-left:17%;">Set a multiplier for the
arrival rate of the emulated business transactions. Any
double value higher than 0 is accepted, but high values may
lead to overload.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--loadfactor
D</b></p>
<p style="margin-left:17%;">Set the proportion of worker
threads that will be active. Any double value between 0 and
1 are accepted.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--hardparse
N</b></p>
<p style="margin-left:17%;">Set to a value between 0 and 2.
The value is a probability that some emulated business
transactions are using SQL statements with literal values in
stead of place-holders and therefore are hard parsed.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--parsefailure
N</b></p>
<p style="margin-left:17%;">Set to a value between 0 and 1.
The value is a probability that some emulated business
transactions are using SQL statements that cause a parse
failure during execution.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--ignore-parsefailure
N</b></p>
<p style="margin-left:17%;">Set to 0 or 1. If set to 1, and
the next oltpxc execution uses parse failures, the actual
ORA- error will be suppressed in the stderr output.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--logoffrate
D</b></p>
<p style="margin-left:17%;">Specify the proportion of
sessions that when returned to the session pool, also will
be forced to log off from the database. Set to a value
between 0 and 1. Suggested values are around 0.1 to 0.2 and
values close to 1 will cause very high database logon
rates.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--minpool N
<br>
--maxpool N</b></p>
<p style="margin-left:17%;">Change either of the minimum or
maximum pool size of the session pool in each worker
thread.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--cursorleak
D</b></p>
<p style="margin-left:17%;">Set the proportion of cursors
that will be leaked. The value is a double value between 0
and 1, 0 meaning no leak. Any non-zero value will cause an
eventual ORA-01000 error, the higher the value the faster
the ORA-01000 errors will occur. If you have set a non-zero
value and observe ORA-01000 errors, you can change the value
back to 0 and the ORA-01000 errors will disappear after some
time.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--sessionleak
D</b></p>
<p style="margin-left:17%;">Set the proportion of sessions
that will be leaked. The value is a double value between 0
and 1, 0 meaning no leak. Any non-zero value will cause
sessions to become blocked an unavailable, and may
eventually cause the run to get into an unrecoverable state.
Any non-zero value should be small and used with care.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--cursorcache
N</b></p>
<p style="margin-left:17%;">Set the size of the cursor
(statement) cache. The lowest allowable value is 1, which
will cause almost all executes to also imply a (soft)
parse.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--badplan
N</b></p>
<p style="margin-left:17%;">Set the number of queries in
the awindex_query transaction that uses a full table scan
rather than an index. The value must be in the range
0..10.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--cpusec
D</b></p>
<p style="margin-left:17%;">Set the number of seconds each
of the frequently executed transactions will be a cpu hog
while it has a session.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--waitsec
D</b></p>
<p style="margin-left:17%;">Set the number of seconds each
of the frequently executed transactions will be waiting
doing nothing while it has a session.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--proccount
N</b></p>
<p style="margin-left:17%;">Set a process count to be used
by the next run.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--stopnow</b></p>
<p style="margin-left:17%;">Abort one run prematurely. This
will be done without cleanup, but a new run will be started
shortly after when using oltpxcrun.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--finishnow</b></p>
<p style="margin-left:17%;">Abort current run prematurely
and also stop oltpxcrun.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--finishnext</b></p>
<p style="margin-left:17%;">Wait for the current run to
complete normally and then finish oltpxcrun.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--nopool
<br>
--yespool</b></p>
<p style="margin-left:17%;">When the next run starts, it
will be using dedicated connections respectively session
pool; the latter is the default.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--default</b></p>
<p style="margin-left:17%;">Set all values to their
defaults.</p>
<p style="margin-left:11%; margin-top: 1em"><b>--no-show</b></p>
<p style="margin-left:17%;">Do not show all values after
modifications have been done.</p>
<h2>USAGE
<a name="USAGE"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">The command is
supposed to be used as part of a demonstration together with
various other live displays of values such as DBCPU, DBTIME,
contention, etc. You will need to gain experience with the
various settings to understand the implications.</p>
<p style="margin-left:11%; margin-top: 1em">It is highly
recommended that you use this in combination with oltpxcrun
having long runtimes. When starting oltpxcrun, make sure to
redirect stderr to a place (e.g. via tail -f of a file) that
can be shows as part of the demonstration.</p>
<p style="margin-left:11%; margin-top: 1em">The options for
leaking, in particular sessionleak, should be used with
care. Do not use the command against a production
database.</p>
<p style="margin-left:11%; margin-top: 1em">At present, the
parameters cursorleak, sessionleak, logoffrate, hardparse
and parsefailure only have actual impact on a subset of
emulated business transactions.</p>
<h2>NOTES
<a name="NOTES"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">The primary
purpose of external control is for internal use by the
Oracle Real World Performance team.</p>
<p style="margin-left:11%; margin-top: 1em">Changes,
including changes that are incompatible with ealier versions
of external control should be expected.</p>
<h2>BUGS
<a name="BUGS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">Not everything
is described and some description is inaccurate.</p>
<h2>COPYRIGHT
<a name="COPYRIGHT"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">Copyright
© 2023 Oracle Corporation <br>
Licensed under the Universal Permissive License v 1.0 as
shown at https://oss.oracle.com/licenses/upl</p>
<h2>SEE ALSO
<a name="SEE ALSO"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><a href="oltp.html">oltp(2rwl)</a>,
<a href="oltpcore.html">oltpcore(2rwl)</a>, <a href="oltprun.html">oltprun(2rwl)</a></p>
<hr>
</body>
</html>