-
Notifications
You must be signed in to change notification settings - Fork 19
Expand file tree
/
Copy pathpersec.html
More file actions
184 lines (135 loc) · 5.06 KB
/
persec.html
File metadata and controls
184 lines (135 loc) · 5.06 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
<!-- 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>persec</title>
</head>
<body>
<h1 align="center">persec</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">rwlman −
RWP*Load Simulator persec table and persec_a view</p>
<h2>DECLARATION
<a name="DECLARATION"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">The
<b>persec</b> table and associated view save information
about the count of executions of each procedure per second
since the common start time.</p>
<pre style="margin-left:11%; margin-top: 1em">create table persec
( runnumber number not null
, procno number not null
, vname varchar2(30) not null
, second number not null
, scount number
, wtime number
, etime number
, atime number
, dtime number
, constraint persec_pk primary key(runnumber, procno, vname, second)
)
create view persec_a
( runnumber
, pcount
, vname
, second
, scount
, wtime
, etime
, atime
, dtime
)</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, persec_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>second</b></p>
<p style="margin-left:17%;">This is the whole second after
the common start time.</p>
<p style="margin-left:11%; margin-top: 1em"><b>scount</b></p>
<p style="margin-left:17%;">Total number of executions of
the procedure in the latest second until the value of the
<b>second</b> column. In the persec_a view the value is
aggregated over all processes.</p>
<p style="margin-left:11%; margin-top: 1em"><b>wtime</b></p>
<p style="margin-left:17%;">Total time spent getting a
session from a pool for all executions of the procedure in
the latest second until the value of the <b>second</b>
column. In the persec_a view the value is aggregated over
all processes. If not using a pool, the value is 0.</p>
<p style="margin-left:11%; margin-top: 1em"><b>etime</b></p>
<p style="margin-left:17%;">Total time spent executing the
procedure in the latest second until the value of the
<b>second</b> column. In the persec_a view the value is
aggregated over all processes.</p>
<p style="margin-left:11%; margin-top: 1em"><b>atime,
dtime</b></p>
<p style="margin-left:17%;">Application and database time
spent executing the procedure in the latest second until the
value of the <b>second</b> column. In the persec_a view the
values are aggregated over all processes.</p>
<p style="margin-left:17%; margin-top: 1em">See
<a href="runres.html">runres(1rwl)</a> for details about these two columns.</p>
<h2>NOTES
<a name="NOTES"></a>
</h2>
<p style="margin-left:11%; margin-top: 1em">The per second
counts and times are like all other statistics held in
memory buffers, and is flushed to the repository database
just before rwloadsim termination. If the --flush-every
option is used, the per second values will be flushed every
so often, which can e.g. be used to show a running graph of
the throughput. Note that --flush-every has overheads as
mutexes are needed to protect the buffers and due to the
execution of a sql statement against the repository
database. If the value for the --flush-every option is
larger than 1, each update to the repository will contain
per second counts for multiple seconds.</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="runres.html">runres(1rwl)</a></p>
<hr>
</body>
</html>