-
Notifications
You must be signed in to change notification settings - Fork 19
Expand file tree
/
Copy pathrunres.html
More file actions
212 lines (157 loc) · 6.02 KB
/
runres.html
File metadata and controls
212 lines (157 loc) · 6.02 KB
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
<!-- Creator : groff version 1.22.3 -->
<!-- CreationDate: Mon Mar 18 08:51:05 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>runres</title>
</head>
<body>
<h1 align="center">runres</h1>
<a href="#NAME">NAME</a><br>
<a href="#DECLARATION">DECLARATION</a><br>
<a href="#COLUMNS">COLUMNS</a><br>
<a href="#NOTES">NOTES</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">runres −
RWP*Load Simulator runres table and runres_a view</p>
<h2>DECLARATION
<a name="DECLARATION"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">When using the
-s option and a results database, the runres table saves
overall execution statistics of the execution of all
procedures doing database work or having the statistics
attribute. The runres_a view aggregates results from a multi
process run.</p>
<pre style="margin-left:11%; margin-top: 1em">create table runres
( runnumber number not null
, procno number not null
, vname varchar2(30) not null
, wtime number(*,6)
, etime number(*,6)
, atime number(*,6)
, dtime number(*,6)
, ecount number
, tcount number
, constraint runres_pk primary key(runnumber, procno, vname)
)
create view runres_a
( runnumber
, pcount
, vname
, wtime
, etime
, atime
, dtime
, tcount
, avgw
, avge
, avga
, avgd
, ecount
)</pre>
<h2>COLUMNS
<a name="COLUMNS"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em"><b>runnumber</b></p>
<p style="margin-left:17%;">This is the number that
uniquely identifies a run.</p>
<p style="margin-left:11%; margin-top: 1em"><b>procno
pcount</b></p>
<p style="margin-left:17%;">In single process runs, procno
is zero, in multi-process runs, it gets its value from the
Operating System process number of from the -p option to
rwloadsim. In the aggregate view, runres_a, the total
process count is in the pcount column.</p>
<p style="margin-left:11%; margin-top: 1em"><b>vname</b></p>
<p style="margin-left:17%;">This is the name of the
procedure being executed.</p>
<p style="margin-left:11%; margin-top: 1em"><b>wtime</b></p>
<p style="margin-left:17%;">Total time in seconds spent
waiting to get a session from a session pool. For a
dedicated database, this time can be positive if a control
loop uses queue every and the $queueeverytiming:on directive
is used.</p>
<p style="margin-left:11%; margin-top: 1em"><b>etime</b></p>
<p style="margin-left:17%;">Total time in seconds spent
executing the code in the procedure, not including time used
to get a session.</p>
<p style="margin-left:11%; margin-top: 1em"><b>atime</b></p>
<p style="margin-left:17%;">When the
<b>$statsapptime:on</b> directive is used, the time spent
executing OCI calls that interact with the database will be
measured. The total time spent using such calls effectively
is time spent <i>outside</i> your rwl program, and that
total time is subtracted from the value saved in the
<b>etime</b> column and saved in the <b>atime</b> column.
Effectively, the <b>atime</b> column therefore is the time
spent executing <i>application</i> code. There is some
overhead in measuring this time, and if no
<b>$statsapptime:on</b> is used, a value of zero will be
stored in the atime <b>column.</b></p>
<p style="margin-left:17%; margin-top: 1em">The current
list of calls where this time is measured is OCIStmtExecute,
OCIStmtFetch2, OCITransCommit, OCITransRollback, OCIPing and
OCI calls that deal with reading and writing lob data.</p>
<p style="margin-left:11%; margin-top: 1em"><b>dtime</b></p>
<p style="margin-left:17%;">When the <b>$statsdbtime:on</b>
directive is used, OCI_ATTR_COLLECT_CALL_TIME is enabled and
measured for the OCI calls mentioned above under
<b>atime</b>. The sum of these times is subsequently saved
in the <b>dbtime</b> column. This time effectively
represents the <i>database time</i> spent by your rwl
program. There is some overhead in gathering this time, and
if <b>$statsdbtime:on</b> is not used, a value of zero will
be stored in the dtime <b>column.</b></p>
<p style="margin-left:11%; margin-top: 1em"><b>ecount</b></p>
<p style="margin-left:17%;">Total number of executions of
the procedure.</p>
<p style="margin-left:11%; margin-top: 1em"><b>tcount</b></p>
<p style="margin-left:17%;">Number of threads having an
execution of this procedure.</p>
<p style="margin-left:11%; margin-top: 1em"><b>avgw, avge,
avga, avgd</b></p>
<p style="margin-left:17%;">Average time spent waiting for
a session, executing the procedure, execuring application
code respectively database time.</p>
<h2>NOTES
<a name="NOTES"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">At present, the
atime and dtime columns only contains values from executing
the OCI calls mentioned above under the description of
<b>atime</b>. The implication is that the <b>atime</b> and
<b>dtime</b> columns only are correct if your procedures do
not call other procedures using a stacked at clause. This
may change in some future release.</p>
<h2>COPYRIGHT
<a name="COPYRIGHT"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">Copyright
© 2023 Oracle Corporation</p>
<p style="margin-left:11%; margin-top: 1em">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="statistics.html">statistics(1rwl)</a>,
<a href="controlloop.html">controlloop(1rwl)</a>, <a href="atclause.html">atclause(1rwl)</a></p>
<hr>
</body>
</html>